Try our new research platform with insights from 80,000+ expert users
reviewer1040850 - PeerSpot reviewer
Director of Sales and Marketing at a tech services company with 11-50 employees
Real User
Integrates well with Microsoft tools and has a good familiarity but lacks technical support
Pros and Cons
  • "It integrates with all of the Microsoft tools."
  • "The initial setup is a little bit technical."

What is our primary use case?

We primarily use the solution for integrating into our ERP so people can have a dashboard analysis of whatever is important to analyze or compare, whether it be top-selling products or sales performance, or quota analysis.

What is most valuable?

Just as a BI tool, there's not much difference between solutions. It works well with our product and it's something that customers are familiar with and they often already have a lot of licensing with Microsoft. It's an easy add-on to their users.

There's generally a sense of familiarity with the product.

It integrates with all of the Microsoft tools.

What needs improvement?

It's not even fair for me to respond on that as that's not my wheelhouse. I don't know how easy it is as I'm not doing any of the designs. Therefore, I have not had any real training on it. I don't think that's fair for me to criticize anything that they're doing.

The initial setup is a little bit technical and what an end user wants to see is always a moving target.

The solution needs better technical support.

For how long have I used the solution?

I've been using the solution for about three years at this point.

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

What do I think about the stability of the solution?

In terms of stability, we haven't had any challenges with it at this point. As with multiple integrations across several companies we tend to make whatever change is best for the biggest base of clients. We haven't had any issues thus far.

How are customer service and support?

Technical and end user support is something that might be lacking from Microsoft. As a user when I want to find an answer to, "Hey, how do I do this?" I often get better answers by going to a  website of a company that represents them than I do going directly to their site.  Maybe they do that on purpose to help drive business to those people, however, it would be helpful if it was more centralized and the quick and simple steps answers that I get elsewhere.

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

I have some past experience with solutions such as Tableau and Cognose but not integrated into this ERP product.  We chose one that we would feel would be on a common platform of our customers.

How was the initial setup?

The setup is fairly straightforward but implementation is a little bit complex mostly due to how the customer driven scope changes often as they realize the power of a BI tool and want to be able to expand it's use.

We're on a Progress platform, so that's a little more technical on our side at the beginning of the original project.

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

The licensing costs vary. It all depends on the individual customer due to the fact that Microsoft's options are modular. For example, they have Microsoft Office suite, then they add CRM and then you might add BI.  It's not expensive per user, however, as you increase the functionality or add different tools, it becomes more expensive.

What other advice do I have?

We qualify as a partner as we're a software distributor. We're using the most current version of the solution.

Here is the biggest thing: when you look at any BI tool or if it's the first time you're implementing one, you can easily get over enticed by the flashy display or the common things. However, it's the ability to drill down to your true business processes that are going to make it or break it as being the right tool or accesses the right information. Somebody that gets a BI tool for the first time will open a dashboard and say, "Oh, that's important for me to see every day." However, the reality is, when using a dashboard view you're looking for a red flag or highlights. The power of the BI tool is allowing you to drill down to the data behind the dashboard, that's where the real testing comes in.  Figuring out where to get the information from and how best to analyze it.  That's my best BI tool advice. Anybody can make a dashboard look pretty. It has to be useful too.

In general, I would rate the solution seven out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1391733 - PeerSpot reviewer
Business Intelligence Manager at a tech services company with 51-200 employees
Real User
Good reporting, enables self-service BI, it's stable, and we are satisfied with the pricing
Pros and Cons
  • "It's easy to create reports and it's easy to download the data from the corresponding report."
  • "We would like improvements made to the paginated reports so that it produces quality similarly to SSRS."

What is our primary use case?

This solution is primarily used for business analytics. We generate reports so that the business analytics team can use them for their analysis.

How has it helped my organization?

Previously, we used Excel to perform the analysis. It was very tedious for them to get data into Excel, do the refresh, and generate the reports. Now, using Microsoft BI, they can connect directly with the data, it gets refreshed automatically, and they don't have to worry about refreshing it.

They get the data in the report section and they don't have to worry about report generation, data modeling, and other aspects.

What is most valuable?

The most valuable feature is the reporting. It's easy to create reports and it's easy to download the data from the corresponding report.

This product enables self-service BI.

What needs improvement?

The paginated report functionality, which was intended to replace SPSS, is not yet up to the mark. We would like improvements made to the paginated reports so that it produces quality similarly to SSRS.

There is no automation for paginated reports, so then need to make it automated.

