Data Visualization

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)

Dear ACM Chicago Chapter members, On March 4, we are hosting a hybrid event at AON Center (200 E. Randolph, suite 200). Please note that this venue requires the attendee list to be submitted 48 hours before the event starts, so the RSVP will close then. Please remember to bring your government-issued ID to present to building security. You can also join virtually using the Zoom link below: [https://acm-org.zoom.us/webinar/register/WN_Ky5PEBMTSaiGQ6Q42-qrNA](https://acm-org.zoom.us/webinar/register/WN_Ky5PEBMTSaiGQ6Q42-qrNA) **Talk Title:** Effective Data Visualization **Speaker:** David Giard, Partner Solution Architect at Microsoft, **Tald Abstract:** We spend much of our time collecting and analyzing data. That data is only useful if it can be displayed in a meaningful, understandable way. Yale professor Edward Tufte presented many ideas on how to effectively present data to an audience or end user. In this session, I will explain some of Tufte's most important guidelines about data visualization and how you can apply those guidelines to your own data. You will learn what to include, what to remove, and what to avoid in your charts, graphs, maps and other images that represent data. **Agenda (Central Time):** * 5:30 – 6:00 PM — Networking * 6:00 – 6:05 PM — Introductions * 6:05 – 6:45 PM — Talk * 6:45 – 6:55 PM — Q&A * 6:55 – 7:00 PM — Adjournment * 7:00 – 7:30 PM — Networking Refreshments will be provided. Hope to see you there!

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

NFT's are here to stay folks! This is a group for like minded people interested in understanding, leveraging, using, creating for, profiting from, trading too i suppose, NFT's.. everything around them, complexity, fear and exploits, best practices and more. **PLUS** This group will talk AI ART tools, techniques, artists, video, audio, prototypes and more in the AI assisted production space- ART specifically, but we can get into any aspect of some of the cooler things happening in AI in general.

Our monthly PHP meetup. A virtual shindig courtesy of Zoom. Check back here for the details around 6:15 pm

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