Microsoft Business Intelligence Program

Microsoft Business Intelligence

Our Alumni works at

To improve assistance, please provide

Program Path
Mentors Details

Course Description

MSBI Developer, In this program, you will learn the skills to manage the data for both operational and analytical applications.

Microsoft Business Intelligence platform allows the companies to manage the business intelligence platform effectively. You will be able to understand different source systems which feeds data to the Datawarehouse and work effectively on Database management, integration, reporting and building dashboards.

Inclusion (SQL, TSQL, DW CONCEPTS, SSIS, SSRS, POWERBI)

Business 101

• Introduction to Business • Industries and Business Characteristics • Approach to learn anything in business • Horizontal and Verticals in Industries • Industry to Information • Understanding Business Process • High Level View of a Company / Organization

Communication

• Seven Cs of Communication

• Tenses

• Redundant Words

• Similar Sounding Words

• Common Grammar Mistakes

• Common Mistakes

Oracle, SQL server

• Introduction to RDBMS

• Objects in RDBMS

• Entities & Relationships

• Data Model Fundamentals

• SQL — Language in

• RDBMS

• DDL, DML, DCL

• Create, Alter and Drop

• Select, Insert, Update and Delete

• Grant and Revoke — Security

• Data Storage

• Data Retreival

• Hands On

• Assesment & Mentoring

• Data Dictionary

• MetaData Definition

Types of Writing Queries

• Simple Select

• Sub Query

• Joins

• Aggregate Queries

• Corelated Queries

• Set Operators

• Derived / Inline Views

• OLAP / Analytical Queries

• Indexes

• Views

• Sequences

• Synonyms

TSQL

• TSQL Introduction

• Conditional and Loops

• Cursors

• Exceptions

• Procedures

• Functions

• Dynamic SQL

• Temp Tables

• Triggers

• Tuning and Scheduling

DW Concepts

• Data Warehousing

• Concepts

• OLAP and OLTP

• DSS Architecture

• Data Warehouse

• Data Mart

• Users in the Data

• Platforms

• Dimensional Modeling

• Dimension Fact

• Types of Dimensions

• Slowly Changing dimensions

Types of Measures

• ETL Transformations

• Data Lake Introduction

• Different types of Data we deal

• OLAP — Reporting / Dashboards

• Static Reports & Ad Hoc

• Reports

SQL Server Integration Services (SSIS)

• Loading data from File to Database

• Loading data from Database to File

• Loading data from Database to Database

• Applying Different Transformations

• Cleansing Data

• Testing the package

• Migration of Packages to different environments

SQL Server Reporting Services (SSRS)

• Introduction to Reporting Services

• Architecture of Reporting Services

• Creating simple tabular report

• Writing Queries to create the reports

• Data sets and the fields

• Creating Group reports, summary columns

• Writing test cases for reports

• Sub Reports for Drill down and Drill through

• Migration of Reports to different environments

Power BI

• Introduction to PowerBI

• PowerBI Desktop Interface

• Connecting Power BI to excel

• Charts and thier properties

• Table,matrix properties, Tree Map

• Introduction to DAX,Derived Fields and Date functions

• Introduction to conditional statements

• Slicers and its basic uses properties

• Super aggregations and Scatter plot

• Introduction to rank and Parameter

• Introduction to Power BI Service,Row Level Security

• Time intelligence functions YTD,QTD,MTD

• Date ADD, Same period, Parallel Period

Rajesh Kumar

Having 25+ years of experience in the IT industry. Empowering jobseekers to become good employees who work effectively at every opportunity.

Key Highlights

Embark on a journey of professional growth with our holistic approach to skill development. Our dedicated team provides tailored guidance and support, ensuring you're well-equipped for the demands of the job market. Whether you prefer weekday or weekend sessions, our flexible scheduling options cater to your convenience. With hands-on training and industry-recognized certifications, you'll gain the confidence and expertise needed to excel in your chosen field. Join us and unlock your full potential as you take the first steps towards a successful career.