How to Build a Star Schema Data Model

Ever get frustrated when watching Power BI training videos or reading through best practice documentation because the data sources that you have at work aren’t anything like the pristine data warehouse sources from the video?

This session will provide guidance and tips for building a solid Power BI data model with less than ideal data sources. If you have ever struggled building a data model from super wide, flattened out excel spreadsheets, this session is for you. We’ll start off with some flattened data sources and end up with a star schema that will impress any data warehouse architect!

Prior to building out an Enterprise Data Warehouse as a developer on the Business Intelligence team, Mark Beedle started out as the vlookup/pivot table guy in the Customer Service department. He enjoys a good bourbon, has a big beard, and believes The Office is the greatest television show every created. While his current passion is helping people with Power BI, he’ll never forget his Excel roots!

Portland Power BI User Group

Portland Power BI User Group

The Portland Power BI User Group is a community of people excited about the business analytics tool, Power BI. We believe the platform offers rich possibilities, and we keep pace by sharing our learning and doing deep-dive explorations of topics. We run the gamut from new to experienced users and welcome anyone who shares an interest in data analytics. Some great perks to joining our monthly meetups are networking, knowledge transfer, and community building. We aim to foster a vibrant community that shares success in implementing best practices for Power BI. Complimentary pizza and refreshments are served at every meetup.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?