We just raised a $30M Series A: Read our story
2018-05-21T07:41:00Z

What advice do you have for others considering Microsoft BI?

6

If you were talking to someone whose organization is considering Microsoft BI, what would you say?

How would you rate it and why? Any other tips or advice?

ITCS user
Guest
6161 Answers

author avatar
Top 20Real User

I'd rate Microsoft BI as an eight out of 10. The biggest drawback is the user interface. From what I'm seeing, Windows 11 is going to have a more user-friendly interface. Even Microsoft Edge is adopting a more user-friendly interface. I'm hoping that Power BI follows this trend as well. My advice for anyone who is thinking about adopting Microsoft BI is to understand what you're trying to do with it. If you're trying to do analytics with it, then it depends on the kind of analytics. If you're want to do statistical analytics, it's not the tool for you. It's a tool that's better suited for visual analytics than it is for straight-up analytics. If you're dealing with patterns and data, it's great. If you're working with numbers and data, it's not so good. You're better off with a statistical package.

2021-09-24T23:07:00Z
author avatar
Top 20Real User

Because of performance issues and because we're unable to do all the aggregation, I rate this solution six out of 10.

2021-09-02T20:30:56Z
author avatar
Top 5Reseller

I would advise others to just do their research and figure out what they want to do with it so that they know if it is going to be hard or easy. I would rate Microsoft BI an eight out of 10.

2021-08-19T20:40:21Z
author avatar
Top 5LeaderboardReal User

While PowerBI is cloud-based, it can be used both on-and-off-premises. MSBI can also be implemented on-premises. PowerBI mostly involves visualization. I rate Microsoft BI as an eight out of ten.

2021-08-12T19:21:43Z
author avatar
Top 5Real User

I would recommend this solution to others. I rate Microsoft BI a seven out of ten.

2021-07-21T14:20:44Z
author avatar
Top 5LeaderboardReal User

I would recommend the cloud version of this solution. I would rate Microsoft BI an eight out of ten.

2021-06-29T15:28:41Z
author avatar
Top 10Real User

On a scale from one to ten, I would give Microsoft BI a six.

2021-06-09T21:21:29Z
author avatar
Top 20Real User

I would recommend this solution to those that have smaller businesses where they have lower user numbers and not a lot of data points. If they have a larger business I would choose an alternative, such as Qlik. I rate Microsoft BI a seven out of ten.

2021-06-05T17:34:11Z
author avatar
Top 5LeaderboardReal User

It can also be deployed on-premises. If you have it on-premises, make sure that you meet all the prerequisites and have all permissions. You should sort these things out before deploying Power BI. I faced some issues because I missed one of the prerequisites, and it took me one month to get it resolved. That's why I recommend completing all prerequisites. I would rate Microsoft Power BI a seven out of ten.

2021-05-19T22:14:12Z
author avatar
Top 10Real User

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.

2021-05-12T12:29:06Z
author avatar
Top 10MSP

We are consultants and implementers so we usually resell software. We do the end-to-end automation for customers as well. In the case of Microsoft BI, our clients are the ones that buy the license and use it. We don't necessarily use it directly. We're always working off the latest version, as the solution is constantly updated online. I would recommend the solution to other companies and users. I'd rate the solution at a nine out of ten.

2021-04-21T20:19:55Z
author avatar
Top 20Real User

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.

2021-03-30T14:50:02Z
author avatar
Top 5Real User

I would recommend this solution. It has many features that are good. It mostly needs improved licensing. I would rate Power BI a nine out of ten.

2021-03-26T17:03:07Z
author avatar
Top 20Real User

I would recommend this solution. It is pretty good. Technically, it is at the same level as the other products that I've used so far. It has all the features, and it is easy to deploy. Its costs are really palatable. They are improving it all the time. I am fairly satisfied with this product. I would rate Microsoft BI a seven out of ten. There are always areas for improvement, but I am fairly happy with it. I would not rate anything else also higher than seven.

2021-03-26T13:39:50Z
author avatar
Top 20Real User

