fbpx

Why Power BI loves a Star Schema

Are you using a flat table in your Power BI report? You may be missing out! Patrick explores what a STAR SCHEMA is and why you should be using it. Guidance doc: https://docs.microsoft.com/power-bi/guidance/star-schema DAX.tips: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/

Why Power BI loves a Star Schema2021-02-24T08:47:17-05:00

Best Practice Analyzer in Tabular Editor for your Power BI Dataset

Do you work on your Power BI dataset or data model? Are you following best practices? Patrick walks you through a best practice analyzer set for Tabular Editor, from Michael Kolvasky, that can help you improve your data model. Blog post: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance/ Tabular Editor: https://tabulareditor.com/ Download BPA Rules: https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules Michael Kolvasky's Blog: https://www.elegantbi.com/ Feedback: pbibestpractice@microsoft.com

Best Practice Analyzer in Tabular Editor for your Power BI Dataset2021-02-18T07:09:18-05:00

Working with Slowly Changing Dimensions in Power BI

Do you have slowly changing dimensions in your Power BI dataset? Struggling to work with them to get the right values? Patrick walks you through how you can deal with them. Wikipedia https://en.wikipedia.org/wiki/Slowly_changing_dimension Using calculation groups to switch between different dates (SQLBI) https://www.youtube.com/watch?v=kilQrRR04mY P3 - https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/ Download Sample

Working with Slowly Changing Dimensions in Power BI2021-02-17T05:43:50-05:00

🔴 Power BI tips from the Pros – LIVE with Phil Seamark (Feb 13, 2021)

Join us live as we answer your questions about Power BI! 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions as we can. 👉 If you SPAM your [...]

🔴 Power BI tips from the Pros – LIVE with Phil Seamark (Feb 13, 2021)2021-02-09T06:27:45-05:00

Power BI for report consumers and end users (2021)

In this video, we look at Power BI for report consumers, or end users. Those folks that maybe don't author reports, but just view reports within Power BI. We introduce some basic Power BI concepts and introduce you to areas of the Power BI service to get you familiar with the portal. Documentation: https://docs.microsoft.com/power-bi/consumer/

Power BI for report consumers and end users (2021)2021-02-11T05:50:28-05:00

Handling MULTIPLE fact tables in Power BI

You've got multiple fact tables in your Power BI dataset. And, dimension tables for each. Struggling to slice and dice across both? Patrick shows you how to deal with this mess. Understand star schema and the importance for Power BI https://docs.microsoft.com/power-bi/guidance/star-schema

Handling MULTIPLE fact tables in Power BI2021-02-10T07:43:45-05:00

🔴 Power BI tips from the Pros – LIVE (Feb 6, 2021) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority [...]

🔴 Power BI tips from the Pros – LIVE (Feb 6, 2021) (Member Chat 2nd Half)2021-02-03T09:12:13-05:00

New Contoso Sample app for Power BI Embedded

There is a new Power BI Embedded sample application called Contoso Sales. The best part? The source code is available out on GitHub! Adam walks you through the sample application. Contoso Sales Embedded Demo GitHub Repo https://github.com/microsoft/Power-BI-Embedded-Contoso-Sales-Demo Contoso Sales Embedded Demo https://contososalesdemo.azurewebsites.net/ Old Warehouse embedded demo (logins are embedded on the sign in page - [...]

New Contoso Sample app for Power BI Embedded2021-02-04T07:27:41-05:00

Power BI slicers vs the filter pane

What's the difference between Power BI slicers and the Filter pane? The filter panel can satisfy a majority of scenarios. There are a few that it can't. Which Power BI feature will you choose? Slicer Panel: https://www.youtube.com/watch?v=xy9nmSQeUWg

Power BI slicers vs the filter pane2021-02-03T08:52:57-05:00
Go to Top