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

What you'll learn

Master the art of data preparation and cleaning with Tableau Prep

Explore the Tableau interface and workflow for data preparation and visualization

Learn how to use Tableau to explore and analyze data to make data-driven decisions

Explore data blending techniques to integrate data from multiple sources

Master the use of data hierarchies and groupings to organize and filter data

Build your skills in using calculated fields and parameters to create advanced visualizations

Learn how to use advanced mapping techniques to visualize geographic data

Requirements

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

Description

If you are looking to take your data preparation and visualization skills to the next level, then Tableau & Tableau Prep for Data Preparation & Visualization is the course for you! Are you tired of spending hours wrangling your data, only to be left with less than satisfactory visualizations? Do you struggle to tell a compelling data story to your stakeholders? Look no further!In this course, you will develop advanced analytics skills and become a data storytelling expert. You will master the art of data preparation and visualization using the powerful Tableau and Tableau Prep tools. Here are some of the key benefits you will gain from this course:Develop sophisticated data visualizations that will impress your stakeholdersMaster the art of data storytelling and effectively communicate your insightsBuild interactive dashboards that will allow your stakeholders to easily explore and understand your dataStreamline your data preparation process with Tableau PrepAutomate repetitive data preparation tasks to save time and increase efficiencyData is the backbone of decision making, and the ability to effectively analyze and communicate data is a highly sought-after skill in today's job market. In this course, you will complete hands-on activities such as building interactive dashboards, cleaning and transforming data, and crafting compelling data narratives.This course is different because it combines the power of Tableau and Tableau Prep, giving you a holistic approach to data preparation and visualization. You'll learn from industry experts who have years of experience in data analytics and visualization. Join us now to accelerate your analytics skills and become a pro at preparing and visualizing data.

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 Retrieving 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 Concepts

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 and 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 Cateorising 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

Lecture 47 Moving to Tableau Desktop

Section 15: Tableau Desktop and Tableau Public

Lecture 48 Why Tableau

Lecture 49 Tableau Products

Section 16: Installation and getting started

Lecture 50 Installing Tableau desktop and Public

Lecture 51 About the data

Lecture 52 Connecting to data

Lecture 53 Live vs Extract

Section 17: Combining data to create Data model

Lecture 54 Combining data from multiple tables

Lecture 55 Relationships in Tableau

Lecture 56 Joins in Tableau

Lecture 57 Types of Joins in Tableau

Lecture 58 Union in Tableau

Lecture 59 Physical Logical layer and Data models

Lecture 60 The visualization screen - Sheet

Section 18: Data categorization in Tableau

Lecture 61 Types of Data - Dimensions and Measures

Lecture 62 Types of Data - Discreet and Continuous

Lecture 63 Changing Data type in Tableau

Section 19: Most used charts

Lecture 64 Bar charts

Lecture 65 Line charts

Lecture 66 Scatterplots

Section 20: Customizing charts using Marks shelf

Lecture 67 Marks cards

Lecture 68 Dropping Dimensions and Measures on marks card

Lecture 69 Adding marks in scatterplot

Section 21: Other important charts

Lecture 70 Text tables, heat map and highlight tables

Lecture 71 Pie charts

Lecture 72 Area charts

Lecture 73 Creating custom hierarchy

Lecture 74 Tree map

Lecture 75 Dual combination charts

Lecture 76 Creating Bins

Section 22: Grouping and Filtering data

Lecture 77 Grouping Data

Lecture 78 Filtering data

Lecture 79 Dimension filters

Lecture 80 Measure filters

Lecture 81 Date-Time filters

Lecture 82 Filter options

Lecture 83 Types of filters and order of operation

Lecture 84 Customizing visual filters

Lecture 85 Sorting options

Section 23: Map charts in Tableau

Lecture 86 How to make a map chart

Lecture 87 Considerations before making a Map chart

Lecture 88 Marks card for customizing maps

Lecture 89 Customizing maps using map menu

Lecture 90 Layers in a Map

Lecture 91 Visual toolbar on a map

Lecture 92 Custom background images

Lecture 93 Territories in maps

Lecture 94 Data blending for missing geocoding

Section 24: Calculations and Analytics

Lecture 95 Calculated fields in Tableau

Lecture 96 Functions in Tableau

Lecture 97 Table calculations theory

Lecture 98 Table calculations in Tableau

Lecture 99 Understanding LOD expressions

Lecture 100 LOD expressions examples

Lecture 101 Analytics pane

Section 25: Sets and parameters

Lecture 102 Understanding sets in Tableau

Lecture 103 Creating Sets in Tableau

Lecture 104 Parameters

Section 26: Dashboard and Story

Lecture 105 Dashboard part -1

Lecture 106 Dashboard part - 2

Lecture 107 Story

Section 27: Appendix

Lecture 108 Connecting to SQL data source

Lecture 109 Connecting to cloud storage services

Lecture 110 The final milestone!

Section 28: Congratulations and about your certificate

Lecture 111 Bonus lecture

Business analysts who want to improve their data visualization and analysis skills,Students and professionals who are new to data analysis and want to learn Tableau and Tableau Prep from scratch.,Data analysts who want to learn how to use Tableau prep for data preparation and Tableau for visualization