Try our new research platform with insights from 80,000+ expert users
reviewer1551786 - PeerSpot reviewer
Project Consultant at a financial services firm with 501-1,000 employees
Consultant
A stable solution with a great dashboard
Pros and Cons
  • "Microsoft BI is very easy to set up and use."
  • "Integration with products that are not Microsoft could be more improved."

What is our primary use case?

Around 50% of our customers use this solution. We plan to extend our usage of this solution.

What is most valuable?

Our customers really like the dashboard. They can click on whatever they want for an in-depth view. Microsoft BI is very easy to set up and use. 

What needs improvement?

In general, all the Microsoft programs are integrated quite well, but it could be improved. Also, integration with products that are not Microsoft could be more improved.

For how long have I used the solution?

I have been using Microsoft BI on and off for the past two years. 

Buyer's Guide
Microsoft Power BI
January 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,071 professionals have used our research since 2012.

What do I think about the stability of the solution?

If implemented correctly, Microsoft BI is quite stable. 

What do I think about the scalability of the solution?

It's quite scalable. 

How are customer service and support?

I have never contacted customer support. 

What's my experience with pricing, setup cost, and licensing?

I don't know much about the licensing because our customers pay for it. 

What other advice do I have?

I would recommend this solution. Overall, on a scale from one to ten, I would give Microsoft BI a rating of nine. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1535370 - PeerSpot reviewer
Solutions Architect at a tech services company with 11-50 employees
Real User
Multiple datasets synchronization, visual customization, and reliable
Pros and Cons
  • "The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app."
  • "They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."

What is our primary use case?

The solution is a dashboard. We have the on-premises data gateway, which allows us from the Azure Cloud to get into Power BI. The dataset content comes from the on-premise data warehouses.

We have produced historical analytics and KPIs from ServiceNow for Incident management, performance, SLA coverage, trends, and identifying anomalies. Anomalies are, for example, if a ticket is reopened, that means it was closed incorrectly or the solution was not correct. If a ticket has been an incident or a request has been routed more than two times, that means somewhere in the processes it was not clear and the ticket is going in circles out to the anomalies data.

A lot of analytics based on ServiceNow and Gyra as ITSMs systems. There is also combined analytics between Salesforce and for example, Web analytics, Google Analytics, and so on. Allowing us to see how visits to the website translate into lead opportunities. This is done by combining the two, extracting them and combining the two sources of data, such as Google Analytics and Salesforce.

What is most valuable?

Some of the most valuable features of this solution are the ability to take your data and have the possibility to combine them into datasets and have synchronization. 

You are able to synchronize the data without additional cost eight times a day and you can set when you want to synchronize it. For example, during business hours, we synchronize the data once an hour and during the night I do not synchronize it at all. 

The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app.

Microsoft is open to suggestions for improvements in future releases. We requested to allow Python Notebooks to be displayed as visuals on top of the datasets, which now available and was not five versions ago.

What needs improvement?

The possibility to synchronize more often without having to pay more would be great. They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly.

For how long have I used the solution?

I have been using the solution for three years.

What do I think about the stability of the solution?

I have found the solution to have high performance and to be reliable.

What do I think about the scalability of the solution?

The solution is highly scalable. We have approximately 100 people using the solution in my organization.

How was the initial setup?

The solution is a service, which does not require a traditional installation. However, there is a large configuration portion. It can be very simple to configure minor operations but can become complex if you connect via Power BI, a lot of sources.  For example, from on-premise and from multiple clouds. It allows you to go from very simple, to very complex. It is up to your solution design in the end. 

You can create your first dataset in a matter of hours. This once again is dependent on your configuration.

The solution requires maintenance but not to the Power BI itself. The configuration is deployed on top of Power BI, you can set automatic alerts if, for example, the data is not synchronized or It not available.

What's my experience with pricing, setup cost, and licensing?

The price of the solution can be expensive if you want to synchronize your data more.

What other advice do I have?

