Microsoft Power BI Reviews

We use the tool for data analysis and reporting through dashboarding, identifying trends, and mapping.

The product is intuitive and user-friendly. It could be rolled out to anyone across the business. DAX is a good feature. The real-time dashboard updates are good. The ease of integration is good. We connect it to different databases. The clients we work with work on different databases. It is easy to manage and share Power BI reports across different teams and departments.

The solution struggles with large amounts of data. It has some limitations. Sometimes, we don't know if we have the full picture.

I have been using the solution for four years.

I rate the tool’s stability a ten out of ten. I haven't come across any issues.

I rate the tool’s scalability an eight out of ten.

The deployment is not difficult. It is relatively easy to maintain the product. For our needs, we need one person to maintain the tool.

I have used MicroStrategy. Power BI is more user-friendly. When we roll it across the business, it's easier for the users to use. MicroStrategy can handle large amounts of data.

Overall, I rate the product an eight out of ten.

Enterprise reporting and digitization of dashboards using Microsoft Power BI, SSRS and Azure Reporting DB by integrating several applications to establish single version of truth.

Microsoft BI stack is very easy to use and most of the developer versions are free such as Power BI, DAX, SQL Server Development Edition. This helped us quick prototyping to generate value of data resting in silos. 

What I like most is that I can do everything in Power BI that I can do in Excel. It is very compatible with Excel tools, and anybody who works with Excel can learn and use Power BI quickly. 

Writing formulas and data transformation are good features.

The only challenge I have found is that they do not have a Mac version of Power BI. They should have versions for both Apple and Unix because you cannot install the desktop version for these operating systems.

In the future, I would like to see them add more AI and machine learning features, as well as self-service analytics.

You can use R and Python, but it would be helpful if they had some no-code machine learning options that you find in other tools.

The UI/UX can be improved. Products such as Tableau and QlikView are very good in terms of the user interface.

I have been using Microsoft BI for five years, on and off.

I have not found any issues with respect to stability. Microsoft has invested a lot and they are continuing to invest in Power BI.

Given that there is a server version for services that can be used to implement and roll out reports at the organizational level, it's scalable.

In my current organization, I am training 15 people on how to use it and I am looking to expand to 50 users.

Microsoft support is quick. We also have a dedicated partner for support, and they are good.

Positive

Prior to incorporate Power BI in the stack, we were using Microsoft SQL Server Reporting Services(SSRS) only. They do not have any visualization interface, but you can do static reporting. This is the reason that we are switching. Probably, we will use SSRS and Azure SQL at the backend, but there won't be used as the visualization tool.

For visualization, we used to use Excel. Which not reliable. 

The installation is easy. The download takes perhaps five minutes, depending on the bandwidth. Overall, it can be downloaded and installed within half an hour and no training is required.

The desktop version is used for development and the cloud version is used to submit a report. Essentially, it is Power BI Desktop and Power BI Services. The desktop version is what is on-premises.

You can deploy yourself but of course, in an office, you require an administrator.

The cost of this product is very low, at approximately $8 or $9 per month for a developer. It is the cheapest of all of the visualization tools. They have a 30-day trial available for you to try it.

For personal use, this product is free to use.

Tableau is a little bit expensive, although it is good if they want a very sophisticated solution. Both Tableau and QlikView are a little better in terms of the user interface.

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.

Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point. 

We can send various project reports from the dashboard to management. It allows us to set up our own preferences. 

We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible. 

The solution has been very stable so far.

We find the product to be quite scalable. 

It's quite difficult to learn how to use Power BI. I'm not from the IT background, and I've been given the license to use the Power BI, however, I find that the support and video demos from Microsoft are not really helpful for me. I don't handle Microsoft BI 24/7. My working time isn't dedicated to using it and learning it. I need it for certain tasks and trying to wrap my head around it, while also handling other duties is difficult. There's too much of a learning curve for beginners.

The cost of the solution is high.

We originally started our migration back at the end of 2019. We've used it for a year or two now.

The product is stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

The solution can scale. If a company needs to expand it, it can do so. It's not a problem. 

Right now, in our organization, only 15 of us have the full license for the Power BI Pro. Not everyone in the office actually uses it. However, we have over 1,000 people using various other Microsoft products in our company.

As I am not technical, I did not handle the initial setup. We have IT personnel within our organization that handled it. I just gave them my laptop, and they just installed it for me. Occasionally, they can also do it remotely from their office to our office. I never touch it. We just open the apps from the desktop. The process, when do that way, i's quite convenient. It's quite easy for end-users.

We have our own IT team that handles the installation. They either take the laptop or do the installation remotely. In either case, it's handled in-house and not by integrators or consultants. 

