AWS QuickSight - Full Course 2023 !

Name: AWS QuickSight - Full Course 2023 !
Rating: 4.1 (37 reviews)

Learn Amazon QuickSight and Unlock the Power of Data Analysis.

Created byZakariyaa ISMAILI, Abdellah ISMAILI

Last updated 5/2023

English

English [Auto],

What you'll learn

Get an overview of QuickSight and its benefits, and learn how to sign up for a QuickSight account.
Learn how to connect QuickSight to different data sources such as AWS S3, RDS, Athena, Redshift, and more.
Learn how to clean and transform your data within QuickSight using features such as calculated fields, filters, and pivots.
Discover how to create beautiful and insightful visualizations using QuickSight's wide range of chart types and formatting options.
Learn how to perform data analysis using QuickSight's built-in features, such as pivoting, filtering, and grouping data.
Learn how to share your QuickSight dashboards and analyses with others and collaborate on projects in real-time.
Learn how to set up permissions and manage security for your QuickSight account and data sources.
Learn how to embed QuickSight visualizations into your own applications or websites using QuickSight's API.
Explore advanced features of QuickSight, such as machine learning insights, custom SQL, and advanced visualizations.
Learn tips and best practices for using QuickSight effectively and efficiently to get the most out of your data.

Course content

4 sections • 36 lectures • 2h 59m total length

What is QuickSight1:20
Discover how Amazon QuickSight functions as a cloud-based business intelligence service that connects data from cloud sources, third-party apps, spreadsheets, and CSV files to generate dashboards for quick insights.
Create Quicksight Account6:24
Set up your AWS Quicksight account by creating an AWS account, selecting an admin, and signing up for Quicksight, including verification steps and choosing a standard or enterprise plan.
QuickSight Interface4:49
Log in to the QuickSight interface, manage favorites, dashboards, and datasets, upload data sources (CSV, Excel), explore sample analyses, access tutorials, and note the one gigabyte capacity limit.
Upload a File7:25
Upload a CSV to AWS QuickSight, adjust the separator to semicolon, and prepare the data by editing formats, renaming columns, and creating calculated fields and filters for analysis.
First Visual7:54
Exclude safari, opera, edge, and unknowns to group them as others, publish the dataset, and build the first visual in QuickSight.

Numeric Calculated Fields6:35
Learn data preparation in AWS QuickSight by uploading a CSV, standardizing headers, and creating numeric calculated fields for total population and gender percentages with an if-else guard for zeros.
Extract from String4:47
Conditional Functions8:50
Clean data in AWS QuickSight by excluding region codes and creating calculated fields. Build age group categories using if-else logic and apply to upper to standardize codes for analysis.
Practice Activity 1 -Data Preparation0:31
Practice Activity 1 Solution - Data Preparation8:19
Upload the office supply csv as a new QuickSight dataset, fix date formats and data types, create calculated fields for cost, sales, and profit, and define sales groups with if-else.
Tables Formatting11:02
Explore how to build and format tables in AWS QuickSight, including sorting, aggregations, totals, and conditional formatting for population by region.
Dimensions and Measures3:25
Distinguish green aggregation measures from blue categorization dimensions, adjust data types when needed, and save and publish a data set for visualization.
Cross Filtering and dates Agregation9:34
Upload a sales dataset in aws quicksight and build cross-filtered visuals. Aggregate dates by week, month, quarter, or year to analyze sales trends across categories.
Conditional Formatting - Colors5:33
Apply conditional formatting in AWS QuickSight to color table cells using background or text colors. Configure gradient and threshold rules, such as greater than a million, and add icons.
Numeric and Text Filters4:25
Apply numeric and text filters in AWS QuickSight to refine data, using country text filters, top/bottom profit filters, and range conditions on profit.
16 Practice activity - 2- Filters-Actions-Conditional Formatting0:39
Practice Activity - 2 - Filters-Actions-Conditional Formatting5:22
practice activity 2 on filters, actions, and conditional formatting in aws quicksight; build four visuals - sales by rep, region, product, and date - enable interactivity and formatting.
Text Controls6:16
Learn to add text, numeric, and date controls to visuals, apply filters (rep names and sales), view totals, and reuse controls across single or multiple visuals and sheets.
Numeric Controls2:55
Master numeric filters in AWS QuickSight using a slider to filter sales, view totals on a table, and compare representatives across defined ranges.
Date Control4:00
Use date control to filter sales by date ranges and relative dates, pin the control to the top, and observe totals across time with chosen granularity.
Parameters3:54
In AWS QuickSight, create a rep parameter and a custom action to navigate from a source sheet to a target sheet, filtering sales by rep and updating the target title.