I rate Microsoft BI an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Microsoft Power BI
January 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,071 professionals have used our research since 2012.
reviewer1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
Real User
Good reporting, and provides data insights that help to improve efficiency and profit
Pros and Cons
  • "The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website."
  • "I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account."

What is our primary use case?

I have developed and deployed more than twenty separate customer solutions. I am a Business Intelligence Deployment Specialist. The most significant implementation was to reduce the Financial consolidation time for one hundred and twenty companies into one shareholder report, from thirty days to four minutes.

How has it helped my organization?

We help customers deploy and analyze sophisticated analytics models. These models have helped them all to get a better insight into their data and many of them have found very valuable insights that made them more profitable, more efficient, and in some cases changed the direction of the business.

What is most valuable?

The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website. Data that is not classified as confidential can very easily be exposed to customers, vendors, or even just visitors to the web site.

What needs improvement?

I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account.

The minimum embedded capacity for Machine learning is currently an A3 capacity, and this should be reduced to include A1 level licenses.

For how long have I used the solution?

I have been using this solution for three years.
Disclosure: My company has a business relationship with this vendor other than being a customer: Microsoft Gold Partner
PeerSpot user
IT & Projects Development at Anfasic Dokhoon
Real User
Quickly shares data from the source to business users

What is our primary use case?

  • Management BI/dashboard reporting
  • Quick sharing of data from source to business users which is very useful.

How has it helped my organization?

  • Giving visibility to management/business users about the business by mobility.
  • Easy to develop and manage.

What is most valuable?

  • Mobility.
  • It's easy to use.
  • Multiple data sourcing.
  • Quick development and deployment.
  • Mobility and ease of use.

What needs improvement?

  • Dependency on data warehousing and pricing.
  • Clarity on the Power BI (free) compared to Power BI (pro).

For how long have I used the solution?

