Havens Consulting
Let's discuss five reasons why you'd want to consider hiding columns from the report view in Power BI. All of these suggestions are centered around curating the Fields list during report development for both yourself, and any other potential business users or analysts who might want leverage your model for reports in the Power BI service. Tune in to learn more!
Video by: Reid Havens
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
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.
