💹

Dashboards

Previously, you learned how Data Engineers collect and store data in a database. Now, you'll learn how Data Analysts Visualize and explore that data using dashboards.

What is a dashboard?

A dashboard is a set of metrics, usually in the form of graphs, that update on a schedule. Some dashboards can update in real-time, but others update daily or weekly.

Let's discuss some common dashboard elements

Tracking a value over time

One of the most common dashboard elements is a time series that tracks a value over time. This type of plot shows both the current value of a quantity and enough historical data to give context to that value.

In this example, we see the number of monthly active users over a ten month period.

Tracking composition over time

This chart gives additional context to the previous monthly active users chart: it tells us the percentage of those users that come from different sources, such as paid ads or social media. The total percentages will always add up to 100 percent; that's why all of the bars are the same height.

With stacked bars, we can easily notice trends, such as the increase in traffic from Blogs in March & April.

Categorical Comparison

Another common dashboard element is a categorical comparison using a bar chart. Here, we see the average number of minutes spent on a webpage by different groups. Whereas, time series provides a historical basis for comparison, bar charts compare different groups during the same time period.

When you see a chart like this, it's always important to ask what data is included. In this case, we'll add a label indicating that this data is from the past 30 days.

Highlighting a single number

Sometimes, we want to highlight just one number. In this case, we want to know how many people visited our website today. Even when showing just one number, it can be helpful to give a small amount of context for comparison, such as how today's value differs from yesterday's.

Displaying Text

Generally, we avoid adding tables to dashboards because graphics are easier to read. Display text is an exception.

For example, displaying a small number of comments can be a great way to add some qualitative data to an otherwise quantitative picture.

Where can we build a dashboard?

There are many ways of building dashboards. Some are built with spreadsheet tools like Excel or Google Sheets. Others are built using specialized Business Intelligence tools, such as Tableau, Power BI, or Looker. For something really customized, some analysts using programming languages like R Shiny or d3.js

All of these tools are a great way to get fast, accurate dashboards. It's best practice to ensure that everyone in the organization uses the same one so that there is no confusion about where to go for dashboard information.

Requesting a dashboard

Is a dashboard the correct solution?

Before issuing a request, be sure that a new dashboard is actually the best solution to your problem. Dashboards are required when you will need to access the information many times, that information needs to be updated frequently, and the information that you need will always be the same.

Once, you're sure that you need a dashboard, make your request as specific as possible. Do you need a single number of comparison over time? What time frame is relevant to you? Be sure to include your use case; this can help a data analyst choose the type of dashboard that is best for you.