image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Are you ready to
kickstart
your career in
Data Analytics
? Want to add something
special
to your resume?
Need more knowledge in Tableau, Data Visualization and Analytics?
This course is for
YOU.
In this course you will build
6
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 can link these in your resume to show potential employers what you can do!
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:
Discount Mart:
Discount Mart is a small supermarket.The owner wants a dashboard where he can track how well Discount Mart is doing for this year (in terms of Sales, Profit and Quantity Sold).
Green Destinations:
 Green Destinations is a well known travel agency. The HR Director has recently noticed an increase in employees leaving (attrition). She would like to figure out any trends or patterns based on a dashboard we will be building for her.
MyPaper:
MyPaper is a paper supplier. The Finance Manager would like to create a dashboard to detail Accounts Receivable and any customers who owe MyPaper money.
Super Store: 
Superstore is a famous retailer in Canada. They have expanded into the USA and their business model involves placing Sales Agents in every state in the USA. These sales agents are responsible for bringing in sales for the state that they are assigned.
The Sales Manager wants a dashboard to track how Sales Agents are doing.
Northwind Trade:
Northwind Trade is a company which ships a variety of FMCG (Fast Moving Consumer Goods) all over the world.
The Shipping Manager doesn't have much visibility and doesn't know how many orders are processed and shipped on a monthly basis. He would like a dashboard of this where he selects a month and can tell how many orders are outstanding a day and where they should be shipped.
Tesla:
Tesla is an American electric vehicle and clean energy company. An important shareholder is tired of receiving only monthly updates of the stock price. The shareholder would like to see any trends of the stock price specifically for the last 3 months. He also wants this data to be updated daily.
Who this course is for:
This course is for anyone who wants to kickstart their career in Data Analytics
This course is for anyone who wants to learn more about Tableau

What you'll learn

By the end of this course you'll understand the inner workings of the data analytics pipeline from joining, filtering, extracting data to developing dashboards

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

Connect to different data sources such as Excel, Google Sheets and even servers!

Be able to create in depth analyses with bar charts, line charts, donut charts and even geographical maps.

Develop a solid understanding of how calculations on Tableau work

Be able to understand joining data sources on Tableau and understanding types of joins

Work with sets and Level of Detail Calculations

Understand how Groups and Hierarchies on Tableau Works

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction to the Course
8
1.1-Introduction to the Course
1.2-What is Tableau? An Introduction to Tableau.
1.3-How the Course is Structured
1.4-Signing up for a Tableau Public Account
1.5-Install the 14 day free, full trial of Tableau
1.6-The Different Products of Tableau
1.7-The Lifecycle of Data
1.8-Why Data Visualization is Important
2-Project 1: Discount Mart (Sales and Profit Analytics)
7
2.1-Project Brief for Discount Mart
2.2-Connecting and Preparing Data for Discount Mart
2.3-Building Charts on Tableau for Discount Mart (Part 1)
2.4-Building Charts on Tableau for Discount Mart (Part 2)
2.5-Creating Headline Cards on Tableau for Discount Mart
2.6-Building and Publishing Dashboards on Tableau
2.7-Review of Learnings from Section 1
3-Project 2: Green Destinations (HR Analytics)
9
3.1-Project Brief for Green Destinations
3.2-Connecting and Preparing Data for Green Destinations
3.3-Building Charts on Tableau (Part 1) for Green Destinations
3.4-Building Charts on Tableau (Part 2) for Green Destinations
3.5-Creating Headline Cards on Tableau
3.6-Building a Dashboard for Green Destinations
3.7-Publish your Dashboard to Tableau Public
3.8-An introduction to Tableau Server
3.9-Review of Learnings from Section 2
4-Extra Project: MyPaper (Accounts Receivable)
5
4.1-Project Brief for MyPaper
4.2-Connecting to Data Sources and Introducing Joins
4.3-Lecture 3: Building Charts
4.4-Lecture 4: Publishing a Dashboard
4.5-Dashboard Design Tips
5-Project 3: Superstore (Sales Agent Tracker)
8
5.1-Project Brief for Super Store
5.2-A quick note before you watch the next lecture
5.3-Connecting and Preparing Data for Super Store
5.4-Building Charts on Tableau (Part 1) for Super Store
5.5-Building Charts on Tableau (Part 2) for Super Store
5.6-Building a Dashboard
5.7-Publish your Dashboard to Tableau Public
5.8-Review of Learnings from Section 3
6-Project 4: Northwind Trade (Shipping Analytics)
4
6.1-Project Brief for Northwind Trade
6.2-Connecting and Preparing Data for Northwind Trade
6.3-Building Charts on Tableau for Northwind Trade
6.4-Building and Publishing Dashboards for Northwind Trade
7-Project 5: Tesla (Stock Price Analytics)
8
7.1-Project Brief for Tesla
7.2-Important note on connecting to Google Sheets before the next video
7.3-Creating a Data Source through Google Sheet Functions
7.4-Connect to the Data for Tesla
7.5-Building Charts on Tableau for Tesla
7.6-Building Headline Cards
7.7-Building a Tesla Dashboard
7.8-Publish your Dashboard to Tableau Public
8-Bonus: Introduction to Database Concepts
6
8.1-Introduction to Database Concepts
8.2-Understanding Relational Databases
8.3-Relationships of Database Entities
8.4-Primary and Foreign Keys
8.5-Data types and Naming Conventions
8.6-Assignment: Correct this database!
9-Section 8: Tableau Stories
1
9.1-Creating Stories on Tableau
10-Data Optimization
1
10.1-How to Optimize Data in Tableau