Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member 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
Testimonials
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
Marco Iuliano
some of the best practices on charts
AIG SHARED SERVICES-BUSINESS PROCESSING, INC.
Related Courses
Stata: Beginner to Advanced
14 hours
Alteryx Advanced
14 hours
Alteryx for Data Analysis
7 hours
Alteryx for Developers
14 hours
Data Preparation with Alteryx
7 hours
Cluster Analysis with R and SAS
14 hours
SAS Programming
14 hours
Google Sheets for Excel Users
14 hours
IBM Cognos Analytics
14 hours
QlikView for Business Users
7 hours
QlikView for Developers
14 hours
Data Analysis with Redash
14 hours