What is our primary use case?
My focus is mainly on analytics use cases, so I am not able to go into the functional aspects. From a client perspective at a high level, I am supporting descriptive analytics. I provide high-level operational reporting and analytical reporting, where clients can see how they are performing in a particular business process. Clients define certain KPIs and we build them, then they can monitor how it is happening.
On a day-to-day basis, I handle operational reporting for what they are doing. At the same time, I track how different processes are happening over the period of time with time series related metrics.
What is most valuable?
From a standard reporting standpoint, there are drill-down features where you can go from higher hierarchy to lower hierarchy. You can navigate from one functional subject area to another functional subject area. For example, I can move from financial analytics to HR-related or sales analytics. I can drill across and go from one functional area to another functional area.
Microsoft is now coming with Copilot, where a business user does not need to go to each and every report and understand it manually. They can summarize reports by asking Copilot to summarize, and it will give all the details. I can bookmark it, and whenever I want, I can go ahead and review it.
I can put all the reports into an application. For financial analytics, I can build one app so that relevant dashboards and reports can be grouped together and all the data is available at one place for my analysis. This can be for regional directors, operational managers on the ground, or CXOs. They can view the data with executive dashboards, tactical reporting, and operational reporting all in one place. I can give the kind of access levels and implement who can see what, so all the securities, data security, and data privacy can be implemented very easily.
From a visualization perspective, Microsoft Power BI is really good and gives a lot of features, and the business users can understand very easily. Microsoft Power BI is well integrated with Microsoft products. I can view the reports in Outlook, I can view the reports in Teams as well. I can get the data in Excel as well. It is completely integrated with MS Office, Outlook, and Teams channels. From a collaboration perspective, they made it a very robust and very useful tool so that business users can use it.
All the premium providers and cloud data warehouses can be connected, and then I can build reports on top of them. Microsoft Power BI has all the connectors.
What needs improvement?
Tech support is an area where there is always hope to improve. It takes some time to get the result. When there are human interactions involved, obviously it takes time. There is definitely a scope for improvement.
When I raise a ticket, they will take their own time. By the time I get it resolved, there is always a scope for improvement.
For how long have I used the solution?
I can claim almost six to seven years of experience with Microsoft Power BI. Earlier I used to work with it, and now I have started working with it again. The total put together is almost six years that I can claim working with Microsoft Power BI.
What do I think about the stability of the solution?
Right now with cloud AI systems in place, everything is perfectly integrated and I am not seeing any issues. In fact, we need to cope with the new features that are coming up because of AI integration and agentic AI, everywhere. Everything is flexible and super fast from an implementation perspective. All features are available. The only thing is we are still exploring the gamut of features that are available. Earlier it used to take six months to one year; now we can do it in one week. All those functionalities are happening, so amazing things are occurring right now.
What do I think about the scalability of the solution?
Real-time analytics is possible with Microsoft Power BI. Right now we are still in batch analytics only. The data can be fetched real-time from the operational store, and then I am able to provide real-time analytics as well with Microsoft Power BI.
How are customer service and support?
There is room for improvement in tech support. It takes some time to get the result due to human interactions, which takes time.
When I raise a ticket, they will take their own time. By the time I get it resolved, there is always a scope for improvement.
Which solution did I use previously and why did I switch?
Tableau was there earlier, but right now it is owned by Salesforce. Microsoft Power BI is the market leader in the reporting side. There are other reporting tools available, but Microsoft Power BI is the market leader.
How was the initial setup?
I would not say the setup is very complex; I would not say it is very simple either. It is kind of medium. Whoever has experience setting up things and production environments will find it easy to go ahead and set it up. From a setup perspective, it is absolutely not an issue.
What's my experience with pricing, setup cost, and licensing?
Price-wise, Microsoft Power BI operates on a pay-as-you-go model. Fabric is available and already integrated. There is a Microsoft Power BI Desktop which is free, so if I want to build my own reports, I can. All the functionality and free features are also available. Price-wise, it is really good. Earlier Tableau was there as a competitor. Now Tableau is part of Salesforce. I can say that Microsoft Power BI is a market leader.
I can give it a rating of seven or eight. Still, there could be better pricing that they could offer.
What other advice do I have?
They can learn quickly and start using Microsoft Power BI very quickly. It is well integrated with MS Office. Whoever is using MS Office can very easily learn Microsoft Power BI and then start exploring enterprise-grade reporting from advanced analytics to operational reporting. It is a fantastic tool. I would rate this product nine out of ten.
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?