Learn MSBI Step by Step with Hands On Training

We at QuestPond are glad to announce MSBI Step by Step Hands On Training through BI expert trainer Mr Gurunatha Dogi (Software Developer | Blogger | Trainer | Digital Marketer) with 10+ years of exp.

Course Duration : 30 days (Every day 1 hour)

Free Demo Course : Available for 1 hour

  • What is meant by MSBI?
  • MSBI Advantages Over Other BI Tools
  • Jobs and scope of learning MSBI
  • How to install MSBI Step by Step (VS 2017) along with other prerequisite req ****Here we will also learn Installation of SQL Server along with hands-on sql server with sample queries examples
  • What SSIS, SSAS and SSRS
  • Understand (Extraction, Transformation and Loading) process in Data Warehouse using microsoft tool SSIS
  • SSIS conditional split using an example
  • Data conversion using example
  • Understand Data Quality Services (DQS)
  • How to handle errors in SSIS an example step by step
  • Understand using Loops (SSIS) in MSBI
  • Understand use of Variables, Parameters and Debugging with project deployment in SSIS
  • What is File System Task and How to use it for Package Deployment in SSIS
  • Scheduling SSIS Package From SQL Server
  • Understand Sort, SSIS Merge & SSIS Merge Join
  • Understand slowly changing dimension (SCD) step by step
  • Learn SSIS Lookup component
  • Understand what is fact table, Dimension, Star Schema and Snowflake in Data Warehouse
  • How to Design Star Schema using example
  • How to Design Snowflake using example
  • Implementing transaction & checkpoints in SSIS Package
  • Learn how to create SSAS Cube
  • SSAS Data Mining Time Series
  • Understand SSAS Hierarchies with its different types
  • Understand SSAS Hierarchies with Multiple Dimension Tables
  • Understand SSAS Calculations & Actions
  • How to add calculations in SSAS cubes
  • SSAS Dimension usage - many to many relationship
  • SSIS Script Component as Transformation
  • Learn How To Partition an SSAS Cube
  • Tabular Model in SSAS
  • SSAS Power Pivot Mode in SQL Server 2017
  • MDX and DAX Query Analysis in SSAS
  • Learn How To Write MDX Queries In SSAS
  • What are aggregations in SSAS
  • Learn SSAS - MOLAP, ROLAP and HOLAP storage types
  • What is SQL Server Reporting Services (SSRS) & When is SSRS the Right Tool
  • How to create a simple SSRS Report using SSAS Tabular model
  • How to create a simple SSRS Matrix Report
  • What is the difference between Tabular and Matrix Report
  • How to Sort SSRS Report
  • SSIS Performance Tuning Techniques
  • Best Practices For Performance Tuning In SSAS Cubes