Open Government Data

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)

The Humanist Monthly Program is our longest running event and still a community favorite. In the old days it used to be called "Going to HCCO" and we still like to think of it as our flagship event. Food and drinks will be provided at the event. Feel free to show up a little bit early to hang out and talk. Our March speakers are Molly Gaines and Zack Parrish, co-organizers of the Secular Education Association: They will share their story of how a small group of Ohio parents grew into a national organization tracking released-time religious instruction and other church–state issues in public schools. The presentation will cover SEA’s early wins and hard lessons, what we’re seeing nationally right now, and how local advocates can play a meaningful role in protecting public education. Attendees will leave with a clearer understanding of the landscape — and practical ways to get involved. Going forward our meetings will be hybrid. You can meet us in-person or attend online Join Zoom Meeting [https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1](https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1) Meeting ID: 878 3656 4953 Passcode: 760812 One tap mobile +19292056099,,87836564953#,,,,\*760812# US (New York) +13017158592,,87836564953#,,,,\*760812# US (Washington DC) The formal presentation will start at noon

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

Join membersrs of the Central Ohio UX and digital design community for a casual monthly breakfast.

**New Dojo Location!** **Draft Day Columbus** 1130 Dublin Road Columbus, OH 43215 We're going to try a new dojo location for a few weeks and see how it works Dojos are informal Python group study sessions where everyone interested in Python gathers to learn about Python, help others with Python, or just hang out. Everyone is welcome from Python beginners to experts. Bringing a laptop is encouraged (we'll have extension cords and power strips). If there's something you want to learn leave a comment on this invite so we can plan ahead. We're looking for topic suggestions and people interested in presenting at our monthly meetings. To this end we've set up a survey form at [https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc](https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc)