Course Outline
Introduction
- Overview of AWS QuickSight.
- What are AWS and QuickSight?
Getting Started with AWS QuickSight
- Setting up AWS and QuickSight accounts.
- Understanding the QuickSight workflow.
- Navigating the QuickSight interface.
Data Preparation in QuickSight
- Overview of data preparation in QuickSight.
- SPICE versus direct query.
- Uploading and importing data into QuickSight.
- Working with columns and fields.
- Understanding calculated fields, functions, and operators.
- Incorporating calculated fields using strings into projects.
- Extracting information from strings.
- Utilizing conditional functions.
- Creating calculated fields with numeric values.
- Adding various filters to a project.
Data Analysis and Visualization
- Distinguishing between data preparation and analysis.
- Building data analyses.
- Creating visualizations.
- Understanding dimensions and measures.
- Incorporating additional data sets.
- Field formatting, aggregation, and granularity.
- Formatting visuals.
- Creating stories and treemaps.
- Utilizing filters and tables.
- Adding KPI visuals.
Exporting and Sharing Project Data
- Understanding refresh mechanisms and scheduled refreshes.
- Exporting project data as .csv files.
- Adding users to an account.
- Sharing data sets and analyses.
- Creating and sharing dashboards.
Using Databases as Data Sources
- Setting up a database.
- Preparing dummy data.
- Connecting QuickSight to a database.
- Importing data into SPICE.
- Importing data via query.
- Importing calculated fields and queries.
- Utilizing NoSQL databases.
Summary and Next Steps
Requirements
- Foundational knowledge and understanding of data analysis.
Audience
- Data analysts.
- Individuals interested in data analysis and visualization.
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
he was well prepared - and he is very sympathetic
Oliver - Post CH AG
Course - Splunk Fundamentals
Used good examples, good pace of the training and covered most things
David - McGraw Hill
Course - Data Preparation with Alteryx
lots of pratical exercises
