Data Science and Analytics with AWS Quicksight and Power BI

Name: Data Science and Analytics with AWS Quicksight and Power BI
Rating: 3.9 (54 reviews)

Learn to create Power BI Visualization Charts and Reports | Data Preparation | Finding Insights from Data in Quicksight

Created byHarshit Srivastava

Last updated 11/2022

English

What you'll learn

You would be able to create various kinds of Visualization charts using AWS Quicksight
You could create charts such as Pie, Bar, Treemap and Pivot table
You could visually find insights from the dataset and perform analysis to find useful information
You could create Filters and Calculated fields to perform data cleaning and preparation
You will learn to create various Visualization charts in Microsoft Power BI
You will be able to create various charts such as Bar, Pie, Line, Ring, Donut, Ribbon, Treemap charts
You will learn to create Table and Matrix and perform various operations on charts

Course content

10 sections • 23 lectures • 2h 0m total length

Introduction1:53
Learn data visualization with Power BI and AWS QuickSight, building dashboards and charts such as bar, line, map, ribbon, and waterfall, while preparing data and applying conditional formatting.

Treemap 1- Drill down dashboard4:48
Build a treemap drill-down dashboard in Power BI with a four-rectangle dream up chart showing category weights and interlinked visuals.
Treemap 2- details4:06
Table and Matrix5:41
Explore Power BI tables and matrices to organize data: columns, rows, and values. Learn formatting, drill down, and use measures and dimensions for analyzing order, quantity, profit.
Drill Down Table and Matrix3:39
Implement drill down on tables and matrices to explore deeper hierarchies and update visuals. Interact with connected charts to filter by country or category and see focused insights.

Importing dataset and understanding group and values3:53
Import or upload a dataset in QuickSight, create your first BI report and visualization, and build charts by placing fields into group and value.
Creating Treemap and Customizing charts4:59
Create a treemap and customize charts by mapping size to margin and color to price, then export to PDF and share insights offline.
Data Preparation- Editing Dataset before creating Charts6:06
Load datasets from connectors or upload files, then edit data and create calculated fields to prepare charts. Apply filters, clean data, and adjust data types for the data preparation dashboard.

Create a Calculated Field using Functions- ceil and concat5:44
Create a calculated field using ceil and concat to derive new columns. Learn data preparation, tax calculations on profit at 10 percent, and concatenating product id, category, and name.
More calculated fields3:18
Create and edit calculated fields to generate new columns such as profit per unit and price per unit, using ceiling, for data cleaning and preparation and chart creation.
Creating Filters and Excluded list6:20
Learn to refine datasets with exclude filters and standard filters in AWS QuickSight and Power BI, including country and date range filters, and create calculated fields to support visualizations.

Requirements

Before taking this course, if your are already familiar with Microsoft Excel or similar spreadsheet editors it would be helpful but it is not a prerequisite.
Before taking this course, if you are familiar with AWS (Amazon Web Services) cloud computing platform, it would be useful

Description

Data Science has been one of the most demanded skillset that has been well reputed in this Internet age. Every moment, we are creating raw data by all our digital activities- from searching to streaming, shopping to learning and everything else. Not just humans, but street cameras, animals, IoT devices and countless other sources are also contributing to this massive pile of information. As someone said it correctly- Data is the new Oil. In order to find meaningful insights from a dataset that can drive business decisions and other actions we need certain tools and techniques where we can perform various operations on the dataset.

Microsoft Power BI is one of the popular tool that can be used to perform wide range of operations on a dataset. It can be used for creating some amazing Visualization charts and BI report that can be used to find critical insights from the dataset. In this course, you will learn to create a variety of visual charts and ways to customize them. You will learn to create-

Bar, Line and Pie charts
Donut or Ring chart
Drill down and Analysis of charts using Treemap
Table and Matrix
Ribbon and Waterfall charts

After you have learned Power BI, you can perform various operations on the similar dataset on the Cloud computing platforms such as AWS (Amazon Web Services) using AWS Quicksight Business Intelligence and Data Analysis tool. You will learn about Data Preparations, Data Cleaning, Data Visualization and Data Analysis-

In Data Preparation, you will learn to-

Edit Dataset before creating charts or Data Cleaning by removing unwanted fields or rows from the dataset
Create Calculated fields for custom columns
Using filters to aggregate fields based on certain criteria and Using Excluded lists to discard certain columns

After that you will learn to create some visualization charts and analyze them such as-

Basic charts such as bar, treemap
Pivot table
Map chart and conditional formatting

Who this course is for:

Anyone who is curious to learn Data Science on AWS cloud computing platform using Quicksight
Anyone interested in Data Analysis and Business Intelligence
Curious to learn Data Visualization and creating various data analytics charts and reports
Someone looking to learn Microsoft Power BI

Data Science and Analytics with AWS Quicksight and Power BI

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 2min

Creating Visualization Charts with PowerBI4 lectures • 22min

Drill down and Analysis of Charts4 lectures • 18min

Ribbon and Waterfall Charts2 lectures • 13min

Create buttons1 lecture • 6min

Introduction to AWS Quicksight1 lecture • 6min

Getting started with Data Preparation3 lectures • 15min

Calculated Field3 lectures • 15min

Map and Pivot chart Visualization4 lectures • 24min

Practice Quiz0

Requirements

Description

Who this course is for: