BISP 

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


Power BI - A 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, Many: Many) Single & Bi-directional Filtering
  • Composite Models

3. Reports Development

  • Reports Development in Power BI Working with Different Visuals Formatting Options in Reports Working with Filters
  • Custom Visuals Tool Tips Themes Wallpapers
  • Q & A

4. Power BI Service (Power BI Service Domain account Credentials will be Provided in the course)

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

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

5. 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


6. Advanced/ Other Power BI Concepts

  • Parameters Drill Through Bookmarks
  • Row level Security Dynamic Measures Dynamic Axis in Charts Dynamic Filters
  • Power BI Template file Editing the Themes Power BI Updates
Course Id:
MSPB001 
Course Fees:
301 USD