Ultimately, I would like to see all of the features from SSRS that are missing. That's ideally what I would like to have.

For how long have I used the solution?

I have been using Microsoft BI for the past 10 years.

What do I think about the stability of the solution?

This product is pretty stable.

What do I think about the scalability of the solution?

Scalability depends on the kind of reports and data we are looking at. It has multiple features for us based on the functionality and the requirement of the customer. It's not limited only to enterprise-specific customers. Rather,  It can be used by small, medium, as well as enterprise-based customers.

There is no limitation as such. So it's quite scalable.

I have work two different companies at this time, and as far as I know, there are between 1,500 and 2,000 people who use this product.

How are customer service and technical support?

The quality of support depends on the Microsoft partner that you are working with. 

We have not faced any significant issues, but when we have, we raised a bug with the Microsoft technical team and they have resolved things accordingly.

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

This is the only tool that we are using for reporting. Previously, we used Crystal Reports.

What about the implementation team?

We deployed this product ourselves. We used the documentation that is available at Microsoft.com.

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

The cost of licensing depends on the number of people that are going to be using the reports, and we are satisfied with it at $10 per user.

Which other solutions did I evaluate?

Our company focuses on Microsoft products, so we did not evaluate solutions by other vendors.

What other advice do I have?

My advice is that if you are looking for an aggregated level of data, using it for reporting, then it's better to use Power BI because everything will be in memory and it will be much faster.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

Private 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
November 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.
823,875 professionals have used our research since 2012.
reviewer1447446 - PeerSpot reviewer
Data Analyst at a tech services company with 201-500 employees
MSP
Easy to deploy and use, but it should support integration with more systems
Pros and Cons
  • "The user interface is easy to work with."
  • "More connections with other systems should be added, which would allow for other integrations."

What is our primary use case?

We are a service provider and Microsoft BI is one of the tools that we implement for our clients. We do not use it ourselves.

My primary use case is integration, but it is also used for reporting and data analysis services.

What is most valuable?

The user interface is easy to work with.

What needs improvement?

More connections with other systems should be added, which would allow for other integrations.

For how long have I used the solution?

I have been using Microsoft BI for between eight and nine months.

What do I think about the stability of the solution?

Microsoft BI is a stable product.

How are customer service and technical support?

I do not have experience with technical support. In cases where I have found an issue, I Google it, spend time learning about the problem, and then resolve it.

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

I have also used Alteryx and Informatica. We still may use one of these other products, depending on our client's requirements. If the client wants us to work using a specific product then that is their choice.

How was the initial setup?

The initial setup is straightforward and the deployment will take an hour, or an hour and a half.

What about the implementation team?

We deployed this product ourselves. It is easy to work on.

What other advice do I have?

I primarily use Microsoft BI for integration, so it is difficult for me to say what needs to be improved. Overall, this is a good tool and I recommend it.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user866316 - PeerSpot reviewer
Director, Education Management Information Systems with 51-200 employees
Real User
Ease of integration with various data sources and the dashboards are key for us
Pros and Cons
  • "Key features are its dashboard functionality and ease of integration with various data sources."
  • "It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."

What is our primary use case?

We use it primarily to create visualizations, along with very light analytics of education performance data.

How has it helped my organization?

We cannot truly speak to improvements yet, as we are just exploring it. Potentially, it can provide instant access to a very current state of affairs for school performance.

What is most valuable?

  • Dashboard functionality
  • Ease of integration with various data sources

What needs improvement?

It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool.

What do I think about the stability of the solution?

No issues with the stability.

What do I think about the scalability of the solution?

I can't speak about the scalability, but I can speak more towards the interoperability. There is a very rich capacity for sharing its functionality.

How was the initial setup?

It is a very simple application so there was no real setup. Just download it.

What other advice do I have?

My most important criteria when selecting a vendor are

  • cost
  • sustainability.

I would rate it at eight out of 10 because of its ease of use, simple setup, and excellent integration. I would rate it a 10 if they provided free training.

