- Power BI Tutorial
- Power BI - Home
- Power BI - Introduction
- Power BI - Installation Steps
- Power BI - Architecture
- Power BI Desktop
- Power BI - Desktop
- Power BI - Desktop Window
- Power BI Service
- Power BI - Window Supported Browsers
- Power BI - Generating Reports
- Power BI Desktop Service
- Power BI - Desktop vs Service
- Power BI - Supported Data Sources
- Power BI - Comparison Tools
- Power Query Editor
- Power Query Editor - Introduction
- Power Query Editor - Data Discrepancy
- Power Query Editor - Merge Queries (Part 1)
- Power Query Editor - Merge Queries (Part 2)
- Power BI - Develop Star Schema
- Data Modeling Concepts
- Power BI - Data Modeling
- Power BI - Manage Relationships
- Power BI - Cardinality
- Power BI - Dashboard Options
- Power BI Report Visualizations
- Power BI - Visualization Options
- Power BI - Visualization Charts
- Power BI - Stacked Bar Chart
- Power BI - Stacked Column Chart
- Power BI - Clustered Chart
- Power BI - 100% Stacked Chart
- Power BI - Area Chart and Stacked Area Chart
- Power BI - Line and Stacked Column Chart
- Power BI - Line and Clustered Column Chart
- Power BI - Ribbon Chart
- Power BI - Table and Matrix Visuals
- Power BI Map Visualizations
- Power BI - Creating Map Visualizations
- Power BI - ArcGIS Map
- Power BI Miscellaneous
- Power BI - Waterfall Charts
- Funnel Charts and Radial Gauge Chart
- Power BI - Scatter Chart
- Power BI - Pie Chart and Donut Chart
- Power BI - Card and Slicer Visualization
- Power BI - KPI Visual
- Power BI - Smart Narrative Visual
- Power BI - Decomposition Tree
- Power BI - Paginated Report
- Power BI - Python Script & R Script
- Power BI - Multi-row Card
- Power BI - Power Apps & Power Automate
- Power BI - Excel Integration
- Power BI Dashboard
- Power BI - Sharing Dashboards
- Power BI Sales Production Dashboard
- Power BI - HR Analytics Dashboard
- Power BI - Customer Analytics Dashborad
- Power BI - DAX Basics
- Power BI - Administration Role
- Power BI - DAX Functions
- Power BI - DAX Text Functions
- Power BI - DAX Date Functions
- Power BI - DAX Logical Functions
- Power BI - DAX Counting Functions
- Power BI - Depreciation Functions
- Power BI - DAX Information Functions
- Power BI Useful Resources
- Power BI - Quick Guide
- Power BI - Useful Resources
- Power BI - Discussion
Power BI - Introduction
There are two main variations of Power BI −
- Power BI Desktop
- Power BI service based on SaaS
Power BI Desktop
Dynamic reports and data models may be made with Power BI Desktop. Power BI is available in both 32-bit and 64-bit versions. It is free to download and not reliant on Microsoft Office. It is enriched with extensive visuals, built-in DAX functions, and numerous libraries. To download the latest version, you can use the following link: https://powerbi.microsoft.com/en-us/downloads/
Power BI Desktop can handle multiple tasks, such as −
- ETL(Extract, Transform, and Load) processes are implemented.
- Fetch the data from numerous sources like Excel, Sharepoint, SQL Server, Azure, etc.
- Generating a Data Model.
- Examine the compiled data in a table or single report.
- Develop a visual with your data in the report and publish the report.
Power BI Service
Power BI Service (Software as a Service - SaaS) is used to develop and publish the reports executed on Microsoft Azure. It can be accessed at the website https://app.powerbi.com
Power BI can be used for multiple tasks such as −
- Developing interactive Dashboard
- Viewing and modifying reports
- Mutual collaboration and report distribution to others
- Creation of apps and their subscription from Power BI service
The Power BI mobile app is used to view the reports and dashboards.
Before You Start
Before you delve into this tutorial, learners should have a fundamental knowledge of the basic concepts covered in our Excel and MySQL tutorials.
This tutorial emphasizes heavily on using Excel, and SQL Server in a Power BI. Many case studies given in this tutorial will be useful for Power BI aspirants.
We suggest you check our Excel Tutorial for your reference.