What is our primary use case?
We use it specifically for pure data analysis.
What is most valuable?
I like the speed of building a visual and the transformation feature where you can make changes to the data, and then revert back very fast. These features, where you make transformations and then delete that step when you don't need them, are some of the best.
Power BI's integration with other tools is very good. With Power BI, if there are other systems on the network, you can easily connect to anything like SQL Server, Oracle, Amazon, Salesforce, SAP...anything you can easily connect. I have not faced difficulties with that.
What needs improvement?
The real-time data refresh capabilities is one of the things I had issues with. The refresh sometimes doesn't really work very well because there are two ways of connecting: direct and import.
When it's direct, it's refreshed, but then you have limitations. But when you import the data, I feel there is always a limitation in the refresh. It is kind of like a room for improvement for Microsoft Power BI to work more on these real-time data refresh capabilities.
Microsoft Power BI changes almost every month; make changes regularly. I sometimes even see features that disappear, change, and update. So, I'm not keeping up. They are already doing a lot of changes. They keep updating regularly.
For how long have I used the solution?
I have been using it for six to seven years.
What do I think about the stability of the solution?
It's quite stable. Power BI is very stable.
What do I think about the scalability of the solution?
It is very scalable. Almost everyone in our company uses it.
I personally use it daily.
How are customer service and support?
I don't usually deal with customer service and support. It's our technical team that deals with them, but I don't see them complaining.
Which solution did I use previously and why did I switch?
I used Excel. Power BI can crunch the data faster, and you can build a dashboard nicer and faster. Building a visual in Power BI is always easier, quicker, and simpler than Excel. It's Excel on steroids.
I used to use Excel pivot tables a lot, but with Power BI, it's faster. It's easier to play with the data. If I want to make a list or put some formulas and stuff, Excel is good. But if I want to visualize the data, crunch it properly, and build measures quickly, Power BI is better.
How was the initial setup?
I would rate my experience with the initial setup an eight out of ten, with ten being easy and one being very difficult.
It is deployed both on-premises and the cloud.
The deployment time varies and depends on the company. Every company is different. Here, internally, we have Microsoft Power BI Cloud, so it's easy.
But in the previous company, we did not have Microsoft Cloud. So, to install, we had to install Microsoft Reporting Server and then Power BI internally. That took quite a while.
But if you have Microsoft Cloud in your company, that's easy. And it's quicker on the cloud than on-premises.
What about the implementation team?
Maybe a third party helped with the deployment.
What's my experience with pricing, setup cost, and licensing?
Downloading Power BI Desktop is free. But when you want to use the cloud, this is where I think it's per user payment. I'm not really very familiar with the licensing because I think they have more than one level.
But to use Power BI internally for yourself, it's free. You download it. It's a free application.
What other advice do I have?
I would recommend Power BI to other people. Overall, I would rate it an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.