image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Tableau Prep
is an industry-leading data prep tool, with intuitive tools for combining, shaping, and cleaning raw data for analysis. With data prep often accounting for >80% of the data analytics workflow,
these skills are
critical
for any analyst or business intelligence pro
!
This course is a
practical
,
hands-on
, and
project-based
introduction to Tableau Prep and Tableau Prep Builder, designed to teach you how to connect to sources, examine and filter data, apply operations and custom calculations, join and pivot tables, and share data outputs. As always, we’ll be applying these tools to real-world business intelligence use cases every step of the way.
Throughout the course, you’ll be playing the role of Data Analyst for
Maven Charter Schools
, an up-and-coming private institution. Your mission? Use Tableau Prep, and the skills you learn throughout the course, to prepare data from a variety of sources, including teacher pay, SAT scores, graduation rates, and more.
But don't worry, we'll be guiding you each step of the way, with
crystal clear explanations
and 
helpful pro tips
to help you build your Tableau Prep skills.
We'll start with how to connect and configure sources, and apply operations for grouping, splitting and cleaning data. From there, we'll create custom LOD and analytic calculations, and use tools to join, aggregate and transform tables. Finally, we'll review options for saving, updating, and publishing data outputs, along with tools to automate and share flows built with Tableau Prep.
COURSE OUTLINE:
Introducing Tableau Prep
Tableau Prep download, user roles, workspace, visual dictionary, data design, etc.
Connecting to Data
Connection types, unions & joins, data sampling, refreshing data, etc.
Examining & Filtering
Data types & sizes, value distribution, highlighting, filtering methods, etc.
Operations & Calculations
Value & field operations, clean step layouts, calculated fields, LOD calculations, etc.
Combining & Pivoting
Union & join, aggregate, pivot, organize your flow, etc.
Sharing & Updating
Desktop preview, local extracts, published data sources, external databases, etc.
Throughout the course, you’ll come across unique opportunities to put your Tableau data prep and analysis skills to the test, like consolidating World Happiness data, profiling Indian dish recipes, cleaning survey response data, exploring F1 race results, and more.
Whether you’re an aspiring data analyst, business intelligence professional or data scientist, or just looking to take your Tableau Prep skills to the next level,
this is the course for you
!
__________
Join today and get
immediate, lifetime access 
to the following:
5+ hours of high-quality video
Tableau Prep for Business Intelligence ebook
Downloadable Tableau project files & solutions
Homework assignments & quizzes
Course Q&A forum
30-day money-back guarantee
See you in the course!
-Dustin

(Featured Tableau Author & Lead Tableau Instructor,
Maven Analytics
)
__________
Looking for our full course library?
Search "
Maven Analytics
" to browse our full collection of
Excel, Power BI, SQL
,
 Tableau
,
Python
,
Alteryx
&
Machine Learning
courses!
See why our courses are among the TOP-RATED on Udemy:
"Some of the BEST courses I've ever taken. I've studied several programming languages, Excel, VBA and web dev, and Maven is among the very best I've seen!"
Russ C.
"This is my fourth course from Maven Analytics and my fourth 5-star review, so I'm running out of things to say. I wish Maven was in my life earlier!"
Tatsiana M.
"Maven Analytics should become the new standard for all courses taught on Udemy!"
Jonah M.
Who this course is for:
Anyone looking for a hands-on, project-based introduction to Tableau Prep
Analytics or BI professionals who need to clean and prepare raw data
Aspiring data professionals looking to add Tableau skills to the resume
Anyone seeking to learn one of the industry's most popular data prep tools
Students who want a comprehensive, engaging, and highly interactive approach to training

What you'll learn

Build professional-quality data flows with Tableau Prep

Combine, shape, clean, and prepare raw data for analysis

Learn the same tools used by professional business intelligence analysts and data scientists

Showcase your skills with unique course projects & assignments (with step-by-step solutions)

Explore unique data sets and case studies (Retail, Restaurants, Banking & HR)

Learn from a best-selling instructor, featured author, and award-winning Tableau developer

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Getting Started
5
1.1-Course Structure & Outline
1.2-READ ME: Important Notes for New Students
1.3-DOWNLOAD: Course Resources
1.4-Introducing The Course Project
1.5-Setting Expectations
2-Introducing Tableau Prep
8
2.1-Meet Tableau Prep
2.2-Tableau User Roles
2.3-Downloading Tableau Prep
2.4-Tableau Prep Workspace
2.5-Visual Dictionary
2.6-Example Flow Diagram
2.7-PRO TIP: Data Design
2.8-Introducing Tableau Prep
3-Connecting to Data
12
3.1-Connecting to Data
3.2-Data Connection Types
3.3-Data Connection Examples
3.4-Wildcard Unions
3.5-PRO TIP: Input Joins
3.6-Input Cleaning
3.7-Text Configuration
3.8-Data Sampling
3.9-Refreshing Data
3.10-ASSIGNMENT: Connecting to Data
3.11-SOLUTION: Connecting to Data
3.12-Connecting to Data
4-Examining & Filtering
10
4.1-Examining & Filtering
4.2-Data Types & Sizes
4.3-Value Distribution
4.4-Finding Fields & Values
4.5-Sorting & Moving Profile Cards
4.6-Highlighting
4.7-Filtering Methods
4.8-ASSIGNMENT: Examining & Filtering
4.9-SOLUTION: Examining & Filtering
4.10-Examining & Filtering
5-Operations & Calculations
6
5.1-Operations & Calculations
5.2-Value & Field Operations
5.3-Clean Step Layouts
5.4-PRO TIP: Pausing Data Updates
5.5-Value Operations
5.6-Value Operations
Clean;5.7-Value Operations
2
Manual Grouping
5.8-Value Operations
Automatic Grouping;5.9-Value Operations
2
Split Values
5.10-Value Operations
Edit;5.11-Value Operations
2
Convert Dates
5.12-Field Operations
Field Types;5.13-Field Operations
2
Data Roles
5.14-Field Operations
Cleaning;5.15-Calculated Fields;5.16-Level of Detail Calculations;5.17-Analytic Calculations
6
Rank
5.18-PRO TIP: Copy & Paste
5.19-PRO TIP: Reusable Flow Steps
5.20-ASSIGNMENT: Operations & Calculations
5.21-SOLUTION: Operations & Calculations
5.22-Operations & Calculations
6-Combining & Pivoting
2
6.1-Combining & Pivoting
6.2-Combine Data
Union;6.3-Union Results & Common Issues;6.4-Combine Data
2
Aggregate
6.5-Combine Data
Join;6.6-Join Results & Common Issues;6.7-Pivot;6.8-PRO TIP: Organize Your Flow;6.9-ASSIGNMENT: Combining & Pivoting;6.10-SOLUTION: Combining & Pivoting;6.11-Combining & Pivoting
1
7-Sharing & Updating
7.1-Sharing & Updating;7.2-Saving Flows;7.3-PRO TIP: Preview in Desktop;7.4-Creating Local Extracts;7.5-Saving to External Databases;7.6-Creating Published Data Flows;7.7-PREVIEW: Tableau Prep Conductor;7.8-ASSIGNMENT: Sharing & Updating;7.9-SOLUTION: Sharing & Updating;7.10-Sharing & Updating
1
8-Wrapping Up
8.1-BONUS LESSON
0