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
 21 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories