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
Many reporting requests have a common starting point - existing reports.
These might be Excel workbooks, large PowerPoint slide decks, or bundles of reports scattered across other technologies. For one reason or another, these reports need to be re-made, re-designed or migrated over to Power BI. “They need to be in Power BI, and they need to be there now.” The business has urgent needs, and there’s pressure from management to see the result. But where do we start? What do we make? Defining the right requirements is essential if we want to make an effective report that is used and delivers value. Otherwise, it will just be collecting digital dust & cobwebs in an abandoned app…
Kurt will discuss three common approaches to collecting reporting requirements, arguing in favor of the third approach - working iteratively & collaboratively with business users.
Kurt Buhler is a Power BI data goblin, speaker, and consultant. Kurt discovered his passion for working with & analyzing data during his doctoral research in Biomedical Sciences. Since then, he has worked as a consultant and bridge-builder between IT & Business in organizations to derive value from their data using actionable visuals and solutions. He advocates a design-thinking, user-centric approach to data projects to ensure solutions meet business needs and improve effectiveness. He's a lover of cats, tabletop roleplaying games, and all things Power BI & data related.
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 & Gustaw Dudek
Learn how to create a customized bar chart (styled) visual with formatted totals using a native matrix visual in Power BI. This technique will leverage conditional formatting and DAX to reveal the hidden gems of the matrix visual!
Gustaw Dudek works as Head of Business Intelligence at the Polish Company (Enterium). He has multiple years of experience in the field of data analytics and business intelligence. In addition he's one of the resident Enterprise DNA Experts, having created multiple showcase reports for various EDNA contests. Despite of designing most of showcase reports in dark-mode, Gustaw is a huge advocate of IBCS chart standards and really enjoys exploring both the art and science of report design.
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.
