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!
__________
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 the full business intelligence stack? Search for “Maven Analytics” to browse our full course library, including Excel, Power BI, MySQL, Tableau and 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.
