Tableau & Tableau Prep for Data Preparation & Visualization

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

Covers both Tableau and Tableau Prep, visualize & prep your data with ease with hands-on Tableau & Tableau Prep training

1. Introduction

1. Introduction

2. Installation and getting started

1. Tableau prep Installation

2. Course Resources.html

3. This is a Milestone!

4. The example problem statement

5. Demonstration of Tableau transformation

3. Basic concepts - Theory for foundational understanding

1. What is ETL

2. Data Warehouse, Ops Database

3. Inmon vs Kimble

4. ETL vs ELT

4. The ETL process The practical part begins here

1. Data and the ETL process

5. DATA EXTRACTION Extracting tabular data

1. Inputting Data from a TXT (text) file

2. Inputting Data from CSV file

3. Inputting Data from Excel file

6. Extracting data from an SQL table

1. Plan for importing sales data

2. Installing and setting up postgreSQL

3. Creating sales table in SQL

4. Exporting from an SQL table

7. Storing and Retrieving Data from Cloud storage

1. Storing and Retrieving Data on Google Drive

2. Importing Product data

8. Merging Data streams

1. Merging customer table

2. Merging Sales Data

9. Data Cleansing

1. Introduction to Data Cleansing

2. Value Mapping

3. Replacing Strings

4. Fuzzy Matching Concepts

5. Fuzzy Matching in Tableau Prep

6. Changing data format

7. Common data Cleaning steps

10. Data Validation

1. Introduction to Data validation

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

3. Data validation 2 - Checking Reference Values

4. Data validation 3 - Order date shipping date

5. Common data validation

11. Error Handling

1. Correcting the errors

2. Writing the error to separate file

12. Transformation and Analytics steps

1. Concatenation

2. Aggregation

3. Normalization and Denormalization

4. Cateorising customers with Age

13. Conceptual understanding for Loading Data

1. Facts and dimension table

2. Surrogate key in dimension table

14. Loading the data into a Data Mart

1. Creating tables in Database

2. Loading Customer Data

3. Loading Product Data

4. Loading Sales Data

5. Moving to Tableau Desktop

15. Tableau Desktop and Tableau Public

1. Why Tableau

2. Tableau Products

16. Installation and getting started

1. Installing Tableau desktop and Public

2. About the data

3. Connecting to data

4. Live vs Extract

17. Combining data to create Data model

1. Combining data from multiple tables

2. Relationships in Tableau

3. Joins in Tableau

4. Types of Joins in Tableau

5. Union in Tableau

6. Physical Logical layer and Data models

7. The visualization screen - Sheet

18. Data categorization in Tableau

1. Types of Data - Dimensions and Measures

2. Types of Data - Discreet and Continuous

3. Changing Data type in Tableau

19. Most used charts

1. Bar charts

2. Line charts

3. Scatterplots

20. Customizing charts using Marks shelf

1. Marks cards

2. Dropping Dimensions and Measures on marks card

3. Adding marks in scatterplot

21. Other important charts

1. Text tables, heat map and highlight tables

2. Pie charts

3. Area charts

4. Creating custom hierarchy

5. Tree map

6. Dual combination charts

7. Creating Bins

22. Grouping and Filtering data

1. Grouping Data

2. Filtering data

3. Dimension filters

4. Measure filters

5. Date-Time filters

6. Filter options

7. Types of filters and order of operation

8. Customizing visual filters

9. Sorting options

23. Map charts in Tableau

1. How to make a map chart

2. Considerations before making a Map chart

3. Marks card for customizing maps

4. Customizing maps using map menu

5. Layers in a Map

6. Visual toolbar on a map

7. Custom background images

8. Territories in maps

9. Data blending for missing geocoding

24. Calculations and Analytics

1. Calculated fields in Tableau

2. Functions in Tableau

3. Table calculations theory

4. Table calculations in Tableau

5. Understanding LOD expressions

6. LOD expressions examples

7. Analytics pane

25. Sets and parameters

1. Understanding sets in Tableau

2. Creating Sets in Tableau

3. Parameters

26. Dashboard and Story

1. Dashboard part -1

2. Dashboard part - 2

3. Story

27. Appendix

1. Connecting to SQL data source

2. Connecting to cloud storage services

3. The final milestone!

28. Congratulations and about your certificate

1. Bonus lecture.html

179,000 تومان

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

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

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

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