Analytic Solutions

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)

Discover Kiro, AWS’s innovative development environment that adapts to your workflow. Whether you prefer specification-driven development or a more intuitive, vibe-based approach, Kiro empowers you to build applications your way. In this session, speakers will explore Kiro’s core functionality and its evolution through re:Invent 2025, along with demonstrations of prompts used to create APIs, hooks, and steering documents. In the latter part of the session, watch as we build a complete example from scratch, showcasing Kiro’s agentic AI workflow in action for spec-driven development and vibe coding. What You'll Learn - Core Kiro concepts and development philosophy Feature evolution: pre and post re:Invent 2025 Practical examples: API creation, hooks, and steering docs Live coding demonstration with real-time problem solving Who Should Attend - Developers, solutions architects, and technical leaders interested in modern AWS development tools and AI-assisted coding workflows. **Speakers Bio:** Matthew Jorat: Matthew Jorat is a Customer Solutions Manager at AWS with nearly three decades of expertise in AI, cloud transformation, migration, modernization, IT, technology, and business. His career spans infrastructure engineer, solutions architect, security auditor, customer success director, support and services director, and operations officer. He was an early adopter of AWS services as a customer, and his current role at AWS uniquely blends his technical and business skills as he partners with executive teams to translate strategic priorities into measurable business outcomes through cloud adoption, AI implementation, and operational excellence. Matt leads end-to-end AI initiatives for enterprise customers, identifying high-impact use cases and maintaining relentless focus on measurable ROI. He holds eight AWS certifications and serves as Adjunct Professor at Franklin University teaching cloud computing and AWS architecture. His expertise encompasses GenAI, agentic AI systems, migration, modernization, and optimization strategies that drive transformation at scale. [https://www.linkedin.com/in/mattjorat/](https://www.linkedin.com/in/mattjorat/) Girish Bhatia: Girish Bhatia is a seasoned technology delivery leader with deep expertise in cross-domain program management. He holds multiple AWS certifications, including AWS Certified Solutions Architect – Associate, AWS Certified Developer – Associate, and AWS Generative AI Practitioner, and is also an AWS Community Builder. Girish brings over two decades of experience in the information technology industry. Throughout his career, Girish has led major technology-driven business transformation from modernizing on-premises applications to driving large-scale cloud migrations. His work includes API-based integration platforms, data-center and mainframe modernization, and enterprise cloud adoption initiatives. Based in Columbus, Ohio, Girish works at a tech-forward fintech company. He is passionate about AWS serverless architectures, Generative AI and emerging cloud technologies. An avid learner and builder, he continues to explore and apply the latest innovations in AWS to help organizations accelerate their digital transformation. https://www.linkedin.com/in/girishbhatia/[https://www.linkedin.com/in/girishbhatia/](https://www.linkedin.com/in/girishbhatia/) **THANK YOU** *Franklin University* for hosting our meetup! To learn more about *Franklin University*, please visit their website: https://www.franklin.edu/ **DIRECTIONS** Franklin University Fisher Hall 300 E. Main St, Columbus, OH 43215 Map: https://maps.app.goo.gl/jxjBA2hUmS5qrvhq8 Parking is FREE! Please park in Lot C in front of Fisher Hall. See attached map. NOTE: Map the address only. When mapping with Google Maps it may use the Fisher Hall at OSU, which is NOT correct. **Want to sponsor the pizza and/or bar tab?** Please contact me if you would like to sponsor this meetup's pizza and/or bar tab: angelo@mandato.com

