image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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 changes 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!
I would be really happy to welcome you in this course!
Manuel
Who this course is for:
People who never heard of or worked with QuickSight and who want to get started with the tool
Anybody who is interested into analyzing and visualizing data with modern Business Intelligence tools
People who want to learn how to connect QuickSight to different services within the AWS universe

What you'll learn

At the end of this course students will be able to connect QuickSight to different data sources and create their own analyses

Students will understand the basic concepts behind QuickSight and its positioning within AWS

Students will be able to dive deeper into QuickSight and feel comfortable in working with the tool and its different functions

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Welcome & First Steps
9
1.1-Welcome to This Course
1.2-What is QuickSight?
1.3-What is AWS?
1.4-Join our Online Learning Community
1.5-AWS – A Closer Look (Optional)
1.6-Let's Start: Creating our AWS and QuickSight Accounts
1.7-Starting Our First Project
1.8-Creating our First Visual
1.9-Course Outline
2-QuickSight - Starting with the Basics
5
2.1-The Development of QuickSight
2.2-Understanding the Workflow
2.3-Looking at the Interface
2.4-SPICE - What it that actually?
2.5-Pricing and Editions of QuickSight
3-Preparing our Data
18
3.1-Module Introduction
3.2-Before we Start: Understanding Data Preparation in QuickSight
3.3-Loading Data: SPICE vs. Direct Query
3.4-Introducing AWS S3
3.5-Uploading Data and Importing Data to QuickSight
3.6-A Closer Look at the Interface
3.7-Working with Columns and Fields
3.8-Taking a First Look at Calculated Fields
3.9-Understanding Functions and Operators
3.10-Adding Calculated Fields using Strings to our Project
3.11-Extracting Information out of Strings
3.12-Working with Conditional Functions
3.13-Another Look at the IF-Function
3.14-Creating Calculated Fields with Numeric Values
3.15-Adding Different Filters to our Project
3.16-A Little Helper: Dealing with Skipped Rows
3.17-Module Summary
3.18-Time to Practice: Data Preparation
4-Analyzing and Visualizing our Data
19
4.1-Module Introduction
4.2-Preparing Data vs. Analyzing Data - Understanding the Differences
4.3-Creating the Analysis
4.4-Understanding the Interface and Creating our First Visual
4.5-Understanding Dimensions and Measures
4.6-Adding Additional Data Sets to our Analysis
4.7-Understanding Field Formatting, Aggregation and Granularity
4.8-Formatting our Visuals
4.9-Adding Drill-Down
4.10-Creating our First Story
4.11-Creating a Treemap
4.12-Applying Filters
4.13-Understanding Pivot Tables
4.14-Continuing our Story
4.15-Understanding Heat Maps
4.16-Adding a KPI visual
4.17-Adding the Final Scene to our Story
4.18-Module Summary
4.19-Time to Practice: Analysis and Visualization
5-Refreshing, Exporting and Sharing our Project Data
13
5.1-Module Introduction
5.2-Our Ways to Continue
5.3-Understanding Refresh and Schedule Refresh
5.4-Exporting our Project Data as .csv Files
5.5-Adding Users to our Account - Some Theory
5.6-AWS - More about IAM (Optional)
5.7-Adding a User to our Account - Continuing with the Project
5.8-Sharing our Data Set
5.9-Sharing our Analysis
5.10-Creating and Sharing Dashboards
5.11-Managing Capacity and Understanding Subscriptions
5.12-Taking a Quick Look at the Mobile App
5.13-Module Summary
6-Databases as Data Sources
11
6.1-Module Introduction
6.2-Setting up a Database (Optional)
6.3-More Information about AWS RDS
6.4-Preparing Dummy Data (Optional)
6.5-Connecting Quicksight to a Database
6.6-More Resources about Connecting Quicksight to Databases
6.7-Importing Data into SPICE
6.8-Importing Data as a Query
6.9-Calculated Fields & Query Imports
6.10-What about NoSQL Databases?
6.11-Wrap Up
7-Course Roundup
1
7.1-Course Roundup