Microsoft Power BI Reviews

The data is captured by transaction processing systems, and even when the data is captured by a very sophisticated enterprise resource planning system, or ERP system, such as SAP. We'll find that that data is organized in a manner that is suited for the data updated. Therefore, when data has to be used for decision making, it has to be reoriented and organized in a manner that is suitable for data analysis and further for predictive analytics also. What we do is pull out data from multiple data sources, either on SAP or somewhere else.

There could be a certain budget or plan or target-related data on some other platform or on a Microsoft Excel spreadsheet. The data is stored at different places. Some data could be on your internet platforms. Wherever it is, we pull out the data. Then we get that into the SQL server and we organize it in a manner that's suitable for further creation of dashboards and analytics applications, which can be used for better decision making.

The company has been able to make better decisions, due to the fact that, when we prepare business intelligence or data analytics applications, they are used by very similar decision-makers, as well as middle-level management decision-makers. From the same infrastructure, the data is used by even the report consumers. You can consider three layers of users, report consumers, mid-level use, as in, those who do interactive analysis of data, and decision-makers. Right at the top, those who would like to see the key performance indicators and use them for deciding a course of action can do so. All of our applications have been providing functionality for all these types of needs, including risk and compliance.

The solution offers many features, however, just the way in which that product is designed is quite useful for us. 

The way in which it can connect to multiple data sources is also very useful. The way in which data can be manipulated by using data analysis expressions has also been a good feature for us.

The solution is stable.

The solution is quite scalable. 

Our clients seem to be happy with the level of technical support they receive.

With our experience, the initial setup is straightforward.

Microsoft is often updating the solution adding new helpful features.

I'm not a product expert as such, however, I am aware that Microsoft comes out with a newer version, which is really downloadable and it's replaced every month. Therefore, the improvement is continuous. Since Microsoft provides a free downloadable desktop version of our BI. That desktop portion gets a new version which comes every month, we can replace the older version. 

Their ecosystem is quite good in terms of adding new features, in terms of adding custom visuals or adding many more interfaces or reporting features and more functionality within existing reporting and graphs. We don't have much to complain about except that they can always add many more features as they go.

Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution.

We've used the solution since its inception. We've used it for a very long time. We have been in this domain for the past 30 years.

The solution is quite stable. That's why it is right at the top, of Gartner's quadrant. We have deployed it with hundreds of users and it's withstood the test of time.

The solution is quite scalable. Of course, it requires data strategy just like any solution or any tool.

We tend to have 100 to 200 users at a minimum using the solution.

The solution is extensively deployed. We have plans to use it on an ongoing basis. They come out with new versions and new features every month, and this constant updating and iteration of the product have really been very helpful for us to provide more advanced solutions.

In terms of technical support, we don't really deal with it. Normally, our clients have a contract with Microsoft, however, my understanding is that their experience is good. 

We were using a CA tool and we have done work on Oracle. We have done work on many such platforms. However, since 2008 or 2009, we have been focusing on Microsoft as the total cost of ownership has been quite reasonable.

The initial setup is quite straightforward.

Our implementation strategy involved a business requirement phase where we sought out to understand exactly the expectations for a particular project. Then there is was a design phase where we decided on a data strategy of pulling data from multiple data switches. After that, there was a dashboard design phase, which includes wireframing of dashboards and then designing the dashboards according to those wireframes. Finally, we deploy and in that phase, we put in role level security, et cetera, and deploy it at an enterprise level. The entire process tasks three to four months in total, end-to-end.

We don't require much maintenance due to our maturity in design and development. We have been monitoring sites without having to add too many resources at our end as we have a robust design and maybe one person can handle four to five.

We do the implementation on our own. We have deep experience in this area, and we have developed two types of processes that we use to deploy our solutions. One is the data approach, where you know all best practices and methodologies are embedded into that thing. That framework gives a hundred percent assurance in terms of the success of that project. We have also developed a presentation layer framework whereby different subject areas are designed with very indicative dashboards and those dashboards can be quickly adapted to any data. That way, rather than starting from scratch, we use this framework which helps us to deploy our solution quite successfully. It's very fast also. We save around 50% to 55% of the time this way.

