Microsoft Azure BI

Mail: Boyapati.ram100@gmail.com

Mob:9885245722

Website: www.eclasess.com

Services:    Duration:45 hours

Resume Preparation

Interview Questions and Answers

Real Time Project Explanation

INTRODUCTION TO MICROSOFT AZURE
  • Introduction to Microsoft Azure

  •  what is Cloud computing

  • what are services offering Microsoft azure

  • Advantages of cloud computing

  • Types of cloud deployments

  • Types of cloud Services

  • Microsoft Azure vs AWS

  • How to Create Azure Account

  • Azure Architecture & Services

  • How to Create Resources and Resource Groups in Microsoft Azure

  • Azure Resource Manager vs. classic deployment

  • How to create Virtual Machine

What are Storage Accounts in Azure
  •   Blob

  •   File

  •   Queues

  •   Tables

Azure SQL Databases
  • What is Azure SQL

  • Different deployments of SQL in Azure

  • How to create Azure SQL Server

  • How to Create Database in Azure SQL Server

  • How to Query Azure SQL Server from On-premises SSMS and Cloud

  • What is Polybase in Azure SQL

  • What is External tables

  • What are limitations compared On-premises to Cloud SQL Server

  • How to Load Data from On-premises to Cloud SQL using data factory

  • Migration of Existing Data from on premises to SQL Azure

What is Azure Data ware House
  • Compare SQL Database vs Azure DW

  • How to Create Azure DW

  • How to cross query data in DW

  • How to Query Azure SQL DW from On-premises SSMS and Cloud

  • How to Load Data to Azure DW using data Factory from Azure SQL

  • How to Load Data from on premises to Cloud SQL DW using data factory

Azure Data Factory
  • ·       Azure Data Factory vs SSIS

  • ·       Linked Services

  • ·       Data Sets

  • ·       Pipelines

  • ·       Parameters

  • ·       Copy Data

  • ·       Monitor Manage

  • ·       Autor and Deploy

  • ·       Different kinds of integration runtimes

  • ·       How to create pipelines from template

  • ·       How to configure different Integration Runtimes

  • ·       Azure Integration runtime

  • ·       Azure Self Hosted Integration Runtime

  • ·       SSIS Integration runtime.

  • Move & transform

  • ·       Copy Data

  • General activities

  • ·       Append Variable

  • ·       Execute Pipeline

  • ·       Execute SSIS Package

  • ·       Get Metadata

  • ·       Lookup

  • ·       Stored procedure

  • ·       Set Variable

  • ·       Delete

  • ·       Wait

  • ·       Until

  • Iteration & Conditionals

  • ·       Filter

  • ·       For Each

  • ·       If Condition

  • ·       Until

  • What are ARM Templates using for Deployment

  • How to Deploy Data Factory Pipelines DEV, Test, Prod environment

  • Version Control and Code Repository in Git Hub

  • Debugging and Monitoring Pipelines

  • Error handling and Logging error records

  • Lift and Shift SSIS packages in to Azure Data Factory

Azure Analysis Services
  • What is Azure Analysis Services Tabular Model

  • How to create Azure Analysis Service Tabular model project

  • What is Workspace database

  • Import Data

  • Direct Query Mode

  • Tables and Columns

  • Relationships

  • Calculations

  • Measures

  • KPIs

  • Hierarchies

  • Partitions

  • Perspectives

  • Translations

  • Roles

  • Deployment of Tabular Project

  • Migration of Tabular Project

Data Lake
  • What is Data Lake

  • How to store Data into data lake

  • How to Query data from datalake to SQL Server.

  • Introduction to Azure Data Lake U-SQL Batch Job

  • Data Lake Analytics

  • What is HD-insight

  • U SQL

Databricks
  • What is Databricks

  • Configure data bricks

  • Read data from data bricks by creating clusters

Azure Event Hub & Realtime Analytics
  • What is Azure Event Hub

  • How to configure Event Hub

  • Perform Realtime analytics on Event Hub Data

Power BI
  • what is power BI

  • How to create Reports in Power BI desktop Using Azure Data sources

  • Publish Reports into power BI cloud

Comming soon......

Contact: 9885245722

 

#50, Kamala Nivas, Sap Street Gayatri Nagar, Behind Mytrivanam, Building,Ameerpet, Kumar Basti, Srinivasa Nagar, Ameerpet, Hyderabad, Telangana 500038

  • Facebook - Grey Circle
  • LinkedIn - Grey Circle
Get a quote: 9885245722