Business Intelligence Dashboards

Dashboards built from each team's real questions, with named owners, reconciled numbers, fast load times and a monthly prune of the charts nobody opens.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Business Intelligence Dashboards, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

199

Starter tasks

📊 Data & Analytics

Business Intelligence Dashboards

Building dashboards in BI tools that answer real questions for each team, kept fast, trustworthy and pruned of charts nobody reads.

  1. Dashboard estate inventory with owners and view dates
  2. Ninety-day dashboard usage baseline
  3. Business questions register for each team
  4. Named owner and steward for every shared dashboard
  5. Workspace folder structure and naming convention
  6. Certified and exploratory content tiers
  7. Dashboard style guide for colours, fonts and number formats
  8. Access groups and permission model for the BI workspace
  9. One-page brief before any new dashboard
  10. Reconciling headline dashboard numbers to source systems
  11. Monthly prune of unused dashboards
  12. Weekly health check of certified dashboards
  13. Quarterly dashboard review with each owning team
  14. Data freshness labels and refresh schedule upkeep
  15. Dashboard change log and monthly release notes
  16. Load time watch on the twenty most used dashboards
  17. Quarterly BI licence and seat review
  18. Dashboard feedback channel and weekly triage
  19. Scheduled report and subscription clean-up
  20. Correcting a dashboard that showed a wrong number
  21. Choosing the right chart for each dashboard tile
  22. Layout and visual hierarchy on a single screen
  23. Filters, parameters and drill-through design
  24. Calculated fields in your BI tool's formula language
  25. Performance basics of extracts, live queries and aggregations
  26. Accessible dashboards for colour-blind and screen reader users
  27. Comparisons, targets and annotations on headline tiles
  28. Consolidating duplicate revenue dashboards into one
  29. Rebuilding the slowest certified dashboard
  30. Finding out why people export dashboards to spreadsheets
  31. Replacing a manual slide-deck report with a live dashboard
  32. Shared datasets behind dashboards instead of per-report logic
  33. Phone layouts for dashboards checked on the move
  34. Self-explaining dashboards with built-in definitions
  35. Launching a new team dashboard with a walkthrough
  36. Fiscal year rollover for dashboards
  37. BI tool release test pass
  38. Keeping dashboards running through a source system migration
  39. Annual dashboard user survey
  40. First dashboard for someone new to the BI tool
  41. Commissioning a dashboard for your team as a manager
  42. Inheriting a dashboard estate as a new BI lead
  43. Re-cutting dashboards after a team reorganisation
  44. Wall-screen dashboard for an operations or support floor
  45. Handing over your dashboards when you change role
  46. Dashboards as code with version control and review
  47. Row-level security for regional and client data
  48. Customer-facing embedded analytics
  49. Migrating dashboards to a new BI tool
  50. Automated regression tests for critical dashboards

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Dashboard estate inventory with owners and view dates

Before building anything new, list what already exists. Most BI workspaces older than two years hold several hundred dashboards, many of them copies, and nobody can say which version finance actually uses. An inventory of every dashboard with its owner, data source, last edit and last view is the map every later decision in this area depends on.

First tasks

  • Find where your BI tool reports content usage, such as an admin portal or audit log
  • Export the full list of dashboards with creator, folder and data source
  • Add last viewed and last edited dates to each row
  • Tag every dashboard keep, review or likely retire

Ninety-day dashboard usage baseline

Usage figures settle arguments that opinions cannot. Counting distinct viewers and views per dashboard over the last ninety days shows which handful carry the business, which are opened once a quarter and which have not been opened since their author left. Taking the baseline now gives a before figure for every pruning and consolidation project that follows.

First tasks

  • Check how many days of usage history your BI tool keeps by default
  • Pull views and distinct viewers per dashboard for the last ninety days
  • Rank dashboards by distinct viewers and name the top twenty
  • List every dashboard with zero views in the period

Business questions register for each team

Dashboards built around whatever data is available end up as walls of charts; dashboards built around questions get used. Sitting with each team for half an hour and writing down the five to ten questions they need answered each week, and what they would do differently with each answer, gives every future dashboard a reason to exist and a test it must pass.

First tasks

  • List the teams that use dashboards and one contact in each
  • Book a thirty-minute question session with each team contact
  • Record each question with the decision it informs and how often it comes up
  • Match each question to an existing dashboard or mark it unanswered

Make it yours.

Install Business Intelligence Dashboards, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.