Tableau Prep Builder Training Course
Tableau Prep Builder is a software application designed for combining, shaping, and cleaning data to prepare it for analysis. It allows users to extract data from diverse sources, transform it, and output the results for analytical purposes.
This instructor-led, live training (available online or onsite) targets data analysts who want to effectively prepare and shape their data using Tableau Prep Builder.
Upon completing this training, participants will be equipped to:
- Install Tableau Prep.
- Understand and implement a Data Science Workflow.
- Import data from various sources, including Excel and databases.
- Prepare, shape, and sample data for analysis within Tableau Desktop.
- Explore and validate data.
- Create and publish Tableau Prep flows.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practice sessions.
- Hands-on implementation in a live-lab environment.
Customization Options
- To request customized training for this course, please contact us to make arrangements.
Course Outline
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform and Load) tool
Setting up Tableau Prep Builder
- Activating and Registering Tableau Prep Builder
Overview of Tableau Prep Builder Features and Architecture
- Tableau Prep Builder and its relation to Tableau Desktop, Tableau Server and Tableau Prep Conductor
Navigating the Tableau Prep Builder Workspace
- Panes and data grids
Connecting to Data Source
- Reading an Excel file
- Reading from a database
Shaping Data
- Creating a Join
- Creating a Union
Pivoting Data
- Changing columns to rows
Cleaning Data
- What is dirty data?
- Changing the data type
- Filtering data
- Aggregating data
- Updating multiple values at once
Running a Flow
- Building a flow
- Refreshing a flow
- Running a flow from the command line
Outputting Data to Tableau Desktop
- Analyzing data
Publishing Data
- Packaging a Prep Builder data flow into an extract
- Publishing a flow with Prep Conductor
Best Practices
Troubleshooting
Summary and Conclusion
Requirements
- Experience with Tableau Desktop
- Experience writing calculations
Target Audience
- Data analysts
- Data scientists
Open Training Courses require 5+ participants.
Tableau Prep Builder Training Course - Booking
Tableau Prep Builder Training Course - Enquiry
Tableau Prep Builder - Consultancy Enquiry
Testimonials (2)
The joyful atmosphere, the openness of the knowledgeable trainer who offered us a lot of tips and tricks.
Ionut - MOLSONCOORS GLOBAL BUSINESS SERVICES SRL
Course - From Tableau Beginners to Advanced User
No pressure on the attendance
Agata Budzynska - Tech NorthWest Skillnet
Course - Tableau Fundamentals
Upcoming Courses
Related Courses
Data Visualization Principles for Tableau
14 HoursThis course explores the science of human perception and demonstrates how to leverage it to generate powerful insights. You will gain proficiency in design theory, covering Gestalt laws, pre-attentive attributes, and inclusive design practices. The curriculum also clarifies the distinctions and overlaps between exploratory and explanatory data analysis. You will learn how to select the most appropriate chart types for specific data scenarios. By the conclusion of the course, you will be equipped to apply effective design principles to visualizations created within the Tableau software.
Data Analysis with SQL, Python, and Tableau
14 HoursThis instructor-led, live training in South Korea (online or onsite) is tailored for data scientists and developers who aim to utilize and integrate SQL, Python, and Tableau for complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.
Tableau Fundamentals
14 HoursThroughout this course, you will gain the ability to:
Designed as an introductory course for Tableau users, this program is tailored for anyone interested in working with data. It aims to help you master the core functionalities of Tableau.
- Establish connections with your data.
- Edit and save data sources.
- Grasp Tableau-specific terminology.
- Leverage the Tableau interface and paradigm to create impactful visualizations.
- Develop basic calculations, such as fundamental arithmetic, custom aggregations, ratios, date operations, and quick table calculations.
-
Utilize the following visualization types to represent your data:
- Cross tabs
- Geographic maps
- Heat maps
- Tree maps
- Pie charts and bar charts
- Dual axis and combined charts with various mark types
- Highlight Tables
- Scatter Plots
- Construct dashboards to effectively share your visualizations.
Data Science with Tableau and R Programming
14 HoursUpon completing this training, participants will gain the ability to:
This instructor-led live training in South Korea (available online or onsite) is targeted at data scientists who wish to program R for Tableau.
- Integrate R-based analytics into Tableau.
- Return values to Tableau using R's machine learning algorithms.
- Organize and visualize R functions using Tableau.
- Drive business operational decisions through data analysis.
Tableau Desktop
21 HoursThis instructor-led, live training in South Korea (online or onsite) is aimed at beginner-level to intermediate-level data analysts who wish to use Tableau Desktop to transform raw data into meaningful insights through graphical representations such as charts, graphs, maps, and tables.
By the end of this training, participants will be able to:
- Connect to multiple types of data sources (Excel, CSV, databases, cloud-based) and understand the distinctions between live and extract connections.
- Prepare and clean data for analysis, including renaming fields, handling null values, and combining datasets through joins and blends.
- Create basic visualizations such as tables, bar charts, line charts, and maps, and apply filters to refine data presentations.
- Develop intermediate visualizations including geographic maps, dual-axis charts, and use hierarchies, groups, and sets to enhance analysis.
- Build calculated fields and parameters to create dynamic and customized visualizations based on user inputs and logic functions.
- Design interactive dashboards and stories, incorporating multiple visualizations and filters to tell a cohesive narrative.
Tableau Explorer: Interactive Data Analysis and Dashboard Navigation
7 HoursTableau Explorer represents a specific license tier within Tableau Cloud, tailored for users who engage with dashboards, apply filters, generate views, and collaborate with teams via published data sources.
This instructor-led live training, available either online or onsite, targets beginner to intermediate business users eager to explore, filter, and interact with data using the Tableau Explorer role in Tableau Cloud.
Upon completion of this training, participants will be able to:
- Confidently navigate Tableau dashboards and shared workbooks.
- Apply filters, drill down into details, and export data directly from dashboards.
- Create saved views and establish custom alerts triggered by data changes.
- Collaborate effectively with team members through comments, subscriptions, and shared views.
Course Format
- Interactive lectures paired with live demonstrations.
- Practical exercises utilizing shared dashboards and published content.
- Real-time practice in Tableau Cloud with guided exploration.
Customization Options
- To arrange a customized version of this course, please contact us to discuss your needs.
Tableau Forensic Imager
14 HoursBy the end of this training, participants will be able to:
This instructor-led, live training in South Korea (online or onsite) is designed for intermediate-level digital forensic and cybersecurity professionals who wish to develop a comprehensive understanding and practical skills in using Tableau Forensic Imager for digital forensic purposes.
- Understand the role and importance of digital forensic imaging in investigations.
- Operate Tableau Forensic Imager to acquire forensically sound images.
- Apply best practices in handling and preserving digital evidence.
- Navigate the software interface to configure, execute, and manage imaging tasks.
- Analyze and validate forensic images to ensure integrity and admissibility in court.
Tableau Fundamentals to Advanced
28 HoursThis instructor-led live training, available in South Korea (online or onsite), targets data analysts and data scientists who aim to explore, analyze, and visualize data using Tableau.
Upon completion of this training, participants will be equipped to:
- Establish connections with various data sources.
- Edit and save data sources efficiently.
- Gain a thorough understanding of key Tableau terminology.
- Navigate the Tableau interface and leverage its paradigms to create impactful visualizations.
- Develop complex calculations, including arithmetic operations, custom aggregations and ratios, date functions, and table calculations.
- Represent data effectively using a variety of visualization types.
- Construct interactive dashboards to share and present visual insights.
Tableau Prep Builder and Data Maps
21 HoursThis instructor-led, live training in South Korea (online or onsite) is aimed at beginner-level to intermediate-level data analysts who wish to gain practical knowledge of Tableau Prep Builder and the essential mapping functionalities in Tableau to address data preparation and visualization challenges.
By the end of this training, participants will be able to:
- Connect to a variety of data sources, including cloud-based and local files, and manage live and extracted data connections.
- Perform data fusion and combination using advanced joining techniques to merge multiple datasets from different sources for better analysis.
- Create calculated fields and perform operations to manipulate and analyze data dynamically.
- Publish and update prepared data to Tableau Server or Tableau Online, enabling automated updates and scheduling.
- Create basic and advanced maps with geographic data, including filled maps, density maps, and dual-axis maps.
- Apply mapping techniques to solve real-world business problems by creating interactive, detailed geographic visualizations.
Data Analysis with Tableau and Python
14 HoursTableau serves as a prominent business intelligence and data visualization platform, while Python is a versatile programming language that supports a broad spectrum of statistical and machine learning methods. By leveraging Tableau's robust visualization capabilities alongside Python's powerful machine learning functions, developers can swiftly construct sophisticated data analytics solutions tailored to diverse business requirements.
Through this instructor-led live training, attendees will discover how to effectively merge Tableau and Python for advanced analytical tasks. The integration between these two tools is facilitated via the TabPy API.
Upon completion of this training, participants will be able to:
- Integrate Tableau and Python using the TabPy API
- Utilize the combined power of Tableau and Python to analyze complex business scenarios with minimal Python code
Audience
- Developers
- Data scientists
Format of the course
- A mix of lectures, discussions, exercises, and extensive hands-on practice
Tableau Server for Architects
14 HoursUpon completion of this training, participants will gain the ability to:
This instructor-led, live training in South Korea (available online or onsite) is designed for intermediate to advanced-level data architects who wish to acquire the skills necessary for installing, configuring, managing, and maintaining a Tableau Server.
- Gain a comprehensive understanding of Tableau Server architecture.
- Grasp the core processes and functions of Tableau Server.
- Leverage Tableau Server to automate operational tasks.
- Configure and oversee the Tableau Server environment.
- Establish Tableau Server configurations for high availability and scalability.
Data Visualization for Nonprofit using Tableau Public
21 HoursIdeal for beginners or those seeking a refresher, this program guides learners through the foundational steps of creating their first visualization from scratch. Participants will also acquire essential design principles to enhance their Tableau dashboards. Upon completion, you will possess the skills to craft and disseminate impactful insights to a broader community.
Tableau Advanced
14 HoursThis instructor-led, live training in South Korea (online or onsite) is aimed at advanced-level data professionals who wish to use Tableau to build complex visualizations, optimize dashboards, and perform advanced data analysis.
By the end of this training, participants will be able to: install and configure Tableau for advanced use, create advanced calculations, design interactive dashboards, and optimize performance.
From Tableau Beginners to Advanced User
28 HoursThis engaging four-day course is designed for individuals new to Tableau. Participants will become proficient in all Tableau functionalities and learn how to create and share data visualizations. The curriculum guides you through every step of the process, from connecting to data sources, creating calculations, selecting appropriate chart types, building dashboards, to publishing your final work.
The course structure consists of lectures focused on specific topics, followed by practical exercises. It concludes with a 30-minute knowledge test and a 60-minute hands-on project assignment.
Course milestones:
- Get familiar with the Tableau interface.
- Connect to and work with your data.
- Utilize Tableau's key features.
- Build insightful visualizations.
- Share your work with a broader audience.
Course format:
- Interactive lectures and discussions.
- Ample exercises and practice opportunities.
- Hands-on implementation in a live-lab environment.
- Knowledge assessment and hands-on project at the course conclusion.