BISP 

60% Complete Courses » Microsoft Power BI
  • Course Content
  • Course Overview
  • Training Schedule
  • Demo Video
  • Learning Material
  • Register




Power BI - Complete Package


1. Introduction

  • Introduction to Power BI
  • Components of Power BI
  • Installing Power BI Desktop
  • Various Options in Power BI Desktop

2. Working with Different Sources (Excel, SQL Server, OData Feed etc.)

  • Import
  • Direct Query
  • Import vs Direct Query
  • Limitations of Direct Query
  • Query Editor
  • Working with Power Query
  • Relationships (1:1, 1: Many, Many:1)

3. Reports Development

  • Reports Development in Power BI
  • Working with Different Visuals
  • Formatting Options in Reports
  • Working with Filters
  • Custom Visuals

4. Power BI Service

  • Overview of Power BI Service
  • Publishing the Reports
  • Dashboards
  • Gateways
  • Enterprise vs Personal Gateway
  • Work Spaces
  • Content Packs
  • Apps
  • Security
  • Schedule Data Refresh
  • Power BI Premium

5. SSAS Tabular

  • SSAS Tabular Overview
  • Install and Configure SSAS Tabular
  • Building a Tabular Model
  • SSAS Tabular as Source
  • Live Connections
  • Deploy & Processing in Tabular
  • SQL Server Agent
  • Schedule Processing of Model


6. Data Analysis Expressions (DAX)

  • Introduction to DAX
  • Calculated Columns
  • Measures
  • Calculated Columns vs Measures
  • Variables
  • Table Functions
  • Evaluation Contexts
  • Calculate
  • Time Intelligence in DAX
  • Frequently Used DAX functions in Real time
  • Calendar Functions

7. Advanced/ Other Power BI Concepts

  • Parameters
  • Drill Through
  • Bookmarks
  • Row level Security
  • Dynamic Measures
  • Dynamic Axis in Charts
  • Dynamic Filters
  • Power BI Template file
  • Wallpapers
  • Themes
  • Q&A
  • Editing the Themes
  • Power BI Updates

8. Demo Project

Course Id:
MSPB001 
Course Fees:
301 USD