Course Outline
Introduction
Configuring Tableau
Overview of Tableau Features and Architecture
Navigating the Tableau User Interface
Establishing Data Connections
Organizing, Filtering, Sorting, and Grouping Data
- Structuring your data effectively.
- Slicing data by date ranges.
- Simplifying views and applying sorting rules.
- Advanced techniques for filtering and hiding data.
- Exploring various options for ordering and grouping datasets.
- Managing Sorts, Groups, Bins, and Sets.
- Understanding the interplay between these functional elements.
Handling Data within Tableau
- Incorporating multiple measures into a single view.
- Visualizing relationships between numerical values.
- Inspecting specific data points.
- Customizing data presentation.
- Distinguishing between Dimensions and Measures.
- Understanding data types: discrete vs. continuous for measures.
- Joining multiple database sources.
- Applying Inner, Outer, Left, and Right joins.
- Blending different data sources within a worksheet.
- Utilizing extracts versus live connections.
- Identifying and addressing data quality issues.
- Managing metadata and sharing connections.
Data Calculations and Statistical Analysis
- Performing row-level calculations.
- Executing aggregate calculations.
- Working with arithmetic, string, and date calculations.
- Defining custom aggregations and calculated fields.
- Implementing control-flow logic.
- Understanding the underlying computational mechanisms.
- Applying advanced statistical methods.
- Manipulating dates and time values.
Deep-Dive into Table Calculations
- Utilizing quick table calculations.
- Defining scope and direction.
- Managing addressing and partitioning.
- Advanced table calculation techniques.
Advanced Geographic Techniques
- Creating foundational maps.
- Configuring geographic fields and map options.
- Plotting data geographically.
- Customizing geographic views.
- Integrating Web Map Service (WMS).
- Visualizing non-geographic data using background images.
- Strategies for effective mapping.
- Performing distance calculations.
Implementing Parameters in Tableau
- Creating and managing parameters.
- Using parameters within calculated fields.
- Configuring parameter control options.
- Enhancing analytical depth and visualization interactivity with parameters.
Constructing Basic and Advanced Visualizations
- Creating cross tabs.
- Developing geographic maps, heat maps, and tree maps.
- Generating pie charts and bar charts.
- Designing date/time visualizations and Gantt charts.
- Building stacked bars and area charts.
- Visualizing KPIs and Pareto charts.
- Creating dual-axis and combined charts with varied mark types.
- Implementing highlight tables.
- Generating scatter plots.
- Exploring bar chart variations, including bullet charts and bar-in-bar designs.
Advanced Formatting Options
- Adding and formatting labels.
- Customizing legends.
- Emphasizing data with reference lines.
- Inserting annotations for clarity.
Storytelling with Data Dashboards
- Establishing a dashboard framework.
- Implementing filter actions.
- Using highlight actions.
- Configuring URL actions.
- Setting up cascading filters.
Identifying Trends and Forecasting
- Interpreting and customizing trend lines.
- Analyzing data distributions.
- Performing forecasting.
Integrating Tableau and R for Advanced Data Analytics
- Option to incorporate specific R-based data analytics methods upon participant request.
Troubleshooting Best Practices
Summary and Conclusion
Requirements
- Prior experience with business intelligence and data visualization concepts.
Audience
- Data Analysts
- Data Scientists
Testimonials (3)
The Practice, I created a dashboard is super easy, once time understand the subjects.
Luis Fernando - si
Course - Tableau Fundamentals to Advanced
Hand's on exercise under the control of trainer. All attendees were thus highly encouraged to participate.
Gerard Suissa - Brown-Forman France
Course - Tableau Fundamentals to Advanced
The trainer answered all of my questions and gives us a walkthrough.