IQubz

Microsoft Business Intelligence

4.5 / 5 31 reviews


Average Ratings

31 Reviews
  • 4.5 / 5
    Overall
  • 4 / 5
    Ease of Use
  • 3.5 / 5
    Customer Service

Product Details

  • Starting Price
    $99.00/month/user
  • Deployment
    Cloud, SaaS, Web
  • Support
    Online
    Business Hours

Vendor Details

  • IQubz
  • www.iqubz.com
  • Founded 2007
  • United States

About Microsoft Business Intelligence

Get a 360-degree view of your financial, operational, and marketing functional areas with powerful business intelligence and reporting solutions based on Microsoft Platform: SQL Server Database Engine, SQL Server Integration Services, SQL Server Analysis Services (OLAP), SQL Server Reporting Services, PerformancePoint Server, Excel and Excel Services, Reporting and BI for Dynamics GP and Dynamics CRM.


Spotlight_media_placeholder

Microsoft Business Intelligence Features

  • Ad hoc Analysis
  • Ad hoc Query
  • Ad Hoc Reports
  • Benchmarking
  • Budgeting & Forecasting
  • Dashboard
  • Data Analysis
  • Data Visualization
  • Key Performance Indicators
  • OLAP
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Strategic Planning
  • Trend / Problem Indicators

Microsoft Business Intelligence Reviews Recently Reviewed!

Easy to pick up & fun to use

Nov 17, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Being able to visualize data and interact with it is a huge advantage of Power BI. As an accountant/analyst, I was concerned about the software being too technical for me, but within a day of using the software I was able to put together a very basic client profile dashboard, which impressed our executives.

Cons: The drill down features are great, but our company is on a fiscal year (not calendar year). The native drill down features do not support fiscal years, to my knowledge. This will be a challenge as we begin to use this tool more.

Excellent learning curve experience within a familiar paltform

Nov 09, 2017
4/5
Overall
3 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: Generally a good product that I am having my team self learn on and use in our management reports. Would like to see better connectivity to SQL within our secure corporate environment rather than having everything pushed to an Azure solution, which we are unlikely to get anytime soon. The pricing didn't seem to lend itself well to SME.

Pros: Power BI is free to learn on which is ideal for novice users and organisations that have limited experience with BI packages. The developmental nature of the package is also interesting as new features are added in response e to the user community feedback through the forums. The learning from community forums , on line tutorials and Youtube videos has been invaluable.

Cons: The limitations in the free version are frustrating as you can't share dashboards with colleagues unless they have Power BI. This means you can't show it off easily to others who may also start using it. Getting the IT department to implement this is a hard slog if you can't demonstrate the productivity gains to a wider audience. The CEO is not going to install Power BI, she just wants to see the output and then will endorse wider adoption.

Great Product! Highly Recommend

Nov 09, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: The ease of use is amazing, it is really easy to learn and is great for data analytics purposes Has beautiful data visualizations and makes great for any presentation to big time clients or executives You can integrate it with a lot of different technologies

Analytics Dashboard for everyone

Oct 25, 2017
4/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
3 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Pros: It's easy to use, better than biggest alternatives (I've tested Qlik and TableAu) and I've chosen Power BI

Cons: There need some expertise with other Microsoft Office products, and a little programming skills / SQL

Power BI on the way forward

Oct 25, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: I am now on my third BI Project in which I created the User interface with Power BI Reports and Dashboards. So far the clients were extremely happy with the way Power BI looks as well as how easy it is to learn. The most popular feature is the report interactivity - clicking in a chart is filtering the rest of the report accordingly which is really fun to make use of.

Pros: - Easy to use - Easy to learn - very intuitive - Allows powerful calculations - constantly new features and developments - great community, you can find an answer to almost any question - very interactive, it tempts to play around with the reports

Cons: - Some small bugs here and there, due to the ongoing development - At the moment On-premises version does not offer the same scope as the Cloud version. Cloud is more comprehensive.

Building dashboards and predictive models to reduce hospital remissions

Oct 12, 2017
4/5
Overall
3 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: 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.

ERP consultant

Oct 10, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: 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.

Power BI power to spare

Oct 10, 2017
5/5
Overall
4 / 5
Ease of Use
5 / 5
Features & Functionality
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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.

Redefining the way we make reports

Oct 10, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: 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.

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

Oct 03, 2017
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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.

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

Sep 22, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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.

using, sharing how to use Power BI

Sep 14, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
4 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: 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

Power BI

Sep 14, 2017
3/5
Overall
5 / 5
Ease of Use
3 / 5
Features & Functionality
1 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

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.

Excel lovers will hate it

Aug 08, 2017
2/5
Overall
2 / 5
Ease of Use
2 / 5
Features & Functionality
1 / 5
Customer Support
2 / 5
Value for Money
Likelihood to Recommend: 5.0/10 Not
Likely
Extremely
Likely

Comments: 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.

Simple, powerful visualisation solution

Jul 12, 2017
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

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.

Power BI is really a Powerful BI tool

Jun 15, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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)

BI Lite

Jun 09, 2017
4/5
Overall
3 / 5
Ease of Use
3 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

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.

Number Crunching at it's best

Jun 09, 2017
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
4 / 5
Customer Support
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

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.

Microsoft Power BI, Master of the Analytics World

May 08, 2017
5/5
Overall
1 / 5
Ease of Use
5 / 5
Features & Functionality
2 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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.

Miscrosoft Power BI for Federal Acquisition Spend Analysis

Apr 24, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: 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.

A Growing Tribe of Apps and Visualizations

Dec 14, 2016
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money

Comments: 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.

Intuitive and easy to use

Dec 02, 2016
5/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Comments: 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.

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

Super simple to use and start analyzing your data

Oct 20, 2016
4/5
Overall
5 / 5
Ease of Use
4 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: 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

Recommendations to other buyers: 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.

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

Oct 18, 2016
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
3 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: 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.

Recommendations to other buyers: 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.

Nov 04, 2017
5/5
Overall

Feb 23, 2017
4/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Jan 29, 2017
5/5
Overall
4 / 5
Ease of Use
4 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Oct 14, 2016
5/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
5 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Aug 30, 2016
4/5
Overall
5 / 5
Ease of Use
5 / 5
Features & Functionality
3 / 5
Customer Support
5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Aug 25, 2016
5/5
Overall

Apr 13, 2016
5/5
Overall
5 / 5
Ease of Use
3 / 5
Customer Support
5 / 5
Value for Money