Bootstrap

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.

* Second ever book club! April meet up. All are welcome. * The book will be Play Nice by Rachel Harrison (determined by votes from March Book Club. Let me know if you’d like a free digital copy of the book) * This event will be at the main library, meeting room 1B, the location will not be changed for this event due to the number of people attending, we will just add more chairs if needed! * Feel free to come whether or not you’ve started or finished the book ◡̈ * Small snacks will be provided. You’re welcome to bring your own snacks & drinks too! Starting in June I will try to keep future book clubs at the Dublin Library. Now that I understand their reservation system, I will be on top of it with booking that location as soon as the date is released for the month. Thanks for your understanding with the varying locations in the meantime.

Some trained COUNT volunteers work together once a month at RMH (http://www.rmhc-centralohio.org/volunteer.php) as Housewarmers (usually on the 1st Sunday from 1 – 5 PM). Some schedule other shifts at their convenience. You may try this out with less fuss by following a "Fast track" or go through the normal process. Fast track • Arrange a time to shadow a COUNT volunteer. Call Dave Nohle at 614-268-9558 (cell). • Show up and try it out. • Complete application, etc. later. Normal process • Complete an online application (http://rmhc-centralohio.org/volunteer/). • Attend orientation in advance. • At orientation you will complete forms agreeing to keep family/patient info private and allowing a background check and tour the facility. • Complete one training shift. Daily shifts are: morning 9 AM - 1 PM, afternoon 1 - 5 PM and evening 5 - 9 PM. • Schedule shifts online using the on the RMH scheduling system (http://www.volgistics.com/ex/portal.dll/?FROM=32895). The Ronald McDonald House (RMH) provides housing and meals for families with sick children. The Columbus RMH is the largest in the world with 137 rooms. COUNT has been volunteering there since May 2014. Housewarmers work with RMH guests to provide a home-like environment - greet, assist with family needs, answer phones, give tours, assist with checkin/checkout, prepare guest rooms after checkout, clean facility, laundry, restock supplies and staff the front desk. RMH Housewarmers volunteer at least one four-hour shift a month. All Housewarmers must complete an application and agree to a background check before they can be full fledged volunteers.

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

Pay attention! We’re delaying a week for those of you who may be on Spring break and/or celebrating the holiday. Ok, no pancakes, but waffles-a-plenty. Join the local UX and Digital Design community for a casual monthly breakfast. Look for us upstairs!