Course Outline
Introduction
- Tableau Prep Builder as an ETL (Extract, Transform and Load) tool
Setting up Tableau Prep Builder
- Activating and Register 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
- 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
Outputing 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
Audience
- Data analysts
- Data scientists
Testimonials
The way he sure that each trainee understand each process.
Thakral One Inc.
All the information and details he shared about Tableau and the examples he showed us as well
Thakral One Inc.
The training is very informative and interactive in terms of the hands-on activities.
John Marnel San Pedro - Thakral One Inc.
The training is very informative and interactive in terms of the hands-on activities.
John Marnel San Pedro - Thakral One Inc.
Training exercises and hands on practice.
Thakral One Inc.
The knowledge of trainor about the tool.
Kendrick Bacani - Thakral One Inc.
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Instructor was very good.
Tech NorthWest Skillnet
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
Learning the different ways to present data
Katie Matthews - Quofox GmbH
All good
Tabreed
The learnings on parameters are great
JPMorgan Chase Bank, N.A – Philippine Global Service Center
all the materials and how the trainer teach
Ma Rowenaliz Gayoma - JPMorgan Chase Bank, N.A – Philippine Global Service Center
I liked that the trainer could see all desktops and could see if anyone was struggling it was a great interactive training.
Claire - Bernie Carlin, Tech Northwest Skillnet
Although a lot of information was presented, it was presented in a way where we could take learning from it, everything was well explained.
Donna - Bernie Carlin, Tech Northwest Skillnet
Thought it was a very good course.. Im a beginner and everything explained perfectly and at a good pace.
Noreen Gallagher - Elaine Rodger, Tech Northwest Skillnet
I liked how we could work alongside instructor within our own VM. This kept us engaged
Michelle Ahern - Elaine Rodger, Tech Northwest Skillnet
Very hands on approach to learning Approachable and well informed on the course materials. structured approach to training.
Deepika Vasudevan - Elaine Rodger, Tech Northwest Skillnet
Trainer was knowledgable and friendly, and did well to balance exercises and demonstrations. He was also good at assisting those who were struggling/needed any help with tasks.
Alan O'Reilly - Elaine Rodger, Tech NorthWest Skillnet
Virtual desktop sharing.
Elaine Rodger, Tech NorthWest Skillnet
Kostas kept the pace going thorughout.
Lloyd Carr - Elaine Rodger, Tech NorthWest Skillnet
Costas was fluid in his approach to training. He started at the why and gave really understanding and then application. He was really easy to understand and always answered questions really well.
Zara O'Gorman - Elaine Rodger, Tech NorthWest Skillnet
Trainer was great and very patient with us. Anything we asked, he explained very well. He shared is VM and we were able to follow his direction on using Tableau by seeing what he was doing. it was a great help to me.
Ciera McCarron Toland - Elaine Rodger, Tech NorthWest Skillnet
loved the hands on exercises and that the trainer walked us through how to do them and helped anyone that was having an issue. He made excellent use of the training room functionality and actually watched everyones progress.
Jill Schmaedeke - Elaine Rodger, Tech NorthWest Skillnet
Weronika created a really friendly, informal atmosphere. The training involved a lot of useful knowledge transfer, technical skills exercises and theory, as well as best practices and guidance on how to handle our own data.
Julia Kuczma - Julia Kuczma, DLA Piper GSC Poland Sp. z o.o.
Statistics and Array manipulation, Khobeib was able to spend time working through specific analytical questions with us and demonstrate custom calculations and solutions to our questions. Khobeib was also able to adjust the training to our pace and level of understanding. Having worked with data for some time some of the intermediate level core subjects were not required. To his credit Khobeib took this on board and moved through the contents at a speed relevant to our knowledge and understanding.
Department of Home Affairs
Su paciencia y forma de transmitir el conocimiento
Estefania - Ruth Elizabeth Rodriguez Escamilla, si
The Practice, I created a dashboard is super easy, once time understand the subjects.
Luis Fernando - Ruth Elizabeth Rodriguez Escamilla, si
Hand's on exercise under the control of trainer. All attendees were thus highly encouraged to participate.
Gerard Suissa - Brown-Forman France
The trainer answered all of my questions and gives us a walkthrough.
Mark Xavier Rimas - AIGSS- BPI
Almost every topic we had the chance to do it ourselves and that really help us learn it easier
AIGSS- BPI
Plenty of exercise to do to better understand the topic.