Data Science and Analytics with AWS Quicksight and Power BI

Data Science is one of the most demanded skills that has been well-reputed in this Internet age. Every moment, we are creating raw data through 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 tools that can be used to perform a wide range of operations on a dataset. It can be used for creating some amazing Visualization charts and BI reports 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 similar datasets on cloud computing platforms such as AWS (Amazon Web Services) using the 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 the 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