Tableau Prep Masterclass: Data Preparation, Analysis & Etl
Published 3/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.62 GB | Duration: 4h 4m

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

What you'll 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

Requirements

A PC with internet connection to run Tableau Prep. You will be guided on how to setup Tableau prep in the course.

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 pipelineMaster Tableau Prep's ETL capabilities to effectively clean, combine, and transform your dataLeverage advanced analysis tools to generate deeper insights from your dataUtilize Tableau Prep's powerful automation features to simplify and accelerate your workflowsUnderstanding 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.Our PromiseTeaching 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!

Overview

Section 1: Introduction

Lecture 1 Introduction

Section 2: Installation and getting started

Lecture 2 Tableau prep Installation

Lecture 3 Course Resources

Lecture 4 This is a Milestone!

Lecture 5 The example problem statement

Lecture 6 Demonstration of Tableau transformation

Section 3: Basic concepts - Theory for foundational understanding

Lecture 7 What is ETL

Lecture 8 Data Warehouse, Ops Database

Lecture 9 Inmon vs Kimble

Lecture 10 ETL vs ELT

Section 4: The ETL process: The practical part begins here

Lecture 11 Data and the ETL process

Section 5: DATA EXTRACTION: Extracting tabular data

Lecture 12 Inputting Data from a TXT (text) file

Lecture 13 Inputting Data from CSV file

Lecture 14 Inputting Data from Excel file

Section 6: Extracting data from an SQL table

Lecture 15 Plan for importing sales data

Lecture 16 Installing and setting up postgreSQL

Lecture 17 Creating Sales table in Sql

Lecture 18 Exporting from an SQL table

Section 7: Storing and Retrieving Data from Cloud storage

Lecture 19 Storing and Reading Data on Google Drive

Lecture 20 Importing Product data

Section 8: Merging Data streams

Lecture 21 Merging customer table

Lecture 22 Merging Sales Data

Section 9: Data Cleansing

Lecture 23 Introduction to Data Cleansing

Lecture 24 Value Mapping

Lecture 25 Replacing Strings

Lecture 26 Fuzzy Matching Concept

Lecture 27 Fuzzy Matching in Tableau Prep

Lecture 28 Changing data format

Lecture 29 Common data Cleaning steps

Section 10: Data Validation

Lecture 30 Introduction to Data validation

Lecture 31 Data validation 1 - String to Int and integer range validations

Lecture 32 Data validation 2 - Checking Reference Values

Lecture 33 Data validation 3 - Order date < shipping date

Lecture 34 Common data validation

Section 11: Error Handling

Lecture 35 Correcting the errors

Lecture 36 Writing the error to separate file

Section 12: Transformation and Analytics steps

Lecture 37 Concatenation

Lecture 38 Aggregation

Lecture 39 Normalization and Denormalization

Lecture 40 Categorising customers with Age

Section 13: Conceptual understanding for Loading Data

Lecture 41 Facts and dimension table

Lecture 42 Surrogate key in dimension table

Section 14: Loading the data into a Data Mart

Lecture 43 Creating tables in Database

Lecture 44 Loading Customer Data

Lecture 45 Loading Product Data

Lecture 46 Loading Sales Data

Section 15: Moving to Tableau Desktop

Lecture 47 Tableau Desktop

Section 16: Congratulations and about your certificate

Lecture 48 The final milestone

Lecture 49 Bonus Lecture

Business analysts who want to enhance their data preparation and analysis skills and take their career to the next level.,Data analysts who want to add advanced ETL and data preparation techniques to their skill set to better manage complex data sets.,Professionals who are already using Tableau for data visualization tool and wish to learn to a strong preprocessing tool to prepare data before data visualization