Microsoft Power BI Reviews

We have many projects in the company. Some of them are self-service where they can connect on their own to local on-premises databases. Some of them are with big databases on the cloud, such as Azure SQL or Azure Synapse, and some of them are with local sources, such as Excel files, etc.

It is really flexible. The charts and reports are really nice. You have the flexibility of self-service.

It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well.

I am not really satisfied with their support. Their support should be faster. They should also be more knowledgeable.

I have been using this solution for two and a half years.

It depends. It is not really for enterprises. Even though Microsoft is trying, it isn't yet ready for enterprise use. For self-service, it is pretty fine. If you don't have a huge data set, it is quite stable.

If you try to have a big enterprise data model, it doesn't scale so well. You wouldn't get results similar to some of the other on-premises tools.

In terms of its users, I don't know the exact number, but we have about 10,000  to 20,000 users. Its usage is increasing.

I have contacted them a lot of times. I am not really satisfied with their support. Lately, it has become even worse. They are probably overloaded, and it takes really long. Many times, they just say, "That's how it works." In reality, it is a bug.

Many times, their first-level support doesn't understand what the problem is, and they don't reach out to the proper people to get into the issue. It is not really good.

We have been using different tools, such as QlikView, on-premises OBIEE, Tableau, Excel, etc. We are trying to migrate almost everyone to Power BI. So, eventually, we will have only Power BI. Its usage is growing.

It is really easy. It is mostly automated. You simply publish the dataset. 

It doesn't take too long. It takes about 5 to 10 minutes.

I'm a part of the team that manages all the projects that are done with Power BI within the company. We guide them and help them with the development and all the architecture.

The number of people required depends on the size of the project. For one of the big projects we have, there are a couple of developers. There is one person for the management of Power BI. We also have 10 to 12 people doing the reports, etc.

We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free.

I would recommend it, but if you want to use it enterprise-wide, you need to be really careful because you might face problems. In general, it's really a great tool. For self-service, it is more than okay, but when you try to use it enterprise-wide, it doesn't really work well.

Overall, I would rate it a seven out of 10.

We built a BI system to provide clients with access to the data that we collect. They can access the data report and various reports by using Power BI.

It is built into the Azure cloud. You can't deploy it otherwise.

We have a product called ED Tracker, and we allow clients to subscribe to this product, and they use it through Power BI. It enables us to offer new services to clients and basically allows them to work on the data or report themselves, rather than sending them data with PowerPoint decks, PDF reports, etc. So, we work with our clients through this platform. They need to have the license. If they want to access the system, we just tell them that they need to get a license. The license is very cheap. It is $10 a month per user. It is not very expensive, and once they have the license, they can access our cloud solution.

Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly.

It is an evolving solution. So, it still has some rough edges. As compared to Tableau or QlikView, there are some things that you can't do when you want to. For example, giving specific access to some reports for users. You can get it up and running very fast, but some things are a bit trickier, and for some of the things, you need to actually write code. 

It is sort of a work in progress. They're catching up on the competition, but it still takes time. Other solutions are more mature, and they have been in the market much longer, but it is catching up. It has come a long way in terms of how it was working two years ago, but there are some things that you still can't do with it. For example, permission management and user access management are still a bit limited. It is basically based on the idea that everybody from the organization can see everything or limit the type of data they can see. If I want you to see only one report and the other guy to see another report, I can't do it. There should be a better way to manage permissions and users. It should also support external users much better.

There should be the ability to export to PowerPoint or PDF. It should be more efficient. It's rather clunky right now. Sometimes, the system is inconsistent in the way it does things. 

I have been using this solution for two years.

It is adequate in terms of speed and stability. It is very stable. Sometimes, it is a bit slow. It can be faster, but you need to subscribe and purchase additional packages or resources, and then it becomes more expensive.

We haven't scaled yet, but you have the ability to have a dedicated server on Azure with CPU. You can increase and have an SQL Server, so you can scale it.

As of now, we have around 10 to 12 users internally and externally. Some are internal, and some are external clients. We do have plans to increase the usage because we're trying to sell and market the product to other clients as well. So, we do have plans to increase the number of users. One of the benefits is that it doesn't matter if we have 10, 20, or 50 users. It doesn't inflict any costs on us because they go directly to the cloud. They don't come to us. It is very indirect, but we do plan to extend the usage of that system. We might also extend it internally.

