Microsoft Power BI Software


 

Microsoft Power BI is a web-based business analytics and data visualization platform that is suitable for businesses of all sizes. It monitors important organizational data and also from all apps used by organizations. Microsoft Power BI provides tools to quickly analyze, transform and visualize data, and also share reports.

Microsoft Power BI offers SQL Server Analysis Services through which users can quickly build reusable models using the overall data. The software enables users to integrate their apps, so as to deliver reports along with real-time dashboards.

Microsoft Power BI also provides self-service access to major third-party cloud sources such as GitHub, Zendesk, Marketo and Salesforce.

Microsoft Power BI is available both in free and paid (Pro) versions. The free version is not limited by any time period; however data of only 1GB per user can be analyzed. Otherwise, it costs $10 per user per month for 10GB storage.

 

Microsoft Power BI - Metrics dashboard
 
  • Microsoft Power BI - Metrics dashboard
    Metrics dashboard
  • Microsoft Power BI - Public preview
    Public preview
  • Microsoft Power BI - Retail analysis sample
    Retail analysis sample
  • Microsoft Power BI - Sales manager
    Sales manager
  • Microsoft Power BI - Share dashboard
    Share dashboard
  • Microsoft Power BI - Travel analysis
    Travel analysis
Supported Operating System(s):
Windows 7, Windows Vista, Windows XP, Mac OS, Web browser (OS agnostic), Windows 2000, Windows 8, Windows 10

25 Reviews of Microsoft Power BI

 

Start your review of Microsoft Power BI

Click to start
https://www.softwareadvice.com/bi/microsoft-power-bi-review/
Software Advice Reviews (18)
More Reviews (7)

Showing 1-18 of 18

Brian from Mercy Health
Specialty: Healthcare / Social Services
Number of employees: 10,000+ employees Employees number: 10,000+ employees

October 2017

October 2017

Building dashboards and predictive models to reduce hospital remissions

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

This tool, like so many other Microsoft developments, is a game changer in the analytics and reporting world. Power pivot is now native to Excel, and can basically turn a mid-level spreadsheet user into an analyst and DBA through DAX, M Query, and the ssas architecture that underlies it's capabilities. The addition of power BI increases that ability even more by integrating more data sources, providing a more user friendly interface (including NLP!!!), and dashboards that look as good as any other (one of excels major drawbacks), I'll be interested to see if the competition has a good answer.

Pros

I love the number of files it recognizes and the ability to integrate then into a single data model. Also, very convenient tool that offers a one stop service for database administrative, data analytics, and user friendly reporting.

Cons

No scheduled updating for olap or odbc linked reports. Despite operating on a Microsoft infrastructure that has the capability, this is a glaring imperfection.

 
 

Dong from Naviworld
Specialty: Consulting
Number of employees: 51-200 employees Employees number: 51-200 employees

October 2017

October 2017

ERP consultant

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Good

Pros

Power BI have good look in interface. It is very easy to build chart and easy to query data. It is easy to build dashboard.

Cons

The version in Desktop is different with cloud version. Complex to set up real time update data with SQL.

 
 

Michael from U Saw It Enterprises
Specialty: Software / Technology
Number of employees: 2-10 employees Employees number: 2-10 employees

October 2017

October 2017

Power BI power to spare

Ease-of-use

Functionality

Product Quality

Customer Support
N/A

The ability to leverage scheduled and near real-time data updates is quite powerful for pro users.

Pros

Being able to connect various data sources to Power BI visuals is beneficial and allows compelling reports and dashboards to be created.

Cons

The features that are available to free and pro customers seems to be an evolving, moving target that has proven frustrating for some end users.

 
 

Diego from Grupo Valor
Specialty: Consulting
Number of employees: 51-200 employees Employees number: 51-200 employees

October 2017

October 2017

Redefining the way we make reports

Ease-of-use

Functionality

Product Quality

Customer Support
N/A

It's an awesome tool,.

Pros

This tool helps you arrange, process and show data in a way you can use it for decision making.
The model built can be used for making custom reports depending on the user needs.
It can be easily shares via cloud feature.

Cons

Lacks some crucial features like filtering tables in data model and options for cuatomisating some graphs.
Needs some background in data analysis, managing data bases at first.

 
 

Pamela from Visiting Angels Cuernavaca
Specialty: Healthcare / Social Services
Number of employees: 11-50 employees Employees number: 11-50 employees

October 2017

October 2017

Easy to use (if you are used to Excel features like dynamic tables) very attractive to end users

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Great product! I hope it keeps being part of Microsoft Office and that more and more people use it so it improves even more.

Pros

