Executive BI Framework - Demo

Summary:

This is my interpretation/design for a business Executive Dashboard with a high degree of focus on usability and accessibility to streamline the visuals and reduce the number of required pages.

Pages:

Overview: Highlights best and worst performing months

Location: Hierarchical location tree with YoY, Dynamic Calculation, Ranking, & Quartile evaluation

Customer: Hierarchical customer tree with YoY, Dynamic Calculation, Ranking, & Quartile evaluation

Product: Hierarchical product tree with YoY, Dynamic Calculation, Ranking, & Quartile evaluation

Historical: Tracks multi-year performance (2020–2024) with CAGR trends, regional and product trajectories, and performance heatmaps.

What sets this dashboard apart:
1) Dynamic Calculation slicer (seen at the top left, below page title): This is the primary calculation engine that affect most visuals on each page. 
Allows users to seamlessly switch between standard business metrics and observe/analyze the impact visually.

2) Nested Slicer Bookmarks (slicer icon at top right): A booklet of slicers organized by categories. Enables the entire suite of slicers for each page while having a minimal impact on overall space.

3) Dynamic Time Intelligence slicer (inside Nested Slicer Bookmarks): Fully integrated time intelligence slicer that affects all visuals of each page, ranging from Trailing 7 days, Trailing 12 months, YTD, Full Year etc. Integration of Dynamic Time Intel in conjunction with Dynamic Calculation provides a level of flexible reporting and analysis that few can replicate. 

eyJrIjoiNjY2YTllYmItNjczNy00NDRkLTlmOTctNWUzNDgxMTAxOTA4IiwidCI6IjUxZTIwNTFkLWFiM2QtNDk4Mi04MTFiLWQ2ZjUwZjcxMzQyOSIsImMiOjZ9