Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us

Call: +1 416-623-9493 or +1 416-333-3717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

Software Quality Assurance Training Business Analysis Training Microsoft BI Training Azure Business Intelligence Training Cyber Security SAP Training DevOps Training PMP Training Informatica Training JAVA Training MICROSOFT .NET Training Big Data & Hadoop Training Scrum Training ORACLE Admin Training

Azure Business Intelligence Consultant Training
  DURATION   39 Hours
  Course Fee   $1800+HST

Microsoft Cloud BI Course is designed to provide insights on different tools in Microsoft BI, Azure Cloud fundamentals, SQL Server, Azure data factory for ETL, Reporting on Power BI


SQL Server

database & data warehouse design and development including data mart structures and SQL coding, performance tuning


  • Introduction to Cloud Computing
  • Azure Core Services
  • Azure Networking
  • Azure Storage
  • Understanding Cloud Concepts
  • Azure Core Services
  • Understand Security, Privacy, Compliance and Trust
  • Understanding Azure Pricing

Unit 1) Non-Relational Data Stores and Azure Data Lake Storage

  • Document data stores
  • Columnar data stores
  • Key/value data stores
  • Graph data stores
  • Time series data stores
  • Object data stores
  • External index
  • Why NoSQL or Non-Relational DB?
  • When to Choose NoSQL or Non-Relational DB?
  • Best Uses
  • Scenarios
  • Azure Data Lake Storage
  • Definition

Azure Data Lake-Key Components

  • How it stores data?

Azure Data Lake Storage Gen2

  • Why Data Lake?
  • Data Lake Architecture

Assignments in Unit 1

Unit 2 )Data Lake and Azure Cosmos DB

  • Data Lake Key Concepts
  • Azure Cosmos DB
  • Why Azure Cosmos DB?
  • Azure Blob Storage
  • Why Azure Blob Storage?
  • Data Partitioning
  • Horizontal partitioning
  • Vertical partitioning
  • Functional partitioning
  • Why Partitioning Data
  • Consistency Levels in AzureCosmos DB

Semantics of the five-consistency level


  • Load Data fromAmazonS3 to ADLS Gen2 with Data Factory
  • Working with Azure Cosmos DB

Assignments in Unit 2

Unit 3 )Relational Data Stores

  • Introduction to Relational Data Stores
  • Azure SQL Database
  • Deployment Models
  • Service Tiers

Hands-on: Create a Single Database Using Azure Portal

Hands-on: Create a managed instance

Hands-on: Create an elastic pool

  • Why SQL Database Elastic Pool?
  • Hands-on: Create a SQL virtual machine
  • Hands-on: Configure active geo-replication for Azure SQL Database in the Azure portal and initiate failover.

Assignments in Unit 3

Unit 4)Azure Data Factory

  • Flow Process of Data Factory
  • Why Azure Data Factory
  • Integration Runtime in Azure Data Factory

Azure data factory Pipelines.

  • Copy data in cloud
  • Copy on-premises data to cloud
  • Copy data in bulk
  • Copy data incrementally
  • Load ADLS Gen2
  • Load SQL DW
  • Load SAP BW

Assignments in Unit Data Factory Pipelines.

Azure Data Factory Dataflows

  • Data transformation

What are mapping data flows?

  • Create data flow

Data flow expression language

  • Debug data flow

Execute data flow activity inside pipeline

  • Monitor data flow
  • Data flow performance

Unit 5 ) Azure Data Bricks

  • What is Azure Databricks?
  • Azure Spark-based Analytics Platform
  • Apache Spark in Azure Databricks
  • Hands-on: Run a Spark Job on Azure Databricks using the Azure portal
  • Hands-on: ETL Operation by using Azure Databricks
  • Hands-on: Stream data into Azure Databricks using Event Hubs

UNIT 6 )Azure Stream Analytics

  • Working of Stream Analytics

Key capabilities and benefits

  • Hands-on: Analyse phone call data with stream analytics and visualize results in Power BI dashboard

Stream Analytics Windowing Functions

  • Tumbling window
  • Hopping Window
  • Sliding Window
  • Session Window

Unit 7 )Monitoring & Security

  • What is Azure Monitor?
  • Metrics
  • Logs
  • Metrics Vs Logs

What data does Azure Monitor collect?

What can you Monitor?

Insights and Core Solutions

Alerts in Azure

  • Flow of Alerts

Key Attributes of an Alert Rule

What can you set alert on?

  • Manage alerts
  • Alert States

How to create an alert?

Hands-on: Create, View, and Manage Metric alerts using Azure Monitor

Hands-on: Monitor your Azure Data Factory Pipelines proactively with Alerts

Azure Security Logging & Auditing

  • Types of Logs in Azure

Azure SQL Database Auditing

Server-level vs. Database-level Auditing Policy

Hands-on: Azure SQL Database Auditing

Introducing Power BI

  • Creation of Report
  • Publishing to CLOUD
  • DAX Introduction
  • Basic Calculation using DAX
  • Measures on Category AXIS
  • DATA Transformations
  • Designing a DASHBOARD
  • Advanced Features of POWER BI CLOUD SERVICE
  • Advanced Features of POWER BI DESKTOP CLIENT
  • DATA Types
  • Logical Functions
  • Error Handling
  • Context
  • Context Interactions
  • Context over Relations
  • SCHEMA Relations
  • Table Functions
  • Time Intelligence Functions
  • Rankings
  • GATEWAY and Schedule Refresh
  • Row Level Security

Project 1 )

Financial Data loading using Azure Data Factory from On premise source system to AZURE SQL DB Datawarehouse.

Project 2 )

Purchasing,Inventory,Production data Data loading using Azure Data Factory from On premise source system to AZURE SQL DB Datawarehouse.

  SOFTWARE   Weekend Batch -Demo Class May 7th or May 8th 2022 from 10:00 AM to 12:00 PM

Mississauga: 1065 Canadian Place, Suite 201, Mississauga ON L4W 0C2
Scarborough: 2401 Eglinton Ave E, Suite 304, Scarborough(Eglinton & Kennedy) ON M1K 2M5
Montreal: 279 Rue Sherbrooke O, Suite 209, Montreal, QC H2X 1Y2 PH: +1-514-664-3900

Phone: +1 416-623-9493 or +1 416-333-3717

E-mail: training@globalerp.ca