Module 1: Planning Power BI Projects

Power BI deployment modes

Corporate BI

Self-Service Visualization

Self-Service BI

Choosing a deployment mode

Project discovery and ingestion

Sample Power BI project template

Sample template – Adventure Works BI

Power BI project roles

Dataset designer

Report authors

Power BI admin

Project role collaboration

Power BI licenses

Power BI license scenarios

Power BI Premium features

Data warehouse bus matrix

Dataset design process

Selecting the business process

Declaring the grain

Identifying the dimensions

Defining the facts

Data profiling

Dataset planning

Data transformations

Import versus DirectQuery

Import mode

DirectQuery mode

Sample project analysis


Module 2: Connecting to Sources and Transforming Data with M

Query design per dataset mode

Import mode dataset queries

DirectQuery dataset queries

Data sources


Data source settings

Privacy levels

Power BI as a data source

Power BI Desktop options

Global options


SQL views

SQL views versus M queries

SQL view examples

Date dimension view

Mark As Date Table

Product Dimension view

Slowly-changing dimensions

M queries

Data Source Parameters

Staging Queries

DirectQuery staging

Fact and dimension queries

Source Reference Only

M query summary

Excel workbook – Annual Sales Plan

Data types

Item access in M

DirectQuery report execution

Bridge Tables Queries

Parameter Tables

Security Tables

Query folding

Partial query folding

M Query examples

Trailing three years filter

Customer history column

Derived column data types

Product dimension integration

R script transformation

M editing tools

Advanced Editor

Visual Studio Code

Visual Studio



Module 3: Designing Import and DirectQuery Data Models

Dataset layers

Dataset objectives

Competing objectives

External factors

The Data Model

The Relationships View

The Data View

The Report View

Fact tables

Fact table columns

Fact column data types

Fact-to-dimension relationships

Dimension tables


Custom sort

Bridge tables

Parameter tables

Measure groups

Last refreshed date

Measure support logic




Single-direction relationships

Direct flights only

Bidirectional relationships

Shared dimensions

Date dimensions

The CROSSFILTER function

Model metadata


Column metadata

Default Summarization

Data format

Data category

Field descriptions

Optimizing performance

Import 147 Columnar compression

Memory analysis via DMVs


Optimized DAX functions

Columnstore and HTAP


Module 4: Developing DAX Measures and Security Roles

DAX measures

Filter context

SQL equivalent

Measure evaluation process

Row context

Scalar and table functions

The CALCULATE() function

Related tables

The FILTER() function

DAX variables

Base measures

Measure support expressions

KPI Targets

Current and prior periods

Date intelligence metrics

Current versus prior and growth rates

Rolling periods

Dimension metrics

Missing dimensions

Ranking metrics

Dynamic ranking measures

Security roles

Dynamic row-level security

Performance testing

DAX Studio

Tracing a Power BI dataset via DAX Studio


Module 5: Creating and Formatting Power BI Reports

Report planning

Power BI report architecture

Live connections to Power BI datasets

Customizing Live connection reports

Switching source datasets

Visualization best practices

Visualization anti-patterns

Choosing the visual

Tables versus charts

Chart selection

Visual interactions

Edit interactions

What-if parameters


Slicer synchronization

Custom slicer parameters

Report filter scopes

Report filter conditions

Report and page filters

Page filter or slicer?

Relative date filtering

Visual-level filtering

Top N visual-level filters

Visualization formatting

Visual-level formatting

Line and column charts


Report page tooltips

Column and line chart conditional formatting

Column chart conditional formatting

Line chart conditional formatting

Table and matrix

Table and matrix conditional formatting

Values as rows

Scatter charts

Map visuals

Bubble map

Filled map

Mobile-optimized reports

Responsive visuals

Report design summary


Module 6: Applying Custom Visuals, Animation, and Analytics

Drillthrough report pages

Custom labels and the back button

Multi-column drillthrough


Selection pane and the Spotlight property

Custom report navigation

View mode

ArcGIS Map visual for Power BI

ArcGIS Maps Plus subscriptions

Waterfall chart breakdown

Analytics pane

Trend Line

Forecast line

Quick Insights

Explain the increase/decrease

Custom visuals

Adding a custom visual Power KPI visual

Chiclet Slicer

Impact Bubble Chart

Dot Plot by Maq Software

Animation and data storytelling

Play axis for scatter charts

Pulse Chart


Module  7: Designing Power BI Dashboards and Architectures

Dashboards versus reports

Dashboard design

Visual selection


Navigation pane

