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