Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Overview of AWS QuickSight
- What is AWS and QuickSight
Getting Started with AWS QuickSight
- Creating an AWS and QuickSight account
- Understanding the QuickSight workflow
- Navigating the QuickSight UI
Preparing Data in QuickSight
- Understanding data preparation in QuickSight
- SPICE vs. direct query
- Uploading and importing data to QuickSight
- Working with columns and fields
- Understanding calculated fields, functions, and operators
- Adding calculated fields using strings to our project
- Extracting information out of strings
- Using conditional functions
- Creating calculated fields with numeric values
- Adding different filters to a project
Analyzing and Visualizing Data
- Understanding the difference between preparing and analyzing data
- Creating the data analysis
- Creating visuals
- Understanding dimensions and measures
- Adding additional data sets
- Field formatting, aggregation, and granularity
- Formatting visuals
- Creating a story and treemap
- Using filters and tables
- Adding a KPI visual
Exporting and Sharing Project Data
- Understanding refresh and schedule refresh
- Exporting project data as .csv files
- Adding users to an account
- Sharing data set and analysis
- 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 as a Query
- Importing calculated fields and query
- Using NoSQL databases
Summary and Next Steps
Requirements
- Basic knowledge and understanding of data analysis
Audience
- Data analysts
- Anyone who is interested in data analysis and visualization
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (5)
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
the ease of explanation and the professor's robust knowledge
JOSE FERNANDO MELO - MCGRAW-HILL INTERAMERICANA
Course - Alteryx Advanced
Machine Translated
The practical exercises, the course order, and the explanations were clear
Cristina Morales - SOFI de Chihuahua SA de CV
Course - Alteryx for Data Analysis
Machine Translated
Very clearly articulated and explained
Harshit Arora - PwC South East Asia Consulting
Course - Alteryx for Developers
Linear regression - the algorithm to predict the trend
