power bi desktop

• Introduction

• What is PowerBI

• How to install

• Project Setup

• How to connect Files

• Query Editor and How it works

• What is Data Model & How to create your first Visual

• Understanding PowerBI Desktop workflow

• Understanding the interface Data Model & Query Editor

• Project Files & Recommended Settings

• Connect Source files to PBI-Desktop

• Data Transformation

• Appending Queries

• Data Formatting & Handling Errors

• Pivot & Unpivot Data

• Split data

• Create Groups & Clean Up Project

• Star Schema

• How to use it in Project

• Query Duplicates & References

• Creating Dimension Table

• Merging Queries

• Join Kind

• Creating Fact Table

• Introduction to Relationships

• Cardinality & Types

• Cross filter Direction & Active Properties

• What is M Language & DAX

• Difference between M & DAX

• Basics of DAX

• DAX & Data Types

• Operators & DAX Functions

• Calendar Function

• IF & Related

• FILTER

• COUNTROWS

• ALL & ALLEXCEPT

• TOPN

• ADDCOLUMN

• SUMMARIZE

• EARLIER

• CALCULATE & CALCULATABLE

• USERELATIONSHIP

• Basic visual Concepts

• Creating first visuals

• Tooltips interactions

• Drill modes & Hierarchical

• Data Color & Conditional formatting

• Formatting reports

• Slicer & Its use

• Summarization & Sorting

• Tree maps & Tables

• Filter Types

• Working with row cards

• Data Gateways and Schedule Refresh

• Row Level Security

• Row Level Security in Power BI Desktop

• Q&A Natural Language Processing option in Power BI

• Quick Insights