Microsoft Power Business Intelligence (BI) Training

Secure enrollment now

Syllabus

Introduction to Power BI

 

  • Business Intelligence
  • Self Service Business Intelligence
  • SSBI Tools
  • What is Power BI
  • Why Power BI?
  • Key Benefits of Power BI
  • Flow of Power BI
  • Components of Power BI
  • Architecture of Power BI
  • Building Blocks of Power BI

​

Overview of Power BI Desktop

 

  • Data Sources in Power BI Desktop
  • Connecting to a data Sources
  • Query Editor in Power BI
  • Clean and Transform your data with Query Editor
  • Combining Data – Merging and Appending
  • Cleaning irregularly formatted data
  • Views in Power BI Desktop
  • Modelling Data
  • Manage Data Relationship
  • Cross Filter Direction
  • Create calculated tables and measures
  • Optimizing Data Models

​

Data Analysis Expressions (DAX)

​

  • Essential concepts in DAX
  • Why is DAX important?
  • DAX Syntax
  • Data Types in DAX
  • Calculation Types
  • DAX Functions
  • Measures in DAX
  • DAX Operators
  • DAX tables and filtering
  • DAX queries
  • DAX Parameter Naming

​

Data Visualization

​

  • Introduction to visuals in Power BI
  • Charts in Power BI
  • Matrixes and tables
  • Slicers
  • Map Visualizations
  • Gauges and Single Number Cards
  • Modifying colors in charts and visuals
  • Shapes, text boxes, and images
  • What Are Custom Visuals?
  • Page layout and formatting
  • KPI Visuals
  • Z-Order

​

Introduction to Power BI Q&A and Data Insights

​

  • Introduction to Power BI Service
  • Dashboard vs. Reports
  • Quick Insights in Power BI
  • Creating Dashboards
  • Configuring a Dashboard
  • Power BI Q&A
  • Ask questions of your data with natural language
  • Power BI embedded

​

Direct Connectivity

​

  • Introduction to using Excel data in Power BI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
  • Introduction to Power BI Development API
  • Import Power View and Power Pivot to Power BI
  • Power BI Publisher for Excel
  • Content packs
  • Introducing Power BI Mobile

​

Power BI Report Servers

​

  • Report Server Basics
  • Web Portal
  • Paginated Reports
  • Row level Security
  • Data Gateways
  • Scheduled Refresh
  • Resources (Rest API/ SOAP API’s/ URL Access)
  • Advanced Analytics in Power BI using R & Python

​

Advanced Analytics in Power BI using R & Python

​

  • R Integration in Power BI Desktop
  • R visuals in Power BI
  • R Powered Custom Visuals
  • Creating R visuals in Power BI
  • R Visuals in Power BI Service
  • R Scripts Security
  • Creating visual using Python

Complimentary sessions on communication presentation and leadership skills.

Benefits from the course

Mode of Teaching

​

Live Interactive

​

  • Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator.

 

  • Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modelling capabilities including data preparation, data discovery and interactive dashboards.

 

Prerequisite:

 

  • Fundamental understanding of Microsoft Excel and formulas

​

Prerequisites

  • Fundamental understanding of Microsoft Excel and formulas.

Course Duration:

27 Hours

Class Hours:

2 Hours Day time slots or 3 Hours week end Slots (May change)

Video Clip