Select Distinct Logo Clear Background

Power BI

Power BI Overview

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 on mobile, tablet and desktop, Power BI overview
Power BI by Microsoft

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

Work Together

Where ever you are

Download the free Power BI Desktop software

Connect your data from databases, CSV files, Spreadsheets and much much more





With the Pro Licence you unlock the ability to publish your reports to the cloud and share with your colleagues

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


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


A collection of visualizations like graphs, charts, tables, filters, and slicers. Reports are created using Power BI Desktop

Power Bi Report Example


Graphical representations of data, in the form of charts, tables and more

Power BI Visualisations

Data model:

A collection of tables, columns, and relationships. Connecting the separate data sets together

Power BI Data Model Example 

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 Natural Language Query Example

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.

Download Power BI Desktop

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


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.

Power BI Logo, black and white no background

Expert guidance, on hand to help you when you need that little bit of extra guidance