Tableau Prep Masterclass: Data Preparation, Analysis & ETL

سرفصل های دوره

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

1 - Introduction

1 - Introduction

2 - Installation and getting started

2 - Tableau prep Installation

3 - Course Resources.html

4 - This is a Milestone

5 - The example problem statement

6 - Demonstration of Tableau transformation

3 - Basic concepts Theory for foundational understanding

7 - What is ETL

8 - Data Warehouse Ops Database

9 - Inmon vs Kimble

10 - ETL vs ELT

4 - The ETL process The practical part begins here

11 - Data and the ETL process

5 - DATA EXTRACTION Extracting tabular data

12 - Inputting Data from a TXT text file

13 - Inputting Data from CSV file

14 - Inputting Data from Excel file

6 - Extracting data from an SQL table

15 - Plan for importing sales data

16 - Installing and setting up postgreSQL

17 - Creating Sales table in Sql

18 - Exporting from an SQL table

7 - Storing and Retrieving Data from Cloud storage

19 - Storing and Reading Data on Google Drive

20 - Importing Product data

8 - Merging Data streams

21 - Merging customer table

22 - Merging Sales Data

9 - Data Cleansing

23 - Introduction to Data Cleansing

24 - Value Mapping

25 - Replacing Strings

26 - Fuzzy Matching Concept

27 - Fuzzy Matching in Tableau Prep

28 - Changing data format

29 - Common data Cleaning steps

10 - Data Validation

30 - Introduction to Data validation

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

32 - Data validation 2 Checking Reference Values

33 - Data validation 3 Order date shipping date

34 - Common data validation

11 - Error Handling

35 - Correcting the errors

36 - Writing the error to separate file

12 - Transformation and Analytics steps

37 - Concatenation

38 - Aggregation

39 - Normalization and Denormalization

40 - Categorising customers with Age

13 - Conceptual understanding for Loading Data

41 - Facts and dimension table

42 - Surrogate key in dimension table

14 - Loading the data into a Data Mart

43 - Creating tables in Database

44 - Loading Customer Data

45 - Loading Product Data

46 - Loading Sales Data

15 - Moving to Tableau Desktop

47 - Tableau Desktop

16 - Congratulations and about your certificate

48 - The final milestone

49 - Bonus Lecture.html

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training