HOT
blank

Tableau Prep Masterclass: Data Preparation, Analysis & ETL

Business

Rating4.4
Enroll Now

Tableau Prep Masterclass: Data Preparation, Analysis & ETL, available at $64.99, has an average rating of 4.38, with 51 lectures, 5 quizzes, based on 88 reviews, and has 6212 subscribers.

You will learn about 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 This course is ideal for individuals who are Business analysts who want to enhance their data preparation and analysis skills and take their career to the next level. or Data analysts who want to add advanced ETL and data preparation techniques to their skill set to better manage complex data sets. or 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 It is particularly useful for Business analysts who want to enhance their data preparation and analysis skills and take their career to the next level. or Data analysts who want to add advanced ETL and data preparation techniques to their skill set to better manage complex data sets. or 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.

Enroll now: Tableau Prep Masterclass: Data Preparation, Analysis & ETL

Summary

Title: Tableau Prep Masterclass: Data Preparation, Analysis & ETL

Price: $64.99

Average Rating: 4.38

Number of Lectures: 51

Number of Quizzes: 5

Number of Published Lectures: 50

Number of Published Quizzes: 5

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 55

Original Price: $24.99

Quality Status: approved

Status: Live

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

Who Should Attend

  • 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

Target Audiences

  • 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

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.

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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: Installation and getting started

Lecture 1: Tableau prep Installation

Lecture 2: Course Resources

Lecture 3: This is a Milestone!

Lecture 4: The example problem statement

Lecture 5: Demonstration of Tableau transformation

Chapter 3: Basic concepts – Theory for foundational understanding

Lecture 1: What is ETL

Lecture 2: Data Warehouse, Ops Database

Lecture 3: Inmon vs Kimble

Lecture 4: ETL vs ELT

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

Lecture 1: Data and the ETL process

Chapter 5: DATA EXTRACTION: Extracting tabular data

Lecture 1: Inputting Data from a TXT (text) file

Lecture 2: Inputting Data from CSV file

Lecture 3: Inputting Data from Excel file

Chapter 6: Extracting data from an SQL table

Lecture 1: Plan for importing sales data

Lecture 2: Installing and setting up postgreSQL

Lecture 3: Creating Sales table in Sql

Lecture 4: Exporting from an SQL table

Chapter 7: Storing and Retrieving Data from Cloud storage

Lecture 1: Storing and Reading Data on Google Drive

Lecture 2: Importing Product data

Chapter 8: Merging Data streams

Lecture 1: Merging customer table

Lecture 2: Merging Sales Data

Chapter 9: Data Cleansing

Lecture 1: Introduction to Data Cleansing

Lecture 2: Value Mapping

Lecture 3: Replacing Strings

Lecture 4: Fuzzy Matching Concept

Lecture 5: Fuzzy Matching in Tableau Prep

Lecture 6: Changing data format

Lecture 7: Common data Cleaning steps

Chapter 10: Data Validation

Lecture 1: Introduction to Data validation

Lecture 2: Data validation 1 – String to Int and integer range validations

Lecture 3: Data validation 2 – Checking Reference Values

Lecture 4: Data validation 3 – Order date < shipping date

Lecture 5: Common data validation

Chapter 11: Error Handling

Lecture 1: Correcting the errors

Lecture 2: Writing the error to separate file

Chapter 12: Transformation and Analytics steps

Lecture 1: Concatenation

Lecture 2: Aggregation

Lecture 3: Normalization and Denormalization

Lecture 4: Categorising customers with Age

Chapter 13: Conceptual understanding for Loading Data

Lecture 1: Facts and dimension table

Lecture 2: Surrogate key in dimension table

Chapter 14: Loading the data into a Data Mart

Lecture 1: Creating tables in Database

Lecture 2: Loading Customer Data

Lecture 3: Loading Product Data

Lecture 4: Loading Sales Data

Chapter 15: Moving to Tableau Desktop

Lecture 1: Tableau Desktop

Chapter 16: Congratulations and about your certificate

Lecture 1: The final milestone

Lecture 2: About your certificate

Lecture 3: Bonus Lecture

Instructors

Rating Distribution

  • 1 stars: 1 votes
  • 2 stars: 1 votes
  • 3 stars: 10 votes
  • 4 stars: 31 votes
  • 5 stars: 45 votes

Frequently Asked Questions


How long do I have access to the course materials?


You can view and review the lecture materials indefinitely, like an on-demand channel.


Can I take my courses with me wherever I go?


Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

You may also like

Top 10 Relationship Building Courses to Learn in November 2024

Top 10 Storytelling Courses to Learn in November 2024

Top 10 Resilience Training Courses to Learn in November 2024