Havens Consulting
Learn how to use Power Query to transform wide single tables into relational models that leverage fact and dimension table design with relationships. This process optimizes the tables for the tabular model in Power BI resulting in smaller file/model size, and faster performance! While aiming towards a star schema design, which works best in Power BI. Tune in to learn more!
Video by: Reid Havens
Understand Star Schema Importance in Power BI
Building Your First Calendar Table
One of the first steps of becoming a M-Code Ninja is to master the few elements in the M Language. When you know the basic elements like lists, records, tables, parameters, and functions, the next steps will be a lot easier. In the session we will go through what these elements are and how and where you can use them in order to become a (M)inja. Through a series of demos Erik will get you comfortable with editing your queries so they can be more dynamic and execute with less lines of code.
Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 60+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He runs the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his wine shop and his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.
Video by: Reid Havens
Part two of two of my videos on creating a Power Query Calendar Table. In this video we’ll see how to create the necessary date columns needed for dependent and independent hierarchies.
Part 1: Creating a Dynamic Range Calendar Table in Power Query
Video by: Reid Havens
Part one of two of my videos on creating a Power Query Calendar Table. In this video we’ll see two methods for creating either a dynamic or relative date range for a calendar table created in the Power Query Editor.
Part Two: Creating a Dynamic Range Calendar Table in Power Query
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
