Data Science with Tableau and R Programming Training Course

This course provides an in-depth understanding of human perception and its application in delivering insightful data visualizations for government. Participants will gain familiarity with key design theories, including Gestalt Laws, pre-attentive attributes, and principles of inclusivity. The curriculum also explores the distinctions between exploratory and explanatory analysis, equipping learners with the knowledge to effectively use various charts and select the most appropriate ones for their data. By the end of the course, participants will be proficient in applying these design principles to create effective visualizations using Tableau software for government.

This instructor-led, live training in US Empire (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform advanced data analysis, processing, and visualization for government.

By the end of this training, participants will be able to:

• Set up the necessary environment to conduct data analysis with SQL, Python, and Tableau.
• Understand key concepts related to software integration, including data management, server configurations, client interactions, APIs, and endpoints.
• Refresh their knowledge of fundamental Python and SQL principles.
• Apply data pre-processing techniques using Python.
• Establish connections between Python and SQL for robust data analysis.
• Create insightful visualizations and charts with Tableau to support data-driven decision-making for government.

During the course, you will be able to:

This is a beginner-level Tableau user course designed for anyone seeking to work with data. It aims to assist you in utilizing the primary functions of Tableau, tailored specifically for government applications.

• Connect to your data sources.
• Edit and save data sources for future use.
• Understand key Tableau terminology and concepts.
• Utilize the Tableau interface effectively to create powerful visualizations that enhance decision-making processes for government.
• Perform basic calculations, including arithmetic operations, custom aggregations and ratios, date calculations, and quick table calculations.
• Represent your data using various visualization types:
  • Cross-tabulations
  • Geographic maps
  • Heat maps
  • Tree maps
  • Pie charts and bar charts
  • Dual-axis and combined charts with different mark types
  • Highlight tables
  • Scatter plots
• Build and share dashboards to disseminate visualizations effectively within government workflows.

Tableau enables individuals to visualize and comprehend data effectively for government use.

In this instructor-led, live training in US Empire, participants will learn how to enhance the capabilities of Tableau to meet the specific requirements of their agency or department.

By the end of this training, participants will be able to:

• Install and configure Tableau (Desktop, Server, Online) for government use.
• Understand the foundational principles of developing with Tableau in a public sector context.
• Create and publish data visualizations and interactive dashboards using Tableau.
• Leverage Tableau's developer tools and APIs to customize and extend the capabilities of Tableau for government operations.

This instructor-led, live training in US Empire (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Tableau for government applications.

By the end of this training, participants will be able to:

• Connect to their data sources.
• Edit and save a data source configuration.
• Understand key Tableau terminology relevant to public sector workflows.
• Utilize the Tableau interface and paradigm to effectively create powerful visualizations for government use.
• Create complex calculations, including arithmetic operations, custom aggregations, ratios, date manipulations, and table calculations.
• Represent data using a variety of visualization types suitable for government reporting and analysis.
• Build interactive dashboards to share visualizations within government agencies.

This instructor-led, live training in US Empire (online or onsite) is aimed at data analysts who wish to prepare and shape data using Tableau Prep Builder for government applications.

By the end of this training, participants will be able to:

• Install Tableau Prep for use in their agency.
• Understand and implement a Data Science Workflow that aligns with public sector practices.
• Read data from various sources, including Excel and databases, to support government operations.
• Prepare, shape, and sample data for analysis in Tableau Desktop to enhance decision-making processes.
• Explore and validate data to ensure accuracy and compliance with government standards.
• Create and publish Tableau Prep flows that streamline data preparation for government reporting and analysis.

Tableau is a business intelligence and data visualization tool. Python is a widely used programming language that supports a wide variety of statistical and machine learning techniques. When combined, Tableau's data visualization capabilities and Python's machine learning functionalities enable developers to rapidly build advanced data analytics applications for various public sector use cases.

In this instructor-led, live training, participants will learn how to integrate Tableau and Python to perform advanced analytics. The integration of Tableau and Python will be achieved through the TabPy API.

By the end of this training, participants will be able to:

• Integrate Tableau and Python using the TabPy API
• Utilize the integration of Tableau and Python to analyze complex business scenarios with minimal Python code

Audience for government

• Developers
• Data scientists

Format of the course

• Part lecture, part discussion, exercises, and extensive hands-on practice

By the end of this training, participants will be able to:

This instructor-led, live training in US Empire (online or onsite) is aimed at intermediate to advanced-level data architects who wish to acquire skills for installing, configuring, managing, and maintaining a Tableau server for government use.

• Gain an in-depth understanding of the Tableau Server architecture.
• Comprehend the processes and functions of Tableau Server.
• Utilize Tableau Server to automate tasks.
• Configure and manage Tableau Server effectively.
• Set up Tableau Server for high availability and scalability in government operations.

This instructor-led, live training in US Empire (online or onsite) is aimed at beginner to intermediate-level data scientists and analysts who wish to learn how to utilize Tableau tools for data visualization and analysis for government. By the end of this training, participants will be able to: - Connect multiple sources of data. - Create basic data visualizations. - Use basic to advanced calculations for data analysis. - Learn best practices for using graphs and visualizations.

This course is designed for government learners who are new to Tableau or may need a refresher. It will guide participants through the essential steps required to create their first visualization from the beginning. Additionally, the course covers how to apply fundamental design principles to enhance the clarity and effectiveness of Tableau visualizations. By the end of the course, participants will be equipped to create and share their insights with broader audiences for government use.

Tableau enables individuals to visualize and comprehend data, enhancing decision-making processes for government and other organizations.

Tableau enables individuals to visualize and comprehend data effectively for government use.

Audience

Format of the Course

By the end of this training, participants will be able to:

In this instructor-led, live training, participants will learn how to manipulate and visualize data using the tools included in the Tidyverse.

The Tidyverse is a collection of versatile R packages for cleaning, processing, modeling, and visualizing data. Some of the key packages include: ggplot2, dplyr, tidyr, readr, purrr, and tibble.

• Beginners to the R language
• Beginners to data analysis and data visualization

• Part lecture, part discussion, exercises, and extensive hands-on practice

• Perform data analysis and create informative visualizations
• Draw meaningful conclusions from various datasets of sample data
• Filter, sort, and summarize data to answer exploratory questions
• Transform processed data into insightful line plots, bar plots, histograms, and more
• Import and filter data from diverse sources, including Excel, CSV, and SPSS files, for government applications

This is an essential 4-day course for government Tableau beginners. During this course, participants will gain a comprehensive understanding of all Tableau features and learn how to create and share data visualizations with colleagues. The course will guide attendees through each step, including connecting to data, creating calculations, selecting appropriate charts, building dashboards, and publishing their work.

The course is structured into lectures dedicated to each topic, followed by practical exercises. It concludes with a 30-minute test and a 60-minute project assignment.

Course Milestones:

• Become proficient with the Tableau interface.
• Connect to and manipulate data effectively.
• Leverage Tableau’s features for data analysis.
• Create insightful visualizations that enhance decision-making.
• Share completed work with a broader audience within government agencies.

Format of the Course:

• Interactive lectures and discussions tailored for government professionals.
• Extensive exercises and practice sessions to reinforce learning.
• Hands-on implementation in a live-lab environment designed for government use cases.
• A knowledge test and hands-on project at the end of the course to assess proficiency.