Power BI is a business analytics service by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Getting Started With POWER BI
Download and Install Power BI Desktop
Power BI November 2021 updates
Power BI Get Data
- Connect Power BI to SQL Server
- Connect and Load Data from Excel file to Power BI
- Power BI Connectivity with AZURE BLOB Storage
- Load Data From Multiple Data Source
- Load JSON data files into Power BI
Difference between PBIX, PBIT and PBIDS file format in Power BI
Power BI Service
Workspace
Publish Report to Power BI Service
Introduction to Workspace in Power BI, Assign Roles and Permission
Monitor usage and performance in workspace
Power BI Data Gateway
Install and Configure on-premises data gateway (Standard Gateway)
Download and install On-premises data gateway (Personal mode)
Data Alert
Create and Manage Data Alerts in Power BI Service
Row-Level Security in Power BI
Implement Row-Level security in Power BI
Data Visualizations, Reports & Tricks
- Creating a Calculated Columns in Power BI
- Create Report ToolTip Pages in Power BI
- Edit interactions in Power BI
- Create a Groups in Power BI
- Page Navigation in Power BI
- Implementation of Dynamic Page Navigation in Power BI
- Personalize Visuals Preview in Power BI
- Creating a dynamic Title based on Slicer Selection
- Creating Dynamic Title Based on Slicer Selection – Advance Level
- Change matrix background color based on value
- Show or Hide visuals in Power BI
- Show/Hide Measures in Line chart visuals using slicer in Power BI
- Creating a calendar table
- Creating a relationship between tables when both table have duplicate values
- Visual Zoom Sliders Feature in Power BI
- Sort By Month Name in Power BI
- Creating a Data profiling Report
- Adding Sparklines to Matrix or table in Power BI
- Field parameter
- TOP N and Others in Power BI
- Display Last N months data based on month selected in slicer
Working with Parameters
- Implementing Parameters in Power BI
- Changing the Data Source dynamically using Parameters
- Creating a What-if parameter
- Create and invoke custom function
Power BI Report Performance Optimization
Using Report Performance Analyzer Tool
Power BI native & custom Visuals
Power BI DAX
Data Transformation using Power Query
Downloads
- Download Power BI Tools and Apps
- Sample Data for Practices – Global-SuperStore.CSV
Power BI Videos