Microsoft BI using SSIS, SSAS and SSRS

Powerful platform to learn the advanced data management & reporting for large & medium enterprises. Leverage existing databases like MS-SQL server to read and store data. A complete guide to learn, enhance and improve data management skills.


This program facilitates understanding of Microsoft Business Intelligence platform to transform, process, store, retrieve, model and visualize the data. The approach is to use a specific industry example: like Manufacturing or Retail sales and help business processes set up data pipelines and maximize data reach to business users in the most effective and simplistic manner.
Tools like SSIS will be used to collect and apply data transformations, SSAS for data modelling and aligning metadata for business strategy and finally SSRS for business reporting and analysis.
The course is backed with complete business and technology notes.



What Will I Learn?

  • Describe Microsoft BI Services and its components
  • Create data transformations and build business specific data models
  • Publish and query data models for information retrieval
  • Create visual views to interact, filter and drill down deep into data granularity
  • Enhance a Reporting services report
  • Configure report publishing

Topics for this course

33 Lessons50h

Implement and Maintain Microsoft SQL Server Integration Services

Installation of Microsoft Integration Services & Control Flow
Moving Data with Export and Import wizard
Installing SSIS
Installing Sample Database
Creating a Solution and a Project + Exploring SSDT
Creating Packages
Upgrading Packages to SQL Server 2012
Upgrading to the Project Deployment Model
Control Flow- Using Precedence Constraints
File System Task, Execute SQL Tasks, Execute Process Tasks, Create a Data Flow
Data Flow and Make Packages Dynamic
Extract Data from Sources & Load Data to a Destination
Make a Dynamic Package & a Dynamic Connection
Incremental Data Load
Dimension and Fact Load

Implement and Maintain Microsoft SQL Server Analysis Services

Implementing and Maintaining Microsoft SQL Server Reporting Services

About the instructors

Pedagogy Trainings

4.67 ratings (6 )
23 Courses
83 students



Course Details

  • Level: Beginner
  • Categories: Business Analytics
  • Total Hour: 50h
  • Total Lessons: 33
  • Total Enrolled: 0
  • Last Update: April 14, 2021


  • Exposure to create report using MS Access or equivalent tools
  • SQL skills and basic DML (Data Manipulation Language)
  • Experience with windows services
  • Knowledge on services accounts and other built accounts in windows

Target Audience

  • Intended for Information – Technology (IT) professionals and developers who need to implement & develop ETL solutions, implement OLAP multidimensional analysis
  • Developers who need to implement reporting solutions using Microsoft BI 2016.