Tableau Prep Masterclass: Data Preparation, Analysis & ETL

Focused View

Start-Tech Academy,Start-Tech Trainings

4:03:45

57 View

1 - Introduction

1 - Introduction.mp4

04:06

2 - Installation and getting started

2 - Tableau prep Installation.mp4

06:12

3 - Course Resources.html

4 - This is a Milestone.mp4

03:31

5 - The example problem statement.mp4

03:43

6 - Demonstration of Tableau transformation.mp4

14:19

3 - Basic concepts Theory for foundational understanding

7 - What is ETL.mp4

03:30

8 - Data Warehouse Ops Database.mp4

05:22

9 - Inmon vs Kimble.mp4

03:33

10 - ETL vs ELT.mp4

03:11

4 - The ETL process The practical part begins here

11 - Data and the ETL process.mp4

03:46

5 - DATA EXTRACTION Extracting tabular data

12 - Inputting Data from a TXT text file.mp4

03:25

13 - Inputting Data from CSV file.mp4

03:51

14 - Inputting Data from Excel file.mp4

02:49

6 - Extracting data from an SQL table

15 - Plan for importing sales data.mp4

02:03

16 - Installing and setting up postgreSQL.mp4

10:44

17 - Creating Sales table in Sql.mp4

07:31

18 - Exporting from an SQL table.mp4

03:53

7 - Storing and Retrieving Data from Cloud storage

19 - Storing and Reading Data on Google Drive.mp4

04:01

20 - Importing Product data.mp4

02:30

8 - Merging Data streams

21 - Merging customer table.mp4

04:30

22 - Merging Sales Data.mp4

05:10

9 - Data Cleansing

23 - Introduction to Data Cleansing.mp4

03:07

24 - Value Mapping.mp4

03:28

25 - Replacing Strings.mp4

05:03

26 - Fuzzy Matching Concept.mp4

04:25

27 - Fuzzy Matching in Tableau Prep.mp4

12:50

28 - Changing data format.mp4

03:22

29 - Common data Cleaning steps.mp4

03:57

10 - Data Validation

30 - Introduction to Data validation.mp4

03:26

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

07:46

32 - Data validation 2 Checking Reference Values.mp4

04:50

33 - Data validation 3 Order date shipping date.mp4

05:08

34 - Common data validation.mp4

05:10

11 - Error Handling

35 - Correcting the errors.mp4

11:54

36 - Writing the error to separate file.mp4

05:32

12 - Transformation and Analytics steps

37 - Concatenation.mp4

04:37

38 - Aggregation.mp4

05:18

39 - Normalization and Denormalization.mp4

06:37

40 - Categorising customers with Age.mp4

05:42

13 - Conceptual understanding for Loading Data

41 - Facts and dimension table.mp4

02:25

42 - Surrogate key in dimension table.mp4

02:39

14 - Loading the data into a Data Mart

43 - Creating tables in Database.mp4

05:04

44 - Loading Customer Data.mp4

07:45

45 - Loading Product Data.mp4

05:32

46 - Loading Sales Data.mp4

13:31

15 - Moving to Tableau Desktop

47 - Tableau Desktop.mp4

01:24

16 - Congratulations and about your certificate

48 - The final milestone.mp4

01:33

49 - Bonus Lecture.html

Description

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

Who is this for?

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

More details

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.
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!
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

Start-Tech Academy is a technology-based Analytics Education Company and aims at Bringing Together the analytics companies and interested Learners. Our top quality training content along with internships and project opportunities helps students in launching their Analytics journey. Founded by Abhishek Bansal and Pukhraj Parikh. Working as a Project manager in an Analytics consulting firm, Pukhraj has multiple years of experience working on analytics tools and software. He is competent in MS office suites, Cloud computing, SQL, Tableau, SAS, Google analytics and Python.Abhishek worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Start-Tech Trainings

Instructor's Courses

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.