Their technical support is absolutely magnificent. A week ago, we had an issue related to permissions, and we couldn't find out how to do that. My colleague contacted the support of Power BI. They not only answered us by mail; they also had a half an hour session with us on Teams to better understand what our issues were. They wanted us to send them the files. They reviewed them and told us that there were still some limitations, but they were working on them, and they will let us know.

We were stunned that someone from Microsoft is interested in what we're doing and someone is willing to go online and have a half an hour session with us so that we can explain what we're doing and what is our issue, and they can think about how to resolve it. We're a small client. We're not a big company. So, we were stunned by their support. Their support is amazing.

A few years ago, we've tested QlikView and Qlik Sense. Their deployment costs were rather high, so we decided to use Power BI.

It was very easy and straightforward. It was rather quick because you can launch it. It is very easy to publish. They give you direct access to their cloud. For small solutions or datasets like ours, the initial setup was a matter of days. We started with the desktop on-premise, and then we published it to the cloud. It was rather easy. It was a matter of days to a week or two.

We used our own team. Its deployment and maintenance are taken care of by a PM and a colleague of mine. It is very easy. You just press publish, and it's off to the cloud.

In terms of ROI, it is a 10 out of 10.

Its price is very low. It is like $10 per user, per month. The clients pay for their own licenses. It is not on us. 

There are no costs in addition to the standard licensing fees. That's the beauty. With other systems, you need to spend a couple of thousand dollars just to get started, and then you need to spend $500 per year for the license, which becomes much more costly. You have a system here where for $120 to $140 a year, you can start with two people and start developing and deploying. You can see why the cost difference is huge, especially when you are on a low scale, like us, and you're not building something very huge.

We didn't evaluate other options because we have had some past experience with other solutions. We knew that QlikView might be good, but you need to spend a couple of thousand dollars just to get started if you want to do something. We knew the costs, and the entry cost was much higher. So, we decided to go with Power BI. It is also integrated with Office and Excel, so it's very easy to go along and do some of the things that you can do in Excel. It is very easy to transition between them.

If you are looking for a good BI solution for a small business that is very easy to deploy and not costly and that can use the cloud in terms of security, Power BI is probably the best solution in the market.

I would rate it a nine out of 10. There are other solutions that might be better than this, but they're more costly. It is the cheapest BI solution in the market. It is not the best in terms of features, but it is the best in terms of value for money. For the volume of work that we have, there is absolutely no competition.

I use the solution to visualize charts and graphs that provide data insights.

The product is user-friendly.

Power BI shows reports on actual data, not metadata.

I have been using the solution for a few months.

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

The tool is scalable. We can create multiple reports. We have two to three customers who use the solution. Within the client organizations, teams can use different solutions. It depends on the client’s needs.

Creating a report takes 10 to 30 minutes, based on our requirements. It is easy if we have simple requirements. If it is complex, building a report can take days. The product is cloud-based.

People use other tools in the market, like Tableau and Qlik Sense. They are good competitors.

I work in data management. I focus on connecting to the source and getting the metadata information from the tool. I'm interested in metadata, not actual data. Integration with other tools is possible. The solution provides APIs.

I will recommend the solution to others, but my recommendation depends on the clients. If a customer uses Microsoft products, they can use Power BI. If someone wants to build good reports and perform data analysis, Power BI is a good choice. Any dashboarding tool is good for data analysis. Overall, I rate the product an eight out of ten.

In January, I successfully published my application on AppSource, specifically targeting retail customers. Recently, I received positive feedback from a customer, which was truly gratifying. It seems that my application is Microsoft's preferred choice as it effectively addresses the majority of customer requirements and is tailored to their specific requests. 

Apart from retail applications, I have also developed solutions for BigChange, an organization dedicated to driving significant changes. Additionally, I have worked on creating reports focusing on production efficiency within my company. These reports have been well-received and have provided valuable insights. Lastly, I have recently worked on an application that involves managing IT resources and has developed a multi-dimensional model including SSIS and Power BI.

