Course Outline
Introduction to Tableau Desktop
Overview of Tableau Desktop
- What is Tableau?
- Key features and benefits
- Tableau interface and navigation
Understanding Data Visualization Principles
- Importance of visual data representation for government operations
- Best practices for effective visualization in the public sector
Types of Data Connections
- Connecting to Excel, CSV, and text files for government use
- Connecting to databases (SQL Server, Oracle, etc.) for government applications
- Connecting to cloud-based data sources (Google Sheets, AWS, etc.) for government projects
Managing Data Connections
- Live vs. extract connections in a government context
- Data connection settings and management for government datasets
Understanding Data Types and Structure
- Dimensions and measures in government data analysis
- Discrete vs. continuous fields for government reporting
Data Preparation Techniques
- Cleaning and shaping data in Tableau for government use
- Renaming, splitting, and merging fields for government datasets
Using Tableau’s Data Interpreter
- Automatic data cleaning for government data sources
- Handling null values and missing data for government reports
Joining and Blending Data
- Inner joins, left joins, right joins, full joins in government datasets
- Blending data from different sources for comprehensive government analysis
Creating and Formatting Tables
- Simple tabular views for government reports
- Formatting rows, columns, and cells for government presentations
Creating Graphs and Charts
- Bar charts, line charts, and pie charts for government visualizations
- Dual-axis charts and combination charts for government data analysis
Creating Filters
- Using filters for dimensions and measures in government dashboards
- Interactive filters in dashboards for government use
Creating Maps
- Geographic mapping for government applications
- Plotting data on maps with latitude/longitude for government projects
- Creating filled maps for government visualizations
Working with Hierarchies and Groups
- Building hierarchies for drill-down analysis in government datasets
- Grouping data for enhanced analysis in government reports
Using Sets
- Static and dynamic sets for government data management
- Applying sets in filters and calculations for government use
Creating Calculated Fields
- Basic formulas and functions for government data analysis
- Logical functions (IF, CASE, etc.) for government reports
- String functions and date functions for government datasets
Using Parameters
- Introduction to parameters for government applications
- Creating and using parameters for dynamic visualizations in government dashboards
- Parameters in filters and calculated fields for government use
Building Dashboards
- Creating a basic dashboard for government reporting
- Adding interactive filters and actions for government presentations
- Formatting dashboards for presentation to government stakeholders
Storytelling with Tableau
- Using story points to tell a narrative in government reports
- Combining visualizations for impactful storytelling in government communications
Exporting and Sharing Workbooks
- Exporting to PDF, PowerPoint, and images for government presentations
- Sharing workbooks via Tableau Public for government collaboration
Publishing to Tableau Server
- Introduction to Tableau Server for government use
- Publishing dashboards for collaborative use in government agencies
Summary and Next Steps
Requirements
- Basic understanding of data concepts, including databases, spreadsheets, and CSV files
- Familiarity with fundamental computer operations
Audience for Government
- Data analysts
- Managers
Testimonials (5)
The energy, knowledge and style of teaching of the trainer
Ioana - MOLSONCOORS GLOBAL BUSINESS SERVICES SRL
Course - From Tableau Beginners to Advanced User
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 - DLA Piper GSC Poland Sp. z o.o.
Course - Tableau Intermediate Training Course
The trainer answered all of my questions and gives us a walkthrough.
Mark Xavier Rimas - AIGSS- BPI
Course - Tableau Fundamentals to Advanced
The knowledge of trainor about the tool.
Kendrick Bacani - Thakral One Inc.
Course - Data analysis with Tableau
In terms of product knowledge, he’s really knowledgeable and very open to answer questions.