Microsoft Power BI

Course Overview

In the Power BI training, you access data from a wide range of data sources and create Reports using the in-built visuals. You will also learn to format those visuals for maximum effect and import custom MS visuals to extend your reporting capability. You will gain expertise in DAX languages and then publish your masterpiece to a workspace in the Power BI Service, creating Dashboards, sharing Reports and Dashboards with colleagues, concluding with scheduling a data refresh.

Prerequisites: Students should have at least a high school diploma or GED, along with good computer knowledge.

2 Months (95 Hours) of Long Professional Course.

Course Curriculum

Module 1: Dimension Modeling & Data Ware Housing

Dimension Modeling & Data Ware Housing
Basic concepts of Business Intelligence
Basic concepts of Data Warehousing
Designing facts and dimensions
Employing key performance indicators
Dimensional modeling process to design Data Warehouse

Module 2: MS SQL Server Integration Services (SSIS)

Extract, Transform and Load (ETL) data – Covering various transformations
Solve data management problems by migrating and processing data
Demo on populating data into dimension and fact table using adventure works data warehouse
ETL Framework
Enhance package functionality with scripting
Implementing loops to import multiple files
Handling errors and managing exception rows
SSIS Package Performance Tuning & Best practices
Deploy packages to an SSIS server
Administering the storage, security and execution of packages

Module 3: MS SQL Server Reporting Services (SSRS)

Producing table and matrix report with drill down and drill through functionality
Produce reports with enhanced visualization features such as charts, map and gauge
Integrate parameters, filters and interactive components into reports
Create reports on SSAS cubes with Report Builder
Deploying reports to the Report Server
Creating cached instances, snapshots and subscriptions
Configuring and testing security on report items
Report performance tuning

Module 4: MS SQL Server Analysis Services – Multidimensional Analysis Model (SSAS)

Creating and deploying a cube
Extend hierarchies and exploit advanced dimension relationships
Configuring many-to-many dimension relationships
Building aggregations with the Aggregation Design Wizard
Implement Key Performance Indicators to monitor business objectives
Cube storage mode – MOLAP, ROLAP and HOLAP
Implementing an action to open a Reporting Services report or to analyze data using Excel
Automating cube processing with an XMLA script