Exploring my Mailchimp data in Power BI

This is my first post in my new series detailing how I use data and Power BI to grow my own business. What better way to showcase how amazing Power BI is than to show everyone how I use it every day to increase my own community profile and of course revenue, as that’s what

Continue reading

Check out latest Power BI showcase submission

Understanding your customer better. (Play with demo here) Review how sales have performed dynamically in any time frame and also compare that to similar time frames historically.

Isolating the Top or Bottom Outcomes with DAX

Today we are going to focus on a technique used in the ‘Time Intelligence’ demo in the ‘Scenarios’ section of the Enterprise DNA showcase. Being able to show dynamically the top or bottom outcomes of any calculations we do, say for instance sales, profits, margins, costs etc. is a great way to highlight key business

Continue reading

Dynamically compare current totals to last years totals

Latest post out on the Power BI blog out now! Comparing totals this year to last year is a pattern you will use many times over with Power BI. It is always a good benchmark when looking to analyse how a certain metric is performing in the business. Click here to jump over to the

Continue reading

Time Intelligence examples

Time intelligence is the most typical type of analysis you do. That’s why DAX has a section of calculations specifically catered toward ‘Time Intelligence’. Seeing calculations and comparing calculations over time is very common no matter what industry or function that you work in. I thought it would be a good idea to run through

Continue reading