We don't deal directly with licensing. That said, certainly, we are aware in terms of what the Microsoft BI license costs. If it has to be applied on the cloud, then it costs around $10 per month per user. For a pro license and for a premium license it's around $20 per month per user. If it has to be applied on-premises then, depending on the course of your server, you have to buy a software assurance version of the database.

They don't charge for additional features. If you want a premium capacity to handle your work or job, then there is a separate license available. That is a premium license, which is available with the entire product managed by Microsoft and you can use lot more features, including Azure, et cetera.

We are Microsoft partners.

We have two deployment options. Some of our clients have deployed the cloud solution. Some are deployed on-premises.

Anybody who has worked on existing spreadsheet-based solutions can quickly adapt to Microsoft BI and the data visualization and interactive data features, they'll find it very exciting to use and very fast to adapt to it. It's a very effective solution.

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

In terms of impact, Power BI significantly improved decision-making and instilled confidence in our data. It also resulted in cost savings by avoiding the purchase of expensive Oracle integration tools like ODI. These savings were crucial for our fast-growing company, allowing scalability without increasing expenditure.

The most effective feature of Microsoft Power BI for data analysis is the ability to use Power Query directly from Excel. Power BI's integration capabilities impacted our data management by allowing us to push all reporting down to the end user, giving them the capability to perform "what if" scenarios and discover and validate their own data without needing to refer to IT. Additionally, it provided insights that we couldn't get from Oracle Cloud. We wrote an extract routine to transfer our Oracle Cloud database to Power BI, which was a game changer in terms of giving people confidence in the finances.

It was easy to implement Microsoft Power BI into our existing infrastructure, but integrating it with Oracle Cloud was very difficult. The integration with Oracle Cloud required us to build a sophisticated database replication process because the APIs for Oracle Cloud are very restricted in terms of volume, depth, and complexity of queries. However, the part of implementing Power BI into our infrastructure was very easy. It required almost no tech input because it was all part of Office 365. To overcome the integration issues, we developed an extract and update process, although it was quite complicated and involved a lot of IP.

Power BI excels in integrations and its ability to handle various data sources. It would be beneficial if it could integrate more seamlessly with cloud interfaces like Oracle Cloud, although I understand the challenges with Oracle's policies on database access. Another area for improvement would be enhancing error messaging, especially when working with Dataverse and M Code for automation.

I have been using Microsoft Power BI for the past ten years.

I would rate Power BI overall as an eight. It's a very powerful tool for users, which I appreciate. However, there are some areas that could be improved.

As for AI-driven decision processes, I believe Power BI supports them, although we haven't utilized those features ourselves.

My company uses Microsoft BI for reporting purposes. In my company, we extract data from different sources, put it in the staging area, and then use Microsoft Power BI to build the reports and dashboards.

The most valuable feature of the solution is that it is an easy-to-use tool.

Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities. Microsoft BI needs to improve its mobile application compatibility so that people view their reports and dashboards through a mobile app since, nowadays, people move towards tools that are in the digital transformation phase.

I have experience with Microsoft BI. I recently joined a new organization where I see Microsoft BI being used extensively.

Considering that most people in my organization use Microsoft BI, I can say that it is a stable solution.

Microsoft BI is a part of Microsoft Power Platform, because of which Microsoft can increase its capacity based on the needs and licenses of its users.

Around 20 people in my company use Microsoft BI.

My company plans to increase the use of Microsoft BI.

The initial setup of Microsoft BI is straightforward since it comes along with Microsoft Power Platform.

The solution is deployed on the cloud.

I am unsure about Microsoft BI's deployment process since it was already deployed when I joined the organization.

In my company, we have two developers and two testers to look after the deployment and maintenance of the solution.

The company's in-house team did the installation process of Microsoft BI.

When my company compared the price of Alteryx to Microsoft BI, we found Alteryx's price to be higher than Microsoft BI's price.

In general, Microsoft BI's price is lower compared to Alteryx.

I am not a user of the solution at the moment. I am an architect taking time to evaluate and see how my company can use Microsoft Power BI.

Our company hardly finds a tool where we can say one size fits all, so we need to use other tools for larger amounts of data and data cleansing.

It would be effective for those planning to use the solution to find the best solution that suits their requirements.

I rate the overall solution a seven out of ten.

