Elm

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.

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!

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.

Join us again this Saturday for drinks and sweets at this delicious Vegan co-op bakery. Mingle with likeminded Columbus Vegans. We will aim to sit outside after purchasing items and hopefully taking in cooperative weather. Special note on parking: Please try to park along Acton, Richards and/or Chatham streets so as to free up the lot at the back of the building for pick-up orders. Thank you. 😊 Patty Cake offers everything from cupcakes, cookies, cakes, muffins, whoopie pies, as well as gluten free goodies. They also have coffee, oat milk and cold brew

Join us for a two mile trail hike alongside the Brookside Trail at Blendon Woods Metro Park. This trail is largely gravel and does include some hills and stairs. Hopefully we will see some wildlife while hike this scenic trail! Join us!

http://photos2.meetupstatic.com/photos/event/2/a/9/6/600_348310902.jpeg Instructor - Crow, HPS Class fee is $30 at the door or approved exchange RSVP with Advance pay of $25 (discounted) by PayPal on the web or by contacting Enchanted Elements (614) 437-2642. Reservations made directly to Enchanted Elements will be added to the class list manually not online. Private Instruction ~ Closed to the Public ~ Initiated Members Only Please come prepared for ritual. Blessings ~ Crow

Join us for pizza and conversation at Vick’s Gourmet Pizza! 🍕 Good slices, good stories, and plenty of laughs around the table. Come hungry, bring your best conversation, and let’s enjoy a relaxed evening with great company. Extra cheese and extra chatter encouraged! 😄