I would rate Power BI an eight out of ten.

2021-03-25T18:07:44Z
author avatar
Top 10Real User

From a user's perspective, I'd advise people to really try to understand the data sources and have a good data environment in place, beforehand. That makes the Power BI environment much better. Overall, on a scale from one to ten, I would give this solution a rating of nine. I think it's the best BI tool that I've used. I know it has a really good rating. It accomplishes a lot for us in terms of data manipulation and BI in the reporting.

2021-03-11T08:57:48Z
author avatar
Top 20Real User

I am not going to be using the solution in the future because I prefer Qlik Sense. I rate Microsoft BI an eight out of ten.

2021-03-03T16:15:36Z
author avatar
Top 20Real User

We are customers and end-users. We don't have a specific business relationship with Microsoft. I would rate the solution eight out of ten overall. We've been pretty satisfied with the product.

2021-03-02T22:16:49Z
author avatar
Top 20Consultant

I rate this solution an eight out of 10.

2021-02-27T08:22:58Z
author avatar
Top 5LeaderboardReal User

You need a technical team to operate the solution. You need people for the administration of the data connection and data integration. They should be skilled in SQL, data management, and so forth. Typically, these are data engineers. We plan to continue using Microsoft BI. We are onboarding and implementing organization-wide for our long-term strategy, and the entire organization will be using Power BI. My advice for anybody who is considering this product is that it is easy to learn, especially for somebody who is good at Excel. Other tools are easy to use as well but if you are a Windows user then Power BI is a good option. I would rate this solution an eight out of ten.

2021-02-25T14:57:28Z
author avatar
Top 20Real User

I rate this solution a nine out of 10.

2021-02-23T21:06:10Z
author avatar
Top 20Real User

We are just customers and end-users. We don't have a business relationship with Microsoft. We are using the most recent version of the solution at this time. We're still exploring the solution and haven't fully implemented it yet. I would rate the solution at an eight out of ten. It's very user-friendly and so far I have had a good experience.

2021-02-16T19:37:03Z
author avatar
Top 5LeaderboardReal User

I prefer this product and I suggest Power BI to all customers, however, we know that if Power BI is a new idea, we make sure to show company-specific data or analytics for analyzing the data and how this solution can analyze everything quickly. That said, it's not for everybody. If all companies tried to put all their reporting expectations in the Power BI, it would not fit their expectations. It's not a standalone solution. You need other items in your toolbelt. You need, for example, something that can handle raw data, you need warehousing, et cetera. In general, I would rate the solution eight out of ten.

2021-02-12T11:50:52Z
author avatar
Real User

We have a pretty strong partnership with Microsoft and we tend to help them develop their product as well. We are using the latest version of the solution at this time. I would advise other organizations that the product has a lot to offer and therefore it's worth the investment and the effort. I would rate the solution at a nine out of ten. Sometimes it could be quite at rendering data, however, overall, we've been happy with the results.

2021-02-08T17:07:47Z
author avatar
Top 10Real User

I would recommend this product to potential users. But if they have options, I would recommend one of the others. On a scale from one to ten, I would give Microsoft BI a six.

2021-02-04T16:14:43Z
author avatar
Top 5Real User

In summary, this is a good product and I recommend it. I would rate this solution a nine out of ten.

2021-02-03T10:48:30Z
author avatar
Top 5Consultant

My first advice is to learn SQL. The foundational knowledge and SQL skills are the most important. You have to be very strong in writing SQL code. You have to improve your mind so that you know what you are writing in Power BI. After that, it is very easy to pick up any front-end reporting tool, such as Power BI or Tableau. After you have good expertise in Power BI, you can slowly learn Python so that you can do good integration. All these efforts would be great for your career. Being a gold partner of Microsoft for the past few years, we work directly with Microsoft product teams. Sometimes as part of a pre-launch, they also connect with us. If we see a feature or functionality that a client requires, we at least put it across to them. How they prioritize it within their product team is up to them. They prioritize depending on the need of the market and demand from various clients, and they release features accordingly. Sometimes, we also work on a pre-release. They release new features and functionalities every month. They have also recently released data protection smart narratives. If you look at the Gartner report, they are leading. I see a lot of demand for this solution. I would rate Microsoft BI an eight out of ten.