For the last project, I worked on creating data flows and implementing incremental refresh functionality. However, there was an issue we encountered regarding the date field in the tables. The existing portal dates were incorrect as they did not reflect changes in the records. To address this, we collaborated with the developers to introduce an additional column that accurately captures modified data in the system. This improvement has proven to be significant, and it can be implemented using the pro license, rather than relying on the premium license, as the premium license covers different aspects.

The Pro license offers great features such as incremental refreshing, which is highly beneficial. While it doesn't include direct query capabilities, I believe that many customers don't actually require direct query functionality. 

Currently, the developers in my company are busy adding a column in the API as part of our transition to BC Start. Our intention is to gradually migrate our customers to SQL Server, and that's why we are using the app.

In a simplified manner, when working on-site, you cannot directly connect to the regular table without using APIs. That's why the APIs need to be modified to include an additional column, making it suitable for incremental refreshing. Apologies for any disruption caused, but I hope this explanation clarifies the situation.

They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license.

I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. 

This can be a significant drawback for clients who desire more flexibility.

Additionally, changing styles and formatting options for numbers require external tools, which can be inconvenient and time-consuming. Ideally, Power BI should incorporate these features within its platform to enhance user experience and eliminate the need for external tools.

I understand your frustration with the lack of automation and dynamic features in Power BI, particularly regarding the assignment of dynamic titles and content titles. While there are some options available for creating dynamic titles, they may not fully meet your specific requirements. It would be ideal to have more flexibility in manually assigning the desired typography for each call and dynamically setting content titles. Although it is possible to find workarounds for these limitations, I believe Microsoft will likely address these issues in future updates to improve the user experience. Despite these shortcomings, Power BI remains a powerful and highly capable application, and I would rate it an eight out of ten.

I have a strong belief that within the next couple of years, or even sooner, significant advancements will be made in Power BI. These advancements will make it even more powerful and I am confident it will become truly exceptional. I have complete faith in the future development and potential of this platform.

I have been working with Microsoft BI since the start of 2020.

I am working with the latest version.

Microsoft BI is very stable.

Microsoft BI offers scalability, particularly with the availability of premium capacity. With premium capacity, whether it's per user or a dedicated resource, Microsoft BI can effectively handle increased data volumes and accommodate growing user needs. 

Microsoft BI offers scalability in specific areas, but it is important to note that scalability options are limited to certain aspects and may come at a higher cost. For instance, the premium package, which starts at around $5,000 or more, provides enhanced scalability features. However, if you opt for the per-user licensing model, the scalability may be constrained as it is tied to the number of licensed users. Therefore, in terms of scalability, the per-user option may have limitations compared to other packages.

I wrote to Chris Web, and he replied to me immediately. He is the principal program manager at Microsoft.

I have him I have him working And, usually, I don't contact them, only when it is something serious. top expert and experts, and they reply, you know, has been one for us. It's great

In my professional experience, I have primarily worked with AS (Analysis Services), Power BI, and SSIS (SQL Server Integration Services).

Last week, I worked on creating SSRS (SQL Server Reporting Services) reports and integrated them with SSAS (SQL Server Analysis Services). Additionally, I hold a Microsoft certification in this field.

The initial setup is straightforward. It is very easy to set up. it is very intuitive.

Perhaps it's because of my experience and expertise in the field that I approach things with caution. I don't take things for granted. Just because I obtain a certain result doesn't automatically mean it's correct, as there may be errors that are not displayed.

It's important to carefully check the measurements and ensure their accuracy, especially for beginners who may not be familiar with these nuances.

Maintaining the system is not difficult due to the availability of the admin platform. When it comes to permissions and access, it becomes straightforward as long as the customer's requirements are clear. 

You can easily define the level of access they need, whether it's building, reviewing, sharing, or restricting data access for online viewing. Depending on their specific needs, setting up gateways and configuring other settings is also simple. 

It's important to have a clear understanding of their security requirements and engage in discussions with the customer to determine the best approach. 

Often, customers may not be fully aware of what they want to achieve, and it's our job to help them identify their needs.

Especially for clients, it's important to understand that achieving the desired outcome is not as simple as just completing the task and generating the report.

There are several factors and considerations that come into play. Careful attention needs to be given to the creation process by different stakeholders if you truly want to achieve an exceptional result. 

