Course Outline
Introduction
- Overview of AWS QuickSight for government
- Understanding AWS and QuickSight in the context of public sector data analysis
Getting Started with AWS QuickSight for Government
- Creating an AWS and QuickSight account for government use
- Navigating the QuickSight user interface for efficient public sector workflows
- Understanding the QuickSight workflow to align with governmental processes
Preparing Data in QuickSight for Government
- Overview of data preparation methods in QuickSight tailored for government datasets
- Differentiating between SPICE and direct query for optimal performance in public sector applications
- Uploading and importing data to QuickSight, ensuring compliance with government standards
- Working with columns and fields to meet public sector reporting requirements
- Utilizing calculated fields, functions, and operators to enhance data analysis for government
- Adding calculated fields using string operations to support governmental projects
- Extracting meaningful information from strings for government reports
- Applying conditional functions to refine data for public sector use
- Creating calculated fields with numeric values to meet government metrics
- Incorporating various filters into projects to ensure accurate and relevant data for government
Analyzing and Visualizing Data for Government
- Distinguishing between data preparation and analysis in the context of governmental needs
- Creating comprehensive data analyses to support public sector decision-making
- Generating visual representations of data to enhance understanding for government stakeholders
- Utilizing dimensions and measures to provide detailed insights for government reporting
- Incorporating additional data sets to enrich governmental analysis
- Applying field formatting, aggregation, and granularity to meet public sector standards
- Formatting visuals to ensure clarity and compliance with government guidelines
- Creating stories and treemaps to present complex data in a digestible format for government
- Using filters and tables to refine data presentation for governmental use
- Adding KPI visuals to track key performance indicators for public sector initiatives
Exporting and Sharing Project Data for Government
- Understanding refresh and schedule refresh options to maintain up-to-date data for government reports
- Exporting project data as .csv files for easy integration into governmental systems
- Adding users to an account to facilitate collaboration within public sector teams
- Sharing data sets and analyses securely with authorized personnel in the government
- Creating and sharing dashboards to provide real-time insights for public sector decision-makers
Using Databases as Data Sources for Government
- Setting up a database to support governmental data requirements
- Preparing dummy data to test and validate government applications
- Connecting QuickSight to a database to streamline data access for public sector users
- Importing data into SPICE to optimize performance for government analyses
- Importing data as a query to support dynamic reporting in the public sector
- Incorporating calculated fields and queries to enhance governmental data processing
- Leveraging NoSQL databases to manage unstructured data for government projects
Summary and Next Steps for Government
Requirements
- Fundamental knowledge and comprehension of data analysis techniques
Audience
- Data analysts for government
- Individuals with an interest in data analysis and visualization for government purposes
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
