Course Outline
Introduction
- The foundational principles of Python and SQL for government
- An overview of Tableau features and architecture for government
Getting Started
- Setting up the development environment for government use
- Understanding software integration in a government context
Data Pre-processing in Python
- Importing necessary libraries and datasets for government applications
- Handling missing data values in government datasets
- Data normalization and formatting for government standards
- Performing regression analysis on government data
Data Analysis with SQL
- Setting up the database for government operations
- Connecting Python and SQL for enhanced government data analysis
- Querying the database to extract meaningful information for government use
- Manipulating data (filtering, sorting, and grouping) in a government context
Data Visualization using Tableau
- Design principles for visualization in Tableau for government reporting
- Creating dashboards, charts, tables, and mapping for government presentations
- Practical examples and use cases of Tableau in government agencies
Troubleshooting
Summary and Next Steps
Requirements
- Familiarity with SQL concepts and Tableau for government data analysis
- Experience in Python programming
Audience
- Data scientists working in the public sector
- Developers supporting government initiatives
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.