In general Microsoft, BI is used to build dashboards, and the analyzing of data as well as some econometrics.
MBA, MS Business Analytics at a consultancy with 1,001-5,000 employees
Good visualization, simple to use, and easy to install
Pros and Cons
- "The most valuable feature of Microsoft BI is its visualization and its ease of use."
- "I would like to see more visualization options."
What is our primary use case?
How has it helped my organization?
Primarily, it's all about visualization and dashboards. My organization is large, and I don't believe Power BI as a tool has changed or revamped the entire organization; rather, it assists us in creating dashboards. It made things easier.
What is most valuable?
The most valuable feature of Microsoft BI is its visualization and its ease of use.
What needs improvement?
I would like to see more visualization options. I have noticed that it's more driven by corporate data when you look at it. Because I work for the IMF, my data is slightly different, and the corporate solution does not always work.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
For how long have I used the solution?
I have been working with Microsoft BI for one year.
We are using the most recent version.
It can be deployed both on-premises and on the cloud.
What do I think about the stability of the solution?
Microsoft BI has been good. I don't believe I have any issues with the stability aspect of it yet.
What do I think about the scalability of the solution?
Scalability is good; for the time being, it serves the purpose of what we are trying to achieve. However, we haven't attempted to scale it very much.
There should be more than a hundred users in our organization. I'm only referring to the people who develop and implement changes, whereas people who use the dashboards and view them on the entire URL on that page represent the entire organization. There are about 100 or 200 people who actually work and develop things.
For the time being, we are only using it for dashboards because we have other tools for analytics and other things.
How are customer service and support?
I have not contacted technical support.
Which solution did I use previously and why did I switch?
We work in such a way that we can use any tool and accomplish whatever we want. That's the way it works. I wouldn't be able to say that every team uses Power BI for the same purpose, but we have Power BI available to us and can use it however we see fit. I know that it is primarily used for dashboards at this point.
How was the initial setup?
I installed my own personal version of it, and it appeared to be pretty straightforward.
We have a large IT team to update and maintain this solution.
What about the implementation team?
In most cases, the setups are completed by our vendors. We only receive the finished product.
What other advice do I have?
I would rate Microsoft BI a seven out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Director at Decision Science
Saves time in preprocessing stage, but it needs to be more user-friendly for non-technical users
Pros and Cons
- "I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
- "Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
What is our primary use case?
Since we are a consulting company, our cases vary from customer to customer and from department to department, but mainly we have found two "standard" cases: Business users connecting to a DWH, or trying to consolidate several Excel workbooks to create business dashboards.
In the DWH cases, it is simpler since most of the data transformations and modeling are done by IT, but in the 'spreadsheet world', it becomes more complicated.
Users try to move from a huge table filled with numbers and "color-coded" cells to data visualizations, sometimes not even knowing how to write a simple Excel expression.
How has it helped my organization?
The biggest improvement comes from a "do it once, refresh many" concept. The users used to perform a lot of massaging on the data itself prior to the analysis phase. Now, they build their reports and refresh the data, so they have a lot more time to perform analysis, which is the real added value to the business.
Unlike other tools (like Tableau), getting to this point took a lot of resources in training, but when the users got there, it is a real time saver for them, allowing them to focus more on analysis, not on data manipulation.
What is most valuable?
I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.
Data Modeling is very simple and powerful for an experienced user, but I think it needs some improvement for the non-technical people. Besides this, it allows us to save a lot of time in data "massaging" prior to the analysis phase.
Reports are quite easy to build, even when some programming concepts are needed. Some users struggle with DAX a lot!
What needs improvement?
I think Power BI needs to focus more on the end-user (i.e. the business user). Solving things in DAX is not a nice approach to a user that has no knowledge of IT nor wants to get it.
Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product.
I see a lot of materials on how to go about doing things in Power BI, but Microsoft can add a "learning path". It would instruct users where to start, then what to learn next, etc, to sort out their learning journey.
For how long have I used the solution?
I have been using Microsoft BI for ~four years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Microsoft Power BI
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
815,854 professionals have used our research since 2012.
Solution Architect
Provides great container data flow and status related paginated reports
Pros and Cons
- "Provides good data flow related to the container and control flow."
- "There are some connector-related issues in their MSBA solution."
What is our primary use case?
One of our primary use cases is to build an MSBA-based business intelligence solution for collection agents, so that they can receive daily information relating to bills in the form of ledgers. I've built several packages to import the data from where it has been dumped. I then created the data mask for data analysis to showcase all the outputs and conclusions. As a result, there is a clear breakdown of total collections, the different parameters, customer-based information, and other essential information. We are partners of Microsoft BI and I'm a solutions architect.
How has it helped my organization?
The solution has helped increase the client's total sales revenue for their collection agent. It's basically MSBA, plus an AIML kind of solution and it helps the client to increase the overall efficiency of their collection agents, increasing total revenue for the company.
What is most valuable?
The most valuable feature is the data flow related to the container and the control flow. Microsoft has recently introduced paginated reports in the status part. These are web-based and also mobile-based, depending upon the layout of the report. It can be easily printed in Word format as well as in layout format, regardless of size.
What needs improvement?
There are some connector-related issues in their MSBA solution and there are certain features that Microsoft should include in the MSBA solution. One is the connective level problem that we currently face from the different data sources. It provides about 80% connectivity to all the data sources, but there is the remaining 20%. They could provide some kind of additional functionality which would make it a great solution.
For how long have I used the solution?
I've been using this solution for about 18 months.
What do I think about the stability of the solution?
The solution is pretty stable in its current form, and we are working on the same platform to optimize and incorporate everything.
What do I think about the scalability of the solution?
This solution is fully configurable and totally scalable. We are currently expanding the solution to include the area collections managers, the territory collection managers, and the regional collection managers. There are currently close to 3,000 users who are field collection agents. There is a maintenance cost but it's pretty low because it's an on-premise solution, so there is no cost attached to the server-based maintenance. Our support team is responsible for maintenance.
The solution is currently used throughout the company although there are geographical restrictions. They plan to extend usage to a pan-country level. It will take some time to implement but we are at the end stages of deployment on the pan-country level. Once completed, we expect there will be around 15,000 users.
How are customer service and technical support?
We provide technical support as required by our clients. Urgent issues can be resolved within two or three hours.
Which solution did I use previously and why did I switch?
Microsoft BI is similar to Talent and Pentaho BI but Microsoft is more competitive and flexible over the other BI solutions. We can cover up or build our end-to-end solution from scratch and that includes reporting and we don't need to go to any kind of a visualization tool for that.
How was the initial setup?
The initial setup was complex because the data vault was not totally structured and we needed to create some kind of a data lake, dump the data, then analyze it and create the data mask. We require certain validations and checks before importing or exporting the data as well as the application of the cubes to SSRS before reporting services. Deployment time can be dependent on the server and we have designed the system to optimize the process. We have a deployment team which can include two to three developers. Deployment takes about 10 minutes. The client decides on the deployment plan because they have applications that hang on the production server and don't want deployment to hamper other applications.
What was our ROI?
Microsoft BI is provided as a BI solution to incorporate or implement all data in a single platform. It enables you to build a data mart for your company and analyze it on a single platform. Even data analysis techniques can be carried out on this platform, and output of data can be visualized from the SSRS reporting tool. In this solution, the ROI is quite high because collection has increased up to 25% in one month compared to the same month last year.
What's my experience with pricing, setup cost, and licensing?
We have used a client-based service in the pricing. As yet, there are no additional costs.
What other advice do I have?
For anyone interested in building a BI solution from scratch, it's important to be aware that the data is not taken at a single platform. I believe that Microsoft BI is the best platform for this because it gives the flexibility to store the data into an SQL Server from different sources, and the ability to first dump your data into those servers. The analysis and reporting is in the same platform. Power BI has a much greater range than SSRS. Microsoft BI is a tool that gives it to you on a single platform, and you can build an end-to-end BI solution. This is not possible in Power BI.
This solution gives me the total flexibility to use my skill set, in the technical forms and in the analysis form, in one go. I can do several things on a single platform regarding the data science, as well as the data analysis, pulling information, analyzing data, transforming data, creating data lakes, data warehouse, and data masks, all in a single platform.
I rate this solution a nine out of 10.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
MI Manager at a recruiting/HR firm with 1,001-5,000 employees
Extremely responsive and helpful support, easy report modeling, and supports connections with multiple data sources
Pros and Cons
- "It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
- "The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."
What is most valuable?
It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation.
Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution.
Their technical support is very good. They are extremely responsive, helpful, and hands-on.
What needs improvement?
The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick.
Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire.
For how long have I used the solution?
I have been using this solution for about two and a half years. We use Power BI Premium, and we have its latest version.
What do I think about the scalability of the solution?
It is scalable once you've got your ducks in a row. We live in a world of fast-paced data. The business I am working in is dealing with a lot of unstructured data, so it has to go through the data onboarding transformation piece. It is more scalable if it connects to a data warehouse, but connecting to an Excel spreadsheet or unstructured data requires enormous amounts of investment. I have seen some other tools that are more data wrangling tools, so you don't want to blur your line. You need to stick to what you're good at. Is it data visualization and modeling, or is it data transformation? They're trying to diversify and make the tool all-encompassing, but we're now having to use a different tool for data transformation or data wrangling. We then just connect it to a data warehouse, and it becomes a really slick and scalable tool.
How are customer service and technical support?
They are very good. They are extremely responsive and helpful. They arrange a call quite quickly, and they actually get on the call and help you and do troubleshooting with you. They are not sending you to the Q&A page. They are quite hands-on in terms of support. So, I am really happy with their support.
What other advice do I have?
I would advise others to just make sure that whatever you're going to deploy can be scaled out. You should get your data modeling in place first.
I would recommend this solution. They have so many releases every month, which is quite cool. They are keeping on top of it, and it is not like you have to wait six months for a release. I'm still trying to keep up with the releases of the last four or five months.
I would rate Power BI a nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Innovation & Project Portfolio Management Practice Director at FACTUM
I would rate support for this solution as excellent
Pros and Cons
- "Our setup is very straight forward and can be done in a matter of hours."
- "The upgrade process could be improved."
What is our primary use case?
We use Microsoft BI on our portfolio management platform. We use live dashboards, in the public cloud.
What is most valuable?
We only use it for export and import, but that suits our purpose, along with the dashboards.
What needs improvement?
The upgrade process could be improved. Sometimes we miss information if we haven't kept up with the versions. It should be easy to migrate, but it does not provide enough information about what may be lost if you upgrade, especially if something goes wrong with the upgrade. Any current developments should be included in the upgrade so that it is a seamless process.
For how long have I used the solution?
We have been using Microsoft BI for about 4 years. We use the latest version, and we have 4 users.
What do I think about the stability of the solution?
Very good. We don't have any issue regarding the stability of the solution.
What do I think about the scalability of the solution?
The scalability is good.
How are customer service and technical support?
You can find everything on their website. We rarely need to contact Microsoft directly, so I would rate Microsoft support for Microsoft BI as excellent.
How was the initial setup?
Our setup is very straight forward and can be done in a matter of hours.
What other advice do I have?
You have to know what you want to accomplish, meaning that you have to know why you are using the solution, what kind of information you want to show in that solution and the location of the data. I would rate this solution 9 out of 10.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Manager, BI & Analytics at Perceptive Analytics
User-friendly, offers a flexible measure creation capability, scalable to large datasets, and has good community support
Pros and Cons
- "Two valuable most features are the ability to create columns and create measures."
- "In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."
What is our primary use case?
I am currently a management consultant and, before my current employment, I was a management consultant as well. I also had a stint with an online retailer in India. My usage with Power BI has been in the area of practical day-to-day operations, web host operations, and equipment status monitoring.
What is most valuable?
Two valuable most features are the ability to create columns and create measures.
The create measures feature offers you a little bit more flexibility. You can define what kind of measure you need using a formula, and the way Power BI works is very similar to Excel. In fact, most of the functions that you use in Excel are present in Power BI as well. When you create measures or columns, you just write the formula as you would in Excel, which will allow you to visualize that data in the way that you want.
What needs improvement?
In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization. By comparison, if you look at some other visualization tools, such as Tableau, for instance, the range of designs, or the range of graphics that you can create with Tableau is far greater than what you can do with Power BI.
Of course, they do provide an option to download templates and use them, but every time, you have to go to the Power BI store, search for those templates, download them and then use them. I think it's a growing universe of visualizers that they have, so probably, they are also working on the same thing. I believe, in terms of the designs of the visualizations that the tool can create, there is some room for improvement.
One more aspect that needs improvement is the formatting of visualizations that we create. Formatting in this context is the colors or the font style or font sizes. The formatting options, I believe, could be made a bit more user-friendly than the way things are right now. It's a little hard to figure out where to go and how to change the formatting of a particular chart or graph. So, I think the formatting options could be made a little bit more user-friendly.
For how long have I used the solution?
I have been using Power BI for more than three years.
What do I think about the stability of the solution?
Microsoft BI is definitely stable.
What do I think about the scalability of the solution?
This product is scalable and in fact, I have worked on it with fairly large datasets. It also gives you the option of publishing onto a server. When the dashboard/report is published to the Power BI server, we get a link that can be shared with others in the organization. At the enterprise level, it is possible to give access to a list of users who will have a need to look at the report frequently. These users can just click on the link and view the report whenever they want to. It is also possible for them to use filters and interact with the report.
How are customer service and technical support?
I am fairly comfortable with the tool and to this point, I really haven't felt the need to reach out to Microsoft with regard to the specific features of the tool. In case I do need some help on a particular feature, what I usually do is Google what I am trying to find and I get some links to the Microsoft community, or something similar, which answers my question.
To that extent, it has been very convenient to find help in whatever we are required to do with the software. The simple things are taken care of automatically. In case there is some trouble with the visualizations, you can always find help or assistance on the Microsoft community pages.
Which solution did I use previously and why did I switch?
I have also worked with Tableau and I think that each of these tools has its advantages.
I believe the cost of the software plays a deciding factor in a company's decision to implement either of the two. While each product has its pros and cons, if you're looking for something that's more value for money, then I think Power BI is the better choice.
On the other hand, if you are willing to choose an expensive option that gives you a lot more flexibility, then I think that Tableau would be a better choice.
It ultimately depends on what you are going to use it for. If you're using it for a variety of visualizations that you want to create, Tableau will be a better choice. On the other hand, if people have budget constraints then Power BI will provide a good value for the money.
How was the initial setup?
The initial setup is straightforward. You just download the software from their website, install it, and sign in.
What's my experience with pricing, setup cost, and licensing?
This product offers good value for the money.
What other advice do I have?
In a nutshell, I recommend this product and I would suggest implementing it. It has a very good range of features that it offers. For organizations starting on their business intelligence journey, I believe Power BI is a very good tool to start with. It's very user-friendly and it provides a graphical user interface where users can just drag and drop their required fields into particular templates of visualizations. It means that you get the charts quickly. There's no complex learning curve involved. From that perspective, I would say that it's definitely worth a try.
My biggest complaint is that it's a bit limited right now, in terms of the choice of visualizations it offers.
I would rate this solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Identifies customer purchasing patterns and provides good visualization
Pros and Cons
- "It has provided customer purchase patterns and great visualization."
- "This solution needs integration with SAS and more deep analysis functionality."
What is our primary use case?
Our primary use for this solution is geospatial analysis.
How has it helped my organization?
This solution has provided an accurate analysis of our customers repurchasing the same plan for telecom Jio. It has provided customer purchase patterns and great visualization.
What is most valuable?
The most valuable features are the visualization and integration with Office365.
What needs improvement?
This solution needs integration with SAS and more deep analysis functionality.
For how long have I used the solution?
I have been using Microsoft BI for five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Database Expert & BI Developer at a outsourcing company with 10,001+ employees
We were able to improve the performance of our reporting system. Monitoring features and SSIS Connectors need improvement.
Pros and Cons
- "Provides a full platform (database, ETL, reporting, analysis, and so on)"
- "I have to write scripts to query data for analyzing performance."
- "Microsoft needs to provide more drivers to connect other data sources in a native way."
How has it helped my organization?
By building the multi-dimensional database with Analysis Services, we were able to improve the performance of our reporting system. Now, our end-users can see the data stories quickly through Excel, Power BI tools, etc.
What is most valuable?
It provides a full platform for our BI solution (database, ETL, reporting, analysis, and so on).
What needs improvement?
- Monitoring features: I need Microsoft to provide a set of tools to help me monitor Microsoft's products. For example, when I need to investigate the performance issues of SSIS packages, I do not have a tool, instead I have to write scripts to query data for analyzing performance.
- SSIS Connectors: Microsoft needs to provide more drivers to connect other data sources in a native way, which they are doing very well in Power BI, and that we can connect and process data from JSON, SOAP, SAP, Salesforce, and so on.
What do I think about the stability of the solution?
No.
What do I think about the scalability of the solution?
No.
How is customer service and technical support?
It is not excellent, but enough to resolve our issues.
How was the initial setup?
It is quite easy to setup.
Which other solutions did I evaluate?
There are a lot of factors which we analyze and consider before we choose any product. In case we need a solution that we can develop, deploy quickly, and adapt to our business changes, Microsoft is the best candidate.
What other advice do I have?
Microsoft offers us a full platform, which we use to develop and deploy our BI solution quickly and easily. It also provides both of these infrastructure for use: On-Premise and Azure Cloud. They are very flexible.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: November 2024
Popular Comparisons
Splunk Enterprise Security
Databricks
SQL Server
Amazon QuickSight
Teradata
IBM Cognos
Rapid7 InsightVM
SAP Analytics Cloud
Qlik Sense
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?