In this Power BI tutorial, I dive into what’s perhaps a very niche insight. But don’t let that close you off to using this technique — there are plenty of ways to implement this across a range of scenarios. The key is to understand each different part and transfer them across similar elements in your […] The post Discover Where Your Profit Growth Comes From: A Power BI Tutorial first appeared on Master Data Skills + AI ..read more

Here I want to showcase a unique idea around financial reporting, which is allocating results to predetermine table templates inside Power BI. You may watch the full video of this tutorial at the bottom of this blog. After spending quite some time working out how to create these custom templates, I’ve finally devised a strategy […] The post Power BI Financial Reporting: Allocating Results To Templates At Every Single Row first appeared on Master Data Skills + AI ..read more

For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX […] The post Time Intelligence DAX Functions In Power BI first appeared on Master Data Skills + AI ..read more

In this tutorial, we’ll examine an interesting question that was raised on the Enterprise DNA Forum about how to dynamically merge a changing number of columns in a Power Query table. You can watch the full video of this tutorial at the bottom of this blog. This scenario deals with raw data exports that cause […] The post How To Dynamically Merge Columns In A Power Query Table first appeared on Master Data Skills + AI ..read more

I’m going to show you the difference between the Power BI USERELATIONSHIP function and the TREATAS function that are both used when creating DAX measures. You may watch the full video of this tutorial at the bottom of this blog. I got this tutorial idea from a question that was raised on the Enterprise DNA […] The post Power BI USERELATIONSHIP vs TREATAS first appeared on Master Data Skills + AI ..read more

In this tutorial, I’m going to cover a specific technique around Cumulative Total and budgeting information that you might be showing in your reports in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is a very common question in the Enterprise DNA Support Forum. It’s […] The post Showing Cumulative Total Only Up To A Specific Date In Power BI first appeared on Master Data Skills + AI ..read more

In this tutorial, you’ll go through different Power BI design ideas that you can use and implement in your inventory management dashboards. This is the final step when creating a report in Power BI. You need to clean it up so that it gives off a better impression to its users. Previous tutorials have discussed […] The post Power BI Design Ideas For Inventory Management Dashboards first appeared on Master Data Skills + AI ..read more

Here’s a Power BI visualization technique that you can utilize within your reports by using large images in the background. You may watch the full video of this tutorial at the bottom of this blog. In a lot of demos I have created and showcased during the Enterprise DNA webinar series or learning summits, I […] The post Power BI Visualization Technique: Learn How To Create Background Design Plates first appeared on Master Data Skills + AI ..read more

In this tutorial, I will explain how to modify shape maps Power BI visualizations. Shape maps are great for spatial analysis and they go well with Power BI reports and dashboards. They can also be used as a standard map feature. You can watch the full video of this tutorial at the bottom of this […] The post Shape Maps Power BI – How To Create And Repair first appeared on Master Data Skills + AI ..read more

In this tutorial, I show you how you can layer multiple “What If” analysis or scenarios in Power BI, one on top of each other. It takes your analytical output through the roof if you use this technique effectively. You may watch the full video of this tutorial at the bottom of this blog. As […] The post Advanced Analytics in Power BI: Layering Multiple ‘What If’ Analysis first appeared on Master Data Skills + AI ..read more