2021-02-03T09:10:29Z
author avatar
Top 5Real User

I would rate Microsoft BI a seven out of ten.

2021-01-31T07:02:24Z
author avatar
Top 10Real User

My advice is that if you are looking for an aggregated level of data, using it for reporting, then it's better to use Power BI because everything will be in memory and it will be much faster. I would rate this solution a nine out of ten.

2021-01-30T05:46:10Z
author avatar
Top 20Real User

We qualify as a partner as we're a software distributor. We're using the most current version of the solution. Here is the biggest thing: when you look at any BI tool or if it's the first time you're implementing one, you can easily get over enticed by the flashy display or the common things. However, it's the ability to drill down to your true business processes that are going to make it or break it as being the right tool or accesses the right information. Somebody that gets a BI tool for the first time will open a dashboard and say, "Oh, that's important for me to see every day." However, the reality is, when using a dashboard view you're looking for a red flag or highlights. The power of the BI tool is allowing you to drill down to the data behind the dashboard, that's where the real testing comes in. Figuring out where to get the information from and how best to analyze it. That's my best BI tool advice. Anybody can make a dashboard look pretty. It has to be useful too. In general, I would rate the solution seven out of ten.

2021-01-29T05:58:34Z
author avatar
Top 10Real User

If your data source is a Microsoft-based data source, this is the best choice. If you have a data source that is not Microsoft-based and is on a non-Microsoft platform, such as MongoDB or Unix, you should see some solutions like MicroStrategy or Qlik. If you have a pure 100% Microsoft-based data source, Microsoft Power BI is the answer. You can do wonders with Microsoft Power BI. It is a very cool solution. I would rate Microsoft Power BI a nine out of ten.

2021-01-22T23:46:37Z
author avatar
Top 10Real User

I would advise those thinking about implementing the solution to compare different products to see what is on the market. They have to look at the pricing which is what we looked at initially, I think it quite affordable. Additionally, research the infrastructure that is required and the cost per user for the different BI solutions. Some of the solutions are cheap, such as Eclipse BIRT and Knowage, but it takes a lot of efforts to get your reports out with them. With this solution, it is more of a drag and drop scenario. You have a quicker delivery time as compared to the traditional or the older BI solutions. The biggest lesson I have learned with working with this solution has been in the area of data warehousing, you should develop something that is more like a star schema when building a BI solution, especially with this solution. It makes things much easier. We did not favour the star schema, we preferred the snowflake approach. However, data modelling is easier when you use the star schema. I rate Microsoft BI a seven out of ten.

2021-01-21T19:20:09Z
author avatar
Top 20MSP

I would definitely recommend Power BI from a visualization perspective. It's quick and easy to set up and scales up very well. If you've been using data on Excel sheets and converting them to graphs on PowerPoint, I think this is a tool that gives you almost a live visualization of what your operations are. We use it for our day-to-day IT operations. I'm sure it can also be used to visualize other data like how many clients, how clients build up weekly, and the various stages of transitioning client needs into services. These things can be very easily developed on our Microsoft BI dashboard. On a scale from one to ten, I would give Microsoft BI an eight.

2021-01-12T15:44:28Z
author avatar
Top 5LeaderboardReal User

It's very important to have a very good data scientist, without that it's very difficult. It's a key requirement. I'm only unhappy with the Windows software. I'm a Mac user for over 20 years, and, in comparison, Windows is bad. For us, SAP, Oracle, Salesforce, IBM are not affordable. They're interested in larger companies. In the last few years, Microsoft seems to be happier to go for the smaller companies too. I would rate this solution a nine out of 10.

2021-01-10T08:16:16Z
author avatar
Top 5Real User

