Power BI for Professionals

INTRODUCTION OF POWER BI 

- What is Power BI? Basic Introduction 

- Various concepts of Power BI from very beginning step by step 

- Various Examples of Power BI repots 

- Excel Vs Power BI – Differences & Relationships 

- Power BI Licensing and what parts are FREE 

- Installation of Power BI 

- A practical full cycle project to understand how Power BI works

 

CONNECT & TRANSFORM THE RAW DATA 

- Data connection from different type of data sources 

- Importing data from excel, text, pdf, csv, SQL, Oracle, Access.. 

- Transforming from unstructured ugly data to clean data 

- Setting Query properties 

- Working with text tools, numeric values, and date/time 

- Grouping and aggregation 

- Unpivoting the pivotal data

- Merging & Appending queries 

- Data consolidating and importing from multiple data sets 

- Using M-Query 

- Using condition 

- Using custom calculations 

- Data source settings in Power Query 

- Preparing data by flash-filling intelligence

BUILDING A RELATIONAL DATA MODEL 

- Principals of database normalization 

- Concepts of data model 

- Data table Vs lookup table 

- Understanding primary key and foreign key 

- Creating and managing Relationships among tables 

- Relationships Vs merged tables 

- Understanding different types of relationships 

- How relationship works on visualization 

- Understanding filter flow of relationships 

- Importing Query to data model 

ADDING CALCULATION IN DATA MODEL 

- Understanding Data Analysis Expression (DAX) 

- Creating new calculated column in the data model 

- Creating new measure in the data model

- Examples of implicit and explicit measure 

- DAX functions for Date calculation 

- DAX functions for data formatting 

- Using RELATED function 

- Using IF() condition in the data model 

- Using various Aggregation function 

- Using CALCULATE function 

- Using SUMX function 

- Using ALL function 

- Using few other important DAX functions 

- V-arious methods of calculations 

- Understanding DAX operator

DESIGNING INTERACTIVE POWER BI REPORTS

-  Exploring the report view on Power BI window Adding object to the Power BI canvas 

- Drilling down the top-value to breakdown 

- Inserting basic charts and visuals 

- Using conditional formatting 

- Presenting target vs achievement 

- Stopping interaction the dependent visuals 

- Configuring the dependent visuals 

- Using bookmark report in Power BI 

- Importing new visuals 

- Explore Your Data Using Power BI Q&A (Natural Language) Filtering with slicers 

- Setting Row Level Security (RLS) 

- Inserting text cards 

- Data visualizing with treemap 

- Data visualizing with trendline 

PROJECT: Master dashboard project 

 

PUBLISHING THE POWER BI REPORT ON WEB About Power BI Web service 

- Comparing Power BI desktop Vs Power BI Service Power BI Pro Vs Premium 

- Publishing the Power BI report on web 

- Sharing and collaborating with others 

- Row Level Security (RLS) in the Cloud 

- Installing and Configuring a Data Gateway 

- Schedule Refresh the Power BI Report 

- Managing workspace in the Power BI web