Amazon (AWS) QuickSight - Getting Started

Get started with Amazon QuickSight - AWS' Business Intelligence (BI) answer to Tableau and Power BI

Working with modern Business Intelligence tools is exciting. Although the market offers a broad variety of tools, you may not have found the tool that meets all your requirements yet. This course might change that!

In this course, you will learn how to use one of the latest Business Intelligence tools released to the market: Amazon QuickSight, a tool which allows you to easily analyze and visualize data. But what makes QuickSight special? QuickSight is a cloud solution and completely integrated into Amazon Web Services (AWS). With that, it can be easily connected to a broad variety of services and sources which make QuickSight a highly scalable, easy-to-use and very flexible data analysis tool.

This course will give you a first overview of QuickSight including the following topics:

How to use QuickSight and its different functions
Understand the workflow of QuickSight
How to connect QuickSight to different data sources within and outside of AWS
How to prepare your data in QuickSight, for example by adding filters and calculated fields
How to easily create your analysis by building multiple visuals
How to create dashboards and stories
Share your project results with people within and outside your organization
How to use the iOS mobile app
Understand the user management of QuickSight
And more!

These topics will be covered throughout this course, but is this your course?

If you...

... never worked with QuickSight and want to get started with it
... are looking for a cloud based Business Intelligence tool to quickly analyze your data
...have worked with other Business Intelligence tools but want to take a look at new tools
... already worked with AWS and now want to understand how to analyze and visualize your data using a service within the AWS universe
...are generally interested into data analysis

...then this course is made for you!

Course content

Section 1Getting Started

Welcome to This Course
2:14
What is QuickSight?
3:50
Join our Online Learning Community
1:00
What is AWS?
2:36
[OPTIONAL] AWS – A Closer Look
1:00
Let's Start: Creating our AWS and QuickSight Accounts
8:15
Starting Our First Project
8:05
Creating our First Visual
8:03
Course Outline
1:40

Section 2QuickSight - Starting with the Basics

The Development of QuickSightPremium
2:18
Understanding the WorkflowPremium
2:39
Looking at the InterfacePremium
6:22
SPICE - What it that actually?Premium
3:44
Pricing and Editions of QuickSightPremium
2:40

Section 3Preparing our Data

Module IntroductionPremium
1:49
Before we Start: Understanding Data Preparation in QuickSightPremium
3:55
Loading Data: SPICE vs. Direct QueryPremium
3:53
Introducing AWS S3Premium
6:13
Uploading Data and Importing Data to QuickSightPremium
12:47
A Closer Look at the InterfacePremium
6:49
Working with Columns and FieldsPremium
6:38
Taking a First Look at Calculated FieldsPremium
5:04
Understanding Functions and OperatorsPremium
4:03
Adding Calculated Fields using Strings to our ProjectPremium
11:11
Extracting Information out of StringsPremium
2:43
Working with Conditional FunctionsPremium
8:24
Another Look at the IF-FunctionPremium
4:04
Creating Calculated Fields with Numeric ValuesPremium
3:11
Adding Different Filters to our ProjectPremium
6:08
A Little Helper: Dealing with Skipped RowsPremium
2:49
Module SummaryPremium
1:32
Assignment: Basics (Problem)Premium
10:59
Assignment: Basics (Solution)Premium
1:33

Section 4Analyzing and Visualizing our Data

Module IntroductionPremium
1:07
Preparing Data vs. Analyzing Data - Understanding the DifferencesPremium
2:36
Creating the AnalysisPremium
2:50
Understanding the Interface and Creating our First VisualPremium
9:08
Understanding Dimensions and MeasuresPremium
2:55
Adding Additional Data Sets to our AnalysisPremium
9:07
Understanding Field Formatting, Aggregation and GranularityPremium
5:25
Formatting our VisualsPremium
6:04
Adding Drill-DownPremium
3:28
Creating our First StoryPremium
3:57
Creating a TreemapPremium
1:43
Applying FiltersPremium
13:09
Understanding Pivot TablesPremium
11:17
Continuing our StoryPremium
1:26
Understanding Heat MapsPremium
2:35
Adding a KPI visualPremium
8:02
Adding the Final Scene to our StoryPremium
1:07
Module SummaryPremium
1:17
Assignment: Visualizations (Problem)Premium
1:03
Assignment: Visualizations (Solution)Premium
10:18

Section 5Refreshing, Exporting and Sharing our Project Data

Module IntroductionPremium
1:08
Our Ways to ContinuePremium
1:37
Understanding Refresh and Schedule RefreshPremium
6:42
Exporting our Project Data as .csv FilesPremium
1:44
Adding Users to our Account - Some TheoryPremium
4:02
AWS - More about IAM (Optional)Premium
1:00
Adding a User to our Account - Continuing with the ProjectPremium
8:07
Sharing our Data SetPremium
4:44
Sharing our AnalysisPremium
4:59
Creating and Sharing DashboardsPremium
4:27
Managing Capacity and Understanding SubscriptionsPremium
5:55
Taking a Quick Look at the Mobile AppPremium
1:59
Module SummaryPremium
1:37

Section 6Databases as Data Sources

Module IntroductionPremium
0:54
Setting up a Database (Optional)Premium
6:04
More Information about AWS RDSPremium
1:00
Preparing Dummy Data (Optional)Premium
4:28
Connecting Quicksight to a DatabasePremium
8:32
More Resources about Connecting Quicksight to DatabasesPremium
1:00
Importing Data into SPICEPremium
5:42
Importing Data as a QueryPremium
5:58
Calculated Fields & Query ImportsPremium
2:02
What about NoSQL Databases?Premium
1:35
Wrap UpPremium
1:53

Section 7Course Roundup

RoundupPremium
1:58

Course instructor

Manuel Lorenz

Having worked as a business analyst in both a major consultancy and an investment bank, I always found myself confronted with both various and complex problem sets and challenging client demands. The rapid development of technology and business requirements forces everyone to constantly adapt and to continue learning. Since I always found it hard to find high quality, understandable and comprehensive learning materials, I decided to create such materials on my own. Together with Maximilian Schwarzmüller I founded Academind to offer the best possible learning experience on web development and data science to our more than 1,000,000 students worldwide.