You can easly connect the software to SQL databases and to Excel Spreadsheets. The graphics are great and is very portable between different platforms. Results are very easy to share and saves tons of time to developers.

Cons

Filters are a little bit confusing for end users. If they leave a filter ON, the results might cause confussion and is not that easy to find out why. Lack of security to know who is looking to the information. Different profiles for the same results so each person sees what he needs.

 
 

rajiv from Times Network
Specialty: Media & Communications
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

September 2017

September 2017

Power BI is one of the most user friendly BI software for adding visual representation and analytics to your existing reports

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Overall good software for beginners and can be explored to get the best efficiency from the software

Pros

below are a few pros
• Sharing dashboard in a group
a. Sharing can be done once you have the Pro version of Power BI. Dashboard can be shared with the respective department members or your own team members.
b. Since you have prepared the dashboard you will be the owner and you can decide whether you want to give the other members only viewing rights or editing rights as well.
c. With this feature reports will always be on the cloud server and can be viewed as and when required
d. Reports can be downloaded as and when required.
• Viewing dashboard in Mobile/ tab and preparing phone layout
a. Once a dashboard has been prepared and saved, the same can be accessed on Power BI App with the same login.
b. Since the screen is small compared to laptop, all the dashboard elements can be redesigned to suit the phone screen.
c. The other features remain the same and the dashboard is interactive on the phone as well however it cannot be edited on phone.
• Export dashboard to PowerPoint, PDF
a. This is one of the most important features of Power BI. Reports or dashboards prepared can be exported on PowerPoint or PDF with a click of a button.
b. Hence Management reports and department reports can be automated on Power BI and once you refresh the data, the report will be ready to share.
c. One problem is that few images which are not compatible with PowerPoint don’t show post downloading.
• Narratives for dashboard
a. This is one of the recent features offered by Power BI. With the help of narratives you can get the insight of the dashboard in a story form.
b. Narrative uses its intelligence to study the data and give output in pointers, paragraphs etc which can be customised.
• Importing visuals to suit your need
a. Apart from the general visualizations available in Power BI, there are additional visualizations released by Power BI from time to time. These visualizations enhance the visual appearance as well as the adds to further analytics in different ways.
b. Visualizations which have downloaded and used in the dashboard are Infographic designer, Narratives for Business Intelligence, KPI Column chart, and Timeline.
• Edit interactions in dashboard
a. It is important to understand the interactions and groupings in power BI since with the help of these you can control which graphs you want to automatically change by clicking on the other.
b. With the help of grouping you can define groups and sub group which can be viewed together as a group if required.
• KPI Column Chart
a. This is a recent custom visual developed by Power BI. With the help of this visual you can put the KPI target against the actual on a monthly basis.
b. Forecasted revenue/ cost can also be put in this visual which will be shown in different colour.
c. Individual monthly targets can also be put which can be interchanged by putting variance.
d. Data can also been viewed in a table form along with graphical.

Cons

• One of the important features of exporting report in PowerPoint does not allow custom visual to be exported. Hence if there are custom visuals in your report then the same will show error once exported.
• Arranging dashboard is a bit tedious and takes a lot of time
• To share reports, we need to publish to MS Cloud. We cannot share report from Power BI Desktop
• For sharing a report even members to who report needs to be shared have to get Power BI Pro. Since the department to whom report is shared is just to view giving them a Pro license might not be useful.

 
 

Le Huy from Tan Duc IT School JSC
Specialty: Education
Number of employees: 11-50 employees Employees number: 11-50 employees

September 2017

September 2017

using, sharing how to use Power BI

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Very useful

Pros

easy, free both online, desktop. only Pro version, 10usd/user/month is reasonable price.
connect to many data source from on premise and online

Cons

customization or developing. not much available. we are looking for customize and developing to change the layout

 
 

brad from legrand
Specialty: Other
Number of employees: 10,000+ employees Employees number: 10,000+ employees

September 2017

September 2017

Power BI

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

Very powerful visualization tools. The ease in creating different charts and graphs is very appealing. I also love the r script editor to build more complex charts or give yourself the ability to edit data before using it in a visualization.

Cons

Main issues we ran into were with connecting to data sources. Had a lot of trouble collecting data from our Microsoft access database and pulling into power bi. Customer support is also sub par.

 
 

Rinki from Inmarketsales
Specialty: Advertising
Number of employees: 11-50 employees Employees number: 11-50 employees

August 2017

August 2017

Excel lovers will hate it

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Its not as easy as its marketed.

Pros

Loading and connecting to any data source quickly and cloud based thing is a real relief.
Quick insights are great but not useful.

Cons