It’s not just a specific tool I use when providing solutions. In these scenarios, clients often have a significant Microsoft presence with servers for data collection, whether it's in a data lake, data warehouse, or a data lake house. Their users typically require reporting, dashboards, or ad-hoc queries based on their specific business needs. However, most vendors tend to offer inflexible solutions, focusing on predefined reports.

Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support.       

Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is.

I have been using this solution for the past five years. 

It is a stable solution. 

It's a cloud-based platform, and it scales seamlessly based on your usage, which is one of the key advantages of cloud services. You pay according to your usage, without worrying about licenses or ownership. However, there are some limitations to consider. While it's a front-end tool for visualization and analytics, it lacks extensive customization options. If you require complex reports or queries, Microsoft offers support to help you achieve those goals. In my experience over the past five years, I haven't encountered any use case that couldn't be addressed with Power BI. On the contrary, I faced performance issues with other tools like Spotfire, which prompted us to explore different solutions. The effectiveness of Power BI also depends on factors like architecture, deployment, and network quality. If network configurations aren't optimized, it can lead to slow data transfer. However, being a cloud-based solution, the cloud infrastructure often manages these issues. Nevertheless, if you want the best performance, you might need to invest in improving your network infrastructure.

Positive

I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage.

 would recommend the solution, rating it eight out of ten. There’s no such thing as an ideal product. In my perspective, perfection remains an unattainable goal. However, I can't rate it lower than eight because Microsoft actively invests in BI's development and expansion. They have a roadmap and allocate resources to it, which is evident in the growing user base. This continuous growth adds value to the product and benefits its users.

We use Microsoft BI all over our enterprise but our main use is for the organizational dashboard. My organization sends all of our systems and ERP data into a Power BI dashboard, which goes to all the managers, the leadership, and then gets reported up to the company executives.

Microsoft BI has helped out the organization because it has brought visibility of our data across the organization allowing everyone to see the same metrics.

My favorite feature is the power query editor, where it can do the data transformations.

Microsoft BI could improve by having better collaboration between developers working on the same dashboard. The developer platform is all done on a single laptop and it's difficult to have the same project files work. Two developers have to go back and forth. You have to have the project file on one developer's laptop making it difficult to co-develop.

In terms of the performance, it could always improve sometimes. It's only slow to update. The automated data feeds have to be all updated.

I have been using Microsoft BI for two years.

The stability of Microsoft BI is very good. We have not had an issue.

Microsoft BI has scaled very well for us. We have a very large organization with users all across the company.

We have approximately 100 users using this solution. It's a standard program for analysts and even managers will use it. It is a standard business analyst software. 

The solution is extensively being used in our organization.

I have not contacted Mircosoft for technical support. I only use our internal support.

We previously used SAS and it is similar to Microsoft BI. It's a little different in the visualization. It was more on analytics, but it also had the visualization.

We had SAS Enterprise Guide which was on-premise. When they were looking at cloud solutions, they kind of opened it up for more possibilities. The deciding factors of why we switched to Microsoft BI was we already had many Microsoft products and we have a SQL Server Data Warehouse. There's good integration between our existing Microsoft systems with Microsoft BI.

I was part of the initial user testing of Microsoft BI, but it was mostly IT that handled all the initial implementation.

We have a dedicated IT team of two administrators that support Microsoft BI. One of the administrator's full-time job is to manage the Microsoft BI.

My advice to those wanting to implement this solution is to do some training. There is enough training curriculum available to get people going.

I rate Microsoft BI a nine out of ten.

We are using this solution for analytic dashboards.

The solution integrates with other Microsoft solutions very well. 

When it comes to security Microsoft BI can integrate well with Microsoft Domain Services, you are able to make it as secure as you want.

There are useful visualizations available in the dashboards.

If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3.

In a future release, they need to have better integration to allow any visualization that is done in other solutions, such as D3 or Tableau, to be able to be imported in Microsoft BI easily.

I have been using Microsoft BI for approximately five years.

The solution is stable when the database is reasonably sized. If you have large databases of 20 million rows it can begin to have difficulties requiring a purchase of more hardware.

The scalability is good. If you have a direct query, Microsoft BI can run on billions of rows of data.