If you are planning on implementing Microsoft BI, having experience with other Microsoft products will make using this solution easy and straightforward. I rate Microsoft BI a seven out of ten.

2021-01-07T08:05:01Z
author avatar
Top 10Real User

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.

2021-01-05T09:08:00Z
author avatar
Top 5MSP

I'm using the calculator version of the solution. We use both the cloud and on-premises deployment models. We are Microsoft partners. We're not just users. Overall, I would recommend the solution. We do have other plans to use other BI solutions, however, we haven't really focused on that just yet. So far, this product has met our needs pretty well. On a scale from one to ten, I'd rate the solution at a nine. We've largely been happy with the product and its offering.

2020-12-23T21:41:56Z
author avatar
Top 5LeaderboardReal User

May is the next time I'll be teaching the data analytics class, the graduate class, and I will be actively trying to promote Power BI for the team project. I would rate Microsoft Power BI an eight out of ten.

2020-12-13T06:21:00Z
author avatar
Top 5LeaderboardMSP

I primarily use Microsoft BI for integration, so it is difficult for me to say what needs to be improved. Overall, this is a good tool and I recommend it. I would rate this solution a seven out of ten.

2020-12-09T14:37:26Z
author avatar
Top 20Real User

The first piece of advice is to become very clear about licensing and the data governors. Always get the licenses and get them right. You must also be clear about who is going to control these accesses. The second piece of advice is to understand a lot about the low-level security to create profiles and data access features to allow the specific data to be seen only by a specific public. Currently, in my organization, the greatest challenge is getting proper licensing. We have a little bit of resistance from our IT department who would like us to use Tableau more. It is not Microsoft's problem. It has more to do with the vendor of choice of the company, and they say that we have to use Tableau, but I don't want to use Tableau. I would rate this solution a ten out of ten. It deserves this rating.

2020-12-08T00:15:42Z
author avatar
Top 20Real User

I would definitely recommend Power BI for those entities that are not complex. Unless and until there is a very high volume to be handled, I believe Microsoft Power BI is the best solution to go for, particularly when somebody buys a stack of Microsoft products, which includes Office, SharePoint, and so on. The whole Microsoft Office Suite is a brilliant product in its entirety, and there is good and easy integration with SharePoint, etc. This is a nice feature that other products don't have. There is a stack of IBM as well, but it is not as good as Microsoft. I would rate Microsoft BI an eight out of ten. I am pretty happy with this solution, and the two points are down because of the performance issue and probably the cost.

2020-11-27T11:58:15Z
author avatar
Top 5Real User

I would give Microsoft BI a 10 out of 10.

2020-11-23T18:06:00Z
author avatar
Top 5LeaderboardReal User

Every month Microsoft puts in another update. We are likely to use Microsoft BI in future projects. Microsoft BI does not fit every business case, so for that reason, I would give it an eight out of 10.

2020-11-22T15:44:00Z
author avatar
Top 20Real User

I would absolutely recommend this solution to other interested companies. Overall, on a scale from one to ten, I would give Microsoft BI a rating of eight.

2020-11-13T15:11:22Z
author avatar
Top 20Real User

We're just a customer. We don't have a business relationship with Microsoft. I'm not sure which version of the solution we are using. It may be the latest. On a scale from one to ten, I'd rate it at an eight. We've been pretty happy with it, even though it is quite new to us.

2020-11-11T16:18:56Z
author avatar
Top 10Consultant

My advice for anybody who is considering this tool is that if you want to move to a self-service BI, this is probably the best tool available right now. The self-service is pretty good in terms of os user acceptance, usage, and simplicity. It is something that everybody wants and Power BI does really well in that area. The biggest lesson that I have learned from using Power BI is that if the data is not according to what you want, that really isn't a problem. It has been a problem in the past, especially where the data is not in the form or the shape that you need, but with Power BI, that problem can be solved very easily. I would rate this solution an eight out of ten.

2020-11-09T16:54:26Z
author avatar
Top 10Real User

