Reporting

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.

You can also join the meeting by Conference Call at (518) 263-8851.

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

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

Let’s meet and wander the galleries and enjoy a spring evening out downtown! Meeting place and approx route, tba. *Fearure photo by Chalk Goblin

TBA- We will do lunch before the play too! Tickets are on sale now only $20.