It's a wonderful application, it meets our needs.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Accountant at a government
Real User
Flexibility in analyzing data is helpful, but it needs to be simpler to use
Pros and Cons
  • "The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."

    What is our primary use case?

    I use it for budget analysis. I am in charge of budget analysis for the organization. I get figures from other units, and then I do a budget comparison with forecasting.

    The performance is very good.

    How has it helped my organization?

    For a long time I had to do everything manually, and it took a long time. At the moment, I just have to refresh and I get my report. A few clicks are needed. Once I get the data in the right format, then I have the report as quickly as it is required.

    It used to be stressful towards the month's end, to meet the deadline for reporting, especially when these reports are required by the board of the company. But now, as long as the other units give me my numbers on time, I don't waste a lot of time in preparing the numbers. I can now use my time in analyzing the outcome, rather than preparing the figures and cleaning up the data. It provides efficiency and saves time.

    What is most valuable?

    The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization.

    What needs improvement?

    They need to make it as user-friendly as possible. Make it as non-technical as possible. At the moment, if you are not a person who is familiar with modeling analysis, it might be a bit scary. So I think it should be a very simple user interface. It should be very easy to learn. 

    What do I think about the stability of the solution?

    It can be annoyingly slow at times, but I think it's because of the bandwidth, the connectivity we have. I've always believed if we had better connectivity, it would be perfect. Sometimes it's slow. But I really don't blame it on the solution. I blame it, but on my connectivity.

    How are customer service and technical support?

    I always just try to Google if I have issues, and a lot of time that is perfectly good. I just need to know the basics.

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

    I knew there must be a better way of doing what I was performing, so I searched. I did not have a previous solution, I just did things manually.

    How was the initial setup?

    It was easy. The only thing I noticed was that it was so slow. It took a long time to download, but again, I think that was my connectivity.

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

    At the moment I'm using a free version.

    What other advice do I have?

    When selecting a vendor, the most important criterion for me is, it should be something that is really user-friendly. By that I mean, I don't need to go through specialized training to learn how to use it; not in this day and age, when the solution should be really a solution. I don't need to be an expert to know how to use it. Just user friendly, click and go. Also, I think it should be something that assures me of its stability.

    For me, at the moment, it is the best thing that I've used. But I can't compare it to the other ones. It is the only one I know, apart from just normal financial modeling which I've used before. To me it is the best, but I can't really compared to any others because I don't know how the others work.

    Do your research. For me, this is the only one I know. But I know there are others which are better.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    PeerSpot user
    Information System Manager with 501-1,000 employees
    Vendor
    We evaluated both SSRS and Business Objects. We chose SSRS and currently use Cognos as well.

    I've been using Microsoft SSRS for 2 years. For me, the most valuable feature is the integration feature with our ERP. SSRS has room for improvement including drill down and graphs. Although I am happy with the products, I have experience performance degradation at times. 

    We're currently running both SSRS and Cognos. We ended up choosing SSRS after evaluating it alongside Business Objects. Once we chose to go with SSRS, we implemented through the vendor and found their level of expertise to be high which made the process very easy. I would say that our ROI is 200%. I would recommend SSRS to others.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    it_user115422 - PeerSpot reviewer
    it_user115422Works at a tech company with 51-200 employees
    Real User

    Try not to use scalar functions in your SQL queries (unless you want your reports to run all day).

    See all 3 comments
    Carlos Mardinotto Junior - PeerSpot reviewer
    BI Expert at a financial services firm with 1,001-5,000 employees
    Real User
    Top 5
    Fast and user friendly
    Pros and Cons
    • "You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
    • "Microsoft is behind IBM when it comes to security features."

    What is our primary use case?

    I've used it for work I did with three clients in the Brazilian banking sector: 
    Bank Bradesco, B&B Bank, and the Regional Bank of Brazil.

    What is most valuable?

    It's very fast and user-friendly.

    What needs improvement?

    Microsoft is behind IBM when it comes to security features.

    For how long have I used the solution?

    I've used Microsoft Power BI for about three years with different clients.

    How are customer service and support?

    You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have.

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

    I use Cognos Analytics 11 for some projects, but many of my clients prefer Microsoft Power BI because it is less expensive.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Senior Operations Coordinator at CambriLearn
    Real User
    Useful Natural Language feature, reliable, and good technical support
    Pros and Cons
    • "I have found the most valuable feature of this solution is the Natural Language tool."
    • "The solution could benefit by allowing deeper data analytics."

    What is most valuable?

    I have found the most valuable feature of this solution is the Natural Language tool.

    What needs improvement?

    The solution could benefit by allowing deeper data analytics.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately four years.

    What do I think about the stability of the solution?

    The solution is stable.

    How are customer service and technical support?

    I was satisfied with the technical support.

    What other advice do I have?

    I rate Microsoft BI an eight out of ten.

    Disclosure: I am a real user, and this review is based on my own experience and opinions.
    PeerSpot user
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: November 2024
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.