Power BI Overview for Smarter Business Intelligence
Power BI by Microsoft is a powerful business intelligence tool. It allows users to transform and analyse large amounts of data in a visual and interactive way.
It provides a range of capabilities for data modelling, data visualisation, and data analysis. Making it an essential tool for organizations to make data-driven decisions.
Power BI Overview
You can create visually stunning reports and share them with your organization across web and mobile platforms. With a 360-degree view of your business, everyone can customize their dashboards. Moreover, with governance and security features built-in, you can scale your data analytics across your entire enterprise with confidence.
Business Intelligence with Power BI by Microsoft
Easy to Get Started
Start Free
Download the free Power BI Desktop software
Connect your data from databases, CSV files, Spreadsheets and much much more
Work Together
With the Pro Licence you unlock the ability to publish your reports to the cloud and share with your colleagues
Where Ever You Are
With the free mobile app, you can see your data when ever and where you are
What are the components and architecture of Power BI?
Power BI is a business intelligence suite that brings together various technologies.
The Power BI architecture consists of these components
Data sources:
Places where the data is coming from.
Power Query Editor:
Tool used for data transformation.
Power BI Desktop:
Used for modelling and reporting.
Power BI Mobile:
Access your reports anywhere with Power BI Mobile for Android, iOS, and Windows.
Power Pivot:
For in-memory tabular data modelling.
Power View:
For viewing data visualizations.
Power Map:
For visualizing 3D geo-spatial data.
Power Q&A:
For natural language Q&A.
Overview of a typical Power BI Workflow
In simple terms, a Power BI user takes data from various data sources such as files, Azure source, online services, Direct Query or gateway sources. Then, they work with that data on a client development tool such as Power BI Desktop to develop reports.
To develop reports, the imported data is cleaned and transformed according to the user’s needs. Once the data is transformed and formatted, it is ready to use in making visualizations in a report.
A report is a collection of visualizations like graphs, charts, tables, filters, and slicers.
You can publish the reports created in Power BI desktop on two kinds of platforms; Power BI Service and Power BI Report Server.
Power BI Service is a cloud-based platform. And Power BI Report Server is an on-premise platform
Once the reports are published, you can create dashboards on these platforms by pinning visualizations from your published reports. As such a Power BI dashboard can combine tiles made up of sections from a range of reports into a single dashboard
Share your dashboards and reports and collaborate with other users from your organization or outside. Using delivery options like a web-browser, Power BI on iPad, tablets, laptops or phones
Power BI Terminology and Concepts
Here are some of the main concepts used in Power BI
Dashboard:
A single page that displays visualizations and KPIs. These can be used to combine different snippets of data from a range of reports into a single ‘executive’ view using tiles
Report:
A collection of visualizations like graphs, charts, tables, filters, and slicers. Reports are created using Power BI Desktop
Visualizations:
Graphical representations of data, in the form of charts, tables and more
Data Model:
A collection of tables, columns, and relationships. Connecting the separate data sets together
Data Transformation:
The process of cleaning and transforming data according to the user’s needs. To get the data ready for reporting
Data Source:
A place where data is stored, such as a database, file, or web service.
Data Refresh:
The process of updating data in a report or dashboard.
Data Gateway:
A data gateway acts as a bridge between on‑premises data sources and Power BI.
Quick Insights:
A feature that automatically generates insights based on the data.
Natural Language Query:
A feature that allows users to ask questions about their data in natural language.
Power BI Pricing and Licences
Power BI offers both free and paid license options.
The free version of Power BI is called Power BI Desktop and can be downloaded for free from the Microsoft website.
Paid versions of Power BI are Power BI Pro and Power BI Premium Per User (PPU).
Power BI Pro is a per-user license that costs $10 per user per month* and is ideal for small to medium-sized businesses.
Power BI Premium Per User (PPU) is also a per-user license that costs $20 per user per month* and is suitable for larger organizations that require more advanced features.
(* Prices correct as at January 2024 – See Microsoft Site for latest pricing)
Power BI Premium is a capacity-based license that is priced based on the number of users and the amount of data being processed. It is ideal for large organizations that require more advanced features and greater scalability.
If you’re comparing the Power BI Price options, it helps to understand how each licence type fits different business needs.
Summary
With Power BI, users can easily connect to various data sources, such as Excel spreadsheets, databases, and web services, to create data models that can be used to create interactive reports and dashboards. Users can also use Power Query, a data transformation and cleansing tool, to clean and reshape data before importing it into Power BI.
Once the data is imported into Power BI, users can create a wide variety of visualizations, such as charts, tables, and maps, to help them gain insights into their data. These visualizations can be customized with a range of formatting and styling options to help users create professional-looking reports and dashboards.
Expert support on hand whenever you need a little extra clarity or direction.
Easy to Get Started
Start Free
Connect your data from databases, CSV files, Spreadsheets and much much more
Work Together
With the Pro Licence you unlock the ability to publish your reports to the cloud and share with your colleagues
Where ever you are
With the free mobile app, you can see your data when ever and where you are
What are the components and architecture of Power BI?
Power BI is a business intelligence suite that brings together various technologies.
The Power BI architecture consists of these components
Data sources:
Places where the data is coming from.
Power Query Editor:
Tool used for data transformation.
Power BI Desktop:
Used for modelling and reporting.
Power BI Mobile:
For Android, iOS, Windows phones.
Power Pivot:
For in-memory tabular data modelling.
Power View:
For viewing data visualizations.
Power Map:
For visualizing 3D geo-spatial data.
Power Q&A:
For natural language Q&A.
Overview of a typical Power BI Workflow
In simple terms, a Power BI user takes data from various data sources such as files, Azure source, online services, Direct Query or gateway sources. Then, they work with that data on a client development tool such as Power BI Desktop to develop reports.
To develop reports, the imported data is cleaned and transformed according to the user’s needs. Once the data is transformed and formatted, it is ready to use in making visualizations in a report.
A report is a collection of visualizations like graphs, charts, tables, filters, and slicers.
You can publish the reports created in Power BI desktop on two kinds of platforms; Power BI Service and Power BI Report Server.
Power BI Service is a cloud-based platform. And Power BI Report Server is an on-premise platform
Once the reports are published, you can create dashboards on these platforms by pinning visualizations from your published reports. As such a Power BI dashboard can combine tiles made up of sections from a range of reports into a single dashboard
Share your dashboards and reports and collaborate with other users from your organization or outside. Using delivery options like a web-browser, Power BI on iPad, tablets, laptops or phones
Power BI Terminology and Concepts
Here are some of the main concepts used in Power BI
Dashboard:
A single page that displays visualizations and KPIs. These can be used to combine different snippets of data from a range of reports into a single ‘executive’ view using tiles
Report:
A collection of visualizations like graphs, charts, tables, filters, and slicers. Reports are created using Power BI Desktop
Visualizations:
Graphical representations of data, in the form of charts, tables and more
Data model:
A collection of tables, columns, and relationships. Connecting the separate data sets together
Data transformation:
The process of cleaning and transforming data according to the user’s needs. To get the data ready for reporting
Data source:
A place where data is stored, such as a database, file, or web service.
Data refresh:
The process of updating data in a report or dashboard.
Data gateway:
A bridge between on-premises data sources and Power BI.
Quick Insights:
A feature that automatically generates insights based on the data.
Natural Language Query:
A feature that allows users to ask questions about their data in natural language.
Power BI Pricing and Licenses
Power BI offers both free and paid license options.
The free version of Power BI is called Power BI Desktop and can be downloaded for free from the Microsoft website.
Paid versions of Power BI are Power BI Pro and Power BI Premium Per User (PPU).
Power BI Pro is a per-user license that costs $10 per user per month* and is ideal for small to medium-sized businesses.
Power BI Premium Per User (PPU) is also a per-user license that costs $20 per user per month* and is suitable for larger organizations that require more advanced features.
(* Prices correct as at January 2024 – See Microsoft Site for latest pricing)
Power BI Premium is a capacity-based license that is priced based on the number of users and the amount of data being processed. It is ideal for large organizations that require more advanced features and greater scalability.
Talk to us about potential savings on these lists prices
Summary
With Power BI, users can easily connect to various data sources, such as Excel spreadsheets, databases, and web services, to create data models that can be used to create interactive reports and dashboards. Users can also use Power Query, a data transformation and cleansing tool, to clean and reshape data before importing it into Power BI.
Read more here on How to use Power Query
Once the data is imported into Power BI, users can create a wide variety of visualizations, such as charts, tables, and maps, to help them gain insights into their data. These visualizations can be customized with a range of formatting and styling options to help users create professional-looking reports and dashboards.
Expert guidance, on hand to help you when you need that little bit of extra guidance
Frequently Asked Questions
What is Power BI and what does it do?
Power BI is a business analytics service by Microsoft. It connects to hundreds of data sources—like Excel, SQL databases, and cloud services—to simplify data preparation and drive ad-hoc analysis. It produces beautiful, interactive reports that can be published for your organization to consume on the web and across mobile devices.
Is Power BI free to use?
There are three main ways to license Power BI:
Power BI Desktop: Entirely free for individual use. You can connect to data and build reports on your local machine.
Power BI Pro: Costs roughly £8.20 ($10) per user/month. This is required to share and collaborate on reports with others in the cloud.
Power BI Premium: Designed for larger enterprises, offering higher data limits and advanced features, either per user or per capacity.
What is the difference between Power BI Desktop and the Service?
Power BI Desktop: An application you download to your PC. It is used for the "heavy lifting"—connecting to data, modeling it, and designing the reports.
Power BI Service: A cloud-based platform (SaaS) where you publish those reports to share them with colleagues, set up automated refreshes, and create high-level dashboards.
How does Power BI help create a "Single Source of Truth"?
By connecting disparate data sources—such as Excel, SQL Server, Sage, or cloud APIs—into one unified data model, Power BI eliminates data silos. This ensures that every department is looking at the same numbers, reducing conflicting reports and manual data entry.
Can Power BI handle messy data from multiple systems?
Yes. Using the Power Query Editor, Power BI can clean, transform, and reshape "messy" data before it is used for reporting. At Select Distinct, we specialize in "Data Engineering," which involves automating this cleansing process so your reports are always accurate and up-to-date.