Full screen mode

Supporting tiles

Custom date filters

Multi-dashboard architectures

Single-dashboard architecture

Multiple-dashboard architecture

Organizational dashboard architecture

Multiple datasets

Dashboard tiles

Tile details and custom links

Images and text boxes

SQL Server Reporting Services

Excel workbooks

Live report pages

Mobile-optimized dashboards


Module 8: Managing Application Workspaces and Content

Application workspaces

Workspace roles and rights

Workspace admins

Workspace members

My Workspace

Staged deployments

Workspace datasets


Client application ID

Workspace and content IDs

PowerShell sample scripts

Dashboard data classifications

Version control

OneDrive for Business version history

Source control for M and DAX code

Metadata management

Field descriptions

Creating descriptions

View field descriptions

Metadata reporting

Query field descriptions

Standard metadata reports

Server and database parameters

Querying the DMVs from Power BI

Integrating and enhancing DMV data

Metadata report pages


Module 9: Managing the On-Premises Data Gateway 403

On-premises data gateway planning

Top gateway planning tasks

Determining whether a gateway is needed

Identifying where the gateway should be installed

Defining the gateway infrastructure and hardware requirements

On-premises data gateway versus personal mode

Gateway clusters

Gateway architectures

Gateway security

Gateway configuration

The gateway service account

TCP versus HTTPS mode

Managing gateway clusters

Gateway administrators

Gateway data sources and users

PowerShell support for gateway clusters

Troubleshooting and monitoring gateways

Restoring, migrating, and taking over a gateway

Gateway log files

Performance Monitor counters

Scheduled data refresh

DirectQuery datasets

Single sign-on to DirectQuery sources via Kerberos

Live connections to Analysis Services models

Azure Analysis Services refresh

Dashboard cache refresh


Module 10: Deploying the Power BI Report Server

Planning for the Power BI Report Server

Feature differences with the Power BI service

Parity with SQL Server Reporting Services

Data sources and connectivity options

Hardware and user licensing

Pro licenses for report authors

Alternative and hybrid deployment models

Report Server reference topology


Hardware and software requirements

Analysis Services Integrated

Retrieve the Report Server product key

Migrating from SQL Server Reporting Services


Service Account

Remote Report Server Database

Office Online Server for Excel Workbooks

Upgrade cycles

Report Server Desktop Application

Running desktop versions side by side

Report Server Web Portal

Scheduled data refresh

Data source authentication

Power BI mobile applications

Report server administration

Securing Power BI report content

Execution logs

Scale Power BI Report Server


Module 11: Creating Power BI Apps and Content Distribution

Content distribution methods

Power BI apps

Licensing apps

App deployment process

User permissions

Publishing apps

Installing apps

Apps on Power BI mobile

App updates

Dataset-to-workspace relationship

Self-Service BI workspace

Self-Service content distribution

Risks to Self-Service BI

Sharing dashboards and reports

Sharing scopes

Sharing versus Power BI apps

SharePoint Online embedding

Custom application embedding

Publish to web

Data alerts

Microsoft Flow integration

Email Subscriptions

Analyze in Excel

Power BI Publisher for Excel


Module 12: Administering Power BI for an Organization

Data governance for Power BI

Implementing data governance

Azure Active Directory

Azure AD B2B collaboration

Licensing external users

Conditional access policies

Power BI Admin Portal

Usage metrics

Users and Audit logs

Tenant settings

Embed Codes

Organizational Custom visuals

Usage metrics reports

Audit logs

Audit log monitoring solutions

Audit logs solution template

Power BI Premium capacities

Capacity allocation

Create, size, and monitor capacities

Change capacity size

Monitor premium capacities

App workspace assignment

Capacity admins


Module 13: Scaling with Premium and Analysis Services  

Power BI Premium

Power BI Premium capabilities

Corporate Power BI datasets

Limitation of Corporate BI datasets – Reusability

Premium capacity nodes

Frontend versus backend resources

Power BI Premium capacity allocation

Corporate and Self-Service BI capacity

Power BI Premium resource utilization

Data model optimizations

Report and visualization optimizations

Premium capacity estimations

Analysis Services

Analysis Services Models versus Power BI Desktop



Development and management tools

Azure Analysis Services versus SSAS

SSAS to Azure AS Migration

Provision Azure Analysis Services

Migration of Power BI Desktop to Analysis Services


Hi, How Can We Help You?
Welcome To
Portharcourt Data School

Physical & Virtual  Programmes are available !

Enroll Now!

Thank You
100% secure website.