• Post category:StudyBullet-4
  • Reading time:10 mins read


The best course to learn Tableau and Data Analytics by creating visualizations and dashboards for 6 Different Companies!

What you will learn

Install Tableau Desktop

Develop 6 interactive dashboards and showcase them online to create a great profile of work for your Resume.

Create bar charts, pie charts, and line graphs, scatterplots and much more!

Combine multiple data sources and learn how to connect Tableau to data sources like Google Sheets, Excel, Azure etc.

Create calculated fields with conditional logic.

Format numbers and dates, and add labels, tooltips and animation.

Work with Parameters

Create advanced dashboards and tell a story using storyboards

Description

Are you ready to become an Expert in Data Analytics? Do you want more practical, hands-on experience in Data Visualization and tools like Tableau? Do you want to add a portfolio of dashboards to your resume so you can land your dream job in Data?

This course is for YOU!

In this course you will build 6 separate dashboards for companies that face real business problems . You will learn how to connect to various data sources from Excel files to cloud servers such as Azure. You will also learn how to build interactive dashboards and publish it to Tableau Online! You can link these in your resume to show potential employers what you can do!

You will create dashboards that help a hotel manage a booking system, assist a customer service manager in sorting through thousands of reviews, create a sales dashboard for a very busy sales manager and even put together a quick presentation based on the data in a cloud data warehouse!


Get Instant Notification of New Courses on our Telegram channel.


You will master the skills to become a good Data Analyst and build a solid foundation in understanding the data pipeline.

In this course you will learn:

Create 6 interactive dashboards and publish it online to share

  • Learn how to connect to different data sources such as Excel, Google Sheets and Cloud Servers.
  • Create a variety of charts including bar charts, line charts, donut charts, maps, tables and dual axis charts.
  • Create calculated fields including developing IF Statements.
  • Create sets, hierarchies and groups.
  • Understanding how joins work.
  • Understand Level Of Detail calculations.
  • Create Parameters
  • Make use of the analytics pane including using trend lines
  • How to use dashboard actions and create interactive dashboards.
  • Creating a dashboard which updates daily via google sheets.

By the time you complete this course, you’ll be a highly proficient Tableau user and use all the learning from to course to enhance your career in Data and Analytics.

Projects you will work on:

Park City Peaks Hotel: Park City Peaks Hotel provides hotel accommodation to tourists and business travellers. You will create an interactive dashboard to help the hotel manager analysing guest and booking data.

GreatFit: Greatfit is an online e-commerce store that sells ladies clothing. Customers generally leave reviews and Greatfit hasn’t been doing any analytics and investigation in the reviews. The Customer Service manager has asked you to develop a dashboard to give her an idea of how the reviews are.

MegaMart: Megamart is a store which sells various goods to consumers all over the world. The company works only through Sales Agents who are responsible for selling products to their customers. The Sales Manager would like to have a complete sales dashboard based on the sales agents

Facebook: A Facebook investor needs some help. He would like to see a dashboard that updates daily to keep track of FB stocks and the volume traded.

OLIST: Olist is an online e-commerce store which sells and delivers items all over Brazil. The logistics managers want you to create a dashboard so he can have a line of sight of any delivery issues.

Adventure works: Adventure Works is a retail store which sells bicycles and other fitness/exercise items. You are required to do a quick presentation on their shipping and sales data in their Cloud Data warehouse, Azure.

English
language

Content

Introduction

Introduction
What is Tableau?
A Quick Note on the structure of this course
How to Download and Install Tableau Desktop

Project 1 : Park City Peaks Hotel

A Tableau Walkthrough
Park City Peaks – Project Brief
Park City Peaks Hotel – Dashboard Overview
Park City Peaks Hotel – Connecting to the Data
Park City Peaks Hotel – Building our First Chart on Tableau
Park City Peaks Hotel – Building a Pie Chart on Tableau
Park City Peaks Hotel – Building a Packed Bubble Chart on Tableau
Park City Peaks Hotel – Building a Bar Chart on Tableau
Park City Peaks Hotel – Building a Dashboard on Tableau
Park City Peaks Hotel – Publishing our Dashboard to Tableau Public
Tableau Interface Quiz

Project 2: GreatFit Clothing Reviews

GreatFit – Project Brief
GreatFit – Connecting to a Data Source
GreatFit – Building Charts for our GreatFit Dashboard (Part 1)
GreatFit – Building Charts for our GreatFit Dashboard (Part 2)
GreatFit – Build and Publish the GreatFit Customer Review Dashboard
Tableau Building Charts

Project 3: MegaMart Sales Agent Dashboard

MegaMart – Project Brief
MegaMart – Connecting to Data
MegaMart – Building Charts (Part 1)
MegaMart – Building Charts (Part 2)
MegaMart – Building the Sales Agent Dashboard
Quiz on what we learned building the MegaMart Dashboard

Project 4: Facebook Stock Dashboard

Facebook – Project Brief
Facebook – Creating the Google Sheet and Connecting to Data
Facebook – Building Charts for the Investor Dashboard (Part 1)
Facebook – Building Charts Part 2
Facebook – Building and Publishing the Dashboard
Quiz on what we learned building the Facebook Dashboard

Project 5: OLIST Logistics Dashboard

OLIST – Project Brief
OLIST – Connecting to the Data
OLIST – Building Charts for the OLIST Logistics Dashboard
OLIST – Publishing our Logistics Dashboard

Project 6: AdventureWorks – Creating Tableau Stories

AdventureWorks – Project Brief
AdventureWorks – Connecting to a Cloud Database
Adventure Works – Creating a Story on Tableau
A Goodbye Note