Microsoft Power BI Reviews

We are using Microsoft BI to do analytics for tax and customs administration at the centralized level, in order to fight fiscal fraud and detect tax evasion

Microsoft BI has helped the creation of a powerful analytical tool able to detect inconsistencies in different customs and tax declarations/returns and thus allow the Tax Administration to have a full taxpayer view from the fiscal point of view. It finally leads to increasing the collected revenues by cross-checking data coming from different governmental sources.

Microsoft BI was choosen among different proposed solution due to the fact that there was a local knowledge by the staff. Its integration with other Microsoft products used by the administration was also taken into account as being easy. The "already seen" effect was ensuring the staff trust; precious when making a big organisational change : we have observed that staff was more confident to stick to something they have already seen in the past rather that a totally revolutionary approach. The self-service tool is much appreciated.

Not yet assessed. A final assessement will be realized once the system has achieved 1 year of operational results.

I have been using Microsoft BI for approximately six months

The solution is stable. we did not yet had any issue.

We have not scaled the solution much. However, we will extend next year the number of users we currently have to 300. At the moment we're only working with a restricted number of users. We will also extend the number of sources of data.

I have not needed to contact technical support.

The initial IT setup was easy, It took two months for the full deployment to complete. It was fairly quick. From the business point of view, of course, the deployment as envisaged with the different data sources and capabilities will take around 18 months.

We used an integrator for the implementation and they were great. They did a good job. We have approximately three people for the maintenance and support of the solution at the IT level and 20 people using it from Business point of view, with potential increase up to 150.

We expect a dramatic increase of collected revenues once the full solution is in place. The ROI should be at break even in less than two - three years of full exploiting the solution.

We have an enterprise agreement with Microsoft concerning the license which decreased the cost of the licenses for Microsoft BI. I have found it to be cheaper than other solutions. It is always difficult to compare the Total Cost of Ownership, mainly because most of the big companies do have a very blur licensing system. The most open one seems to be Tableau.

We have evaluated and completed a market analysis of Oracle and Tableau before choosing Microsoft BI. Oracle because already being used for the internal databases; Tableau because its facility of development and deployment.

My advice to those wanting to implement this solution is to have the use cases well prepared in advance. Additionally, it is important to know exactly what type of analytics, dashboards, and reports they want, we spend a lot of time with this. I rate Microsoft BI a nine out of ten

On-premises

The primary use case for Microsoft BI is reporting. It comes with the Microsoft 365 E5 license. Then you just need to secure and harden it. That took a bit of time, but you can open it up and let people use it after that. There is a desktop component that they can work on that's independent of the Microsoft license. In that case, they can create files that are like dashboards.

I like Microsoft BI's drill-down feature and its overall ease of use.

I've been using Microsoft BI for about eight months.

Microsoft BI has been stable so far.

Microsoft's support is pretty good. 

Installing Microsoft BI was relatively straightforward. It just took a lot of tinkering with InfoSec to allow us to do stuff.

I rate Microsoft Power BI nine out of 10. If you plan to implement it, ensure that you harden it, so you do not leave it wide open. Otherwise, you're vulnerable to data leakage.

We are software developers. We generate data using the basic data connectors that Microsoft provides. We just follow the importing and exporting data around, the Azure platform.

We are doing C# development. We use an SQL server, and we use Power BI. Those are the main three technologies, and then it's just Microsoft to put it together.

We use this solution to create business intelligence reports for the executive users of our applications. We are creating standard business applications like ERP and CRM and e-commerce type applications. Then, we extract a sample of the data, build a simple data warehouse, in the Power BI service, and create some BI reports.

The data visualisation is very attractive from the user's point of view. Users see their reports and think "Wow - that is amazing". 

However, it is much harder to prepare data for reporting. I would say 95% of your development time is spent gathering, cleaning, and modelling data. However once that is done reporting is easy.

The capacity needs improvement. It is limited in its capacity in power.

Some of its features are incredibly difficult to understand. There is a learning curve to do the more sophisticated things. For example, paginated reports are complicated. But in general, Power BI, it's not an end-user tool, however much Microsoft pretended it is. We just treat it is like another tool that we use and we deliver the reports to our clients.

The orchestration module for refreshing data flows is something that is missing and we have to do it manually. It should be one of the admin features of Microsoft BI.

I have been working with Microsoft BI for 15 months.

We are using the latest version.

It is a reliable solution. 

I haven't tried to scale it, but in theory, I know that is capable. Power BI Premium is easy to scale as long as you have the money.

Inside the business, we only have one user, and outside the business, we have our clients where we have four developers who use this solution.

Our clients are medium-sized companies with 50 to 100 users.

I have not contacted technical support. Google provides the information that we need.

The initial setup is straightforward.