Line Charts14:27
Explore line charts as a key visual for analyzing time-based data, featuring sales trends, order date aggregation (week, month, quarter, year), and rich formatting, tooltips, and reference lines.
KPIs6:16
Learn to create and customize KPI visuals in AWS QuickSight, measuring sales and profit with sum aggregations. Explore target vs actual comparisons, date-based analysis, and conditional formatting to visualize progress.
Pie Charts8:58
Use a pie chart to show sales by region and compare May 2015 to April, highlighting percentage shares and formatting options such as legends and labels.
Vertical Bar Chart4:05
Create a vertical bar chart in AWS QuickSight by region, measuring sales, with product grouping, sorting, color and label formatting, data labels, and added profit totals.
26 Practice Activity - 3 - Pie-Vertical Bars-Map Vusuals0:22
Practice Activity - 3 - Pie-Vertical Bars-Map Visuals6:21
Import an Excel dataset in AWS QuickSight, adjust fields and types, then build a revenue by region pie chart with percent labels and a revenue vs expenses bar chart.
Practice Activity - 4 - Numeric-Text-Controls-Parameters0:29
Practice Activity - 4 - Numeric-Text-Controls-Parameters5:40
Apply numeric and text controls in AWS QuickSight to explore revenue and expenses by state and city. The activity demonstrates filters, drill-through actions, and parameters linking source and target visuals.
Pivot Tables5:40
Explore pivot tables to analyze sales transactions by product and country, configuring rows, columns, and values, applying sums, averages, counts, and subtotals in a dataset.
Pivot Tables Calculations2:55
Explore pivot table calculations in AWS QuickSight to display percent of total alongside absolute sales, compare numbers across countries, and use across, down, and group calculations with subtotals.
Practice Activity - 5 - Pivot Tables Calculations0:35
Practice Activity - 5 - Pivot Tables Calculations6:02
Practice pivot tables on a sports equipment data set, validating decimals for unit price and sales and integers for quantity. Compute totals, averages, medians, counts, and regional and product-category percentages.

Introduction0:21
Explore how QuickSight connects directly to relational databases, creating a database in the upcoming session. Even if you lack one, you can still follow the instructions.
Create a database on AWS1:26
Learn to create a MySQL database on AWS using the RDS service in the management console, configure security, and note the endpoint and port.
Install MySQL and MySQL Workbench1:31
Download and install MySQL and MySQL Workbench on your computer, then configure the open source relational database and its visual management tool.

Requirements

Basic knowledge of data analysis and visualization concepts.
Basic understanding of SQL and database concepts.
A computer with a modern web browser and internet connection.

Description

Looking for a business intelligence tool that is easy to use and scalable? Look no further than Amazon QuickSight.

QuickSight is a cloud solution that is fully integrated into Amazon Web Services (AWS). With that, it can be easily connected to a broad variety of services and sources, making it a highly flexible data analysis tool.

With QuickSight, you can easily analyze and visualize your data, allowing you to make informed decisions.

Whether you are a data analyst, a business owner or manager, or a marketer looking to gain a deeper understanding of your data, QuickSight has you covered.

This course will give you a comprehensive view of QuickSight, including the following :

Using the tool and its distinct capacities,
Understanding the workflow of QuickSight,
Connecting QuickSight to different data sources both inside and outside of AWS,
Arranging data in QuickSight (e.g. by putting filters and calculated fields),
Making multiple visuals to generate analysis,
Creating dashboards and stories,
Sharing the project outcomes with other people in and out of the organization,
Using the iOS mobile app,
Understanding the user management of QuickSight,
... and more.

All these topics will be explored in this course.

Is this the course that is right for you?

If you have never used QuickSight before and want to learn more;
if you are searching for a cloud-based Business Intelligence tool to investigate your data;
if you have already employed other Business Intelligence tools but want to try out something new; or if you have worked with AWS and now desire to understand,

... then this is the course for you.

Who this course is for:

Business analysts who want to create dashboards and visualizations to gain insights and make informed business decisions.
Data analysts who want to learn how to use QuickSight to analyze and report on data from various sources.
Developers who want to embed QuickSight visualizations into their own applications or websites.
IT professionals who want to learn how to set up and manage QuickSight accounts and data sources.
Anyone who is interested in cloud-based data visualization and analysis and wants to learn how to use QuickSight.

AWS QuickSight - Full Course 2023 !

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 28min

Data Prep16 lectures • 1hr 26min

Data Viz12 lectures • 1hr 2min

Avanced - Databases3 lectures • 3min

Requirements

Description

Who this course is for: