Courses
Web Development
Business
Design
Marketing
IT & Software
Photography
Music
View All Courses
Log in Sign Up
Call us
800 388 80 90
329 Queensberry Street,
North Melbourne VIC 3051, Australia.
hi@educrat.com
Popular Categories
Web Development Data Science Design Business Marketing Programming
image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659
Log in Sign up
Home
All courses
Tableau & Tableau Prep for Data Preparation & Visualization
Business Analytics & Intelligence
Business
Tableau

Tableau & Tableau Prep for Data Preparation & Visualization

Covers both Tableau and Tableau Prep, visualize & prep your data with ease with hands-on Tableau & Tableau Prep training

4.6
(261)
17411 enrolled on this course
Last updated 11/2021
None
image
₹ 799.0
₹ 2299.0
Buy Now
30-Day Money-Back Guarantee
Lessons
20
Quizzes
3
Duration
13 Hours
Skill level
Beginner
Language
English
Certificate
Yes
Full lifetime access
Yes

Description

If you are looking to take your data preparation and visualization skills to the next level, then
Tableau & Tableau Prep for Data Preparation & Visualization
is the course for you! Are you tired of spending hours wrangling your data, only to be left with less than satisfactory visualizations? Do you struggle to tell a compelling data story to your stakeholders? Look no further!
In this course, you will develop advanced analytics skills and become a data storytelling expert. You will master the art of data preparation and visualization using the powerful Tableau and Tableau Prep tools. Here are some of the key benefits you will gain from this course:
Develop sophisticated data visualizations that will impress your stakeholders
Master the art of data storytelling and effectively communicate your insights
Build interactive dashboards that will allow your stakeholders to easily explore and understand your data
Streamline your data preparation process with Tableau Prep
Automate repetitive data preparation tasks to save time and increase efficiency
Data is the backbone of decision making, and the ability to effectively analyze and communicate data is a highly sought-after skill in today's job market. In this course, you will complete hands-on activities such as building interactive dashboards, cleaning and transforming data, and crafting compelling data narratives.
This course is different because it combines the power of Tableau and Tableau Prep, giving you a holistic approach to data preparation and visualization. You'll learn from industry experts who have years of experience in data analytics and visualization. Join us now to accelerate your analytics skills and become a pro at preparing and visualizing data.
Who this course is for:
Business analysts who want to improve their data visualization and analysis skills
Students and professionals who are new to data analysis and want to learn Tableau and Tableau Prep from scratch.
Data analysts who want to learn how to use Tableau prep for data preparation and Tableau for visualization

What you'll learn

Master the art of data preparation and cleaning with Tableau Prep

Explore the Tableau interface and workflow for data preparation and visualization

Learn how to use Tableau to explore and analyze data to make data-driven decisions

Explore data blending techniques to integrate data from multiple sources

Master the use of data hierarchies and groupings to organize and filter data

Build your skills in using calculated fields and parameters to create advanced visualizations

