What is Power BI

Welcome

Download & Installing Power BI Desktop

Quick Interface Tour

Mini Project Visualize Data

Mini Project Transform Data

Course Outline What will you learn in this course

How to lean best with this course

Mini Project Creating a Data Model

Creating our initial project file

Exploring the Query Editor

Connecting to our data source

Editing rows

Replacing values

Changing data types

Close & Apply

Connecting to a csv file

Connecting to a web page

Extracing characters

Creating conditional columns

Splitting & merging columns

Creating columns from examples

Merging Queries

Pivoting & Unpivoting

Appending Queries

Practise & Solution Population table

The FactDimensionModel

Organizing our queries in groups

Practise Load the dimension table

Entering data manually

Creating an index column

Workflow & more transformations

Module summary

Advanced Editor Best practises

Performance References vs Duplicating

Group by

Mathematical Operations

Run R Script

Performance Enable Disable Load & Report Refresh

Using Parameters to dynamically transform data

M formula language Basics

M formula language Functions

M formula language Values Lists & Tables

M formula language More functions & steps

Why a data model

Create & edit relationships

Onetomany & onetoone relationship

Cross filter direction

Activate & deactivate relationships

Module summary

Manytomany mn relationship

Our first visual

The format tab

Understanding tables

Conditional formatting

The Pie Chart

All about the filter visual

The filter pane for developers

Creating drill downs

Syncing slicers across pages

Creating drill throughs

Cross filtering & edit interactions

Understanding the matrix visual

The decomposition tree

The tree map visual

Editing pages

Buttons & Actions

Working with custom visuals

Bookmarks to customize your report

Analytics and Forecasts with line charts

Asking questions Q&A visual

Wrap up data visualization

Get data using R Script & R Script visual

Python in Power BI Plan of attack

Transforming data using Python

Setting up Python for Power BI

Violin plots pair plots & ridge plots using Python

Creating visualizations using Python

Performance & Troubleshooting

Machine learning BayesTextAnalyzer using Python

The project data

Intro

CALENDAR

Creating a complete date table with features

Automatically creating a date table in DAX

Measures vs Calculated Columns

Creating key measure table

Aggregation functions

SUMX Row based calculations

The different versions of COUNT

Changing the context with FILTER

ALL

CALCULATE The basics

ALLSELECTED

ALLEXCEPT

YeartoDate & MonthtoDate

Time Intelligence intro & DATEADD

TOTALYTD vs DATESYTD

DATESBETWEEN

Formatting & Commenting

Logical operators

Using Variables

Using quick measures in a smart way

Intro Best practises

Show empathy & indentify the requirements

Find the most suitable KPIs

Choose an effective visual

Make use of natural reading pattern

Tell a story using visual cues

Avoid chaos & group information

Wrap up storytelling with data

How to go on now

Power BI Pro vs Premium & Signing up

Exploring the interface

Discovering your workspace

Connecting Power BI Desktop & Cloud

Understanding datasets & reports

Working on reports

Updating reports from Power BI Desktop

Creating and working with workspaces

Get Quick Insights

Creating dashboards

Installing & using a data gateway

Power BI Mobile App

Sharing our results through Apps

Creating the layout for the Mobile App

Wrap up Power BI Cloud

Intro

Creating a RowLevel Security

RowLevel Security in the Cloud

RowLevel Security & Data Model

Dynamic ManytoMany RLS

Dynamic RowLevel Security

Hierarchical RowLevel Security

JSON & REST API

Connecting to a MySQL database in Power BI

Connecting to a SQL database PostgreSQL

Setting up a local MySQL database

Congratulations & next steps