Data Mining

The Fellowship of the Star Schema: Transforming OLTP Data for Power BI One does not simply build reports on OLTP data. Join us on an epic journey from the depths of raw, normalized tables to the shining halls of a well-modeled star schema fit for Power BI greatness. We will demystify the differences between OLTP and OLAP, walk through star schema vs snowflake (and why Power BI has a clear favorite), and show you the compression differences between normalized and columnar storage that will make you never look at an OLTP model the same way again. We will cover the different types of dimensions, when to use them, and how to handle Slowly Changing Dimensions without losing your mind. You will leave knowing exactly how to identify a bad model, how to convert OLTP data into a clean star schema, and how to forge relationships that rule them all. Whether you are a data wizard, a curious hobbit, or somewhere in between, your models will never be the same.

**The Data-Driven Brand: Using Analytics to Shape Perception** Can you use analytics to improve tacos? This being CBUSDAW, we think the answer is probably “yes”, but we’re not sure how to implement or test this theory. For our April meetup we’ve got Sara Kear, CMO of Condado Tacos, to investigate this delicious question. Sara will explore how she blends quantitative data and qualitative customer feedback to shape brand positioning and drive business decisions. We all know that marketing and analytics go way beyond attribution. Sara will show how Condado uses customer insights to inform product and pricing strategy. She’ll also highlight how Condado leverages customer feedback at scale to influence operational priorities, positioning marketing as the voice of the customer across the organization. In the last 12 years Condado has gone from one location in Columbus to 52 locations across 10 states, so we’re guessing there’s more to that growth than really good guac (though the guac probably helps). Ultimately, this talk focuses on the intersection of art and science—using data to inform creativity and build a brand that resonates with customers in a measurable way. **About Our Speaker** Sara Kear is Chief Marketing Officer at Condado Tacos, where she oversees brand, restaurant design, menu and pricing strategy, off-premise including catering, and customer data strategy. Since joining in 2021, she has helped grow the brand from 19 to 52 locations while building a data-driven marketing organization focused on loyalty and customer insights. Condado has since been named to the Inc. 5000, recognized as Breakout Retailer by Chain Store Age, and consistently ranked among FastCasual’s Top 100 Movers & Shakers. 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)

**First meetup of the Columbus AI Engineering group.** We’ll kick things off with a practical, beginner-friendly discussion on: **How LLMs like ChatGPT actually work — and how to build real applications with them.** We’ll cover: * what’s actually happening under the hood (at a high level) * why LLMs behave the way they do (hallucinations, prompt sensitivity, etc.) * how people are building real systems with them today * where things break in practice This will be a **short, informal talk (\~15–20 min)** followed by open discussion and Q&A. Whether you’re an engineer, builder, or just curious about how modern AI systems work, you’re welcome to join. No slides, no fluff — just real conversation about real systems. We’ll hang out afterward and get to know each other.

**We'll have two meetings covering AI - this second one is for Positron** We will review which AI features are linked in for Positron, and how to use them. **Location:** The meetup will be at SPARK's ([https://annarborusa.org/](https://annarborusa.org/)) Ann Arbor site: [SPARK HQ (Ann Arbor)](https://urldefense.com/v3/__https://www.google.com/maps/place/Ann*Arbor*SPARK*Headquarters/@42.2792515,-83.7447708,17z/data=!3m1!4b1!4m5!3m4!1s0x883cae3effe193cb:0x5296a53db2a282bf!8m2!3d42.2792515!4d-83.7447708?hl=en-US__;Kysr!!HXCxUKc!3EEdBNXRJKknP6LCGkZetSuEsdtChFojQnOVitFUC5C0fyilqXEbiMstT9ajBR3Cw-55qoFkrElCjQvjMdTxUw$). There is on street parking, and parking at local structures. **This will be a hybrid meeting - the Zoom session starts at 6:30 PM.** **Time:** The doors will be open at 6:00, with pizza and beverages provided. We will have a meet-and-greet-and-pizza session, and then at 6:30 we'll have a presentation. **Zoom information:** https://us06web.zoom.us/j/86862937929?pwd=woa95D1r85dobjqxQ07NfBLNdTa9hc.1 Passcode: 705462 **If you can't get in, please call me at: 734 223-3307** **Document source:**

**Improving Office in Franklinton** Physical location: Improving Office 330 Rush Alley Suite #150 Columbus, OH 43215 Schedule: 6:00 p.m.: Socialize, eat, and drink. Improving will be providing pizza and beverages. 6:30 to 8:00 pm. Main meeting and presentation(s). Topic: Type Annotations with John Cassidy We meet on the last Monday of each Month. Presentations are given by members and friends of this group. If you would like to do a presentation (small or large) on a python topic, please contact Central OH Python at centralohpython@gmail.com

**Important time note:** Please plan on arriving between 5:30 and 6:00 as the elevators lock after 6 and you'll need to message us and we'll need to come get you. The building address is 4450 Bridge Park The entrance is 6620 Mooney St, Suite 400 **Abstract** Web Forms gave .NET developers a powerful abstraction for building reusable UI controls long before design systems were a thing. Web Components finally bring that same idea to the browser natively. This session explores how the Web Forms mindset translates into Custom Elements, Shadow DOM, and HTML templates. We’ll examine how Web Components enable design systems that work across frameworks, how they differ from server‑driven controls, and why they’re becoming a foundational layer for modern UI. Whether you’re maintaining legacy apps or building greenfield projects, you’ll leave with a practical understanding of how to apply familiar patterns in a modern, standards‑based way. **YouTube Link** TBA

**New Dojo Location!** **Knotty Pine Brewing** 1765 W 3rd Ave, Columbus, OH 43212 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)