Introduction to Data Analytics on Microsoft Azure Cloud

Name: Introduction to Data Analytics on Microsoft Azure Cloud
Rating: 4.0 (75 reviews)

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

Created bySKILL CURB

Last updated 10/2021

English

What you'll 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

Course content

11 sections • 78 lectures • 4h 57m total length

What is Cloud3:35
Explore what the cloud is in relation to big data, its storage, privacy and security considerations, and how cloud storage provides backups and universal access across devices.
What is Cloud Computing6:58
Cloud Computing Services12:23
Explore cloud computing services and the three service models—infra as a service, platform as a service, and software as a service—along with virtual machines, cloud storage, databases, and cloud applications.
Why Cloud Computing3:53
Explore why cloud computing matters in the digital era, highlighting flexibility, scalability, disaster recovery, and automatic updates that empower teams to work from anywhere and grow business agility.
Quiz

How Data Warehouse Works?6:19
Learn how data warehouses collect data from multiple sources, extract, clean, and transform it, and store it in a central repository for reporting and business intelligence.
Types of Data Warehouse3:33
Data Warehouse Architecture7:40
Analyze data warehouse architectures from basic to staging-area and data-mart designs; learn how online transaction processing data supports online analytical processing through extraction, cleansing, and metadata-driven organization for strategic insights.
Data Warehouse Components9:53
Why use Data warehouse?5:40
Quiz

Create and Setup Azure SQL Database11:37
Azure SQL DB Firewall Settings2:55
Installing the SQL Server Management Studio Part11:53
Installing the SQL Server Management Studio Part20:50
Connecting SQL Server Management Studio with Azure SQL DB2:43
Learn to connect SQL Server Management Studio to Azure SQL DB from your local machine, configure firewall and server authentication, and explore databases and tables with sample queries.

What is ETL7:36
ETL Process in Data Warehouse3:24
Explore the edl/etl process in cloud data warehouses like Redshift and BigQuery, enabling in-place transformations and data modeling, with change data capture and incremental loading across sources and auditing.
ETL Tools2:15
Create Data Factory in Azure3:06
Create Pipeline in Azure Data Factory3:24
Create linked Service for Blob Storage1:50
Create Linked Service for SQL Database3:08
Create COPY Activity and run the pipeline4:42
Create a copy activity in an Azure Data Factory pipeline to move data from blob storage to the Ezekial database, map schemas, convert types, debug, publish, and verify.
Dealing with Multiple Datasets2:21
Upload multiple data set files to blob storage, create a container, and copy the dispatch record and items records into the Eskil database using pipelines and copy activity.
Creating Tables for Multiple Datasets in SQL DB2:46
Creating Linked Service for Multiple dataset in Blob6:30
Create and test link services for blob storage and Eskil database, configure datasets, and copy data from blob to the Eskil database using a copy activity.
Creating linked service for multiple data load to SQL DB3:12
COPY Activity for multiple dataset load to SQL DB4:28
Upload movies dataset for ETL transformation1:48
Create ADF Dataflow and Load Movies dataset4:26
Apply Filter in ADF Data Flow3:14
Apply filters in an ADF data flow to select comedy movies from 1910–2000, then compute yearly average scores using the expression builder and two integer function.
Average-Aggregation Function in ADF2:11
Apply the average aggregation in a data flow with Azure Data Factory, using group by and aggregates, define an expression for the rating output, and store results in blob storage.
Sink Transformed Dataset to Blob Storage5:41
Save the transformed data to blob storage using a data flow in Azure Data Factory, creating a comedy ratings sink and a delimited text dataset saved as a single file.
Quiz

What is SQL ?2:11
Learn sql basics for relational databases, including select, insert, update, and delete statements, creating tables and views, and managing permissions, as standardized by ANSI and ISO.
Basic SQL commands1:33
SELECT ALL Statement3:18
SELECT Single or Multiple Column1:54
DISTINCT Statement2:20
Apply the distinct statement to reveal unique values in dataset columns like region and sales channel, count these distinct values, and understand the distribution across seven regions and two channels.
COUNT and COUNT(DISTINCT)2:46
WHERE Statement3:56
AND Statement2:34
OR Statement2:02
NOT Statement1:30
UPDATE Statement2:35
Master the update statement in sql to modify specific records, such as changing a country name for an order, and avoid updating all rows by using a proper where clause.
DELETE Statement2:10
INSERT INTO Statement2:10
Why Join Datasets (Overview)2:49
SQL Joins3:28
SUM Function4:54
AVG Function2:46
Extreme Value Calculation and Sorting Data5:16
Grouping and Filtering in Groups4:30

What You Will Learn?0:47
Import Dataset from Blob Storage3:22
Import Dataset from SQL Database in Azure2:17
Import Dataset from Excel File2:03
Cards in Power BI4:10
Bar Charts and Column Charts5:50
Line and Area Charts4:41
Line and Column Charts2:05
Explore line and column charts as a powerful combo visualization that stacks columns and adds a line to compare online and offline sales and local revenue.
Waterfall and Funnel Charts4:22
Pie and Donut Chart2:40
Tables in Power BI2:37
Matrix Tables2:48
Analyze total profit by item type, sales channel, and region using a matrix table in Power BI, and compare online versus offline sales counts across the dataset.
Decomposition Tree4:06

Requirements

Existing Azure Account
PC/Laptop with Internet Connection
No Prior Programing Experience is required

Description

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.

Who this course is for:

Beginners in Data Visualization, Data Warehousing.
Students at their initial stage of learning Microsoft Azure Web Services.
Students at their initial stage of learning AWS SQL Databases.
Students at their initial stage of learning AWS Synapse Analytics.
Beginners in learning Azure Data Factory (ADF) for ETL Service
Students at their initial stage of learning AWS Stream Analytics.

Introduction to Data Analytics on Microsoft Azure Cloud

What you'll learn

Explore related topics

Course content

Introduction to Cloud Computing4 lectures • 27min

Introduction to Data Warehouse5 lectures • 33min

Microsoft Azure Cloud Setup1 lecture • 3min

Microsoft Storage Account Setup1 lecture • 10min

Introduction to Azure SQL Database5 lectures • 20min

Introduction to Azure Data Factory (ETL Process)18 lectures • 1hr 6min

Introduction to Azure Synapse Analytics ( Massively Parallel Processing)5 lectures • 20min

SQL Foundation for Data Analytics19 lectures • 55min

Azure Stream Analytics: Real Time Stream Data6 lectures • 22min

Introduction to Azure Power BI13 lectures • 42min

Requirements

Description

Who this course is for: