Course Outline
Introduction
- Overview of AWS QuickSight
- Introduction to AWS and QuickSight
Getting Started with AWS QuickSight
- Setting up an AWS and QuickSight account
- Understanding the QuickSight workflow
- Navigating the QuickSight interface
Preparing Data in QuickSight
- Understanding data preparation in QuickSight
- Comparing SPICE and direct queries
- Uploading and importing data into QuickSight
- Managing columns and fields
- Understanding calculated fields, functions, and operators
- Adding calculated fields using strings to your project
- Extracting information from strings
- Utilizing conditional functions
- Creating calculated fields with numeric values
- Applying various filters to a project
Analyzing and Visualizing Data
- Distinguishing between data preparation and analysis
- Constructing data analyses
- Creating visual elements
- Understanding dimensions and measures
- Incorporating additional datasets
- Field formatting, aggregation, and granularity
- Styling and formatting visuals
- Creating narratives and treemaps
- Using filters and tables
- Adding KPI visuals
Exporting and Sharing Project Data
- Understanding manual and scheduled data refreshes
- Exporting project data as .csv files
- Managing user access within an account
- Sharing datasets and analyses
- Creating and distributing dashboards
Using Databases as Data Sources
- Setting up a database environment
- Preparatory steps for dummy data
- Connecting QuickSight to a database
- Importing data into SPICE
- Importing data as a Query
- Importing calculated fields and queries
- Working with NoSQL databases
Summary and Next Steps
Requirements
- Familiarity with and basic understanding of data analysis concepts.
Target Audience
- Data analysts.
- Professionals 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
