• Post category:StudyBullet-13
  • Reading time:8 mins read


Tableau prep for Data Preparation | Data Cleaning | Data validation | Data integration before Analysis & Visualization

What you will learn

Discover advanced data preparation techniques in Tableau Prep to effectively streamline your data pipeline

Master Tableau Prep’s ETL capabilities to clean, combine, and transform complex data sets into meaningful insights

Develop data analysis skills in Tableau Prep to generate deeper insights and trends from your data

Explore Tableau Prep’s automation features to simplify and accelerate your workflows

Learn how to connect and blend multiple data sources in Tableau Prep

Build data models and create data-driven insights using Tableau Prep

Description

If you are looking to streamline your data pipeline and transform raw data into actionable insights, you’re in the right place! In this Tableau Prep Masterclass, you’ll master the art of data preparation, analysis, and ETL, empowering you to turn complex data sets into impactful visualizations.

Throughout the course, you will develop the following skills:

  • Develop advanced data preparation techniques to streamline your data pipeline
  • Master Tableau Prep’s ETL capabilities to effectively clean, combine, and transform your data
  • Leverage advanced analysis tools to generate deeper insights from your data
  • Utilize Tableau Prep’s powerful automation features to simplify and accelerate your workflows

Understanding the importance of data preparation and data integration is crucial in today’s data-driven world, as it enables you to make informed decisions and gain a competitive edge. In this course, you will complete a series of hands-on activities, including real-world data preparation and analysis scenarios, to apply your new skills and solidify your understanding.

What makes this course unique is the comprehensive approach we take to Tableau Prep. We’ll cover all the key aspects of data preparation, analysis, and ETL, and you’ll receive step-by-step guidance from industry experts with years of experience in data analytics.


Get Instant Notification of New Courses on our Telegram channel.


Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet, or anything related to any topic, you can always post a question in the course or send us a direct message.

Join us today and take the first step towards becoming a Tableau Prep Master!

English
language

Content

Introduction

Introduction

Installation and getting started

Tableau prep Installation
Course Resources
This is a Milestone!
The example problem statement
Demonstration of Tableau transformation

Basic concepts – Theory for foundational understanding

What is ETL
Data Warehouse, Ops Database
Inmon vs Kimble
ETL vs ELT

The ETL process: The practical part begins here

Data and the ETL process

DATA EXTRACTION: Extracting tabular data

Inputting Data from a TXT (text) file
Inputting Data from CSV file
Inputting Data from Excel file

Extracting data from an SQL table

Plan for importing sales data
Installing and setting up postgreSQL
Creating Sales table in Sql
Exporting from an SQL table

Storing and Retrieving Data from Cloud storage

Storing and Reading Data on Google Drive
Importing Product data

Merging Data streams

Merging customer table
Merging Sales Data

Data Cleansing

Introduction to Data Cleansing
Value Mapping
Replacing Strings
Fuzzy Matching Concept
Fuzzy Matching in Tableau Prep
Changing data format
Common data Cleaning steps

Data Validation

Introduction to Data validation
Data validation 1 – String to Int and integer range validations
Data validation 2 – Checking Reference Values
Data validation 3 – Order date < shipping date
Common data validation

Error Handling

Correcting the errors
Writing the error to separate file

Transformation and Analytics steps

Concatenation
Aggregation
Normalization and Denormalization
Categorising customers with Age

Conceptual understanding for Loading Data

Facts and dimension table
Surrogate key in dimension table

Loading the data into a Data Mart

Creating tables in Database
Loading Customer Data
Loading Product Data
Loading Sales Data

Moving to Tableau Desktop

Tableau Desktop

Congratulations and about your certificate

The final milestone
Bonus Lecture