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 !!! :)