Even small changes, such as removing certain elements from the selection or adjusting formatting, can have a significant impact on the report. Users may perceive the tool as being the same regardless of these details, but the difference between a subpar report and a high-quality one lies in the expertise and knowledge of the creator.

There are various options available for creating reports, particularly focusing on online reports. However, the foundation of the process lies in Power BI Desktop. Whatever we develop in Power BI Desktop can be published and accessed through a unified platform and tool. 

Data flows enable us to make necessary modifications, similar to working with Power Query and related functionalities. Personally, I find working with Power BI Desktop easier due to its comprehensive features and user-friendly interface.

You can gather data from various sources, including data flows, RBI databases, and SharePoint, among others, and then create and publish your report. While you do have the option to connect to online sources directly, I personally find that working with local data feels faster, at least for now.

Microsoft BI is considered to be competitively priced when compared to other similar solutions in the market.

I haven't had the opportunity to work with other tools as I found Power BI to be excellent. No one has specifically asked me to explore other tools.

However, I did purchase some tools on my own for personal learning purposes, particularly for tabular data. I may consider exploring other tools after June 15th, once I have completed my Microsoft exam DP-500 for Synapse.

Power BI is a complex tool that should not be taken for granted.

Its capabilities and functionalities are multi-layered, and the more you delve into it, the more you realize how much there is to learn. 

It can be both challenging and fun to explore the different features and unlock the full potential of Power BI.

As a BI developer, I joined the company without prior experience in BI. Since December 2021, I have been working on establishing a BI deployment in collaboration with a partner. My main focus is to create and enhance internal and external applications for app stores. Currently, my task primarily involves developing a new deployment strategy.

I would rate Microsoft BI an eight out of ten.

There are several different use cases. The most basic use case would be just to be able to share data from a database or a data repository. That's the most basic use case.

Microsoft Power BI is a visualization tool, is a BI tool. There are more than 1,000 use cases that you could use. There are countless use cases for which a BI tool or visualization tool could be used for.

The simplest use case is where a colleague in an organization who does not have any coding skills or does not have any technology background wants to be able to look at some data from a database or a repository of data. He or she could use Power PI just to be able to connect to that system and just take a look at or peek into that database. It is as simple as that.

Over the last six years, Microsoft Power BI has evolved, matured, has brought in a lot of new features. Six years back, when I first started using Microsoft Power BI, it was just one of the tools among the crowd of tools that I had access to and may not have been that interesting, at that point in time. It was fairly rudimentary and fairly basic in terms of its feature capabilities. However, in the last six years, Microsoft has put a lot of focus and effort into developing it further, and has, on a regular incremental basis, started deploying and enabling capabilities and features, which now makes Microsoft Power BI one of the leading BI tools in the industry.

We realized the benefits very quickly. In 30 minutes, a company can begin to realize the benefits.

In the most basic use case, which is for a user to be able to just access a data which he or she normally would not have been able to himself or herself, since they don't have SQL query knowledge, or they don't know how to access, log into a SQL Server or a database. They can do that using Power BI within half an hour or less.

Like any typical BI visualization tool, Microsoft has several features. The most interesting feature of Microsoft Power BI is that it's very user-friendly.

It is a cloud-based BI tool even though it does come with a desktop client. The ability for a very beginner, basic user to get started with Power BI is very easy. Even if you don't have Microsoft licenses and just want to use a tool for analyzing data, without having to share it with others, you can do that with Microsoft Power BI.

I'm comparing this with other existing and newcomer BI tools. The look and feel of the tool has, only like a month back, undergone a major change. If not, for the last five years at least, last four years at least, the look and feel have been very, very similar all the time. 

It did not change much in the last four years. Barring a lot of functionalities and capabilities being added, it did not change much. The look and feel were pretty much the same. However, about a month back, the latest release of Power BI, they made some further, drastic changes to the way the buttons and the panels are set up. That said, they can do more. There are still better UI designs they can go through. I'm assuming they are focusing more on capabilities rather than look-and-feel designs.

I've used the solution for six years now. 

