Power BI Time Intelligence
When you have data that has a date most businesses want to able to see trends from previous years, quarters, months, weeks or days to give context to the measure that they are considering. For example:
- Did we do better than last year?
- What impact has the advertising over the past week had on sales?
- Are costs / revenues / quantity rising or falling?
- What’s our performance compared to the national average?
All of these questions can be answered by using DAX within Power BI to compare time periods.
Below is an example of how you can compare prices in one sector of a market to the national benchmark and understand if your performance is better or worse than the national figures over time.
So what does this tell us? Although the home price is rising in Connecticut, it is still below the national home price and has been since 2015. The use of sparklines, with charts and tables gives a full picture on the differences nationally and within Connecticut.
Most of the reports I work on are commercially sensitive, however, I find this initiative by a group of amazing data evangelists really help develop the visual aspects of Power BI but also give a chance to showcase what Power BI can do.
Keeping current and up-to-date is essential in this industry, and this is an excellent way to do this visually
Any questions, happy to help,
Sue