MBSI Microsoft Business Intelligence course Expert level by MP TechnoSolutions

SQL Server Development
SQL Overview
Data types
Constraints
DDL and DML statements
SELECT statement
Built-in Functions
Sub Queries
Joins
Views
CTE
Temp tables
Table variables
Set operators
IF conditions & Loops
Ranking functions
Transactions
Functions
Stored procedures
Triggers & Cursors
Exceptions
SSIS (SQL Server Integration Services)
Introduction ETL and SSIS
Environment Overview
Import and export wizard
Control flow and data flow
Tasks, precedence constraints and containers
Data flow task – all transformations, sources and destinations
Check points, break points, data viewers
Deployment( wizard and command line)
Error handling, loggings
Datawarehousing concepts
Dimension modelling
Schema overview
Types of dimensions
Facts
Project-1
SSRS (SQL Server Reporting Services)
Introduction to SSRS
Architecture of SSRS
What is Report Server
What is Report Manager
Creating Reports using Wizards
Creating reports using BIDS
What are Data sources
What are Shared Data sources
Types of Reports (Table and Matrix)
Parameterized report
Multi-valued Parameterized Reports
Drill Down report
Page break concept
AdHock Report / Wizards – DONE
Cascading report
Drill through Report / hyperlink report / jump report / navigation report / go to report/ Action report
Rectangle Report
Chart report and its properties
Sub report
Gauge
Map Reports
Report Subscription (Email and Windows File Share) and Scheduling
Report Manager Operations
Edit Report
Move / Delete Report
Linked Report
Cashed / Execution Report (Snap short and History comes under this report)
SSAS (SQL Server Analysis Server)
Introduction to SSAS
Schemas
Star Schema
Snowflake Schema
Types of Relationships Concepts:
One – One
One – many
many – many
Data source
Data source views
Options in DSV
Dimension
Measures
Cube Creation
Build
Deploy
Process
How to Brows the CUBE
Types Of Relationships inside CUBE
No relationship
Regular Relationship
Fact Relation
Referenced Relationship
Hierarchies and Performance Tuning Technique
What are KPI’s and How to Create KPI’s in SSAS
What are Perspective and how to create
What are Partitions
What are Translations
What are Actions
What are Calculations
Aggregations and Different types of Creations
Storage design – ROLAP, MOLAP, HOLAP