Power BI

SQL Concepts

Azure Cloud Concepts

Azure BLOB

Azure SQL

Azure Analysis Service

Introduction to Azure data Factory

Introduction to power bi

Creating and formatting a table visualization

Creating different visualizations-Matrices and bar charts

Adding more controls to visualizations

Other important visualizations

Mapping

Measure performance by using KPI and gauges

Other Visualization items

Visualize and analyze the data

Get and transform data

Get data- Home

Getting multiple files

Transform menu

Transform- text and numbers

Transform- date and time

Add columns, view and help menus

View and help menu advanced

Get other type of data

Get and transform

Creating a data model

An introduction to DAX functions

Statistical functions

Mathematical functions

Text functions

Information functions

Filter and value functions

Time intelligence functions

Other important modelling and DAX topics

Introduction to Power BI service

Power bi Pro and adding users

Row and object level security

Dashboards

Manage datasets

Create and manage workspaces

Other power bi service topics

Overview and RDBMS concepts

Create databases

Integrity constrains

SQL statements

Functions and Operators

Order By, Group by and where clause

Having Clause and Top Clause

Union Clause

Null Values

Aliases

Indexes

Temporary table

Joins

Subquery

Introduction to T-SQL, batch and control flow keyword, Begin… End

Working with variables

Go command

IF… Else statement

While loop, Try catch and WAITFOR

Stored Procedure

Introduction to cloud computing

What is Cloud?

What is Azure cloud?

Types of Services in Azure Cloud

Introduction

Blob storage resources

Types of Blobs

How to Create Blob

Blob Connectivity with blob

Introduction

Create blank database in Azure SQL database

Create server level IP firewall rule

Connect with database

Create tables in database

Load data into tables

Query data

Connect azure SQL from Power BI

Introduction

Create service

Create data model and process

Deploy on Azure Cloud

Connect from Power BI