Welcome & First Steps
- Welcome to This Course
- What is QuickSight?
- What is AWS?
- Join our Online Learning Community
- AWS – A Closer Look (Optional)
- Let's Start: Creating our AWS and QuickSight Accounts
- Starting Our First Project
- Creating our First Visual
- Course Outline
QuickSight - Starting with the Basics
- The Development of QuickSight
- Understanding the Workflow
- Looking at the Interface
- SPICE - What it that actually?
- Pricing and Editions of QuickSight
Preparing our Data
- Module Introduction
- Before we Start: Understanding Data Preparation in QuickSight
- Loading Data: SPICE vs. Direct Query
- Introducing AWS S3
- Uploading Data and Importing Data to QuickSight
- A Closer Look at the Interface
- Working with Columns and Fields
- Taking a First Look at Calculated Fields
- Understanding Functions and Operators
- Adding Calculated Fields using Strings to our Project
- Extracting Information out of Strings
- Working with Conditional Functions
- Another Look at the IF-Function
- Creating Calculated Fields with Numeric Values
- Adding Different Filters to our Project
- A Little Helper: Dealing with Skipped Rows
- Module Summary
- Time to Practice: Data Preparation
Analyzing and Visualizing our Data
- Module Introduction
- Preparing Data vs. Analyzing Data - Understanding the Differences
- Creating the Analysis
- Understanding the Interface and Creating our First Visual
- Understanding Dimensions and Measures
- Adding Additional Data Sets to our Analysis
- Understanding Field Formatting, Aggregation and Granularity
- Formatting our Visuals
- Adding Drill-Down
- Creating our First Story
- Creating a Treemap
- Applying Filters
- Understanding Pivot Tables
- Continuing our Story
- Understanding Heat Maps
- Adding a KPI visual
- Adding the Final Scene to our Story
- Module Summary
- Time to Practice: Analysis and Visualization
Refreshing, Exporting and Sharing our Project Data
- Module Introduction
- Our Ways to Continue
- Understanding Refresh and Schedule Refresh
- Exporting our Project Data as .csv Files
- Adding Users to our Account - Some Theory
- AWS - More about IAM (Optional)
- Adding a User to our Account - Continuing with the Project
- Sharing our Data Set
- Sharing our Analysis
- Creating and Sharing Dashboards
- Managing Capacity and Understanding Subscriptions
- Taking a Quick Look at the Mobile App
- Module Summary
Databases as Data Sources
- Module Introduction
- Setting up a Database (Optional)
- More Information about AWS RDS
- Preparing Dummy Data (Optional)
- Connecting Quicksight to a Database
- More Resources about Connecting Quicksight to Databases
- Importing Data into SPICE
- Importing Data as a Query
- Calculated Fields & Query Imports
- What about NoSQL Databases?
- Wrap Up
Course Roundup
- Congratulations
