Tech Videos2019-08-01T07:39:27-05:00

Wednesday/Thursday – Power BI Technology and More

Every Wednesday & Thursday, we look at a tech topic. This could be a new feature, how something works or how to troubleshoot something within Power BI technology, Reporting Services and Analysis Services.

This may also include the occasional topic relating to the Microsoft Data Platform as a whole, such as SQL Server or an Azure technology. Because of Power BI, there will also be content related to Office 365 and Azure Active Directory.

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/

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 [...]

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 [...]

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 [...]

Go to Top