Tableau Prep for Business Intelligence

Learn how to use Tableau Prep & Tableau Prep Builder to clean, shape and prepare data for analysis & visualization

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

Tableau Prep (free 14-day trial, then $70/mo)
We'll walk through the download & installation process (you do NOT need to have Tableau Prep already installed)
Prior experience with Tableau Desktop is helpful, but not required

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 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 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 new Tableau 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 BI professional or just looking to take your Tableau Prep skills to the next level, this is the course for you!

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