The solution is quite stable and we have not had any, not come across significant bugs, so far. We've only come across some features which are missing or could have been improved, like certain types of charts that were missing in the past, which are being added. Some of the advanced charts are available as a paid service from third-party partners and not available out-of-the-box. There are very unique features or some very specific capabilities that were missing or are still missing. We could always manage it by bringing in a partner to create an add-on or something like that.

The solution is very scalable and we do plan to increase usage. 

We haven't opted for technical support yet as we have a few other tools which are also being used by the organization, in the new organization that I'm in, right now. Power BI was being offered to colleagues to use on a self-service basis. There were communities and subject matter experts within the organization who had offered their services to the wider organization to come and ask questions. It was basically community-based support, I would say, within the organization. 

Also, Microsoft offers free community-based support for Power BI and proactive support is simply paid. It's paid service from Microsoft and other partners, so we have not opted for that yet, something we will look into once it comes to that point. Yet, it's a fairly mature product. We don't think there would be issues with the platform. The issues would be more to do with how to use the platform, or how to use the platform in conjunction with other systems, other software, et cetera, which is more specific to our organization rather than something the vendor has to support us with.

You do get your questions answered eventually, however, you have to wait maybe one or two days to get the questions answered.

Positive

I have used more than ten to 15 different types of software in the past 20 years.

I have used Tableau and I have used Qlik Sense. These two are, I would say, the top two leading platforms. We switched completely to Power BI, however, we started using Power BI more, alongside Tableau and Qlik Sense. The organization where I used to work previously had the commercial ability to acquire multiple software, depending on use cases, or depending on business requirements, or needs. In the previous organization, the organization was using one particular platform, then they decided to bring in a second platform, then they decided to bring in the third platform. As part of that mix-and-match scenario, we ended up using Qlik Sense and Tableau. And then we also started, in parallel, using Power BI, which then started to get better feedback and reviews, in general, so we ended up using it more and more.

It comes bundled with Office 365. Office 365 is a SaaS-based office suite. Anything that you build on your desktop or Power BI, you can publish into the Office 365 cloud environment. It's relatively easy to get everything up and running. 

It's as simple as taking your credit card and buying an Office 365 license and configuring the AD group and you can be up and running. Of course, depending on how secure and structured you want to make your entire setup, it can take a few months, sometimes, with the full rollout to happen. 

A very basic pilot rollout can be done in a matter of a few weeks.

For the actual deployment and configuration, we just needed five people, and five resources working between six to 12 months. Some were required only for six months. Some are still continuing as part of further enhancements as some of the resources are being retained from a training and onboarding purpose so that they can do a training of the wider organization, and colleagues in the organization, show them how to use Office 365, and get trained on that. The actual development itself took less than two or three months.

In terms of maintenance, there are regular patch updates that get pushed from Microsoft. The backend IT support team needs to ensure all the patches are tested before they're deployed in production, for all the users to use.

Microsoft usually sells through a partner, most of these licenses, and Microsoft also usually recommends a partner. In our case, we did an RFP to bring in the subject matter experts, partners who are certified on Microsoft platforms.

We had a system integrator who came in and helped us deploy and roll out Microsoft 365. As part of that, as I mentioned, we got Microsoft Power BI. 

We are now thinking if we should switch on all the other capabilities of Microsoft Power BI or not.

We have noted an ROI, however, it varies from use case to use case.

There are some use cases in which if you deliver it, the cost savings or the revenue generated from that, or the benefits from that one single use case will cover the entire cost of all 65 licenses, for the entire year.

Then there are use cases, in which you'll have to wait for a few years or months before a company will actually see some benefit being derived.

They have made the desktop client free of cost, which is also what Qlik Sense is. The Qlik Sense Desktop is free of cost. Tableau, the web version of Tableau online, there's a trial period you can use it for. Microsoft also has made Power BI available as a free add-on, or a free complimentary add-on alongside Office 365 for corporate users. This means even if the organization does not want to use Power BI, if they're using Qlik Sense, Tableau, Looker, ThoughtSpot, Domo, or the other tools, Power BI will still be available to them when they're using Microsoft Office.

While it comes bundled with Office, you don't have to buy any additional licenses, just for building and publishing. That said, the moment you want to start sharing your reports, your dashboards, and your analysis with others, that is the point where you need to then start paying for additional capabilities or plans.

