Let's Start: Creating our AWS and QuickSight Accounts | Academind

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Amazon (AWS) QuickSight - Getting Started

Getting Started

Welcome to This Course (2:14)
What is QuickSight? (3:50)
Join our Online Learning Community
What is AWS? (2:36)
[OPTIONAL] AWS – A Closer Look
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)
The Academind Pro Referral Program

QuickSight - Starting with the Basics

The Development of QuickSight (2:18)
Understanding the Workflow (2:39)
Looking at the Interface (6:22)
SPICE - What it that actually? (3:44)
Pricing and Editions of QuickSight (2:40)

Preparing our Data

Module Introduction (1:49)
Before we Start: Understanding Data Preparation in QuickSight (3:55)
Loading Data: SPICE vs. Direct Query (3:53)
Introducing AWS S3 (6:13)
Uploading Data and Importing Data to QuickSight (12:47)
A Closer Look at the Interface (6:49)
Working with Columns and Fields (6:38)
Taking a First Look at Calculated Fields (5:04)
Understanding Functions and Operators (4:03)
Adding Calculated Fields using Strings to our Project (11:11)
Extracting Information out of Strings (2:43)
Working with Conditional Functions (8:24)
Another Look at the IF-Function (4:04)
Creating Calculated Fields with Numeric Values (3:11)
Adding Different Filters to our Project (6:08)
A Little Helper: Dealing with Skipped Rows (2:49)
Module Summary (1:32)
Assignment: Basics (Problem) (10:59)
Assignment: Basics (Solution) (1:33)

Analyzing and Visualizing our Data

Module Introduction (1:07)
Preparing Data vs. Analyzing Data - Understanding the Differences (2:36)
Creating the Analysis (2:50)
Understanding the Interface and Creating our First Visual (9:08)
Understanding Dimensions and Measures (2:55)
Adding Additional Data Sets to our Analysis (9:07)
Understanding Field Formatting, Aggregation and Granularity (5:25)
Formatting our Visuals (6:04)
Adding Drill-Down (3:28)
Creating our First Story (3:57)
Creating a Treemap (1:43)
Applying Filters (13:09)
Understanding Pivot Tables (11:17)
Continuing our Story (1:26)
Understanding Heat Maps (2:35)
Adding a KPI visual (8:02)
Adding the Final Scene to our Story (1:07)
Module Summary (1:17)
Assignment: Visualizations (Problem) (1:03)
Assignment: Visualizations (Solution) (10:18)

Refreshing, Exporting and Sharing our Project Data

Module Introduction (1:08)
Our Ways to Continue (1:37)
Understanding Refresh and Schedule Refresh (6:42)
Exporting our Project Data as .csv Files (1:44)
Adding Users to our Account - Some Theory (4:02)
AWS - More about IAM (Optional)
Adding a User to our Account - Continuing with the Project (8:07)
Sharing our Data Set (4:44)
Sharing our Analysis (4:59)
Creating and Sharing Dashboards (4:27)
Managing Capacity and Understanding Subscriptions (5:55)
Taking a Quick Look at the Mobile App (1:59)
Module Summary (1:37)

Databases as Data Sources

Module Introduction (0:54)
Setting up a Database (Optional) (6:04)
More Information about AWS RDS
Preparing Dummy Data (Optional) (4:28)
Connecting Quicksight to a Database (8:32)
More Resources about Connecting Quicksight to Databases
Importing Data into SPICE (5:42)
Importing Data as a Query (5:58)
Calculated Fields & Query Imports (2:02)
What about NoSQL Databases? (1:35)
Wrap Up (1:53)

Course Roundup

Roundup (1:58)

Let's Start: Creating our AWS and QuickSight Accounts

Complete and Continue