01-20-2023 08:23 AM
Management often asking, “How are we performing? can be a question that cascades into a series of further questions, spinoffs and investigative research. This is especially true for globally minded companies.
I have Build a report that addressed this kind of exploration.
This report is meant to provide data-driven decision making, while emphasizing user-flexibility and visual analysis.
About dashboard -
A dashboard is most valuable when you immediately understand what you can do. I looked into what attributes that can be influenced by the company:
- What we are selling (products)
- When we are selling (year)
- Where we are selling (country)
- How we are selling (order type)
I made this dashboard into two layers of dynamic parameters.
This was done with a Top 5/Bottom 5 measure that reflects whatever measure the user has selected at the top of the dashboard. This was executed within DAX. The question I wanted to be able to answer was “What is my [Top/Bottom] products by [Value]?” in one, simple, clean visual.
I was inspired by @EnterpriseDNA 's wonderful blog post on Dynamic Visuals, within Powerbi
link for Blog about dynamic visuals - Dynamic Visuals
Overall, with the combination of the custom visuals, and dynamic parameters, I created a clean dashboard for analytical insights that's also a pleasure to interact with.