For the majority of the users of Excel, it can be initially difficult to relate to a tool without pivot table features.
Also as per my need, it doesn't connect to 2 of my digital marketing tools- dfp and eyereturn.
I am still thinking of why did I choose this not so userfriendly tool.

 
 

Tony from Gisborne District Council
Specialty: Government
Number of employees: 201-500 employees Employees number: 201-500 employees

July 2017

July 2017

Simple, powerful visualisation solution

Ease-of-use

Functionality

Product Quality

Customer Support
N/A
Pros

Free, easy to use. Great data connectors. Filters at visual, page and report level. Measures built on powerful DAX engine.

Cons

Need to pay a subscription for the Pro version to be able to effectively share dashboards. Limited (but growing) number of visualization types.

 
 

Dinesh Kumar from Lennox International Inc
Specialty: Banking & Financial Services
Number of employees: 2-10 employees Employees number: 2-10 employees

June 2017

June 2017

Power BI is really a Powerful BI tool

Ease-of-use

Functionality

Product Quality

Customer Support
N/A

I have been using this tool more than a year and I love it. I am huge fan of Power BI

Pros

Excellent Visuals
Variety of visual charts (import from 3rd party sites)
Powerbi.com service is a plus
R programming is a plus

Cons

Arranging dashboard is a bit tedious
Not very user friendly (it takes time to get the ease of working with this tool)

 
 

Jeff from Jeff Brown Lifescience
Specialty: Pharmaceuticals
Number of employees: 11-50 employees Employees number: 11-50 employees

June 2017

June 2017

BI Lite

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Pros

I like the tutorials which lead you through a logical progression and help jump start the learning curve.

Cons

Probably same complaint about all BI software: You need to know what you want for outputs in order to make effective dashboards.

 
 

Femi from Lawrencia Consulting
Specialty: Consulting
Number of employees: 2-10 employees Employees number: 2-10 employees

June 2017

June 2017

Number Crunching at it's best

Ease-of-use

Functionality

Product Quality

Customer Support

Pros

The ease of use of the software is particularly appealing as it is built on the usual Microsoft office interface. I particularly also like the fact the software is available in Desktop and online versions and there is synchronicity between the desktop and cloud versions. Conclusively, diversity of data sources allows for versatility.

Cons

People without private emails cannot publish and this frankly doesn't allow for easy training of other persons
Downloaded visualizations files cannot be imported in multiples and this reduces efficiency a little bit.

 
 

Kenan from Maa Althahab Fragrances
Specialty: Retail
Number of employees: 201-500 employees Employees number: 201-500 employees

May 2017

May 2017

Microsoft Power BI, Master of the Analytics World

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Analytics world is the future, and Power BI is the master of all that Glob...!

Pros

As my experience as MIS Specialist in one of the most famous Fragrances Company in the Middle East, we see that in any company there's the accounting department that provide all reports and analytics that's demanded by other departments, according to that those guys have to do all there outcomes reports manually, and this process will cost time, efforts, stuffs,... for that one of great benefit from MS Power BI, is that he save me money, save me time, save me my the cost of wages for the accountants, my stuff in the accounting department is just about 5 great guys. All the mater is just I have to design the report and working on the Data Warehousing a little bit, then I can get my report in the target template that provide me all what I want, and furthermore, all reports up-to-date 7/24.

Cons

We still need the integration with other services, like Vend POS, Shopify directly without any intermediate programs.

 
 

Jimmy from Distributed Solutions, Inc.
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

April 2017

April 2017

Miscrosoft Power BI for Federal Acquisition Spend Analysis

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.

Pros

Power BI simplifies the process of combining different types of data sources to create a single data model. There are also many built-in Extract, Transform, and Load (ETL) functions that help reduce the time required to prepare data. Creating reports and dashboards is as easy as drag and drop. The Power BI User Groups are strong and plentiful, so you can always read through blogs to get answers to questions that you may have. The Power BI Desktop application is used to perform ETL, create reports and is free. The reports are published to the Power BI cloud service for sharing, which is also free with limited capabilities. For more capabilities, such as security groups and scheduled data refreshing, there is a subscription fee. Microsoft will be releasing an on-premise solution for sharing Power BI content via an update to SQL Server 2016 hopefully within the next few months.

Cons

It's not always easy to speak directly with a MS Power BI expert, so that is a bummer. Also, you have to sign up to the Power BI service using an email address in order to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses which is a real bummer.

 
 

ANurag from EML
Specialty: Insurance
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

December 2016

December 2016

Intuitive and easy to use

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

