Course Outline
Introduction
- Overview of AWS QuickSight.
- Understanding AWS and QuickSight.
Getting Started with AWS QuickSight
- Creating an AWS account and setting up QuickSight.
- Understanding the QuickSight workflow.
- Navigating the QuickSight user interface.
Preparing Data in QuickSight
- Overview of data preparation within QuickSight.
- Differences between SPICE and direct query modes.
- Uploading and importing data into QuickSight.
- Working with columns and fields.
- Understanding calculated fields, functions, and operators.
- Incorporating calculated fields using string operations.
- Extracting information from strings.
- Applying conditional functions.
- Creating calculated fields with numeric values.
- Adding various filters to a project.
Analyzing and Visualizing Data
- Distinguishing between data preparation and analysis.
- Conducting data analysis.
- Creating visual representations.
- Understanding dimensions and measures.
- Incorporating additional datasets.
- Formatting fields, aggregations, and granularity.
- Styling visuals.
- Creating stories and treemaps.
- Utilizing filters and tables.
- Adding Key Performance Indicator (KPI) visuals.
Exporting and Sharing Project Data
- Understanding manual refresh and scheduled refresh options.
- Exporting project data as .csv files.
- Managing user accounts within QuickSight.
- Sharing datasets and analyses.
- Creating and sharing dashboards.
Using Databases as Data Sources
- Setting up a database.
- Preparing dummy data for testing.
- Connecting QuickSight to a database.
- Importing data into SPICE.
- Importing data via queries.
- Incorporating calculated fields and query results.
- Utilizing NoSQL databases.
Summary and Next Steps
Requirements
- Fundamental knowledge and understanding of data analysis.
Audience
- Data analysts.
- Anyone interested in data analysis and visualization.
Testimonials (3)
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
lots of pratical exercises
