• Post category:StudyBullet-14
  • Reading time:12 mins read
🎫 Apply Coupon Code➛
FREE4DEC
Note:- This Coupon is Free for First 500 Enrollments Only!


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

What you will 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

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:


Get Instant Notification of New Courses on our Telegram channel.


📌 We are thrilled to unveil this latest course Tableau & Tableau Prep for Data Preparation & Visualization which is designed to unlock your full potential and propel you towards success. 🚀

📌 Whether you are an aspiring professional seeking to upskill or an enthusiast eager to explore a new passion, this course Tableau & Tableau Prep for Data Preparation & Visualization is tailor-made to cater to your unique learning journey.

📌 Enroll this course Tableau & Tableau Prep for Data Preparation & Visualization to embark on an exciting educational adventure that will redefine your capabilities and broaden your horizons. Get ready to dive into a world of knowledge, innovation, and growth!

📌 Explore our website daily to access a diverse range of free courses covering high-demand fields such as Cloud Computing, Data Analytics, and Cybersecurity. Dive into Trading insights and Real Estate investment strategies, or discover the nuances of Property management.

📌 Elevate your career with Online MBA Programs and College degrees. Explore various financial subjects like Health Insurance, Life Insurance, Credit Card tips, and Legal attorney courses. Our Health and Medical offerings cover Dentistry, Surgery, and beyond.

📌 Begin your Journey with travel-focused courses for Flight and Hotel booking know-how. Enhance your Home Improvement skills with our specialized offerings. Our platform presents learning opportunities across multiple disciplines, providing the latest insights in various industries. As you stay informed, your personal and professional growth thrives.

📌 Dive into Finance with courses on Personal Loans, Retirement Plans, Mutual Funds, and Financial Planning. Uncover insights into Health Insurance, Weight Loss Surgery, Dental Implants, Addiction or Cancer Treatment. Whether you are interested in trading or need guidance on Car or Motorcycle Insurance, our courses empower your knowledge journey.
  • Develop sophisticated data visualizations that will impress your stakeholders
  • Master the art of data storytelling and effectively communicate your insights
  • Build interactive dashboards that will allow your stakeholders to easily explore and understand your data
  • Streamline your data preparation process with Tableau Prep
  • Automate repetitive data preparation tasks to save time and increase efficiency

Data 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.

English
language

Content

Introduction

Introduction

Installation and getting started

Tableau prep Installation
Course Resources
This is a Milestone!
The example problem statement
Demonstration of Tableau transformation

Basic concepts – Theory for foundational understanding

What is ETL
Data Warehouse, Ops Database
Inmon vs Kimble
ETL vs ELT

The ETL process: The practical part begins here

Data and the ETL process

DATA EXTRACTION: Extracting tabular data

Inputting Data from a TXT (text) file
Inputting Data from CSV file
Inputting Data from Excel file

Extracting data from an SQL table

Plan for importing sales data
Installing and setting up postgreSQL
Creating sales table in SQL
Exporting from an SQL table

Storing and Retrieving Data from Cloud storage

Storing and Retrieving Data on Google Drive
Importing Product data

Merging Data streams

Merging customer table
Merging Sales Data

Data Cleansing

Introduction to Data Cleansing
Value Mapping
Replacing Strings
Fuzzy Matching Concepts
Fuzzy Matching in Tableau Prep
Changing data format
Common data Cleaning steps

Data Validation

Introduction to Data validation
Data validation 1 – String to Int and integer and range validations
Data validation 2 – Checking Reference Values
Data validation 3 – Order date < shipping date
Common data validation

Error Handling

Correcting the errors
Writing the error to separate file

Transformation and Analytics steps

Concatenation
Aggregation
Normalization and Denormalization
Cateorising customers with Age

Conceptual understanding for Loading Data

Facts and dimension table
Surrogate key in dimension table

Loading the data into a Data Mart

Creating tables in Database
Loading Customer Data
Loading Product Data
Loading Sales Data
Moving to Tableau Desktop

Tableau Desktop and Tableau Public

Why Tableau
Tableau Products

Installation and getting started

Installing Tableau desktop and Public
About the data
Connecting to data
Live vs Extract

Combining data to create Data model

Combining data from multiple tables
Relationships in Tableau
Joins in Tableau
Types of Joins in Tableau
Union in Tableau
Physical Logical layer and Data models
The visualization screen – Sheet

Data categorization in Tableau

Types of Data – Dimensions and Measures
Types of Data – Discreet and Continuous
Changing Data type in Tableau

Most used charts

Bar charts
Line charts
Scatterplots

Customizing charts using Marks shelf

Marks cards
Dropping Dimensions and Measures on marks card
Adding marks in scatterplot

Other important charts

Text tables, heat map and highlight tables
Pie charts
Area charts
Creating custom hierarchy
Tree map
Dual combination charts
Creating Bins

Grouping and Filtering data

Grouping Data
Filtering data
Dimension filters
Measure filters
Date-Time filters
Filter options
Types of filters and order of operation
Customizing visual filters
Sorting options

Map charts in Tableau

How to make a map chart
Considerations before making a Map chart
Marks card for customizing maps
Customizing maps using map menu
Layers in a Map
Visual toolbar on a map
Custom background images
Territories in maps
Data blending for missing geocoding

Calculations and Analytics

Calculated fields in Tableau
Functions in Tableau
Table calculations theory
Table calculations in Tableau
Understanding LOD expressions
LOD expressions examples
Analytics pane

Sets and parameters

Understanding sets in Tableau
Creating Sets in Tableau
Parameters

Dashboard and Story

Dashboard part -1
Dashboard part – 2
Story

Appendix

Connecting to SQL data source
Connecting to cloud storage services
The final milestone!

Congratulations and about your certificate

Bonus lecture