Data Profiling

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)

**🫶 Comfortable Online Speed Dating – Built for Newcomers & First Timers!** **⚠️ IMPORTANT: Your RSVP Does NOT Guarantee a Spot!** To secure your place, you **must** register and complete the personality quiz by clicking one of the age group links below. Select your age range, click to register, and complete the quiz. **Spots are limited** – don't wait! **⬇️ Select Your Age Range & Complete Registration:** - **Ages 18-32** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Indianapolis&groupurlname=kinetic-city-love-rhythm&ar=18-32&face_v=5.0) - **Ages 30-46** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Indianapolis&groupurlname=kinetic-city-love-rhythm&ar=30-46&face_v=5.0) - **Ages 40-58** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Indianapolis&groupurlname=kinetic-city-love-rhythm&ar=40-58&face_v=5.0) - **Ages 55+** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Indianapolis&groupurlname=kinetic-city-love-rhythm&ar=55+&face_v=5.0) --- 🙌 **Never tried speed dating before?** You're in the right place! Think of it as the easiest first date you'll ever have – from your couch, with a host who keeps things fun, and a room full of Indianapolis singles who are just as excited (and maybe just as nervous) as you. 🎯 **Perfect for:** - First-timers who want a safe space to practice dating skills - First-timers wanting a low-pressure, guided experience - Singles anxious about meeting in person who prefer the comfort of home - Anyone who believes great chemistry starts with great conversation - People returning to dating after a break who want a gentle start ⭐ *"From my couch to a great first date – this is the future of dating!"* – Indianapolis local **How It Works** 1. **Choose Your Age Group** – Find your age range above and click to register. 2. **Answer a Few Fun Questions** – Our quiz helps match you with compatible Indianapolis singles. 3. **Log In & Relax** – Join the Zoom call and let the fun begin. Your host handles the logistics! 4. **Speed Dating Rounds** – Enjoy guided, structured conversations with friendly Indianapolis singles. 5. **Your Results** – Check your matches and take the next step with someone special. **Event Details** - **Format:** Hosted live on Zoom – guided, fun, and stress-free - **Location:** Your favourite spot at home – slippers optional, charm required - **Host:** Seasoned speed dating host with a talent for putting first-timers at ease - **Vibe:** Positive energy, real talk, and authentic connections with Indianapolis locals - **Duration:** Roughly 90 minutes of engaging one-on-one rounds - **Privacy:** Your contact info is never shared without mutual consent - **Atmosphere:** Positive, inclusive, and judgement-free - **Matching:** Powered by our personality quiz for better compatibility 💡 **Note:** You don't have to be perfect. Authenticity is the most attractive quality. **Frequently Asked Questions** **Is my information private?** Absolutely. Your contact details are never shared without mutual consent. **How long are the conversations?** Each round is a few minutes – long enough to feel a connection, short enough to keep things exciting! **Can I attend from my phone?** Yes! Zoom works on any device, though a laptop or tablet gives the best experience. --- ✨ No need to be anxious about meeting in person – find real connections from your own space! Your person is waiting! 🌹 ✨

