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!

Share This:
Twitter
Facebook
LinkedIn

Stay up to date with the latest customer data news, expert guidance, and resources.

Iteration and Error Handling in M Query

All iteration roads in M Query eventually lead to the List.Generate function. In strengthening our data manipulation skills through Power Query, we absolutely need this looping function.

More Resources

Trusted By Over 6 Million End Users​

Industry leaders and over 6 million end users choose SkyPoint as their comprehensive and compliant Modern Data Stack Platform. A Gold Certified Microsoft Partner, SkyPoint Cloud turns siloed customer data into connected customer experiences.