BUSINESS INTELLIGENCE

Power BI is purchased in addition to Dynamics 365, Power BI adds highly accessible visualizations and powerful data controls to your Dynamics 365 apps.

Microsoft Power BI is the right choice if you want a simplified BI experience with dashboards, daily KPIs, and mobile access.

Power BI is also part of the Microsoft Power Platform.

What is Microsoft Power BI?

Microsoft Power BI is a suite that is a collection of business intelligence tools such as software services, apps and data connectors. It is a cloud-based platform used to consolidate data from varied sources into a single data set. These data sets are used for data visualization, evaluation, and analysis by making shareable reports, dashboards, and apps. Microsoft offers three types of Power BI platforms i.e. Power BI Desktop (a desktop application), Power BI Service (SaaS i.e., Software as a Service) and Power BI Mobile (for iOS and Android devices).

Power BI can be deployed both on-premise and on-cloud. It can also import data from local databases/data sources, cloud-based data sources, big data sources, simple Excel files, and other hybrid sources. Thus, Power BI, a leader amongst a lot of other BI tools proves to be an efficient and user-friendly tool for data analysis. It enables the users to consolidate data from multiple sources, make interactive dashboards, evaluate data, create informative reports and share it with other users.

Features of Power BI

Visualizations i.e. the visual representation of data plays a central role in Power BI. It offers a wide range of detailed and attractive visualizations. You can create reports and dashboards using as simple or as complex visualizations as you want to represent your data set with. There is also a library available for custom visualizations.

In Power BI you can create visualizations such as:

  • Stacked bar chart
  • Stacked column chart
  • Clustered bar chart
  • Clustered column chart
  • 100% stacked column/bar chart
  • Line chart
  • Area chart
  • Stacked area chart
  • Ribbon chart
  • Waterfall chart
  • Scatter chart
  • Pie chart
  • Donut chart
  • Treemap chart
  • Map
  • Filled map
  • Funnel chart
  • Gauge chart, etc

Dataset is a single set of data created as a result of taking data from multiple data sources. You can use the datasets to create visualizations of different kinds. A dataset can be made of data taken from a single source like an Excel workbook or from more than a data source.

You can filter the datasets and have smaller subsets containing only the important data and contextual relevance. Power BI provides the users with a wide range of in-built data connectors such as Excel, SQL database, Oracle, Azure, Facebook, Salesforce, MailChimp, etc. Users can easily connect to such data sources and create datasets by importing data from one or more sources.

A tile is a single block containing a visualization in a Power BI dashboard. Tiles segregate each informative visualization properly to provide a clearer view. These tiles can be adjusted and the size can also be changed. Also, they can be placed anywhere on the dashboard as per the users’ convenience.

Reports in Power BI are a combination of dashboards having a different kind of visualizations relevant to a particular business topic. A report shows a complete and structured presentation of data represented in different ways and revealing important insights from the data. Users can easily share reports created on Power BI with other users.

The DAX functions are the Data Analysis Expressions found in Power BI. These analysis functions are predefined codes to perform analytics specific functionalities on data. There are about 200 functions in the Power BI function library as of now. The creators keep on adding new ones.

Using this option, users can automatically launch Microsoft Office 365 apps.

Get Data feature lets Power BI users to select from a range of data sources. The data sources are anywhere in the spectrum from on-premise to cloud-based, unstructured to structured. New data sources are added every month.

Some of the latest available data sources are as follows:

  • Excel
  • Power BI datasets
  • Power BI dataflows
  • SQL Server
  • MySQL database
  • Analysis Services
  • Azure
  • Text/CSV
  • Oracle
  • PDF
  • Access
  • XML
  • JSON

Dashboards are a collection of visualizations offering meaningful information or insights into data. Typical dashboards in Power BI are composed of multiple visualizations as tiles. They are single pages from the reports. The dashboards are shareable as well as printable.

 

The navigation pane has options of datasets, dashboards, and reports. Users can conveniently work in Power BI and navigate between datasets, dashboard they are working on, and reports they are creating.

The Natural Language Q&A i.e. question and answer box is a unique feature of Power BI. Using the Q&A box, a user can ask questions in natural language to search for data and information available in Power BI system. The cognitive engines of Power BI will search for the data or visualization or a part of the report that is been searched for and return it to the user. The cognitive technology uses rephrasing, autofill, suggestions and other such techniques to fulfill the search requirements of users.

Help & feedback buttons are used for multiple setting options such as downloading, asking for support and assistance, giving feedback to the Power BI support team, etc.

Power BI offers content packs which contain dashboards, data models, datasets, embedded queries, etc. Users can directly use a collection of elements in content packs instead of looking for elements separately

Summary

Have a quick look at the features of Power BI that we discussed and some extra ones.

  • Customizable dashboards
  • Datasets
  • Reports
  • Navigation Pane
  • Q&A Question Box
  • Help & Feedback Buttons
  • Ad Hoc Reporting
  • Ad Hoc Analysis
  • Online Analytical Processing (OAP)
  • Trend Indicators
  • Interactive Reports Authoring
  • Complete Reporting & Data Visualization Tools