Learn how to use advanced mapping techniques to visualize geographic data

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
1
1.1-Introduction
2-Installation and getting started
5
2.1-Tableau prep Installation
2.2-Course Resources
2.3-This is a Milestone!
2.4-The example problem statement
2.5-Demonstration of Tableau transformation
3-Basic concepts - Theory for foundational understanding
4
3.1-What is ETL
3.2-Data Warehouse, Ops Database
3.3-Inmon vs Kimble
3.4-ETL vs ELT
4-The ETL process: The practical part begins here
2
4.1-Data and the ETL process
4.2-Quiz
5-DATA EXTRACTION: Extracting tabular data
3
5.1-Inputting Data from a TXT (text) file
5.2-Inputting Data from CSV file
5.3-Inputting Data from Excel file
6-Extracting data from an SQL table
4
6.1-Plan for importing sales data
6.2-Installing and setting up postgreSQL
6.3-Creating sales table in SQL
6.4-Exporting from an SQL table
7-Storing and Retrieving Data from Cloud storage
2
7.1-Storing and Retrieving Data on Google Drive
7.2-Importing Product data
8-Merging Data streams
2
8.1-Merging customer table
8.2-Merging Sales Data
9-Data Cleansing
8
9.1-Introduction to Data Cleansing
9.2-Value Mapping
9.3-Replacing Strings
9.4-Fuzzy Matching Concepts
9.5-Fuzzy Matching in Tableau Prep
9.6-Changing data format
9.7-Common data Cleaning steps
9.8-Quiz
10-Data Validation
5
10.1-Introduction to Data validation
10.2-Data validation 1 - String to Int and integer and range validations
10.3-Data validation 2 - Checking Reference Values
10.4-Data validation 3 - Order date < shipping date
10.5-Common data validation
11-Error Handling
2
11.1-Correcting the errors
11.2-Writing the error to separate file
12-Transformation and Analytics steps
4
12.1-Concatenation
12.2-Aggregation
12.3-Normalization and Denormalization
12.4-Cateorising customers with Age
13-Conceptual understanding for Loading Data
2
13.1-Facts and dimension table
13.2-Surrogate key in dimension table
14-Loading the data into a Data Mart
5
14.1-Creating tables in Database
14.2-Loading Customer Data
14.3-Loading Product Data
14.4-Loading Sales Data
14.5-Moving to Tableau Desktop
15-Tableau Desktop and Tableau Public
3
15.1-Why Tableau
15.2-Tableau Products
15.3-Quiz
16-Installation and getting started
5
16.1-Installing Tableau desktop and Public
16.2-About the data
16.3-Connecting to data
16.4-Live vs Extract
16.5-Quiz
17-Combining data to create Data model
8
17.1-Combining data from multiple tables
17.2-Relationships in Tableau
17.3-Joins in Tableau
17.4-Types of Joins in Tableau
17.5-Union in Tableau
17.6-Physical Logical layer and Data models
17.7-The visualization screen - Sheet
17.8-Quiz
18-Data categorization in Tableau
3
18.1-Types of Data - Dimensions and Measures
18.2-Types of Data - Discreet and Continuous
18.3-Changing Data type in Tableau
19-Most used charts
3
19.1-Bar charts
19.2-Line charts
19.3-Scatterplots
20-Customizing charts using Marks shelf
3
20.1-Marks cards
20.2-Dropping Dimensions and Measures on marks card
20.3-Adding marks in scatterplot
21-Other important charts
8
21.1-Text tables, heat map and highlight tables
21.2-Pie charts
21.3-Area charts
21.4-Creating custom hierarchy
21.5-Tree map
21.6-Dual combination charts
21.7-Creating Bins
21.8-Quiz
22-Grouping and Filtering data
10
22.1-Grouping Data
22.2-Filtering data
22.3-Dimension filters
22.4-Measure filters
22.5-Date-Time filters
22.6-Filter options
22.7-Types of filters and order of operation
22.8-Customizing visual filters
22.9-Sorting options
22.10-Quiz
23-Map charts in Tableau
10
23.1-How to make a map chart
23.2-Considerations before making a Map chart
23.3-Marks card for customizing maps
23.4-Customizing maps using map menu
23.5-Layers in a Map
23.6-Visual toolbar on a map
23.7-Custom background images
23.8-Territories in maps
23.9-Data blending for missing geocoding
23.10-Quiz
24-Calculations and Analytics
7
24.1-Calculated fields in Tableau
24.2-Functions in Tableau
24.3-Table calculations theory
24.4-Table calculations in Tableau
24.5-Understanding LOD expressions
24.6-LOD expressions examples
24.7-Analytics pane
25-Sets and parameters
4
25.1-Understanding sets in Tableau
25.2-Creating Sets in Tableau
25.3-Parameters
25.4-Quiz
26-Dashboard and Story
4
26.1-Dashboard part -1
26.2-Dashboard part - 2
26.3-Story
26.4-Quiz
27-Saving and Sharing your work
3
27.1-Saving and sharing tableau workbook
27.2-Saving and sharing your data
27.3-Saving and sharing views and dashboards
28-Appendix
8
28.1-Connecting to SQL data source
28.2-Connecting to cloud storage services
28.3-Additional resources
28.4-Practical Task 1
28.5-Quiz
28.6-Practical Task 2
28.7-Comprehensive Interview Preparation Questions
28.8-The final milestone!
29-Congratulations and about your certificate
2
29.1-About your certificate
29.2-Bonus lecture

You May Like

10,000+ unique online course list designs

The Complete SQL Bootcamp: Go from Zero to Hero
4.7
(242760)
The Complete SQL Bootcamp: Go from Zero to Hero
icon
24 lessons
icon
N/A
icon
Beginner
J.P
Jose Portilla
$3499.0
$3499.0
Microsoft Power BI Desktop for Business Intelligence
4.6
(177158)
Microsoft Power BI Desktop for Business Intelligence
icon
22 lessons
icon
N/A
icon
Beginner
M.L
Maven Analytics • 1,500,000 Learners
$3299.0
$3299.0
Tableau 2024 A-Z: Hands-On Tableau Training for Data Science
4.6
(105581)
Tableau 2024 A-Z: Hands-On Tableau Training for Data Science
icon
22 lessons
icon
N/A
icon
Beginner
K.E
Kirill Eremenko
$3999.0
$3999.0
Microsoft Power BI - The Practical Guide 2024
4.6
(74981)
Microsoft Power BI - The Practical Guide 2024
icon
28 lessons
icon
N/A
icon
Beginner
M.L
Manuel Lorenz
$3999.0
$3999.0
Business Analysis Fundamentals - ECBA, CCBA, CBAP endorsed
4.6
(67398)
Business Analysis Fundamentals - ECBA, CCBA, CBAP endorsed
icon
24 lessons
icon
N/A
icon
Beginner
T.A
The BA Guide | Jeremy Aschenbrenner
$3499.0
$3499.0
SQL - MySQL for Data Analytics and Business Intelligence
4.6
(63800)
SQL - MySQL for Data Analytics and Business Intelligence
icon
60 lessons
icon
N/A
icon
Beginner
3.C
365 Careers
$3999.0
$3999.0