Tableau Prep Masterclass – Data Preparation, Analysis & Etl – Download Free

Free Download 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
Requirements
A PC with internet connection to run Tableau Prep. You will be guided on how to setup Tableau prep in the course.
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 pipelineMaster Tableau Prep's ETL capabilities to effectively clean, combine, and transform your dataLeverage advanced analysis tools to generate deeper insights from your dataUtilize Tableau Prep's powerful automation features to simplify and accelerate your workflowsUnderstanding 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 PromiseTeaching 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!
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 Reading 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 Concept
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 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 Categorising 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
Section 15: Moving to Tableau Desktop
Lecture 47 Tableau Desktop
Section 16: Congratulations and about your certificate
Lecture 48 The final milestone
Lecture 49 Bonus Lecture
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
Homepage

https://www.udemy.com/course/tableau-prep-starttech/