Kickstart your Data Analytics Career with Tableau: Solving Real Analytical Problems

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

• Introduction to the Course
• Introduction to Tableau
• How this course is structured
• Installing the Free Full Version of Tableau
• Project 1: Discount Mart (Sales and Profit Analytics)
• Discount Mart- Connect to the Data
• Discount Mart- Building Charts Part 1
• Discount Mart- Building Charts Part 2
• Discount Mart- Creating Headline Cards
• Discount Mart- Building a Dashboard
• Project 2: Green Destinations (HR Analytics)
• Green Destinations- Connect to Data
• Green Destinations- Building Charts Part 1
• Green Destinations- Building Charts Part 2
• Green Destinations- Creating Headline Cards
• Green Destinations- Dashboard Building
• Green Destinations- Publishing your Dashboard
• Extra Project: MyPaper - Project Brief
• MyPaper - Connecting to Data Sources
• MyPaper - Building Charts and Creating Tables
• MyPaper - Building and Publishing a Dashboard
• Project 3: Super Store (Sales Analytics)
• A quick note before you watch the next lecture
• Super Store- Connect to Data
• Super Store- Building Charts Part 1
• Super Store- Building Charts Part 2
• Super Store - Dashboard Building
• Super Store - Dashboard Publishing
• Project 4: Northwind Trading (Shipping Analytics)
• Northwind - Data Connection
• Northwind - Charts
• Northwind - Dashboard Building and Publishing
• Project 5: Tesla (Stock Prices)
• Tesla - Creating a Data set
• Tesla - Connect to Data
• Tesla - Building Charts
• Tesla - Building Headline Cards
• Tesla - Dashboard Building
• Tesla - Dashboard Publishing
• Bonus: Data Optimization