Power BI Training

Duration: 30 hours

Class Schedule: Monday to Friday

Course Content

Section 1 : Getting started

• Welcome to the Course

• Understanding the Power BI Tools

• Installing Power BI & Connecting to Data

• The "Locale" used in the curriculum

• Working with the query Editor

• Working with the data model and creating a visualization

• Course outline

Section 2: Intro to Power BI Desktop

• Overview of workflow in power bi desktop

• Introduction to different views of data model

• taking a closer look at the query editor interface

• Required Power BI Settings

Section 3: An introduction to query editor

• What is query Editor?

• About the attached data

• Connecting Power BI Desktop to the data

• Editing Rows

• Understanding Append Queries

• Editing Columns

• Replacing Values

• Formatting Data

• Pivoting & Unpivoting Columns

• Splitting Columns

• Creating a new Group for the queries

• Intro Star Schema

• Duplicating & Referencing Queries

• Entering Data Manually

• Merging Queries

• Creating an Index Column

• Duplicating Column and extracting info

• Creating Conditional Columns

• Performing Basic Mathematical Operations

• Improving Performance and Loading Data into Data Model

• Module Summary

Section 4 : Data & Relationship View

• Module intro

• Query Editor & the data model. Why are they different?

• Intro to relationships

• Editing relationships

• Concepts are cardinality

• Cross Filter selection & Many to many relationship

• Active properties

• M-Language & DAX. How are they different?

• DAX | Measures | Calculated Values

DAX will include complex functions like Calculate, SUM, SUMX, RELATED, ALLEXCEPT, CONCATENATE, LOOKUPVALUE, IF, SEARCH, DATEADD, DIVIDE and many more.

• Categorizing Data

Section 5 : Working in the report view to visulaize our results

• Module intro

• Report view interface

• Creating visuals

• Add tooltips and interactions/markings

• Data color

• Hierarchies & Drill down

• Formatting charts & Sorting

• Introduction to slicers

• Tree maps & Tables

• Types of filters

• Multi-row cards

• Combined visuals & waterfalls

• Module summary

Section 6 : Power Bi Service & Power BI Mobile

• Module Intro

• Why Power Bi Service?

• Comparison Power BI Free & Premium

• Logging into Power Bi Service

• Interface overview

• Importing data from Desktop to Service

• Dataset menu

• Working on reports

• Dashboard overview

• Workspace & Gateways

• Installing Gateways - Personal & On-premise

• Working alone or collaborating with colleagues

• Collaborating in App Workspace

• Sharing the results

• Publishing the app

• Content packs from online services

• Power Bi Mobile Overview

• Excluding dataset from sharing

• Module Summary

Section 7 : Other data source

• JSON Data

• Importing data from rest of the APIs

• Setting up a SQL Server

• Importing data from SQL Server

Section 8 : Course Round up Section 9 : Power App

• Overview

• Basic Power App Concept

• Canvas Apps | Navigation | Customization

• Contents

(Galleries, Data Cards, Forms, Triggers, Functions & Formulas, Edit Forms, Text Boxes)