Search, Information Retrieval

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.

**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)

**[No Surprise, ... YET]** Let's get together and **WORKSHOP** about Job Searching and Career Management. Here are some of the content areas we can cover - expect this to change. * Using AI effectively (search, resume). * Job Search Tooling (i.e. TopResume, Job-Squid). * Resume / LinkedIn Review * Practice Interview * Practice Elevator Pitch ***Bring your laptop and expect to write some (non-AI-generated) code!*** Food and drinks will be available. **LOCATION:** 6515 Longshore Loop, Suite 300, Dublin, OH 43017 **FREE PARKING:** 6725 Longshore Street, Dublin, OH 43017

Rev. Steven Clevenger is an ordained spiritualist minister with over 40 years experience as a Spiritual Healer, Clairvoyant and Spiritual Teacher, educated and trained at the White Lily Chapel. Rev. Siobhan Wolf Shaffer is an ordained spiritualist minister and certified medium and healer with over 20 years experience. She began her development in 1988 in Pennsylvania and continued when she moved to Ohio in 1998 where she studied at Rays of Lights Church with Rev. Steven Clevenger. Our full worship services consist of an inspirational lecture, healing meditation, and messages from the spirit world that serve to demonstrate evidence of eternal life. Please visit our Official Church Website (http://raysoflightchurch.com) for more information.

Join us as we get together to see the period drama / classic monster movie, THE BRIDE! The film is written/directed by Maggie Gyllenhaal and stars Jessie Buckley and Christian Bale in a new take on the classic tale, The Bride of Frankenstein. We'll be seeing this one on Thurs, 3/5 one day ahead of the film's opening on Friday. Here’s a description, trailer and plan for this event: DESCRIPTION: In 1930s Chicago, Frankenstein's creature asks Dr. Euphronius to create a companion for him. They give life to a murdered woman as "the Bride," sparking romance, police interest and radical social change. It is written, directed and co-produced by Maggie Gyllenhaal and stars Jessie Buckley, Christian Bale, Peter Sarsgaard, Annette Bening, Jake Gyllenhaal and Penélope Cruz. TRAILER: https://www.youtube.com/watch?v=n-qJkAXLfYM PARKING: Close, convenient parking is available in the nearby garage (located between 9th and 11th, just off High St). Bring your ticket with you and have it validated at the theater and for $2, you’re covered for the night! PLAN: Please purchase your ticket for the 7:00pm showing and we’ll meet inside the upstairs lobby between 6:40 and 6:50pm. Advance ticket purchase is advised (via Gateway website preferred). Once you have yours, please list your seat number in the Comments below! Pre-show bite at Cazuela’s next door at 5:30pm. Please arrive by 5:30pm and ask for the Movie Group! Look forward to seeing you there, Dan

Meeting @ Improving's office in Downtown Columbus, near Cosi. Parking is paid, food & drink are free! This time we're hanging out after the long winter break. We are going to look at a group-member's project used to help learn the fundamentals of Go, and if time allows, we can take a look at how we like to build Go projects using AI.