Course Outline
Introduction
- Overview of AWS QuickSight
- Defining AWS and QuickSight
Getting Started with AWS QuickSight
- Setting up AWS and QuickSight accounts
- Comprehending the QuickSight workflow
- Navigating the QuickSight user interface
Data Preparation in QuickSight
- Grasping data preparation processes in QuickSight
- SPICE vs. direct query methodologies
- Uploading and importing data into QuickSight
- Managing columns and fields
- Understanding calculated fields, functions, and operators
- Incorporating string-based calculated fields into projects
- Extracting data from strings
- Applying conditional functions
- Generating calculated fields with numeric values
- Applying various filters to projects
Data Analysis and Visualization
- Distinguishing between data preparation and analysis
- Constructing data analyses
- Developing visual elements
- Differentiating between dimensions and measures
- Integrating additional data sets
- Field formatting, aggregation, and granularity
- Styling visuals
- Building stories and treemaps
- Utilizing filters and tables
- Including KPI visuals
Exporting and Sharing Project Data
- Understanding refresh schedules
- Exporting project data as .csv files
- Adding users to the account
- Sharing data sets and analyses
- Creating and distributing dashboards
Utilizing Databases as Data Sources
- Configuring databases
- Preparing test data
- Connecting QuickSight to database sources
- Importing data into SPICE
- Importing data via queries
- Importing calculated fields and queries
- Working with NoSQL databases
Summary and Next Steps
Requirements
- Fundamental understanding and knowledge of data analysis
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
