Power BI Course Content

Introducing Power BI

 Introduction to Power BI – Need, Importance

 History – Power View, Power Query, Power Pivot

 Power BI Data Source Library and DW Files

 Power BI Cloud and Power BI Service

 Power BI Architecture – Overview

 Power BI Desktop – Installation, Usage

Introduction to Power BI Desktop

 Getting Data: Excel vs Power BI Desktop & Service

 Direct Query vs Import Data

 Introduction to Modeling

 Setup and Manage Relationships

 Cardinality and Cross Filtering

 Default Summarization & Sort by

 Creating Calculated Columns

 Creating Measures

Power BI Desktop

 Creating Visualizations

 Color Formatting

 Setting Sort Order

 Scatter & Bubble Charts & Play Axis

 Tooltips

 Slicers & Timeline Slicers

 Cross Filtering and Highlighting

 Visual, Page and Report Level Filters

 Drill Down/Up

 Hierarchies

 Reference/Constant Lines

 Tables, Matrices & Conditional Formatting

 KPI’s, Cards & Gauges

 Map Visualizations

 Custom Visuals

 Managing and Arranging

 Conditional Filters and Clearing. Testing Sets

Creating Customized Tables with Power BI Editor

 General Properties, Sizing, Dimensions, and Positions

 Alternate Text and Tiles. Header (Column, Row) Properties

 Grid Properties (Vertical, Horizontal) and Styles

DAX (Data Analysis Expressions) – FUNCTIONS

 Purpose of DAX, Syntax Rules

 Possible Operations and Usage

 DAX Data Types and Operators

 DAX Values and Usage Options

 DAX Functions – Scalar, Statistical

 Mathematical & Time Functions in DAX

 Aggregate & Logical Functions in DAX

 Conversion & Relational Functions in DAX

 Working with Columns and Measures in DAX

 Row Context and Filter Context

 Using DAX for Calculated Columns

BUILDING A DATA MODEL/Edit Query Properties

 Building Power BI Report Model

 Modeling Roles and Techniques

 Building columns for specific charts

 Using DAX for Slicing Operations in Power BI

 Slicing and Dicing Options with Columns, Measures

 IF..ELSEIF.. Conditions with DAX

 Loading individual tables, Default Values

 Implementing Measures, Hierarchies

 Creating Calculated Columns

 KPIs and Actions with Power BI

 Using Images and Videos with Power Reports

 Indexing Connections and Column Duplications

 Conditional Splits, Merge and Pivot/Un pivot

Publishing and Sharing

 Sharing Options Overview

 Publish from Power BI Desktop

 Publish to Web

 Share Dashboard with Power BI Service

 My Workspace vs Groups (Power BI Pro)

 Content Packs (Power BI Pro)

 Print or Save as PDF

 Row Level Security (Power BI Pro)

Export Data from a Visualization

 Publishing for Mobile Apps

 Export to PowerPoint

 Sharing Options Summary

What’s new in Power BI Report Server (Updates)

Power BI Service

 Consuming a service content pack

 Creating a content pack for your organization

 Consuming an organizational content pack

 Updating an organizational content pack

 Working with Pivot & Un Pivot columns

 Creating index and custom columns

 Group By functionality in Query Editor

 Applied Steps in Query Editor, M Language

 Managing Gateways & Content Packs

 Installing Personal, Enterprise Gateways

 Defining relationships between tables

 Creating a custom Data Set From Service

 Publishing a report to Power BI Services

SSAS Tabular Model Course Contents

Visual Studio basics

 Visual Studio windows

 Setting startup options

 Creating a project Connecting to SQL Server

 Creating and using connections

 Filtering rows and columns Creating a data model

 Hiding from client tools

 Renaming tables/columns

 How column storage works

Relationships

 Diagram view

 Creating relationships Excel pivot tables

 Analysing data in Excel

 Connecting from Excel

 Using Excel pivot tables

Other data sources

 Linking to Excel

 Pasting in data

Calculated columns

 Using IF and SWITCH

 BLANK arithmetic

 Linking tables using RELATED

Measures

 Creating measures

 SUMX, AVERAGEX, etc.

Hierarchies

 Creating a hierarchy

 Viewing hierarchies

KPIs

 The parts of a KPI

 Absolute and relative measures

 Creating and viewing KPIs

Perspectives

 Creating perspectives

 Using in Excel

Security

 How security works

 Creating roles

 Filtering rows by role