1. Why Build Dashboards?

 
Subtitles Enabled

Sign up for a free trial to access more free content.

Free trial

Build Your First Dashboard

11 lessons , 3 exercises

Preview Course

Overview

Dashboards are a convenient way of extracting insights from data. Find out why and how companies build dashboards in this lesson.

Summary

  1. Course Case Study (00:28)

    In this course, we’ll build a dashboard for BloomAcre Software. They sell their product through annual subscriptions to enterprise customers. The company is rapidly growing. Our dashboard will use a sales data set to help the company’s executives generate insight on the company’s performance.

  2. What is a Dashboard? (01:07)

    A dashboard is a single screen interface providing information about a company’s Key Performance Indicators, or KPIs. This information is usually provided in the form of charts and graphs. They also contain elements like buttons and menus that let people interact with the dashboard.

    Dashboards are used to provide managers with a quick, high-level overview of the business. Dashboards make it easier to spot trends and obtain insights from a company’s data. As a result, they should help a company make quicker and better decisions.

  3. Creating Dashboards (02:08)

    Dashboards can be created using purpose built dashboard tools, like Tableau, Power BI or Qlik. These connect to your data sets in Excel or elsewhere, and let you create insightful dashboards. However, some of these tools can be expensive, or they might feature more tools than you really need. Excel offers an alternative solution that’s cheaper and more flexible, but ultimately less advanced.

Transcript

Data dashboards are one of the most popular analysis tools in business. Managers and company executives demand fast access to summaries and insights from our data, and dashboards are the tool of choice for performing this task. In prior courses, we learned how to use tools such as VLOOKUPs, pivot tables, and other techniques to extract valuable information from raw data. In this course, we're going to put these learnings to use and create a sales dashboard for a sample company, BloomAcre Software, which sells its product through annual subscriptions to enterprise customers. The company has 15 sales managers that serve around 4,000 customers across the US. BloomAcre has experienced rapid growth since its founding four years ago and expects to continue this growth in 2013. The finished dashboard that we will create for BloomAcre will extract the information from a raw sales dataset and look something like this.

Before we get started on this case study, let's discuss dashboards in a bit more detail. We'll start off with a question you might be asking yourself, what is a dashboard? Well, dashboards are easy to read, single screen interfaces that show the key performance indicators, or KPIs, for a business unit. As in our case example, they often graphically show the information in the form of pie charts, and bar charts, and contain buttons so that a user can interact with the dashboard. Another question you might be asking yourself is, why do companies use dashboards? Well, dashboards provide managers with a quick, high-level overview of the business, and make it easier to spot trends and obtain insights from the data. As a result, dashboards can save managers and teams a lot of time, and improve the quality of their analysis, which ultimately leads to better decision making, and better results for the company. So, how are dashboards normally built? In this course, we're going to build our dashboard with Excel, but there are a lot of other tools that you can use to build dashboards. Let's first look at some of the more expensive bespoke software packages, such as Tableau and Qlik, that allow you to create insightful dashboards either from simple datasets in Excel, or by connecting these programs directly to your server. Compared to these sophisticated tools, Excel offers a cheaper, more flexible, but ultimately less advanced dashboarding solution. However, for many analysts who are very familiar with Excel, and without the budget to purchase additional software products, it's pretty much ideal. I should also mention that Microsoft's latest version of SharePoint also enables analysts to create complex dashboards directly from the data stored in a database or server. With this introductory lesson out of the way, we'll start our dashboarding process in the next lesson by identifying BloomAcre's sales KPIs.

Excel Excel for Business Analytics Learning Plan
Build Your First Dashboard

Contents

My Notes

You can take notes as you view lessons.

Sign in or start a free trial to avail of this feature.

Free Trial

Download our training resources while you learn.

Sign in or start a free trial to avail of this feature.

Free Trial