The solution is quite expensive. 

I'm an end-user of the product, however, I'm not overly technical or in IT.

We have a custom Microsoft setup. We are using a few apps from Microsoft, such as the Microsoft Plan, and we are using Power BI, Power Automate, et cetera. It's all from Microsoft, and it is part of our IT infrastructure. When we combine it together, it is a project and portfolio management solution. It is not a commercial, off-the-shelf product. 

I'm not sure which version number we are using. 

I'd rate the solution at a nine out of ten.

In terms of Microsoft Power BI, for all people who need to do their own reporting or want to visualize their daily work or tasks, in terms of projection, giving others a view on what they are doing, it's a very good tool. It allows users to show projections of what we are doing. Users can grab statistics, which is quite convenient, and understand what they are doing from a visual perspective, which we find quite useful.

We're a retail hospitality chain spread throughout India, operating over 330 outlets across the country in various formats, ranging from a coffee chain to fast food restaurants through our in-house bespoke brands. All these brands run out of travel hubs like airports, railway stations, and highways stops. We needed a solution to manage both the multiple SKU levels and in terms of individual dynamics, the profitability of each store. We constantly track the various types of back-end raw materials, specifically on our prediction modeling where we use Power BI. We also use Power BI analytics to drive those results with regard to the day-to-day dashboarding, reporting in terms of collection, on sales trends per hour, manpower and the like. We are customers of Microsoft and I'm the CIO. 

I like that the interface is very fluid in the sense that you can upload via Excel or you can attach via connectors, any software you like.

The challenge of this product is in truncating the table data. It would be great if Microsoft would include a naming convention which has the advantage of enabling a VLOOKUP on top of it, so two tables can be merged more seamlessly. Currently, the time it takes to merge two tables in Power BI makes the entire analysis quite complex because it requires common numbering in one table and then creating another common indicator in another table in order to merge the two. It wastes precious time. 

Secondly, while they talk about visual analytics, sometimes the challenge is when you're looking for more in terms of geovisual analytics, such as city maps which requires a functionality whereby you can upload transactions. For example, if I want to visually present my data on an airport map, showing which stores are generating what revenue dependent on the traffic heat map, I am unable to do that because I cannot upload drawings. Ideally, I'd like to show each store as a bar map with waves explaining the sales in each location. It allows me to pinpoint which locations are more profitable. 

I'd like to see a degree of variability so I have the flexibility of putting those variable components in my predictive modeling, and I can get a feel for the trends. It requires a common input database. You can do it in Excel, but you can't do it in Power BI, which I find surprising.

We've been using this solution for nine months. 

The product is fairly stable, it doesn't get too many upgrades or updates from that perspective so it's fairly straightforward in terms of implementation and our entire ecosystem was on Microsoft which helped us. The only area that can be problematic is when you're trying to create relationships between two databases and you're trying to link it with your Power BI solution, sometimes that mapping takes considerable time.

The solution is scalable. We are a cluster of eight legal entities and we've been able to expand to all of them. We started with 20 outlets and today we have 350 outlets. We are more granular and today Power BI allows us to drill down to the last voucher. We have around 14 users from the finance and operations teams.

We haven't needed to call Microsoft, because we worked with one of their gold partners in India. So we are on an AMC model with them in terms of manpower. If there are any problems or upgrades we need, we reach out to the partner. 

The initial setup was straightforward for the simple reason that our entire ecosystem was on Microsoft and we use Azure Web Services in terms of hosting. We split the entire project into two parts to simplify things. The first part was more about the granular analysis of sales and various other elements, which took considerable time due to the many external stakeholders involved. Phase two was relatively simple, because it was department specific and we created a split team, which led to the creation of a better platform.

Licensing is on an annual basis. We have a complete Microsoft Ecosystem license. I think there is room for improvement with the licensing, specifically during the pandemic when it would have been reasonable to offer a discount. Many other companies, SAP and Oracle, for example, gave waivers to the MSME sector. Microsoft traditionally is used by smaller or medium-sized companies so I was expecting some sort of discount on the pricing, but unfortunately that didn't happen. We managed to avoid an escalation in cost, but frankly speaking, a discount would have been much appreciated.

It's important to understand your entire ecosystem in terms of your tables; the kinds of tables your back-end database has and the elements of analysis that you are looking at. If you are looking at predictive modeling, you need to have at least two to three years of data, because that allows you to define the trajectory of the predictive modeling. Otherwise, it doesn't serve any purpose. Secondly, be very specific with your implementation partner, as to how you'd like a particular visualization tool to look, otherwise you may not get what you want. Finally, it's important to invest in people and create a center of excellence made up of people who know Power BI well, or who will get trained and certified on it. You'll need an in-house team which can do the small tweaks and changes as you require, otherwise you'll get stuck each time you need to do something.

