SquaredUp logo
  • Product
    • Community Edition
      Dashboard any data for free
    • Azure Edition
      Take control of Azure costs and performance
    • SCOM Edition
      Unlock insights from Microsoft SCOM
    • Compare Editions
    • Integrations
      Bring together data from anywhere
    • Dashboard Gallery
      Find inspiration and real-life dashboard use cases
  • Pricing
  • Resources
    • Blog
      Discover tips, tricks, news, and more
    • Learn
      Master SCOM and Azure Monitor with help from our experts
    • Webinars and Events
      Sign up for the next event or watch a replay on-demand
    • Downloads
      Download the latest releases, tools, scripts, and more
    • Datasheets
      Get concise SquaredUp overviews to share with the team
    • SCOMathon
      The hub for all things SCOM
  • Support
    • Support Portal
      Search for answers or submit a request to our experts
    • Community Answers
      Connect with a community of experts to ask questions and find answers
  • Company
    • Company
      Find out more about SquaredUp’s vision, people, and values
    • Careers
      Join our growing team – we’re hiring!
    • Customers
      Learn how our customers are taming complex IT landscapes
  • Download now
  • Dashboard Fridays
  • Excel
  • M365/O365
  • Web API
  • HTML
  • Performance
  • Scalar
  • Status
  • Business
  • IT
Dashboard Gallery

Excel Business KPIs Dashboard

The Management Team at SquaredUp needed a dashboard to visualise key metrics related to the different sectors of business to keep an eye on the KPIs and track targets.

This dashboard keeps track of the different key targets set for the business over three time periods and highlights variations. The dashboard also plots the trend on different values hit over the time and helps identify fluctuations.

Adam Kinniburgh , SquaredUp

Challenge

Each department has their own KPIs and their own way of tracking them. They also have their own tools, so it was difficult to present the data to the management and the data correlation was manual and hence prone to errors.

Collating reports from multiple tools took too much time and data visualization was scattered.

Solution

Leveraging the REST APIs that the different tools exposed to read data, SquaredUp was able to bring all the data in the same place and build visualizations on top.

Using labels, they also defined thresholds for indicating different health trackers, to help identify which KPIs were achieved and which ones needed attention.

Dashboard walk-through

The dashboard uses SquaredUp’s WebAPI tile to read from an Excel file on an internal SharePoint folder using Microsoft’s Graph API.

Divided into 3 time periods – last month, last 3 months, and year to date – it compares the corresponding value with the target value and, based on a threshold, assigns health colours to the tiles.

On far right, it also plots the trend graph to help easily identify fluctuations.

NOTE: The data in this dashboard is mocked up but the principle is the same for the actual dashboard.

GET STARTED TODAY

Zero to dashboard hero in 60 seconds

Start now with hundreds of customizable dashboards.

  • Sites
    • Support
    • Download
    • Community Answers
  • Quick Links
    • Webinars and Events
    • About Us
    • Careers
  • Small print
    • Privacy Policy
    • Terms and Conditions
    • Staying COVID-19 Secure
UKAPR 2022-APR 2023

© SquaredUp 2022