Category: Business Intelligence

New vs Existing Customers – Advanced Analytics w/DAX

If you’re an online retailer or a high frequency sales operation, then understanding your customer base, like if they are new customers or existing customers, is a really high quality insight. You’ll want to dive into this type of analysis because you need to evaluate if most of your sales are attributed to people who

Continue reading

Managing Seasonality in Budgeting Analysis – Advanced Power BI

Completing budgeting analysis in Power BI is unfortunately just not that easy. What I’m going to go through today is possibly the most advanced technique that you can get to with budgeting as we need to incorporate some seasonality into our budgeting numbers. I detail this quite extensively in the video tutorial, so there’s lots

Continue reading

Budgeting Scenarios In Power BI Using DAX

So we’re going to really dive into some problem-solving here. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I want to do initially.

Continue reading

Latest Course Release – Advanced Analytics In Power BI

You can view more about this course here – Advanced Analytics in Power BI To review the first course module, check out this link – Anomaly detection techniques for Power BI To round off a huge 2017 I’m releasing a final course into Enterprise DNA Online. It’s been a significant year for content development at

Continue reading