Microsoft Power BI

A brief summary of the topics covered in this Power BI course is as below. This is 16 hours course, it is suggested to complete this course within 1 week.

Introduction and Installation

  • Power BI introduction and overview
  • Key Benefits of Power BI
  • Power BI Architecture
  • Power BI – Building Blocks
  • Power BI vs other BI tools
  • Power Installation
  • Overview of Power BI Desktop
  • Power BI Mobile

Introduction to Interface

  • Data Sources in Power BI Desktop
  • Connecting to a data Sources
  • Query Editor in Power BI
  • Views in Power BI
  • Field Pane
  • Visual Pane
  • Custom Visual Option
  • Filters 

Connecting to Different Sources

  • Introduction to using Excel data in Power BI
  • Import Power View and Power Pivot to Power BI
  • Import data from various sources into PowerBI
  • Exploring live connections to data with Power BI
  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL

Building Reports in Power BI

  • Power Query Introduction
  • Query Editor Interface
  • Clean and Transform your data with Query Editor
  • Data Type
  • Column Transformations vs Adding Colums
  • Text Transformations
  • Cleaning irregularly formatted data -Transpose
  • Date and Time Calculations
  • Advance editor: Use Case
  • Query Level Parameters
  • Combining Data – Merging and Appending
  • Time Intelligence Functions
  • Types of visualization in a Power BI report
  • Custom visualization to a Power BI report
  • Matrices and tables
  • Getting started with color formatting and axis properties
  • Change how a chart is sorted in a Power BI report
  • Move, resize, and pop out a visualization in a Power BI report
  • Drill down in a visualization in Power BI

DAX & PowerBI

  • What is DAX?
  • Why is DAX important?
  • Calculated Columns
  • Measures/New Quick Measures
  • Calculated Tables
  • Optimizing Data Models
  • Row Context vs Set Context
  • Cross Filter Direction
  • Advanced calculations using Calculate functions
  • DAX queries
  • DAX Parameter Naming
  • Data Acquisition and Transformation in Power BI

PowerBI Online

  • Power BI Service
  • Power BI Workspace
  • Power BI Publish
  • Reports in Power BI Service
  • Creating Dashboards
  • Publishing Reports and Scheduling Data Refresh
  • Security, Share PowerBI Reports, Dashboards.
  • Accessing Power BI on Mobile

Data Modelling with PowerBI

  • Manage Data Relationship

Best Practices in Power BI