Microsoft BI is available to the 70,000 users in my organization.

This solution is used extensively because everyone has access to it, not because it is the best.

The support from Microsoft could improve.

The solution is easy to install.

We did the implementation of the solution.

For those customers we have that use Microsoft BI on a dedicated server, we have a technical team that does the maintenance.

I have evaluated Tableau and D3.

I would recommend Microsoft BI over Tableau if you are comfortable with Microsoft solutions. Additionally, understand your use case and choose the best solution that fits your needs.

I rate Microsoft BI a six out of ten.

I'm a project manager and we are customers of Microsoft.

I like the toggling feature, the ability to switch from one page to another. 

I have a couple of dashboards that are weekly and monthly. I was able to download the dashboard, but I cannot paste any images into PowerPoint. There are also visuals based on the brand that should automatically pop up in the graph and which should be a toggling option. And I'm having performance issues if I want to add two or three tables at a time, which I could easily do in Tableau. Copy-pasting data to PowerPoint for presentation to the executive level should be easy but we're only able to copy the visual, not the underlying data. 

I've been using this solution for the past eight months. 

The solution is scalable but we haven't yet migrated everyone to Power BI. Our users are not finding Power BI as good as Pique, which perhaps they're just more used to. They're trying but some of the features available in Pique are not there so they are not comprehensively using it. It's being used mainly for internal analysis for now. 

We initially used Tableau because our data was an internal data source, and now all of our data is migrated to tool environments, that the Power BI is more comfortable with. BI is also a free product which is another reason the company recommends it.

The initial setup was straightforward, we have a Power BI admin team who take care of all that. 

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

Usually, when dealing with business intelligence projects with big data, all customers have Office 365 but within these licenses, Microsoft BI is often included.

The use case depends on the project. For example, in the logistics project, we need maybe four persons. For retail sales without stocks, it's a very easy project for us, but only for sales, and purchase orders, it's a standard part of the tool, to incorporate warehousing. Sometimes it's more difficult to clean the data if you have something like visualizations. It is often more difficult to understand what kind of data you need for the customer, or the strategy of the company who needs the information, to build a suitable solution. Customers often change their requirements. That's why Microsoft BI is more useful than traditional user tools, as it is flexible to changing requirements.

It's a great tool for visualization data, and it's free for engineers. Microsoft BI has a good online community. You don't need to be an engineer to use it. In Microsoft BI you can embed the visualisation and reports into your applications. Embedded items are much faster and cheaper to use. It's very easy to work with the customers using this kind of tool, rather than say, Oracle. I have used the personal edition, but some customers have been trained to use the professional version. Initially, I spent a lot of time learning the new system. As I was already experienced in other, similar technologies it was not difficult to understand the visualizations. I encouraged our clients to do more with Microsoft BI.

It should work faster and have more common languages so that you can use it more in different types of connections. It doesn't work well on big data. It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake. It uses the DAX language, which is not used widely. Maybe they should develop this part of the tool to improve access to people who don't know DAX. Sometimes it needs to have a special configuration and hardware to connect to a data warehouse. So, interoperability with other systems could be improved.

I began using it a few years ago. I was involved in testing and last year, I was tasked with some large projects in Azure which included databases, a data warehouse with SQL, and Azure SQL. It is a cloud-based service, which means that a project is easy to use and design. You can use different tools for different things, but all the visualization in Microsoft BI is all in one tool. 

Microsoft BI is stable and works consistently well. 

Microsoft BI is a very scalable tool. You can start small and build up your project as you wish. 

I used Microsoft Azure support because we have a project. I have a good relationship with Microsoft. I don't have any problems.

It is easy to install Microsoft BI. You simply download and install it from the Microsoft Microsoft BI website, and it is available to download on windows. It can be downloaded and installed in 5 minutes.

Microsoft BI is free for the personal edition, but there is also a paid-for professional version. Setting up Microsoft BI is simple.

Oracle products are well-engineered but too heavy to accomplish small tasks. However, to use it for enterprise, you need to have a lot of knowledge about the different kinds of tools available. It has more flexibility but is more complex because it's designed for enterprise-level systems. Comparing this to Oracle which is at least 10 years old. Java is also old, but it's more structured. It's more proprietary.

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.