WW

Meet at Wolfe Park parking lot by tennis courts. We willl walk along Alum Creek trail, through Jeffrey Mansion Park then along Bexley neighborhood and back. Optional lunch at Trolley District.

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.

Over time I'm hoping to organize a hike to all the Franklin County Metro Parks. This is the first one so if you're interested jump in! We'll start with the Canopy Walk, a cool feature of this park. Climb 100 stairs to the top - or take the elevator if stairs aren't your thing. At the top there are a bunch of things to play on - a rope bridge, a fireman pole that we can slide down - and more! About fifteen minutes there and we'll head to the natural trail, Buttonbush, Maple and Beech Trail for 2.2 miles then do a 1.7 mile loop on the paved Greenway Trail. We'll be passing our cars as we transition if you only want to do the first loop, or the second loop. Pace of around 3.5 mph but no one left behind. If there is an interest we can grab lunch nearby afterward.