Introduction to POWER BI

Power BI is a Business Intelligence and Data Visualization tool which used to create an interactive dashboards and BI reports.

It retrieve data from multiple data sources and shape the data based on requirements, perform data analysis and report the results through different types of visualizations.

Power Bi Desktop is a downloadable app for free of cost and is used to create reports. Power BI Desktop is divided into three categories both conceptually and physically which enables how to interact with data and create reports.

Report view

Data view

Relationships view

Power BI components:

Power BI Desktop

Power BI Service

Power Apps

Power BI Gateway

Power BI Mobile Apps

Power BI API

Power BI Report Server

Concepts for Learning

Basics

What is Power BI and why?
Overview of BI concepts and Reporting Tools
How to install Power BI Desktop
Exploring workflow of the Power BI
Settings of the Power BI Desktop
Work spaces
Extracting/ Importing of data from various sources
Import vs Direct Query vs Live Connection
Power Query
Query Editor/Data Transformation
Relationships
M Language
Measures and Calculated Columns

Data Modelling

Creating table relationships
How to Manage Data Relationship
Cardinality and Cross filtering
Data Analysis Expressions (DAX)
Functions: Time Intelligence, Date and Time, Logical, Mathematical, Statistical, Aggregate and Text; Measures in DAX

Data Visualizations

Creating Visualisations
Conditional Formatting
Charts
Tooltips
Slicers
Filtering: Visual level, Page level and Report level
Drill down or up options
Hierarchies
KPI's
Maps
Grouping & Binning
Bookmarks
Buttons
Custom Visuals

Advanced Concepts

Parameters
Drill down or up options
Bookmarks
Security
Dynamic measures, filters, connections
AI enabled Q&A

Happy Learning !!! :)