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

19 Reviews of Microsoft Power BI

 

Start your review of Microsoft Power BI

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

Showing 1-13 of 12

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