Syllabus of Power BI Training – Next Generation Dashboard – 15 Hours Training

Overview of Power BI Desktop

Power BI Mechanism

Power BI Desktop – Installation

Data Set Transforming

Reports and Visualization Controls

Getting started with Power BI Desktop

Connect to data sources in Power BI Desktop

Clean and transform your data with the Query Editor

More advanced data sources and transformation

Cleaning irregularly formatted data

Excel, Access, Text / CSV

XML, JSON, Web

SQL Server Database

Oracle Database

Power BI Data Sets

Power View, Power Query, Power Pivot

Power BI Template

Custom Visual from file & marketplace

Options – Global

Options – Current File

Data Source Current File

Global Permissions

Guided Learnings

Documentation

Training Videos

Support

About

Power BI Blog

Community

Power BI for Developers

Samples

Community Galleries

Submit an idea

Introduction to modelling your data

How to manage your data relationships

Create calculated columns

Optimizing data models

Create calculated measures

Create calculated tables

Explore your time-based data

Introduction to visuals in Power BI

Create and customize simple visualizations

Combination charts

Slicers & Filters

Map visualizations

Matrixes and tables

Scatter charts

Waterfall and funnel charts

Gauges and single-number cards

Modify colours in charts and visuals

Shapes, text boxes, and images

Page layout and formatting

Group interactions among visualization

Duplicate a report page

Show categories with no data

Summarization and category options

Z-order

Visual hierarchies and drill-down

Introduction to the Power BI service

Quick insights in Power BI

Create and configure a dashboard

Ask questions of your data with natural language

Create custom Q&A suggestions

Share dashboards with your organization

Display visuals and tiles full-screen

Edit tile details and add widgets

Get more space on your dashboard

Install and configure a personal gateway

Introduction to using Excel data in Power BI

Upload Excel data to Power BI

Import Power View and Power Pivot to Power BI

Connect OneDrive for Business to Power BI

Excel in Power BI – summary

DAX Introduction

DAX calculation types

DAX functions

Using variables in DAX expressions

Table relationships and DAX

DAX tables and filtering

Introduction to content packs, security, and groups

Publish Power BI Desktop reports

Print and export dashboards and reports

Manually republish and refresh your data

Introducing Power BI Mobile

Create groups in Power BI

Build content packs

Use content packs

Update content packs

Integrate OneDrive for Business with Power BI

Publish to web

Completion of Power BI Guided Learning