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
Learn how to leverage the functionality of Field Parameters to change the axis of a Report Page Tooltip visual. Based on the slicer selection on the main page, that then updates the visual on the report tooltip page. Tune in to learn more!
Video by: Reid Havens
Video by: Reid Havens
Learn how to leverage the design of report page tooltips to increase your visual performance and decrease page load times, vs using native tooltips!
Video by: Reid Havens
Get a complete step-by-step guide to building out a dedicated calendar table and independent date hierarchy (using DAX) in Power BI. Tune in to learn more!
Date Hierarchy Types
DAX Vs. Power Query Date Table
Power Query Dynamic Date Range
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.
