Course Outline
Introduction and Initial Setup
Data Filtering, Ordering, and Grouping
- Advanced configurations for filtering and element concealment
- Comprehensive review of ordering and data grouping methodologies
- Application of sorting, groups, bins, and sets
- Analysis of interdependencies among configuration options
Data Management within Tableau
- Differentiation between dimensions and measures
- Classification of data types: discrete versus continuous
- Integration of multiple database sources
- Implementation of inner, left, and right join strategies
- Data blending across distinct sources within a unified worksheet
- Utilization of data extracts in place of live connections for enhanced performance
- Mitigation of data quality anomalies
- Management of metadata and connection sharing protocols
Data Calculations and Statistical Analysis
- Execution of row-level calculations
- Implementation of aggregate calculations
- Arithmetic, string, and date-based computations
- Development of custom aggregations and calculated fields
- Utilization of control-flow logic
- Examination of underlying processing mechanisms
- Application of advanced statistical techniques
- Handling of date and time data structures
Table Calculations
- Implementation of rapid table calculations
- Definition of scope and calculation direction
- Configuration of addressing and partitioning rules
- Deployment of complex table calculations
Advanced Geospatial Techniques
- Construction of foundational map visualizations
- Configuration of geographic fields and map settings
- Customization of geographic display parameters
- Integration of Web Map Service (WMS) standards
- Visualization of non-geographic data using background imagery
- Best practices for effective cartography
- Calculation of geographic distances
Application of Parameters in Tableau
- Creation and definition of parameters
- Incorporation of parameters within calculated fields
- Configuration of parameter control mechanisms
- Enhancement of analytical depth and visual output through parameters
Construction of Advanced Chart Visualizations
- Bar chart variations, including bullet charts, bar-in-bar, and highlight charts
- Date and time visualizations, including Gantt charts
- Stacked bars, treemaps, area charts, and pie charts
- Heat map implementation
- Key Performance Indicator (KPI) chart design
- Pareto chart construction
- Bullet chart configuration
Advanced Formatting
- Application of data labels
- Configuration of legends
- Use of highlighting techniques
- Placement of annotations
Narrative Data Storytelling via Dashboards
- Establishment of dashboard architectural frameworks
- Implementation of filter actions
- Application of highlight actions
- Configuration of URL actions
- Design of cascading filter structures
Trend Analysis and Forecasting
- Interpretation and customization of trend lines
- Analysis of data distributions
- Execution of predictive forecasting models
Integration of Tableau and R for Advanced Data Analytics
- Option to incorporate diverse R-based analytics methodologies upon participant request
Requirements
- Familiarity with Tableau fundamentals, including data connections and basic visualization principles
- Proficiency in creating dashboards and worksheets within Tableau
- Foundational understanding of data analysis and visualization concepts relevant to the public sector
Target Audience
- Data analysts seeking to enhance their Tableau capabilities for government use
- Business intelligence professionals engaged in data visualization for public sector governance
- Advanced Excel or reporting users transitioning to Tableau for improved data management and analytics
Testimonials (7)
Great knowledge of the content, good examples, great rapport with the class and very understanding if anyone needed extra help. Willing to stop and go back to explain things again and in a manner in which could be easily understood.
Martina O'Neill - Tech NorthWest Skillnet
Course - Tableau Advanced
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Course - Tableau Advanced
Ability to direct the content covered to suit individual needs
Stefan Wroblewski - Tech NorthWest Skillnet
Course - Tableau Advanced
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
Course - Tableau Advanced
The number of working examples.
Sharon Clarke - Tech NorthWest Skillnet
Course - Tableau Advanced
Learning the different ways to present data
Katie Matthews - Quofox GmbH
Course - Tableau Advanced
all the materials and how the trainer teach