Introduction to Data Analytics on Microsoft Azure Cloud

Learn Azure SQL Database, Synapse and Stream Analytics, Data Factory & Pipeline design, Power BI with Practical Labs

3.75 (37 reviews)

Udemy

platform

English

language

Other

What you will learn

Cloud Computing Basics

Data Warehousing Basics

Azure SQL Database Essentials

Azure Synapse Analytics

Azure Stream Analytics

Azure Data Factory

Azure Pipelines

Loading Datasets to Blob Storage

Multiple Data Importing Techniques in Azure

Azure Data Factory (Extract, Transform, Load Process)

Exporting Blob Storage Data to Azure SQL DB and Synapse Analytics

Network Settings

Data Visualization on Power BI

Dataset Report Generation and Sharing

SQL basics and Aggregations

Why take this course?

Microsoft Azure is one of the most popular public clouds in the industry. Nearly all of the Fortune 100 companies are moving to the cloud, and being able to work with it is one of the most important skills for every developer, architect, or IT admin.

This course is designed for the students who are at their initial stage or at the beginner level in learning data analytics, cloud computing data visualization and Analytics using the Microsoft Azure Cloud Services.

This course focuses on what cloud computing is, followed by some essential concepts of data analytics. It also has practical hands-on lab exercises which covers a major portion of importing and performing some Analytics on the datasets.

The ETL tool used is Azure Data factory and analytics is performed using a visual tool known as Power BI. The lab portion covers all the essentials of the Azure SQL Databases, Azure Synapse Analytics, Azure Stream Analytics, Azure Data Factory and Power BI. Starting from importing the datasets, loading it, performing powerful SQL queries and then analyzing the same data using the queries and visual graphical tools are all covered in great detail.

Again experience with Cloud Azure services taught in this course will give you an edge in the job market and will position you for a successful career.

Content

Introduction to Cloud Computing

What is Cloud

What is Cloud Computing

Cloud Computing Services

Why Cloud Computing

Quiz

Introduction to Data Warehouse

How Data Warehouse Works?

Types of Data Warehouse

Data Warehouse Architecture

Data Warehouse Components

Why use Data warehouse?

Quiz

Microsoft Azure Cloud Setup

Create an Azure Cloud Account

Microsoft Storage Account Setup

Creating Azure Storage Account (Blob Storage)

Introduction to Azure SQL Database

Create and Setup Azure SQL Database

Azure SQL DB Firewall Settings

Installing the SQL Server Management Studio Part1

Installing the SQL Server Management Studio Part2

Connecting SQL Server Management Studio with Azure SQL DB

Introduction to Azure Data Factory (ETL Process)

What is ETL

ETL Process in Data Warehouse

ETL Tools

Create Data Factory in Azure

Create Pipeline in Azure Data Factory

Create linked Service for Blob Storage

Create Linked Service for SQL Database

Create COPY Activity and run the pipeline

Dealing with Multiple Datasets

Creating Tables for Multiple Datasets in SQL DB

Creating Linked Service for Multiple dataset in Blob

Creating linked service for multiple data load to SQL DB

COPY Activity for multiple dataset load to SQL DB

Upload movies dataset for ETL transformation

Create ADF Dataflow and Load Movies dataset

Apply Filter in ADF Data Flow

Average-Aggregation Function in ADF

Sink Transformed Dataset to Blob Storage

Quiz

Introduction to Azure Synapse Analytics ( Massively Parallel Processing)

Create Azure Synapse Workspace

Overview of Azure Synapse Workspace

Upload Dataset in Azure Linked Storage and Perform SQL Query

Create SQL Pool in Azure Synapse

COPY Dataset from Data Lake to Workspace Database

SQL Foundation for Data Analytics

What is SQL ?

Basic SQL commands

SELECT ALL Statement

SELECT Single or Multiple Column

DISTINCT Statement

COUNT and COUNT(DISTINCT)

WHERE Statement

AND Statement

OR Statement

NOT Statement

UPDATE Statement

DELETE Statement

INSERT INTO Statement

Why Join Datasets (Overview)

SQL Joins

SUM Function

AVG Function

Extreme Value Calculation and Sorting Data

Grouping and Filtering in Groups

Azure Stream Analytics: Real Time Stream Data

Create EventHub Namespace and Events

Configure TelecoGenerator App

Create Azure Stream Analytics Job

Create Input Job

Create Output Job

Realtime Data Upload to Blob Storage

Introduction to Azure Power BI

What You Will Learn?

Import Dataset from Blob Storage

Import Dataset from SQL Database in Azure

Import Dataset from Excel File

Cards in Power BI

Bar Charts and Column Charts

Line and Area Charts

Line and Column Charts

Waterfall and Funnel Charts

Pie and Donut Chart

Tables in Power BI

Matrix Tables

Decomposition Tree

Capstone Project

Capstone Project MS Azure

Screenshots

Introduction to Data Analytics on Microsoft Azure Cloud - Screenshot_01

Introduction to Data Analytics on Microsoft Azure Cloud - Screenshot_02

Introduction to Data Analytics on Microsoft Azure Cloud - Screenshot_03

Introduction to Data Analytics on Microsoft Azure Cloud - Screenshot_04

Reviews

Agbor

October 12, 2023

Her English was difficult to listen but I noticed she is from India so it was cool anyway, good lecture.

Ibukun

February 28, 2023

Good experience so far. Though the files in the resourses are not complete / out of date, Also, there was a mention of where the scripts for creating the items Table in one if the videos but couldt find it. The subtitles/captions are a no-no, so I turned it off because they ended up confusing me

Paul

February 3, 2022

Very well produced content - would have been nice to stick to one problem domain, e.g. movies, fraudulent phone calls, all the way through for each lesson.

Charts

Price

Rating

Enrollment distribution

Introduction to Data Analytics on Microsoft Azure Cloud - Distribution chart

Introduction to Data Analytics on Microsoft Azure Cloud

What you will learn

Cloud Computing Basics

Data Warehousing Basics

Azure SQL Database Essentials

Azure Synapse Analytics

Azure Stream Analytics

Azure Data Factory

Azure Pipelines

Loading Datasets to Blob Storage

Multiple Data Importing Techniques in Azure

Azure Data Factory (Extract, Transform, Load Process)

Exporting Blob Storage Data to Azure SQL DB and Synapse Analytics

Network Settings

Data Visualization on Power BI

Dataset Report Generation and Sharing

SQL basics and Aggregations

Why take this course?

Content

Introduction to Cloud Computing

Introduction to Data Warehouse

Microsoft Azure Cloud Setup

Microsoft Storage Account Setup

Introduction to Azure SQL Database

Introduction to Azure Data Factory (ETL Process)

Introduction to Azure Synapse Analytics ( Massively Parallel Processing)

SQL Foundation for Data Analytics

Azure Stream Analytics: Real Time Stream Data

Introduction to Azure Power BI

Capstone Project

Screenshots

Reviews

Charts

Price

Rating

Enrollment distribution

Related Topics