Data Integration

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.

The March Ohio North Database Training user group meeting will be held on **March 3rd, 2026 at 5:00PM**. This will be a **HYBRID** event and we will be joined in person by **Sam Nasr**. You're welcome to come meet in-person at our meeting location, the offices of Improving at **[6000 Freedom Square Dr,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Unit 110,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Independence, OH 44131](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** [Teams Link ](https://teams.microsoft.com/l/meetup-join/19%3ameeting_YTg3MTY3NzItODI3OS00MTRjLTgzYTItYTBlMjY5NTQ5MzU4%40thread.v2/0?context=%7b%22Tid%22%3a%22b966f302-6b93-4686-9041-c084635642c5%22%2c%22Oid%22%3a%2278c760cb-657f-46aa-bd2f-7066d9403bdb%22%7d)if anyone needs it after RSVP-ing for in person. If you would like to subscribe to our email list outside of Meetup, we have changed platforms recently and you will need to register [here in Kit ](https://ohio-north-data-training.kit.com/b8f036f615)instead to receive emails. Agenda: **5:00 PM EST**: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees. **6:00 PM EST**: Updates and announcements, followed by our feature presentation. See below for presentation details. **7:30 PM EST**: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment. We hope to see you there! Session Abstract ### **Data Cleansing using Data Bricks** Machine Learning is highly dependent on adequate data. Not only does quantity matter, but more importantly quality. In this session we’ll cover how to build a custom automated process using Data Bricks. This will provide methods for cleaning data in a data lake using functions in Azure. \*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.

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

Christians in Tech is a community at the intersection of faith and technology. Our meetups are designed to spark meaningful conversations, promote knowledge sharing, and encourage growth—both in your career and your spiritual walk with God. Whether you're an experienced professional or just starting your tech journey, CIT welcomes you. Our Website [https://linktr.ee/citcbus](https://linktr.ee/citcbus) Sponsors and Partners * Improving (Venue Sponsor) * Bethel World Prayer Center (Fiscal Sponsor) * Fruits & Roots (Coffee Partner)

Our monthly PHP meetup. A virtual shindig courtesy of Zoom. Check back here for the details around 6:15 pm

One of the most valuable parts of this community is the opportunity to think out loud with other product professionals. This session is built for exactly that. As we wrap up the quarter, it’s a great time to pause and reflect. What’s on track? What needs adjustment? Where could a small shift create bigger impact? Join fellow product professionals for a focused, interactive conversation designed to help you recalibrate for the next quarter. You’ll have the opportunity to share where you are, hear how others are thinking through similar challenges, and gain fresh perspective you can bring back to your team and organization. We’ll gather at 8:00AM, with discussion starting promptly at 8:15AM. 📍 First Watch - 7227 N High St Located in: The Shops at Worthington Ample parking is available. Food and beverages will be available for purchase. Start your morning with clarity and connection — we hope to see you there! ☀️

Columbus Code & Coffee is an inclusive, informal co-working session. People of all skill levels attend, and we love it that way. Many people (optionally) bring projects to work on, and many other people (optionally) socialize the entire time. It's entirely up to you! **What to Expect at the Intro Circle** \~\~\~\~\~\~\~\~\~\~\~\~\~ Near the beginning of the event (1:30 pm), we do a standup: * Organizer announcements, updates, and logistics Round 1 - (7 secs max): * Your name * What you're working on * What you can help others with Round 2: * Community events you wanna plug. If none, that's cool too. Round 3: * Job opportunities you're hiring for OR announce that you are looking for one. If none, that's cool. After the introduction circle, everything is self-organized! Feel free to work alone, pair up, attend one of our workshops/presentations, or mingle!