It can take a couple of hours to deploy the gateways, then there is the development of it.

It doesn't require maintenance, but we are forever enhancing the reports. In general, it works without problems.

We are developers, we can complete the installation ourselves.

We view it as an expensive product. 

Most of our clients cannot afford the premium capacity. 

We just make do with Power BI pro features, which is always a big shame because we know that the premium version has a lot of features that we would like to use, and are not available to us.

There are a few different licensing models.

It ends up being complicated and people don't like paying for things. It's okay if you're working for a large corporation because they can obviously spend thousands of pounds every month on licenses, but our customers cannot.

Licensing is paid on a monthly basis.

Power BI has approximately 20 new features that come out every month. You just have to be patient and eventually, the features come out.

My advice to others would be to do your homework. It's one of those things where you have to get past the marketing. The marketing message is not helpful.

I would suggest that if you are going to use Power BI, you need to use developers who understand what it can do, what it can't do, and how it works. 

Then they will then guide you to say, this is the type of report you can expect. 

It took me a long time to realize what you can and cannot do with Power BI.

That's why I suggest doing your homework first. It's not as wonderful as Microsoft pretends it to be, but it's not bad, and I am not knocking it, but you have to cut out all the hype that comes with it.

I would rate Microsoft BI a nine out of ten.

On-premises

We use Microsoft BI typically to clean up data in Excel, as well as to create reports for my supervisor that will be analyzed and then used to draw conclusions.

It provides the common ground for data to be cleaned. We use this for everyone to work on cleaning up data in order to use it for visualizations, which has been helpful.

The transforming data before you start with the visualization comes in pretty handy.

It is quite easy to use and it helps me to achieve the projects that I've been assigned.

I have never had the inability to perform the tasks I've been assigned with the software. 

It's very useful because you can create helpful reports, which assist you to analyze data in a very organized way.

I feel the modeling page should be simplified. The links between different parts of your data, on the models' page, are a bit confusing. It was difficult for me to learn. 

I have been using Microsoft BI for three months.

We are using an older version specific to the organization.

Microsoft BI is a stable product.

Microsoft BI is quite scalable, especially with the number of coding languages that are available to use.

We have approximately 23 data scientists in our organization who are using this solution. We use it extensively.

We are mostly using Microsoft BI but we are trying to bring in Tableau and maximize the potential of both.

I have not contacted technical support.

I also have experience with Tableau.

When I arrived, this solution was already set up.

For others who want to start using Microsoft BI, I would say go through some tutorials on your own first and then try and practice with practice data sets that are available online. Also, feel free to play around with the different tools, and the different visualizations, because you can use them differently for different things.

I would rate Microsoft BI a nine out of ten.

On-premises

I mainly use it for sales analysis. We are in the telecom industry, so on a daily basis, we see a couple of trends in the number of activations of customers and registration, the performance of the dealer, and items like that.

Its integration with the Microsoft Office Suite is great. I can easily connect it to any of the Excel or any CSV files, and I can immediately create a dashboard. 

It's like the higher level of pivot tables. For the people who mainly use Excel, this is like an advanced version. This is much more flexible and I don't have to train people to use it, as it's very user-friendly compared to Qlik. Qlik needs some expertise and a layman cannot immediately go to Qlik and do stuff unless he understands it. When it comes to Power BI it's a five minutes tutorial, he can definitely understand what needs to be done.

The solution is stable and scalable. So far I don't have any issues, however, it depends on the amount of data we use. I'm just running it on my PC.

The initial setup is straightforward. 

The solution is free as it's bundled with Office 365.

Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik. 

They could also improve the mobile experience. If people are using this mobile app for BI, they need better performance there. The rendering of the objects, for example, if you create the dashboard on Power BI when someone sees that on the app, it comes in a different format. They can do some enhancements there to standardize it.

Once we expand it as a centralized repository, if I could find much more use cases, that would be ideal. However, now it's very limited in our organization.

We don't use the solution filly and don't yet have a license for it. That said, I've had the chance to work with it for more than a year now.

The solution is stable. There are no bugs or glitches and we don't have any trouble with it crashing or freezing. It's reliable and the performance is good. 

My understanding is that the solution is scalable. 

I can easily load a billion rows in less than two or three minutes and play around with it. However, I haven't tested on big data files or anything like that.

Right now, we don't have too many users. It's just three to four people as of now, as our primary BI tool is still Qlik Sense. It's only for ad hoc use cases we use Power BI, and just myself and a couple of team members, as well as the BI specialist, that access it.

I've never reached out to technical support in the past. If I run into issues, I tend to Google solutions to find answers to my questions. YouTube is also a good resource if you need information.

We currently use Qlik Sense as our BI product.

The initial setup is not complex or difficult. It's simple and straightforward. 