This tool is one of the easiest BI tool to use. I started by connecting simple excel files and now I have connected it to SQL server data sets in direct query. It works really well. Customization level for each visual is really detailed. Constant monthly updates adds new features. Custom visual gallery is also very useful to use different non from the box visuals.

Pros

Ease of use. Regular feature updates. Custom visuals. Slicing and drill down features are really good.
Predictive line and dashboard insights is really cool feature.

Cons

To share reports, we need to publish to MS Cloud. We cannot publish direct query data set without installing a gateway in the server.

Advice to Others

If you want to dazzle your audience and at the same time show meaningful insights, this is the best tool.

 
 

Juan from Derevo
Specialty: Software / Technology
Number of employees: 51-200 employees Employees number: 51-200 employees

October 2016

October 2016

Super simple to use and start analyzing your data

Ease-of-use

Functionality

Product Quality

Customer Support
N/A

I wasn't expecting to like tool as much as I did, I was able to create really nice visualizations and reporting based on simple spreadsheets and flat files that I have in a simple and fast way.

Pros

Ease of use, if you are an Office's user you will love this tool, clean interface with the look and feel of other Microsoft products that allow you to create dashboards from scratch easily.

Cons

The transforms with large files can be frustrating, this feature is not as robust as other BI tools in the market so in case the project requires big data modeling I would suggest to use an external tool to facilitate the ETL process

Advice to Others

I encourage you to use it since is really easy to adopt, is free, the connectivity to data sources is fair and most important for small projects or quick presentations using as a base a Microsoft file (excel, access, etc) it's going to be a pleasant experience.

 
 

Alejandro from Derevo SA de CV
Specialty: Software / Technology
Number of employees: 11-50 employees Employees number: 11-50 employees

October 2016

October 2016

Power BI, great BI tool for Self Service, you can create nice looking good visualizations.

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Power Bi is one of the best BI tools in the market, is easy to connect to multiple data sources and you can display your data in one single glance.

Pros

Full integration with MS Office, is easy to use and users can create visualization in an intuitive way. Easy to connect to different Data Bases like Oracle, Microsoft, Salesforce, etc. Also is not easy customize the objects.

Cons

is really difficult create a Complex ETL process in Power Bi, and is kind of slow dealing with very large data sets.

Advice to Others

Give it a try, it's free and well worth the time. It is an affordable end-to-end solution for your BI requirements. It is very visual and easy end-users / analysts to analyze data and create their own reports.

 
 
 
Showing 1-7 of 7

Price from FPT

December 2016

December 2016

A Growing Tribe of Apps and Visualizations

Ease-of-use

Functionality

Product Quality

Customer Support

Value for Money

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support

For an easy self-service business intelligence (BI) tool that is mostly free, Microsoft Power BI continues to expand and gain new features almost monthly. What started as primarily an add-in for the Microsoft ecosystem has now developed into a more fully functional package that ranks at the top of the self-service BI space. For this reason and more, it wins one of our Editors' Choice awards in this self-service BI tool review roundup (the other award goes to competitor Tableau Desktop$999.00 at Tableau Software). There are more than 40 different data sources that can be accessed with Microsoft Power BI, including Hadoop and QuickBooks Online$39.95 at Intuit (through oAuth), Tableau Desktop, Google Analytics, and numerous enterprise data sources.
Microsoft is continually adding new connectors such as ones for MailChimp databases (so you can monitor data and trends about your mailing list campaigns, reports, and individual subscribers). Microsoft also gives you the ability to directly query Structured Query Language (SQL) databases on SQL Server and in the Microsoft Azure cloud as well as Spark-based data sources.

Source: Capterra
 

Doug from Binary Anvil
Number of employees: 11-50 employees Employees number: 11-50 employees

February 2017

February 2017

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp
 

Carlos from JF Hillebrand Global Beverage Logistics
Number of employees: 1,001-5,000 employees Employees number: 1,001-5,000 employees

January 2017

January 2017

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp
 

Tom from Vigilant.IT
Number of employees: 11-50 employees Employees number: 11-50 employees

October 2016

October 2016

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp
 

Rajesh from smartShift Technologies
Number of employees: 201-500 employees Employees number: 201-500 employees

August 2016

August 2016

Ease-of-use
Usability
Functionality
Functionality
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp
 

Zakaria from LVMH
Number of employees: 10,000+ employees Employees number: 10,000+ employees

August 2016

August 2016

Product Quality
Quality
Source: GetApp
 

Bjoern from Navinos
Number of employees: 11-50 employees Employees number: 11-50 employees

April 2016

April 2016

Ease-of-use
Usability
Product Quality
Quality
Value for Money
Value
Support
Support
Source: GetApp