Pattern Drafting

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!

5:45-7:45 in Conference Room A, Library lower level. Bring your yarn projects, meet new friends. If you plan to attend, please RSVP yes. If you can’t attend, please change your RSVP to no. This helps anyone who is waitlisted and it allows me to have an accurate count of attendees as our space is quite limited. Plenty of parking in the lot, in the overflow lot across the street, and on the street. See you there!

Join us for a casual chat over coffee & tea at Grandview Grind! Come out and meet some new people, enjoy your favorite drink, and make some new friends!

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.