The topic for March is "Our Bodies, Ourselves" Speak Easy: true stories, told live. The idea is simple: an audience, an open microphone, and great stories. Hilarious, gripping, poignant- it's up to you. Audiences are invited to come to listen or come to tell as folks from all corners of Columbus offer their stories live on stage! Held at Wild Goose Creative's warm, intimate space, this night of tales occurs on the 3rd Thursday of every month. Doors open at 6:30 pm, show starts at 7:00 pm. Please arrive early if you want to tell, as we generally only have room for a limited number of tellers, and the sign-up sheet has a tendency to fill up fast. Formed around the idea that people need stories--they're what hold and draw us together--SpeakEasy celebrates the strangeness and commonness of being human. And in a world of smartphones, Facebook, Twitter, and more . . . it gives people a real, breathing, in-person way to connect. The night is geared for true stories of all kinds, taking the best tales told around kitchen tables, in darkened pubs, on the street corner, and at late-night parties and giving them an audience. Speak Easy is also a great outlet for performers, writers, and artists looking to share their favorite stories and perfect their skills. We strongly encourage tellers to please tell the story rather than read it so we keep within the spirit of good storytelling and stay engaged with the audience. All are welcome. Hang around after the show for a drink and build community!

[The Board Walks](http://www.theboardwalks.com/) are for curious people who love deep conversations. If that sounds like you, **bring a thoughtful topic** and join us for a 5-mile walk (10,000+ steps!). **HOW IT WORKS** **Step 1: Bring a topic** Before you arrive, think of **one** topic you want to explore. A question. A thought that's been on your mind. An obsession you want to geek out on. This is your ticket to the event. **Step 2: Circle up & share** We gather in a circle. Your friendly walk host gives a speech to set the tone. Everyone shares: your name, what you're grateful for, and your topic. That's it. 60 seconds. **Step 3: Walk, talk & float** We walk 5 miles. You naturally drift into conversation with 2-3 people at a time, pulled by topics that spark your curiosity. When you're ready to move on, just say: "I'm going to float!" **Step 4: Feel more alive** Two hours flies by. You're back where you started — but you feel different. More alive. More energized. More connected to yourself and others. That's why regulars join 20+ times. *For more details, read our [Orientation Guide.](https://www.theboardwalks.com/orientation)* **HOW TO BRING A GREAT TOPIC** A great topic = something you're genuinely curious about. Recent topics include: * "What are you passionate about right now?" * "What makes a good friend?" * "What's a belief you used to hold that you've completely changed?" * "How do you want to be remembered?" * "What would you do if money wasn't a factor?" Think of your topic like the dish you're bringing to our conversational potluck. If everyone brings an A+ dish (i.e. energizing, uplifting, expansive), we'll all walk away feeling lighter and brighter. **WHAT TO EXPECT** This isn't a fitness event with casual chitchat. It's a walking think tank where we explore life's big questions together, beyond small talk. *If you're looking for light banter or a standard networking event, this probably isn't the right fit.* But if you crave depth, genuine connection, and conversations that make you feel alive? You'll love it here. **FAQ** * Wear casual athletic attire and sneakers. It's a long walk! * We have multiple first-timers at each event. We work hard to create a welcoming, inclusive, clique-free space. * We welcome people of **all** ages, backgrounds, and industries who align with the [intention](https://www.theboardwalks.com/ground-rules) of this space. * Rain or shine, we've been out here nearly every week since July 2022. If the event is cancelled, we'll let you know. * Dogs, babies in strollers, parents, and friends are welcome — please text/email them the event link so they can RSVP and prepare a topic! **LOGISTICS** * If you'll arrive over 10 minutes late, we suggest skipping the event. It's hard to find us once we start walking, and your host can't answer messages during the event. * This walk is designed for everyone to *move together at the same steady pace* (about 20 min/mile). This format works best when the whole group moves in unison. If you have mobility limitations, we kindly encourage you to find an event better suited to your needs. * Read our [Orientation Guide](https://www.theboardwalks.com/orientation) for full details. * If you enjoy the event, send **[this](http://www.theboardwalks.com/)** to a friend or sign up for our **[newsletter](https://theboardwalks.beehiiv.com/)**. We're in multiple cities with more on the way. 🤠👋 **IF YOU WANT TO GO DEEPER...** [The Board](https://stan.store/ellebeecher/p/the-board) is the next step: a high-trust collective for renaissance people devoted to creating, connecting, and building lives that light us up. * This is a global HQ for people who crave big talk, deep connection, and dream collaborations with people across industries. If the walks feel like a spark... The Board is the fire. Apply [here](https://stan.store/ellebeecher/p/the-board).