I've always been part of different transformation programs where we were required to evaluate a BI tool, to meet the business requirements. Usually, Power BI ends up coming in the short list of products from a BI perspective, from a BI reporting perspective, apart from sometimes Tableau, and Qlik Sense. Sometimes, we also come across ThoughtSpot, Sisense, and Domo. These are some of the other tools which we have also, sometimes, shortlisted.

The differences have become very, very minimal between solutions. There are very few, minor differences between different tools. About four or five years back, there used to be drastic capability gaps between the different tools. Four or five years back, Tableau was the most mature, followed by Qlik Sense, followed by MicroStrategy, followed by a few other tools like SAP Analytics, or a few others. Today, Power BI is alongside Tableau, and Qlik Sense is in the top three. That's based on my experience of having worked on all these three platforms. Tableau, among the three, has the best UI, user interface. Qlik has the best performance, in terms of building complex data models. Power BI, however, is the easiest and most fun to use when it comes to getting somebody to use the tool from scratch. 

There are a few other benefits and strengths. Qlik Sense and Power BI, both come with built-in ETL which is data integration capabilities. They have very mature data integration capabilities, as compared to Tableau, whereas Tableau has very basic integration capabilities. You need to buy another ETL product for it to be able to do a similar level of data transformation as Qlik Sense, or Power BI.

We are a customer and may also be a Microsoft partner, as we are a telecom. 

I'd rate the solution nine out of ten.

A client used Power BI mainly for banking reports. Another client was working in the field of laboratories, and they requested Power BI for the analysis of laboratory-related data for COVID-19. There were also some use cases where we used predictive analytics or utilized the power of Power BI services in the cloud.

It can be deployed on-premises and on the cloud.

It helps in automating the process of filling the data or refreshing the data to give you timely calculations for all the aspects of the dashboards that you have built. You can easily see all the real-time data with Power BI.

The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R.

You can integrate it with the cloud. On the desktop level, you just install the desktop installer, which is about a hundred megabytes or something like that, and it connects to the cloud. So, on the desktop, you can utilize the cloud power for AI and machine learning to help you with predictive analytics.

Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them.

I have been using this solution for six years.

It is stable. Solving dashboard issues on other products, such as Oracle, took us a lot of time, whereas solving issues in Power BI was so simple. The language they're using is also easy. In Power BI, you use the DAX language, which is derived from Excel. So, anyone who knows how to write Excel code would know how to deal with Power BI. It is going to be so simple.

The cloud version is scalable.

It is super easy to set up. I've been giving training on this to new employees, and they quickly learn how to work with the whole product. It doesn't take them more than one or two sessions.

The installation of Power BI Desktop on a computer takes a maximum of 10 minutes. You just have to install it on the computer, and that's it. Most of the services are over the cloud. When you do the subscription, you just connect or sign in with your company email address that has been registered, and that's it.

The on-premises version requires extra staff. It requires an engineer who knows how to implement AI algorithms and then connect them to the offline Power BI solution.

Power BI is subscription-based, and you have three options. The Pro edition, which is the standard one, is about $9 per user. The Premium edition, which provides AI and cloud capabilities but at a limited size, is for small to medium enterprises. It is about $20 per user. For large enterprises, such as manufacturing facilities, there is an option for the capacity. The capacity subscription is about $4,000 per capacity level.

They also have an option for the on-premises version, but it is not common to see someone going for the on-premises version. The on-premises version requires a specific license that is attached to SQL Server. I believe it is about $17,000, but I'm not sure about it.

It has an on-premises version as well as a cloud version. I usually recommend people to work with the cloud version. In the on-premises version, if they want it to go with the artificial intelligence part, they are going to require engineers to configure it, whereas it is already there in the cloud version. It is already configured and affordable. The cloud version costs between $9 to $20 per user, which makes it very affordable, and you also have the capacity option, which costs about $4,000 per month per capacity. The capacity option is usually for huge enterprises. Regular companies, even banks, can work efficiently with the cheapest option, which is $9 to $20 per user.

After working with Power BI, I would rate it an eight out of 10. There is huge competition in the market when it comes to BI tools, and there are fractional differences between Power BI and some of its competitors.