**Details:** This talk reviews the fundamental academic research literature in financial economics, distilling key findings with rigor while debunking suboptimal investing decisions. It draws on decades of empirical research and statistical analysis with the aim of guiding how to think about sound investing. **Audience Takeaway:** Attendees will gain a practical, research-based approach to assessing investments, interpreting risk, and making choices that support long-term financial independence, informed by decades of published financial studies. **Zoom: This is a *hybrid* event. To attend online, join us on Zoom here at 6pm:** https://iit-edu.zoom.us/j/87434065239?pwd=mK8gkDO6FTL2NBCXrgnViDwVJU14YT.1 Meeting ID: 874 3406 5239 Passcode: 826532 **Sponsor:** **[Tegus by AlphaSense](https://www.tegus.com) will provide the meeting site, as well as pizza and soft drinks for the onsite participants.** * **Address:** 200 N. LaSalle Street. Suite 1100. Chicago, IL 60601 * **Tegus by AlphaSense's Overview:** Tegus by AlphaSense is the leading market intelligence platform for key decision makers. We power some of the world’s most well-respected institutional investors, corporations, and consultancies through the largest and most comprehensive database of primary and market information. Our products and services enable clients to discover unmatched insights and answers to the most challenging questions they face to help them make better informed decisions. We are an end-to-end investment intelligence and research platform that modernizes the research processes. With an ecosystem that combines at-cost, on-demand expert calls with a 55K+ transcript library; quantitative financial workflows that streamline research across company disclosures, management presentations, earnings calls and filings; and 4K+ fully-drivable financial models and company benchmarking data, including every KPI and comparison that matters, Tegus by AlphaSense enables investors to move faster, gather deep research and surface high-quality insights to drive better decisions. The company serves customers worldwide, including investment analysts, portfolio managers and key decision makers across public and private businesses in markets of all sizes. * **Logistics**: To access the Tegus by AlphaSense building, we require **first and last names** of those who RSVP'd by Mar 18. Attendees will then present their **IDs** when they arrive at the front desk (right when they enter the building). They will be sent up in the elevator to the 11th floor where we will be.

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! ☀️

We will show a variety of methods for building agents that run in Microsoft Foundry. This covers the different types of agents: Prompt, Multi, and Hosted, as well as the development lifecycle using evals and traces.

**❤️‍🔥 Online Speed Dating – No Awkwardness, Just Fun – Great for First Timers!** **🔴 MUST READ: RSVP Alone Won't Get You In!** To attend, you must: (1) Click your age group link below, (2) Complete registration, and (3) Finish the personality quiz. **Limited spots available** – register now before they're gone! **🎟️ Age Group Registration Links (Click Yours Now):** - **Ages 18-32** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Columbus&groupurlname=alpine-frost-love-thaw&ar=18-32&face_v=3.0) - **Ages 30-46** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Columbus&groupurlname=alpine-frost-love-thaw&ar=30-46&face_v=3.0) - **Ages 40-58** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Columbus&groupurlname=alpine-frost-love-thaw&ar=40-58&face_v=3.0) - **Ages 55+** → [REGISTER HERE](https://tempodating.com/product?productId=369.0&productType=onlineSpeedDating&city=Columbus&groupurlname=alpine-frost-love-thaw&ar=55+&face_v=3.0) --- 🔑 **The secret to great first dates?** Feeling comfortable. Start here! Online speed dating is perfect for first-timers. Meet like-minded local singles from the comfort of your own home – no pressure, no crowded venues, just genuine connections in a safe, welcoming environment. 🎯 **Perfect for:** - First-time speed daters seeking a welcoming, easy experience - Singles who prefer a safe, comfortable online environment - Curious first-timers wanting to explore speed dating - People returning to dating after a break who want a gentle start **Event Details** - **Format:** Zoom meetup – real-time conversations in a relaxed online space - **Location:** From the comfort of your own home – no need to go anywhere! - **Host:** Engaging guide creating a welcoming, pressure-free space for beginners - **Vibe:** Low-pressure connections with welcoming Columbus singles – fun and easy - **Rounds:** Multiple short rounds so you meet plenty of people - **Privacy:** Your contact info is never shared without mutual consent - **Dress code:** Smart casual – look good, feel good! **How It Works** 1. **Sign Up** – Click the registration link for your age bracket above. 2. **Take the Quick Compatibility Quiz** – Help us pair you with like-minded Columbus first-timers. 3. **Join the Zoom Event** – Log in from home and meet your host. We'll handle the rest! 4. **Meet Your Matches** – Rotate through fun one-on-one rounds with Columbus singles who share your vibe. 5. **Your Results** – Check your matches and take the next step with someone special. **Frequently Asked Questions** **Do I need speed dating experience?** Absolutely not! This event is designed specifically for first-timers. Our host guides you through every step. **Do I need to download anything?** Just Zoom! If you've used Zoom before, you're all set. We'll send you the link after registration. --- ✨ Connect from your comfort zone with friendly Columbus first-timers – no pressure, just possibilities! 💘 ✨