Course Outline
Introduction
- Overview of AWS QuickSight for government
- Understanding AWS and QuickSight for government
Getting Started with AWS QuickSight for Government
- Creating an AWS and QuickSight account for government
- Understanding the QuickSight workflow for government operations
- Navigating the QuickSight user interface for government users
Preparing Data in QuickSight for Government
- Understanding data preparation in QuickSight for government
- SPICE vs. direct query for government datasets
- Uploading and importing data to QuickSight for government use
- Working with columns and fields for government data analysis
- Understanding calculated fields, functions, and operators for government data
- Adding calculated fields using strings in government projects
- Extracting information from strings for government datasets
- Using conditional functions for government data manipulation
- Creating calculated fields with numeric values for government analysis
- Applying different filters to a project for government data visualization
Analyzing and Visualizing Data in QuickSight for Government
- Understanding the difference between preparing and analyzing data for government
- Creating the data analysis for government reports
- Creating visuals for government presentations
- Understanding dimensions and measures for government datasets
- Adding additional data sets for comprehensive government analysis
- Field formatting, aggregation, and granularity for government data
- Formatting visuals for government reporting
- Creating a story and treemap for government insights
- Using filters and tables for government data presentation
- Adding a KPI visual for government performance metrics
Exporting and Sharing Project Data in QuickSight for Government
- Understanding refresh and schedule refresh for government data updates
- Exporting project data as .csv files for government use
- Adding users to an account for government collaboration
- Sharing data sets and analysis for government stakeholders
- Creating and sharing dashboards for government decision-making
Using Databases as Data Sources in QuickSight for Government
- Setting up a database for government use
- Preparing dummy data for government testing
- Connecting QuickSight to a database for government data access
- Importing data into SPICE for government analysis
- Importing data as a query for government reporting
- Importing calculated fields and queries for government datasets
- Using NoSQL databases for government data storage
Summary and Next Steps for Government Users
Requirements
- Essential knowledge and understanding of data analysis for government
Audience
- Data analysts within the public sector
- Individuals interested in data analysis and visualization for government operations
Testimonials (4)
Deepthi was super attuned to my needs, she could tell when to add layers of complexity and when to hold back and take a more structured approach. Deepthi truly worked at my pace and ensured I was able to use the new functions /tools myself by first showing then letting me recreate the items myself which really helped embed the training. I could not be happier with the results of this training and with the level of expertise of Deepthi!
Deepthi - Invest Northern Ireland
Course - IBM Cognos Analytics
Share example of application
Course - Alteryx for Data Analysis
Very clearly articulated and explained
Harshit Arora - PwC South East Asia Consulting
Course - Alteryx for Developers
Linear regression - the algorithm to predict the trend