It took, 10 to 15 minutes, if I remember correctly, to set everything up. It's just a .exe file installing. It's not hard and it's pretty fast.

We did not need a consultant or an integrator to handle the implementation. I just played around a bit with it.

We don't have a license on Power BI, so we don't publish anything. It's mainly for some ad hoc use cases that we use Power BI format.

Power BI is free; it comes with Office 365.

I've currently looked at MicroStrategy and am in the process of comparing a few other products.

We are just a customer and an end-user.

We are using Power BI, however, not to the full scale. It's still unlicensed as of now, and I'm using desktop versions only.

I don't remember the version, as it comes with Office 365. I didn't give a thought to the version.

From my experience with the desktop version, I'd rate the solution at a nine out of ten.

From my experience, I'd recommend the solution to others. 

On-premises

It is used for data visualization and analytics. We have its latest version.

It has provided better and deeper analytics for our data. It has also been helpful for custom visualizations as per client requirements.

Reports, dashboards, and visualizations are most valuable.

It should have more report outputs. They should expand the report outputs.

Its documentation should also be better.

I have been using this solution for five years.

It is fairly stable.

It is scalable based on licensing. You would need premium and additional organizational licenses. Mostly everyone in the organization uses this feature. We have around 4,000 users of this solution in our organization, which includes a lot of project management people.

We don't have any plans to increase the usage in the future. We are currently content with its usage.

They exceed expectations and provide good quality support.

We had other solutions, but they were some form of ad hoc databases and spreadsheets. We switched to this solution for integrating various data sets from different data sources and for richer analytics.

It was straightforward. It took two weeks.

It was an in-house job. For its maintenance, we probably have a staff of about 20 people.

I would rate Microsoft BI a seven out of ten. It is a really well-developed product, but it has some room for improvement.

Hybrid Cloud

We have a few projects. We're using the solution primarily to develop a modern sitemap.

The product has a very defined, well-prescribed format to it. It's easy for everyone to use for the most part.

The training is pretty good. It's well-described so that users can navigate the solution easily and follow the correct steps to initiate tasks effectively.

The user interface is pretty good.

The technical support on offer is excellent.

We've found the scalability to be quite good.

The solution's initial setup isn't too complicated.

I need more time with the solution. Right now, I can't think of any features that are missing from the product.

The integration with other solutions could be improved for reporting aspects. There are some reporting features in Tableau that we need access to and it would be ideal if there was a function between the two for data integration and data manipulation, with the final representation of the report available on Tableau.

I've been using the solution for a year or more at this point. It hasn't been too long.

So far, the solution has been largely stable. However, I'm still exploring the solution and testing it against my requirements. The stability hasn't quite been proven fully just yet.

The solution is pretty scalable. It meets all of my client's requirements. I'm able to make changes and expand if I need to. It's pretty simple to scale it out as necessary.

We deal, for the most part, with medium-sized companies. We don't really deal with smaller organizations or bigger enterprises.

I'm extremely satisfied with technical support. It's been excellent so far. They are responsive and knowledgeable and I always get my questions answered in a timely manner. I have no complaints about their level of service.

I've also worked with Tableau and SAP products. We use them all currently.

The initial setup is not complex in any way. It's quite straightforward. It was installed quite easily onto our system. We didn't run into any issues in that sense.

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.

On-premises

We use this for data analysis and the creation of indicators. It is one of the most powerful tools for BI in my experience. It works very fast, is intuitive, and useful. You just drag and drop, as soon as you download it.

This solution works very well for updating indicator boards, and for quick visualizations in demos. You can present results in many ways to improve the presentation.

I have used it on a variety of applications where it is important to show analysis and present information in a graphical perspective, and also to modify and present information to developers and executives.

One of the features I really like is that there are a lot of different graphics that are very nicely presented. The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI.

When you start, right from the beginning it can help you. Once you upload the data you can start to play with the different options you have from the graphics available, and also from the different mathematical and logical conversions that it offers.

I also work with other data processors and the facilities that Power BI offer can help to better understand the traditional database tools such as SQL, or others.

Another advantage is that you don't have to have a lot of knowledge about databases. This is because you use Power BI knowing your goal and what you want to achieve with respect to the data that you are processing.

I would like to see the product offer more graphics to impact different audiences. Also, I would like more ease in connecting with the different database drives.

Less than one year.

This is different from other solutions in that Power BI offers ease of use. It is different from any SQL tool because you can use it right away.

If you are looking for free tools to process data in different ways for an easy to medium analysis then you have the free version available. However, if you want a complex analysis from multiple sources of data then you should look for the charge and support version.

In my opinion, both options are good.

I evaluated some other tools but I think they had very different objectives. Power BI looked more generic and has an easy and quick way to present the information in different forms.

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.