I rate this solution an eight out of 10. 

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.

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. 

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. 

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. 

I've been using this solution for about 18 months. 

The solution is pretty stable in its current form, and we are working on the same platform to optimize and incorporate everything. 

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. 

We provide technical support as required by our clients. Urgent issues can be resolved within two or three hours. 

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.

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. 

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.

We have used a client-based service in the pricing. As yet, there are no additional costs. 

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. 

There are multiple use cases. I can't count them even on my fingers. There are around 20 to 30 solutions we have been deploying. We use it across finance, procurement, HR, engineering, and whatnot. Each of the domains we have touched. Data visualization is the main need of any organization. With Microsoft being in our ecosystem, Power BI works perfectly well for us.

The solution overall works quite well, especially if you have a Microsoft-heavy ecosystem.

The ease of creating the dashboard is quite good. 

The analytics are very strong when we couple it with Azure. It offers very good Big Data Analytics that work perfectly well. 

Scalability is not at all a problem. 

You can perform the role-based access perfectly. It gives you everything you need with a single sign-on authentication due to the fact that we are in the Microsoft environment.

You don't have to worry about security. That is very robust.

What matters most is the turnaround time to create a solution, which is quite fast. This is due to the fact that it's quite intuitive in nature. Even those new to the solution can create solutions very quickly. There isn't a high learning curve.

The initial setup was not difficult.

The pricing has been pretty good. 

Technical support is quite responsive.

Overall, the solution is quite intuitive.

If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization.

We've been using the solution for three and a half years at this point. We've definitely used it over the last 12 months.

The product is quite stable. It works well in the Microsoft environment. It doesn't crash or freeze. there are no bugs or glitches. It's reliable.

The solution scales very well. If a company needs to expand its offering, it can do so easily. It's one of the selling points of the solution.

We have about 60 to 70 people on the solution currently.

We already are deployed it at a global level. It's just not India-based. We use it across our organization, and it is getting used a lot.

We've dealt directly with technical support. They have been responsive. We have called them multiple times and the response was good. We are quite satisfied with the level of service.

The initial setup was okay. We didn't have any problems. I wouldn't call it complex. I'd describe it more as straightforward. It took us around three or four months to set up and deploy the solution.

We have a yearly contract. We signed up for three years and that rolls over annually.

We have a bundle, an enterprise-level package. Its pricing is good for us.

We did evaluate Tableau for a moment, however, due to the existing license of Microsoft, the default choice was Power BI.

We are using the latest version of the solution. I can't recall the exact version number.

It's one of the leaders in the top data visualization and analytics toolsets. I'd advise other companies to go for it. It's stable, scalable, and a powerful product and it comes very handy when you want to create visualizations very fast. It's a go-to product if you want to go for data visualization and reporting.

Overall, I would rate the solution at a nine out of ten.

During my internship, I used Microsoft Power BI to create reports for a project we were working on. I also made a dashboard to help a company grow its business.

What I liked most about the tool is that we can use text queries to create projects and modify columns according to our needs. There are hundreds of YouTube courses on how to use it. 

I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier.

I found the tool to be a stable product. One of my favorite features is connecting a SQL database to the tool to generate real-time reports. I was part of a group of 80+ students, but only five of us, including me, were offered internships and could use Microsoft Power BI.

I haven't contacted the solution's support yet. 

Installing Power BI is easy—there are free and paid versions available. I used the free version, which you can download from the Microsoft Store and install, similar to installing an app on your phone.

I used the tool's free version. 

I'd recommend Microsoft Power BI for report generation - it's great software. I rate it a nine out of ten. 

We use this solution for all of our self-service analytics. 

We have the analysis services on-prem and Power BI Pro in the cloud. We are using the latest version of Microsoft BI.

It's the analytic engine in terms of the interface on the Power BI environment, as opposed to pivot tables, and it's a mobile solution.

They have a new update every month. It seems to be pretty dynamic in terms of improvement every year.

Right now, their premium pricing is keeping us out of the premium market. The premium price per user just doesn't make sense for us, but we haven't reached the limit of 500 users to justify the premium.

The stability is good.

We could scale up to premium or Azure. We're fine.

I haven't really used it other than going on their documentation and seeing posts. I have never had to call for technical support.

The initial setup was straightforward. I would rate it a 5 out of 5. 

Deployment was completed in-house.

I would rate them 4 out of 5 for their current pricing. There are no additional costs to the standard licensing fees.

I would rate this solution 9 out of 10. 

They're a market leader. They're the best in class, so I would definitely use them over any analytic tool.