Less than one year.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user872265 - PeerSpot reviewer
Professor of Private International Law with 1,001-5,000 employees
Real User
Flawless stability, integrates well with Access, Excel, but needs ETL functionality
Pros and Cons
  • "It is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow."

    What is our primary use case?

    Visualization and minor analytics. It has performed quite well thus far.

    How has it helped my organization?

    We've not used it enough to be able to speak to organizational improvements.

    What is most valuable?

    • Low cost - it's a free application
    • Ease of use - excellent user interface

    What needs improvement?

    Perhaps the inclusion of ETL functionality would help.

    For how long have I used the solution?

    One to three years.

    What do I think about the stability of the solution?

    Flawless. Absolutely flawless. The stability is excellent.

    What do I think about the scalability of the solution?

    Integrates really well.

    Which solution did I use previously and why did I switch?

    We did not have a previous solution. And we did not choose this solution. We actually inherited it. 

    How was the initial setup?

    There was no real set up, just install the application. No complications whatsoever.

    Which other solutions did I evaluate?

    On our short list, for future consideration: Oracle.

    What other advice do I have?

    Our most important criteria when selecting a vendor are cost, cost, and cost.

    I rate Microsoft BI at seven out of 10 and that's because I have not utilized it as much as I would have liked to. However, it is very well integrated with other Microsoft products, including PowerApps and Excel, as well as Access, so it fits well into our workflow.

    Consider very carefully what your requirements are and plan your projects well. This is a wonderful tool but it will not get the work done for you.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
    Vendor
    ​MS BI comes with all the tools and it is to the best of my knowledge the most affordable solution​.​
    Pros and Cons
    • "MS SQL & SQL Server Analysis Services."
    • "SQL Server Reporting Services (SSRS) is not user friendly."

    What is most valuable?

    MS SQL & SQL Server Analysis Services.

    How has it helped my organization?

    We provide BI solutions to the users at every level in order to monitor business. We can deploy DWH, cubes and reports from scratch within weeks of implementation.

    What needs improvement?

    SQL Server Reporting Services (SSRS) is not user friendly, requires development. Power BI will surely provide a huge boost to MS BI in terms of self-service BI. Then again, SSRS developers are plenty, thus not so expensive.

    For how long have I used the solution?

    Ten-plus years.

    What do I think about the stability of the solution?

    Stability issues are due to bad hardware sizing, bad forecast of volumes, or bad data modeling.

    What do I think about the scalability of the solution?

    Only when data models were faulty of when the infrastructure was not compliant to MS recommendations.

    How are customer service and technical support?

    Tech support from Microsoft, when needed, is as efficient as can be.

    Which solution did I use previously and why did I switch?

    Worked in different technical environments but never saw a switch from MS BI.

    How was the initial setup?

    Developers and architects are easily available for this technology.

    What's my experience with pricing, setup cost, and licensing?

    MS BI comes with all the tools and it is, to the best of my knowledge, the most affordable solution.

    What other advice do I have?

    Watch your data model, use data marts when possible, set your archiving/purge policy from the beginning, size your hardware well (unless on cloud).

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user171969 - PeerSpot reviewer
    Microsoft BI Consultant with 51-200 employees
    Vendor
    Good product for End Users but there are some problems with huge chunks of data.

    What is most valuable?

    Data Integration and Cleansing & Warehousing are the most valuable

    What needs improvement?

    End-user tools such as Excel is not good enough for all business scenarios.

    For how long have I used the solution?

    8 years

    What was my experience with deployment of the solution?

    There are some issues with 2005/2008 releases, but most of them were fixed starting with 2012 release

    What do I think about the stability of the solution?

    Sometimes in the starting few months of every new release.

    What do I think about the scalability of the solution?

    There are some problems with huge chunks of data. Some of these can be addressed with appropriate hardware appliances and a lot of tweaking.

    Which solution did I use previously and why did I switch?

    I do work on projects to switch clients to MS BI usually due to its attractive pricing and tight integration with MS Office suite. Also the learning curve for users is flattened due to their fluency with Excel.

    How was the initial setup?

    MS products are great but security is always a concern to make the whole ecosystem work smoothly. The latest BI suite is tightly integrated with SharePoint which is great; but the set-up process and deployment is still painful.

    What other advice do I have?

    Have knowledgeable people to make the right choices for you.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    reviewer1564200 - PeerSpot reviewer
    Data Science Leader at a tech services company with 11-50 employees
    Real User
    Can be used to plan, communicate, and visualize knowledge extracted from data
    Pros and Cons
    • "The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."
    • "I think that the solution is harder to use for people who are not experts in data."

    What is our primary use case?

    We use it for BI analytics. I am a data scientist, so I model data and show the data through dashboards using this tool.

    What is most valuable?

    I think that the best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question.

    What needs improvement?

    I think that they can make the solution easy to use for people who are not experts in data because many clients try to use it, but they need to be prepared before using it.

    Also, now we have another solution on the market that is more easy to use for those who are not trained in these kinds of tools.

    For how long have I used the solution?

    I have been using Microsoft BI for more than five years.

    What do I think about the stability of the solution?

    I think the stability is good. I haven't had any problems yet with Power BI.

    How are customer service and technical support?

    My experience with technical support has been good.

    How was the initial setup?

    For me, the initial setup was easy, but I have been working for more than 20 years in data analytics. However, sometimes for end-users it's not as easy as another tool on the market.

    A dashboard can be made in 30 minutes or two days, depending on the client, the information, and the quality of the data. I am also a teacher, so for my classes I can create a low plan dashboard in 30 minutes.

    What other advice do I have?

    I used to recommend Microsoft BI, but the only issue is that you would need to know data analytics before using it. So it is not easy to use if you're not an expert. However, it is a good tool, and I think it's a good solution for many business problems.

    Also, I would rate Microsoft BI at eight on a scale from one to ten.

    Which deployment model are you using for this solution?

    Hybrid Cloud
    Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
    PeerSpot user
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: January 2025
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.