I would describe myself as more of a casual user, only because I have so many other things that I have to get done. I wish I could be more of a user, but it's hard. Right now, I have two different main use cases. I use it for teaching. At another institution, I use it for demonstrating how easy it is to build dashboards. It was really to show to all my users the benefit of business analytics. I use it to demonstrate how easy it is to generate your own analytics versus having a department run reports for you then putting it in Excel and making graphs. 

I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.

The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section. It's probably designed by data analysts that typically get the data from somewhere else. So, one person logs into Power BI, moves the data around and puts it in the proper form then somebody else goes in from the dashboard. What I'm finding more and more is that the person playing with the data is also going to be the person building the dashboard, so the interface needs to be more seamless and dumbed down for the average user. 

Tableau is much better at that, which is probably why it's more expensive. The days where one person works on the data and someone else does the analytics are coming to an end. In the past, larger organizations usually had a dedicated analytics team and a dedicated data team. Now we buy data as a service, so we got rid of our data team and we don't have analysts per se. Instead, we have smart users. So I think Microsoft BI needs to move on to the next iteration of truly user-friendly solutions.

I've been using Microsoft BI for about three years.

Microsoft BI has never crashed on me.

I honestly can't comment on how scalable Microsoft BI is because I've never taken it beyond training or simple use. But I would imagine, if it's on Azure, that it's scalable. I haven't had the pleasure of scaling it, so I don't know, but it doesn't strike me as a solution that would have problems with scalability.

I have not had to contact technical support, but I've actually downloaded and taken three Power BI courses for free and they're very good.

I was using Tableau but the licensing cost went up when Salesforce required them to raise the price. But if the price hadn't changed, I would've absolutely stuck with Tableau because I like it. I do not know about the cost of the licenses. We buy it from the state and when it went up, our CIO at the time said no more Tableau licenses. I had to scramble to find a replacement, and fortunately, I discovered that Power BI is included in Microsoft 365. However, I prefer Tableau's interface. Microsoft BI's user interface is convoluted in terms of how you attach a data source. You have a separate screen for defining your data and then you have to jump to a different screen to model the results. In other words, there are two separate interfaces for data and analytics. In Tableau, it's more seamless. 

Setup is very easy. You click on the icon, download the MSI, and it loads itself. It takes about a couple of hours to deploy overall.

I'd rate Microsoft BI as an eight out of 10. The biggest drawback is the user interface. From what I'm seeing, Windows 11 is going to have a more user-friendly interface. Even Microsoft Edge is adopting a more user-friendly interface. I'm hoping that Power BI follows this trend as well. 

My advice for anyone who is thinking about adopting Microsoft BI is to understand what you're trying to do with it. If you're trying to do analytics with it, then it depends on the kind of analytics. If you're want to do statistical analytics, it's not the tool for you. It's a tool that's better suited for visual analytics than it is for straight-up analytics. If you're dealing with patterns and data, it's great. If you're working with numbers and data, it's not so good. You're better off with a statistical package.

Microsoft Power BI is an easy tool for data analysis. It's easier to get the data from different data sources and then create a visual representation. Using the tool comes easily and naturally to people proficient with Excel. You need to have an understanding of data modeling and how the data works. Once you work with Power Pivot, I think Power BI will be a better upgrade than other tools in the market.

There are some issues with Microsoft Power BI's integration with OAC because it's currently in the beta phase. We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data. The solution's integration capabilities have created some issues for us, especially while retrieving data.

I have been using Microsoft Power BI for over seven years.

The solution's technical support has not been very helpful. I have solved my issues by myself and found a workaround for it.

Neutral

I have worked with multiple data visualization tools, such as SAP One and SAP BusinessObjects, where you had different tools for data visualization. I think each tool has its own unique capabilities. The biggest advantage of Microsoft Power BI is its integration with Excel and how it is an upgraded version of Excel. We all know how Excel is used in the market, so Power BI has a strong advantage over its competitors.

I use the solution for myself, and I recommend it to my customers. I would recommend the solution to other users.

The selection of the visualization tool clearly depends on the data sources. I would recommend Microsoft Power BI if I worked for Microsoft. Otherwise, I would recommend other better tools available in the market. It completely depends on the data source and the data volume. I would not recommend Microsoft Power BI if the data volume is very high because it will tend to freeze your report.

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