Quantitative Analysis

**Google Analytics Alternatives** Is it finally time to make the switch away from Google Analytics? Two-and-a-half years ago Jason Packer asked this question at Columbus Web Analytics Wednesday. Since then: Google’s Universal Analytics has been sunset, we’ve changed our name to Columbus Data & Analytics Wednesday, and Jason has released two editions of his book “Google Analytics Alternatives”. Fresh off the release of the 2nd edition of his book, we thought it was time to re-open this conversation. While people love to complain about it, GA’s market share has remained relatively constant (at least in the United States). Why is that? You won’t find any complaints about GA4 in this talk, but rather an overview of what’s currently available in the market and how to frame your decision-making process. We’ll also be giving out some free copies of Jason’s book! So even if you’ve got a “GA4Lyfe” tattoo (no judgement), there’s free books to go with the free pizza and beer. Thanks to our 2026 sponsors: [Clarivoy](https://www.clarivoy.com), [What Box Consulting Group](https://www.whatboxconsultinggroup.com), [Conductrics](https://www.conductrics.com), and [Piwik PRO](https://piwik.pro) More info at [cbusdaw.com](https://cbusdaw.com)

Window functions have nothing to do with the Windows operating system but provide a “window” to a result set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: * Using running totals * Performing operations in intervals * Identifying data gaps and islands * Performing aggregates without losing detail Many people are confused by window functions and do not know how to use them properly. This session will explore window functions, how they work, and how to use them. Demonstrations with several examples will solidify how window functions can simplify queries and make them more powerful.

Come join us for coffee at Matari Coffee to discuss our March book, "The Enchanted Greenhouse"! Book description: Terlu Perna broke the law because she was lonely. She cast a spell and created a magically sentient spider plant. As punishment, she was turned into a wooden statue and tucked away into an alcove in the North Reading Room of the Great Library of Alyssium. This should have been the end of her story . . . Yet one day, Terlu wakes in the cold of winter on a nearly-deserted island full of hundreds of magical greenhouses. She’s starving and freezing, and the only other human on the island is a grumpy gardener. To her surprise, he offers Terlu a place to sleep, clean clothes, and freshly baked honey cakes—at least until she’s ready to sail home. But Terlu can’t return home and doesn’t want to—the greenhouses are a dream come true, each more wondrous than the next. When she learns that the magic that sustains them is failing—causing the death of everything within them—Terlu knows she must help. Even if that means breaking the law again. This time, though, she isn’t alone. Assisted by the gardener and a sentient rose, Terlu must unravel the secrets of a long-dead sorcerer if she wants to save the island—and have a fresh chance at happiness and love.

Start your week the right way with Manic Mondays. Giving you an enjoyable Bachata lesson with a push of cool moves. The second hour has Beginner/Intermediate Salsa on 1. You must understand basic Salsa skills to participate. 730pm-830pm Bachata Cool Moves 830pm-930pm Salsa On 1 (Beginner/Intermediate) $15 for One Class $20 for Both Free Parking & Plenty of Dance Space.

Some trained COUNT volunteers work together once a month at RMH (http://www.rmhc-centralohio.org/volunteer.php) as Housewarmers (usually on the 1st Sunday from 1 – 5 PM). Some schedule other shifts at their convenience. You may try this out with less fuss by following a "Fast track" or go through the normal process. Fast track • Arrange a time to shadow a COUNT volunteer. Call Dave Nohle at 614-268-9558 (cell). • Show up and try it out. • Complete application, etc. later. Normal process • Complete an online application (http://rmhc-centralohio.org/volunteer/). • Attend orientation in advance. • At orientation you will complete forms agreeing to keep family/patient info private and allowing a background check and tour the facility. • Complete one training shift. Daily shifts are: morning 9 AM - 1 PM, afternoon 1 - 5 PM and evening 5 - 9 PM. • Schedule shifts online using the on the RMH scheduling system (http://www.volgistics.com/ex/portal.dll/?FROM=32895). The Ronald McDonald House (RMH) provides housing and meals for families with sick children. The Columbus RMH is the largest in the world with 137 rooms. COUNT has been volunteering there since May 2014. Housewarmers work with RMH guests to provide a home-like environment - greet, assist with family needs, answer phones, give tours, assist with checkin/checkout, prepare guest rooms after checkout, clean facility, laundry, restock supplies and staff the front desk. RMH Housewarmers volunteer at least one four-hour shift a month. All Housewarmers must complete an application and agree to a background check before they can be full fledged volunteers.

**New Dojo Location!** **Draft Day Columbus** 1130 Dublin Road Columbus, OH 43215 We're going to try a new dojo location for a few weeks and see how it works Dojos are informal Python group study sessions where everyone interested in Python gathers to learn about Python, help others with Python, or just hang out. Everyone is welcome from Python beginners to experts. Bringing a laptop is encouraged (we'll have extension cords and power strips). If there's something you want to learn leave a comment on this invite so we can plan ahead. We're looking for topic suggestions and people interested in presenting at our monthly meetings. To this end we've set up a survey form at [https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc](https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc)

Let us meet for some end of week catching up