My advice for anybody interested in using Microsoft BI is to set up the desktop version. It's good to start off with, it's easy to learn, and they get the trial period for the BI service. Then, once they're done with the trial period, I think the licensing per month is quite affordable. In summary, this is a good solution. It is not perfect, although if they added audio, emojis, and more types of graphs, then it would be. I would rate this solution a nine out of ten.

2020-10-29T15:10:53Z
author avatar
Top 5LeaderboardReal User

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.

2020-10-29T10:20:47Z
author avatar
Top 20Real User

I would rate Microsoft BI a seven out of ten.

2020-10-27T22:43:04Z
author avatar
Top 20Real User

I would recommend this solution, especially for the companies that mostly use Microsoft products and ecosystem. I would rate Microsoft BI a seven out of ten.

2020-10-26T09:30:22Z
author avatar
Top 20Real User

Ensure that you use Sharepoint. If you are within the Microsoft system and want to have a similar experience to Microsoft Teams, then Microsoft Power BI is a very good solution for that. I would like to have the ability to run the scheduled refresh for R and Python on the server. Right now, it's not possible. I would rate it a seven out of ten.

2020-07-26T08:19:00Z
author avatar
Consultant

Microsoft Power BI is definitely a good product and Microsoft has a good integration of a good suite of products across the range. I think if you take UI parts recent release, for example, I'm not sure that does it with Power BI but it definitely integrates it across the Microsoft Office activities, so I think it's only a matter of time before a majority of the Microsoft Office products start integrating with UI parts. That would take analysis, reporting, and automation to the next level and we could free up time for the general reporter. I would rate this solution as seven out of ten because it's easy to use and there is a lot of support online. I think Microsoft Office itself has a lot of support being provided. In addition, I like its features and it's growing much faster than some of the other analytical tools out there, although it started off later.

2019-05-22T07:18:00Z
author avatar
Top 10Consultant

It is important to say that the information cannot be confidential or secret. This is because the platform processes all data from the Microsoft cloud and you have to be certain of the security issues that someone could face if a security breach happens. I very much recommend the free trial mode.

2019-05-06T15:17:00Z
author avatar
Real User

Because this solution is very easy, and very visual, you can have results in minutes.

2019-01-20T07:09:00Z
author avatar
Real User

It is a solution that is easy for developers to be hands-on, even if they do not have prior experience with it. It is quite easy to learn.

2018-09-25T09:23:00Z
author avatar
Real User

It depends on how you're going to use the reports, but when looking into this product or similar solutions, check the security side of things. If you don't want to share information with everyone, how does it deal with that? So far, it's one of the best reporting tools I've found. They are improving the product every month. I would rate it at eight out of 10. The two missing points are to see what comes out in the future.

2018-08-01T07:08:00Z
author avatar
Real User

Most important criteria when selecting a vendor: * Price * Ability to go on the Internet and locate support information. * Secure product * Easy interface to use.

2018-07-29T06:51:00Z
author avatar
Real User

I would recommend this solution to another user. We are not dealing the vendor. We are using it directly from Microsoft as part of Office 365.

2018-07-18T07:08:00Z
author avatar
Real User

I would recommend Power BI as the best working solution. Most important criteria when selecting a vendor: Usability of the solution.

2018-07-04T06:10:00Z
author avatar
Real User

I rate it a nine out of 10 because it's very cost-effective, so it's very accessible in that respect, and a lot of folks do use spreadsheets so it helps ease the transition from using just spreadsheets to a more mature reporting environment. My advice is, speak to your users because, at the end of the day, if they don't use it, you've failed, which was the case with other reporting tools.

2018-06-03T09:17:00Z
author avatar
Real User

Our most important criteria when selecting a vendor are cost, cost, and cost. I rate Microsoft BI at seven out of 10 and that's because I have not utilized it as much as I would have liked to. However, it is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow. Consider very carefully what your requirements are and plan your projects well. This is a wonderful tool but it will not get the work done for you.

2018-05-21T07:41:00Z
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,267 professionals have used our research since 2012.