Power BI
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 visualization, 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:
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.
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
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:
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.
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
