Course Outline
-
Connecting to datasources
- Loading data into Tableau
- Combining data tables – join
- Combining data from different sources– merge
- Extracting data to Tableau format
- SQL queries
- Managing data
- Renaming data
- Creating parameters (workbook variables)
- Metadata
-
Effective visualisations
- What makes a good visualisation
- Choosing the right chart
- The role of colour in data storytelling
- How to avoid misleading your audience
- Best practices
-
Calculations
- Arithmetic calculations
- Working with strings
- Operations on dates and time
- Array calculations
- Conditional and logical expressions
- Conditional filtering
-
Processing Array Data
- Difference between Excel and Tableau
- Processing arrays in Tableau
- Writing custom SQL statements
-
Statistics
- Adding reference and trend lines
- Calculating descriptive measures
- Subtotals
- Aggregation and disaggregation
- Forecasting
-
Building effective dashboards
- Combining visualizations
- Formatting dashboards
- Adding filters and actions to create interactive dashboards
- Making an aesthetically pleasing dashboard
- Best practices for creating dashboards
-
Sharing dashboards
- Publish to Tableau Reader
- Publish to Tableau Server
- Publish to PDF
Requirements
Recommended- attendance on the Tableau Fundamentals course (or similar level of experience)
Testimonials
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.
Tableau Intermediate Training Course Course
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.