Kickstart your Data Analytics Career with Tableau by solving Realistic Analytics Projects. Learn Data Visualisation!

Are you ready to kickstart your career in Data Analytics?
Need more knowledge in Tableau, Data Visualization and Analytics?

This course is for YOU.

In this course, you will build 5 separate dashboards depicting real-world problems. You will learn how to connect to various data sources from Excel files to cloud servers. You will also learn how to build interactive dashboards and publish it to Tableau Online!

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 5 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.

All datasets can be found on the below (also check project brief)

Project 1: Discount Mart (Sales and Profit Analytics)

Dataset: https://finch-groundhog-9245.squarespace.com/s/discountmart.csv
Logo: https://finch-groundhog-9245.squarespace.com/s/Discount-Mart-1.png

Project 2: Green Destinations (HR Analytics)

Dataset: https://finch-groundhog-9245.squarespace.com/s/greendestination.csv
Logo: https://finch-groundhog-9245.squarespace.com/s/greendestination-logo.png

Project (Extra): MyPaper (Accounts Receivable)

MyPaper is a paper supplier. The company supplies paper locally to businesses. They allow customers to buy paper upfront but also have a credit option. This is where they supply customers with paper, and the customer doesn’t pay an amount upfront but will make frequent smaller payments.

MyPaper wants to do a full recon of their accounts receivable. The Finance manager would like to select a customer and view some details like

Amount the customer has paid each month
Average Days Overdue (on average, how many days is the customer late by?)
List of invoices and amounts by the customer
Number of times the customer has disputed invoiced.

Dataset:

Dataset: (click the following links for the datasets)
https://finch-groundhog9245.squarespace.com/s/Account-Payments-for- MyPaper.xlsx
https://finch-groundhog-9245.squarespace.com/s/Customers-for-MyPaper.xlsx
Logo: https://finch-groundhog-9245.squarespace.com/s/MyPaper.png

Project 3: Superstore (Sales Agent Tracker)

Dataset: https://finch-groundhog-9245.squarespace.com/s/Superstore.zip
Logo: https://finch-groundhog-9245.squarespace.com/s/superstorelogo.png

Project 4: Northwind Trade (Shipping Analytics)

Dataset: The connection details to Maria DB are below.

Server: hostname: relational.fit.cvut.cz
Database:
port: 3306
username: guest
password: relational

Note: If somehow you can’t connect to Maria DB. I’ve added the compressed folder of the database https://finch-groundhog-9245.squarespace.com/s/csv-northwind.zip. Download it and connect to this instead.

Logo: https://finch-groundhog-9245.squarespace.com/s/NWsquarelogostack.png

Project 5: Tesla (Stock Price Analytics)

Dataset: We will create a live google sheet!
Logo: https://finch-groundhog-9245.squarespace.com/s/teslalogo.png

Abhijit Mandape

1

6