Tag: Advanced analytics

Compare One Sale Versus The Last Sale (No Time Intelligence)

In this unique example, I will show you how you can compare a sale, on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every single day or if you are looking at a particular customer or a product and you want to

Continue reading

How To Calculate Actual Results To Budgets Per Product – Power BI & DAX

In this advanced video tutorial which is a breakout of a budgeting workshop that was part of the Enterprise DNA webinar series, I am going to run through how you can utilize some advanced functions inside of Power BI like CALCULATE, ALLSELECTED and SUMMARIZE. By using all the functions in combination we are able to

Continue reading

How To Create Budgets Which Have Seasonality Adjustments – Power BI Technique

We’re going to get advanced today around budgeting in Power BI. Occasionally, you will not actually have some unique budgeting or forecasting data and you need to create it. Most forecast or budgets will likely be created based on historical results in some way. You might do something very simple, like finding the results from

Continue reading

Showcasing Deviations & Trends With Power BI Using DAX

Recently during an Enterprise DNA webinar series session, I dived into how you can showcase deviations in your data in a compelling way. It’s all about setting up compelling visualizations and making sure that we have our results calculated correctly. This is what this video tutorial is all about. I want to showcase how you

Continue reading

Analyze Margin Changes Overtime – Analytics with Power BI and DAX

Through this really unique and specific example I’m going to dive into how you can combine lots of the techniques that I’ve described in many tutorials and posts in the past. These are techniques like Measure Branching, Trend Analysis, and DAX formula combinations. What we are going to do is analyze the changes to profits

Continue reading