Phillip Burton

In this article, I am going to answer:

So, what is Business Intelligence, and additionally, why should you use dashboards?

You can create more than one dashboard based on the same data but with different focuses. For example, you can have a dashboard for both the finance and marketing departments.

Tableau Data Analyst/Specialist Desktop Certification

Last Updated October 2021

Bestseller
  • 172 lectures
  • Beginner Level
4.6 (7,762)

From beginners to skills needed for Data Analyst or Desktop Specialist certifications. Tableau 2021, 2020, 2019 | By Phillip Burton

Explore Course

You can show hidden data visualizations (“vizzes”) if needed. This can help to create a more detailed yet still self-service Business Intelligence.

Loading data and creating reports

So, how easy is it to create these dashboards? It’s very easy in Tableau, which is a Business Intelligence tool. First of all, you need to open your data sets in Tableau. These data sources may include:

Complex data or big data may need extra processing in Tableau Prep before loading it into Tableau Desktop. The Tableau Creator license includes this program.

You can create many data-driven reports, each containing a single viz once you load the data.

In the viz above, I have created a bar chart using House Price Data for six regions in England. From this viz, you can see:

Want to know how to create these vizzes? My previous article, “What is Tableau? Understanding an Analyst’s Most Important Tool,” shows you how you can create vizzes in a few minutes.

Creating dashboards

These individual BI reports can give you some insights, but only into one aspect of your business at a time. By combining your vizzes, you can create high-level dashboards.

BI dashboards will generally combine many different types of visualizations, such as:

You can also add reference lines on your vizzes, such as:

You should first of all set up an initial draft of your BI Dashboards in Tableau. If you concentrate on what message you want your dashboards to give, you can then decide how to show that message through your dashboard. If you can go through such a process, then you will be able to have a coherent message.

It is important to pre-design your dashboard, even in your head, so that you can enable your vizzes to flow well. To help with this are these options in the Dashboard pane:

Filtering and highlighting

Your dashboard looks at your data at a company- or department-level. You can then allow the end-user to focus on specific items — this can make it a powerful BI dashboard. We call this:

Both of these allow you to create interactive dashboards.

There are two main ways of creating a filter. In the dashboard that I made above, the right-hand side shows my filters from the individual vizzes.

If I click on or alter the settings for any filter, the dashboard would react. For example, if I want to concentrate on the years 2000 to 2009, I could adjust my date slider.

The vizzes have changed to show the years 2000 to 2009.

I can also set up a viz to act as a filter by clicking on it and then clicking on “Use as filter.”

With this enabled, any click with this viz changes the rest of the dashboard. Let’s click on Greater Manchester in the year 2002.

Now my focus is on just one year for one region. However, the dashboard is not as useful as before because the two bottom vizzes show only one data point. It would be more useful if I could drill down to a per-quarter or per-month view. You can add this drill-down functionality by using Actions. To do this:

If I now click on a bar in the year 2002, Tableau opens a different dashboard. This dashboard is designed to focus on a single year and includes a bar chart showing different quarters within the year, together with a scatter graph.

This drill-through functionality can make it easier for the end-user to explore the data and then make business decisions.

Publishing your BI Dashboard

After you have created your dashboard, you can publish it on a cloud-based server. There are several places to do this:

With either paid-for service, you have the option to publish BI dashboards on a secure cloud-based server. You can also add security so that only certain employees can use it.

Top courses in IT & Software

[NEW] Ultimate AWS Certified Cloud Practitioner – 2021
Stephane Maarek | AWS Certified Cloud Practitioner,Solutions Architect,Developer
4.7 (63,659)
Bestseller
TOTAL: CompTIA A+ Certification (220-1002).
Total Seminars • 750,000+ Enrollments, Mike Meyers
4.7 (13,619)
Learn Ethical Hacking From Scratch
Zaid Sabih, z Security
4.6 (98,952)
Bestseller
Ultimate AWS Certified Solutions Architect Associate 2021
Stephane Maarek | AWS Certified Cloud Practitioner,Solutions Architect,Developer
4.7 (97,582)
Bestseller
AZ-104 Microsoft Azure Administrator Exam Certification 2021
Scott Duffy • 600.000+ Students, Software Architect.ca
4.6 (25,682)
Bestseller

More IT & Software Courses

Next steps

I hope that you have enjoyed reading this article. 

Would you like more information on how to create your data reports, dashboards, and more? Then why not join me in my Tableau course on Udemy. It follows the requirements of the official Tableau certification. After completing the lessons, and with a bit more practice, you could enter (and hopefully pass) the official Tableau exams. Wouldn’t that certification look good on your CV or resume?

The principles behind creating dashboards are similar in other Business Intelligence programs. For example, you can use the principles in this article with Power BI as well. For more information about both Power BI and Tableau, please see my previous article, “Power BI vs. Tableau – Which One Should I use?”.

Whatever you choose to do, I hope you will look at creating dashboards for yourself and your company. In just a few minutes, you can make complex data look easy to understand.

Thank you very much for reading this, and keep learning!

Page Last Updated: February 2021

Top courses in Tableau

Tableau 2020 A-Z: Hands-On Tableau Training for Data Science
Kirill Eremenko, Ligency Team
4.6 (72,046)
Bestseller
Tableau 20 Advanced Training: Master Tableau in Data Science
Kirill Eremenko, Ligency Team
4.7 (13,707)
Tableau Data Analyst/Specialist Desktop Certification
Phillip Burton
4.6 (7,762)
Bestseller
Tableau Desktop for Data Analysis & Data Visualization
Maven Analytics, Dustin Cabral | Tableau & Data Visualization Expert
4.6 (1,385)
Tableau Prep for Business Intelligence
Maven Analytics, Dustin Cabral | Tableau & Data Visualization Expert
4.5 (191)
Tableau 2019 + Tableau 2018: Tableau CA Certification 2020
Emin Cengay | Tableau Developer
4.7 (1,034)
Highest Rated
Tableau Desktop : Hands-on Dashboards + SQL for Beginners
Dev Bhosale | Tableau AWS Azure GCP Certified Instructor
4.7 (56)
Highest Rated

More Tableau Courses

Tableau students also learn

Empower your team. Lead the industry.

Get a subscription to a library of online courses and digital learning tools for your organization with Udemy for Business.

Request a demo