Datos abiertos

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)

While some are still meeting online, this is an in person event. Please note that we have attendees of all levels of speaking, including some native speakers. All are welcome! Also, as we meet at the same time and place each week, many don’t RSVP on the app, so we will likely have more attendees than noted here. Note: if you are asked to pay and upgrade the Meetup app, this is not necessary. You can ignore this and still attend our meetings.

**\*\*\*TO ATTEND THE EVENT, YOU MUST PURCHASE TICKETS THROUGH OUR WEBSITE\*\*\*** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Hosted by Pre-Dating Speed Dating, the experts, bringing people together since 2001! *Our events have been featured on CNN, CBS, Axios, Miami New Times, TLC's 90 Day Fiance - The Single Life, Tampa Bay Times, Southbend Times, Citylink Magazine, Essence, The Wall Street Journal, Best of Baltimore, AM New York, Chicago Tribune, WINK FM, Woman's World Magazine, and 100s more -- but come see for yourself!* Join us for a night of fun, flirtation, and possible romance at our singles speed dating event! If you're tired of swiping left and right on dating apps, speed dating is a great way to meet new people in person, in a relaxed, safe, and comfortable environment. **HOW IT WORKS:** We'll introduce you to at least 5, and up to 12 - or more - single women or men. Spend a little time with each one, during a series of 6-minute Pre-Dates. Then tell us who you'd like to speak with again & we'll do the rest! It's the modern, civilized, effective, and fun way to meet other professional-level singles. If you're finished with the games and ineffectiveness of online dating and apps, join us to share a wonderful evening of enjoyable conversation with interesting people... and maybe something magical will happen! **GET TICKETS:** A Meetup RSVP is not a ticket, you must purchase on our website. [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) Use Code MATCH5 for $5 off! **DOES IT WORK?** Yes! According to the New York Times, at a speed dating event, people like 2-3 out of 10 people they meet. Online daters only match with 1 in 100 or fewer of the profiles they study. This is the best way to meet new people, and it works! Just ask the thousands of people that have met at our events and had successful relationships and marriages. **WHAT DOES IT COST?** We put a lot of time and effort into creating the best singles events possible, so we collect a fee for our hard work. Our events are an excellent value at about $3 per introduction. Get your ticket for the best singles event in town. **NOTE FOR NEWCOMERS:** We post our events on various platforms. Our events often sell out, so expect plenty of fellow singles, regardless of the numbers you see here :) So what are you waiting for? Join us for some fun conversation with great new people... and maybe something more! Who will you meet? **GET TICKETS:** [https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup](https://www.pre-dating.com/columbus-speed-dating/?utm_source=meetup&utm_medium=event_listing&utm_campaign=meetup) #singles #singlesevents #speeddating #love #relationships

Join us for a fun Saturday evening starting with dinner at Ranchero Kitchen at 6:30 PM, where we’ll be supporting an immigrant-owned local business. Pupusas: Beans, Potatoes, Veggie Homemade juices: Passionfruit, Tamarind, Horchata, Pineapple-cashew After dinner, we’ll head to Skate Zone 71 from 8:00–10:30 PM for skating, music, and good vibes. Come hungry and ready to roll! 😋🛼 Locations: Ranchero Kitchen 984 Morse Rd Columbus, OH 43229 (Same plaza as Ohio BMV license bureau) Skate Zone 71 4900 Evanswood Dr Columbus, OH 43229

**💥 Join us THIS Saturday and EVERY Saturday!** **💥 At Columbus’ Hottest New Salsa Venue!** **.** Lincoln Street Salsa THIS Saturday and EVERY Saturday! 8 pm – 1 am **.** **💥 Gorgeously Renovated Studio!** **💥 Free Parking!** **💥 BYOB!** **💥 Easy Access from Highway!** **.** Lincoln Street Salsa 1717 Brice Rd Reynoldsburg, Ohio 43215 **.** **ENTRANCE IS ON THE NORTH SIDE OF THE BUILDING** **Behind Anthony’s Pharmacy!** **.** **PLEASE SHARE and help get the word out!** **.** **🟣 Salsa, Bachata, and Merengue Dancing!** **.** **🟣** 8:00 pm – 8:30 pm **𝗥𝗲𝗴𝗶𝘀𝘁𝗿𝗮𝘁𝗶𝗼𝗻** **.** **🟣** 8:30 pm – 9:30 pm **𝗕𝗲𝗴𝗶𝗻𝗻𝗲𝗿 𝗗𝗮𝗻𝗰𝗲 Class!** **.** **🟣** 9:30 pm – 1 am **𝗢𝗽𝗲𝗻 𝗗𝗮𝗻𝗰𝗲 𝗣𝗮𝗿𝘁𝘆!** **.** **✅ Questions?** **Visit [LincolnStreetSalsa.com](https://columbussalsadancing.com/)** Or Text Todd: 614-774-8146 **.** **✅ No Experience Necessary!** **✅ No Partner Required!** **✅ Plenty of People to Dance With!** **.** **✅ $15 Cash / $16 Card** **✅ College Students $5 Off with Valid ID!** **✅ BYOB** **✅ Age 18+** **.** **✅ Lincoln Street Salsa is the perfect place for…** **.** **👉 Learning to Dance** **👉** Social Dancing **👉 Birthday Celebration** **👉** Bachelorette Parties **👉 Girl’s Night Out** **👉 Date Night** **👉** Getting Fit / Burning Calories **👉 Meeting New People** **👉** Having Fun, Fun, Fun! **.** ✅ **Questions?** Visit [LincolnStreetSalsa.com](https://columbussalsadancing.com/) Or Text Todd: 614-774-8146