Análisis de datos con R

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.

Ciao a tutt\*! Let's meet Monday at 6.30pm at the Upper Arlington Library (**Tremont** Branch) in **Meeting Room A** to speak in Italian for 1 hour. Keeping Monday for consistency but we can discuss if there are better days/times/locations!

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.

# **Band and caller TBA** Beginner lesson at 1:30, regular dancing begins at 2:00 pm NOTE THAT WE ARE TEMPORARILY DANCING IN THE AFTERNOON INSTEAD OF EVENING. Dance with us in the afternoon then you can still go out in the evening! **Sponsor: All Soles Contra and Square Dancing, First Unitarian Universalist Church, 93 W. Weisheimer Rd., Columbus OH 43214** WHAT IS CONTRA DANCING? Picture the Grand Ball scenes like you’ve seen in period films such as “Pride and Prejudice”, where the dancers are lined up in long lines, across from each other. That’s English Country Dancing, the predecessor of contra dancing. Now, add moves like “swing your partner” and “do-si-do,” like you’ve seen in square dancing. Set it to fabulous, high energy, live music with fiddles, guitars, percussion and more, alá “Riverdance.” Finally, set the whole scene down in the middle of Woodstock, with a hip, groovy atmosphere, a bit of tie-dye, and hints of counter-culture attitude. THAT’s Contra Dancing! Wear cool and comfortable clothes (you will get warm) and clean shoes that won't mark up our nice wood floor. Be sure to come for the beginner's lesson from 1:30 - 2:00, followed by dancing 2:00 - 430. All dances are taught; we will help you learn! Beginners always welcome, no need to bring a partner. Cost is $10.00 adults, $5.00 ages 12-26. Under 12 free. Free parking in church lot. Please bring your own refillable water bottle.

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

💥 𝐋𝐢𝐧𝐜𝐨𝐥𝐧 𝐒𝐭𝐫𝐞𝐞𝐭 𝐒𝐚𝐥𝐬𝐚 💥 𝐅𝐞𝐚𝐭𝐮𝐫𝐢𝐧𝐠: 💥 𝐋𝐢𝐯𝐞 𝐒𝐚𝐥𝐬𝐚 𝐁𝐚𝐧𝐝: 𝐀𝐥 𝐒𝐨𝐧 𝐃𝐞𝐥 𝐈𝐲𝐚! . 💥 𝐒𝐚𝐭𝐮𝐫𝐝𝐚𝐲, 𝐌𝐚𝐫𝐜𝐡 𝟏𝟒 💥 𝟖 𝐩𝐦 – 𝟏 𝐚𝐦 . 🟣 Salsa, Bachata, and Merengue 🟣 Dancing All Night Long! . 👉 𝐁𝐮𝐲 𝐄𝐚𝐫𝐥𝐲 𝐁𝐢𝐫𝐝 𝐓𝐢𝐜𝐤𝐞𝐭𝐬 𝐍𝐎𝐖 𝐚𝐭: [https://columbussalsadancing.com/live-salsa-band-tickets-early/](https://columbussalsadancing.com/live-salsa-band-tickets-early/) . Lincoln Street Salsa 1717 Brice Rd Reynoldsburg, Ohio 43068 . 🟣 𝐑𝐞𝐠𝐢𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧 8:00 pm – 8:30 pm . 🟣 𝐁𝐞𝐠𝐢𝐧𝐧𝐞𝐫 𝐃𝐚𝐧𝐜𝐞 𝐋𝐞𝐬𝐬𝐨𝐧! 8:30 pm – 9:30 pm . 🟣 𝐎𝐩𝐞𝐧 𝐃𝐚𝐧𝐜𝐞 𝐏𝐚𝐫𝐭𝐲 𝐖𝐢𝐭𝐡 𝐋𝐢𝐯𝐞 𝐒𝐚𝐥𝐬𝐚 𝐁𝐚𝐧𝐝! 9:30 pm – 1:00 am . ✅ Cover Includes Dance Lesson and/or Party! . 👉 𝐁𝐮𝐲 𝐄𝐚𝐫𝐥𝐲 𝐁𝐢𝐫𝐝 𝐓𝐢𝐜𝐤𝐞𝐭𝐬 𝐍𝐎𝐖 𝐚𝐭: [https://columbussalsadancing.com/live-salsa-band-tickets-early/](https://columbussalsadancing.com/live-salsa-band-tickets-early/) . 👉 $𝟐𝟓 𝐄𝐚𝐫𝐥𝐲 𝐁𝐢𝐫𝐝 𝐓𝐢𝐜𝐤𝐞𝐭𝐬 (𝐄𝐧𝐝𝐬 𝟑/𝟏𝟒 @ 𝟓 𝐩𝐦!) . 👉 $𝟑𝟎 𝐀𝐭 𝐭𝐡𝐞 𝐃𝐨𝐨𝐫 . ✅ 𝐍𝐨 𝐄𝐱𝐩𝐞𝐫𝐢𝐞𝐧𝐜𝐞 𝐍𝐞𝐜𝐞𝐬𝐬𝐚𝐫𝐲! ✅ 𝐍𝐨 𝐏𝐚𝐫𝐭𝐧𝐞𝐫 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐝! ✅ Always Other People to Dance With! ✅ Singles, Couples, Beginners, and Pros Welcome! . ✅ BYOB ✅ 18+ . ✅ 𝐐𝐮𝐞𝐬𝐭𝐢𝐨𝐧𝐬? 𝐕𝐢𝐬𝐢𝐭: LincolnStreetSalsa.com 𝐎𝐫 𝐓𝐞𝐱𝐭 𝐓𝐨𝐝𝐝: 𝟔𝟏𝟒-𝟕𝟕𝟒-𝟖𝟏𝟒𝟔 . 👉 𝐁𝐮𝐲 𝐄𝐚𝐫𝐥𝐲 𝐁𝐢𝐫𝐝 𝐓𝐢𝐜𝐤𝐞𝐭𝐬 𝐍𝐎𝐖 𝐚𝐭: [https://columbussalsadancing.com/live-salsa-band-tickets-early/](https://columbussalsadancing.com/live-salsa-band-tickets-early/) .

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