Try our new research platform with insights from 80,000+ expert users
it_user553431 - PeerSpot reviewer
Chief Tecnical Officer at a tech services company with 51-200 employees
Real User
​​All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.​​
Pros and Cons
  • "PowerBI – Self-service BI."
  • "People without private emails cannot publish and, frankly, this doesn't allow for easy training."

What is most valuable?

Microsoft BI Stack's best features are as follows:

SSRS – Self-service reporting and powerful subscription service

PowerBI – Self-service BI

MDS – Master data management

SSAS – OLAP Cube

How has it helped my organization?

Microsoft BI Stack improved the way our clients in the beverages (manufacturing and distribution) and the agro industrial sectors manage their financial reporting and board pack preparation, from one week to five minutes.

What needs improvement?

The following areas could be improved:

Publishing and sharing data using PowerBI.

People without private emails cannot publish and, frankly, this doesn't allow for easy training.

It's not always easy to speak directly with a MS Power BI expert.

You have to sign up to the Power BI service using an email address to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses.

For how long have I used the solution?

I have been using the Microsoft BI Stack solution for over five years in the beverages (manufacturing and distribution), agro Industrial, and telecommunication sectors.

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

What do I think about the stability of the solution?

I have not yet encountered any issues with stability.

What do I think about the scalability of the solution?

I have not yet encountered any issues with scalability.

How are customer service and support?

I would rate the level of technical support as 7/10.

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

I did not previously use a solution.

How was the initial setup?

The initial setup of the Microsoft BI Stack environment is complex, has many moving parts, and you need to know what you want for outputs to make effective use of it.

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

All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.

Which other solutions did I evaluate?

The following products were evaluated:
  • QlikView
  • Dundas

What other advice do I have?

If you want to dazzle your audience and, at the same time, show meaningful insights, then this is the best tool.

Disclosure: My company has a business relationship with this vendor other than being a customer:
PeerSpot user
PeerSpot user
Founder & Principal Architect at a tech services company with 1,001-5,000 employees
Consultant
Most complete business intelligence suite for the least money

Valuable Features:

Microsoft SSRS is a fantastic means for end users to access, run, and schedule delivery of reports. - Core functionality is simple to use for business users of all skill levels - Report models even allow end users to adjust their own reports using a model of your data - Report builder provides an even easier method for users to build their own reports - Report data can even be scheduled for periodic delivery with the report data as an attachmentMicrosoft SSAS is one of the best BI suites on the market. It is also one of the least expensive, and the features bundled rival competitors with prices many more times as expensive. - This feature is one of the most exciting areas of database technologies today - Very powerful and relatively easy to use when compared to other Bi suites

Room for Improvement:

- Active Directory authentication requires an additional login for users without Internet Explorer - Learning curve behind any business intelligence package is quite steep - Price of the SQL Server bundle is potentially cost prohibitive for smaller businesses

Other Advice:

I am quite passionate about the SQL Server suite of tools, and am a fervent user of SSRS. I use SSAS less, only because I am focused more on administration and have not moved into the SSAS space - yet. I am looking to head into the BI arena later on this year, and SSAS is my BI suite of choice!
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user4014 - PeerSpot reviewer
it_user4014Developer at a tech consulting company with 51-200 employees
Consultant

Hi Kleegeek !

Nice to read your review, while I was reading it I noticed some of the points which you might still not be aware of. Let’s analyze those;

SSRS: SSRS is a good reporting tool, but mostly it is used for static reporting, detail level reports, it doesn't provide the ability to dynamic dashboard with drill up / drill down options unless you define Action Item for each text box.

Microsoft provides Dynamic Dashboard with PPS or Power View where End-User can change the layout of the dashboard or grid on the fly, add different measures at rum time.

SSAS: The biggest selling point of Microsoft BI is its powerful Multidimensional Model, some of us known it as "Cube". With a craftily designed OLAP Model you can leverage the End-User to perform deep data analysis.

I would like to disagree with you on the point, that cost is the only selling factor or Microsoft BI, because QlikView and Tableau are both very cheap if you compared them with Microsoft BI, and they both provide nice dashboard and charts.

The selling point of Microsoft BI is its architecture and ability to handle the needs of enterprise requirements. In smaller industries QlikView and Tableau gives really tough time on pricing.

Regards,
Hasham Niaz

Buyer's Guide
Microsoft Power BI
May 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,823 professionals have used our research since 2012.
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
PeerSpot user
MSBI Technical Lead at a tech company with 10,001+ employees
Vendor
Top 20
It's been stable for over eight years, but is lacking a data warehouse manager.

Valuable Features

  • It's a user-friendly tool
  • Very stable
  • It always helps us to achieve organizational goals

Improvements to My Organization

It's been stable for over eight years, and all the latest products/versions have backwards compatibility, or an upgrade facility. It has helped to fetch many projects, and to deliver them on time, as well as helping to resolve complex business challenges. The product has continual updates so we can stay on top of the market.

Room for Improvement

  • Data warehousing manager is not available, which can be introduced
  • Reporting or SharePoint needs a lot of learning so you can build reports

Use of Solution

I've used it for 10 years.

Deployment Issues

No issues encountered.

Stability Issues

No issues encountered.

Scalability Issues

No issues encountered.

Customer Service and Technical Support

Customer Service:

Microsoft has a great level of customer service.

Technical Support:

There are great public forums available for tech support.

Initial Setup

  • Straightforward - installation, development, deployment, and maintenance
  • Little complex - Learning the tool

Implementation Team

We did it in-house.

ROI

I am not sure how to calculate this. The solution significantly improved BI and reporting capabilities. Without this solution, the business can’t think of successful operations.

Pricing, Setup Cost and Licensing

It is not costly when compared with other competitor products. This is a rock solid solution for any BI organization.

Other Solutions Considered

We didn't do much evaluation as our dev teams experience is with Microsoft BI.

Other Advice

This product is hassle free to utilize for your BI environment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user580566 - PeerSpot reviewer
it_user580566VP, Business Intelligence at a healthcare company with 1,001-5,000 employees
Real User

2016 is significantly improved as does Power BI with monthly releases. TCO is very inexpensive (Pro is 9.95 per month per user) with many data connectors, constant updates, well-integrated with Azure, powerful data blending tool and Power BI portal. Seems like comments here are not recently and this suite of tools is WELL worth the time to evaluate.

See all 6 comments
reviewer1501212 - PeerSpot reviewer
Part Owner at a tech services company with 11-50 employees
Real User
Great technology and some very good features
Pros and Cons
  • "Good CS and administration."
  • "Creating dashboards could be easier."

What is our primary use case?

I am a consultant for a big company. We deal with energy companies, petroleum, sales companies and we deal with everything from financials to operations. We deal with market strategy and we provide consultancy services - I'm a part owner of the company. 

What is most valuable?

I like the CS, administration, most of the features are good as well as the technology.

What needs improvement?

I think creating dashboards could be easier. Compared to other solutions, the cost of the license is expensive and that could be improved. 

For how long have I used the solution?

I've been using this solution for over 20 years. 

What do I think about the stability of the solution?

The stability is excellent. 

What do I think about the scalability of the solution?

The scalability is excellent, all our professional consultants use it. Where we deploy in the banking sector, they can have 1,000 licensed users; in smaller companies there can be 50 users. 

How are customer service and technical support?

Technical support is quite good, but I'd like to see a quicker response time. 

How was the initial setup?

Deployment time depends on the company, it can take up to two months. 

What other advice do I have?

I rate this solution a nine out of 10. 

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
BI Analyst at eVision Industry Software
Real User
Easy to use, good self service functionality, facilitates collaboration with other users
Pros and Cons
  • "If you are not very technical this tool could be very useful."
  • "Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."

What is our primary use case?

Power BI is a great tool for analytics. It is useful if you have a requirement to create a dashboard with self-service capability, along with KPIs, and you want to drill down to the data details.

How has it helped my organization?

I have tried SSRS and later moved to Power BISSRS requires every analytical feature to be implemented separately. However, with the appropriate granularity of data, you can drill down and drill up easily which gives you a different view of the dashboards. Now with having on-premises availability, it makes this tool even more powerful.

What is most valuable?

If you are not very technical this tool could be very useful.

The most valuable features are:

  • Self service
  • Inbuilt analytics
  • Custom visualization
  • Printing of dashboard helps a lot
  • Dashboard scheduling
  • Easy collaboration with other users on Power BI
  • Learning curve for this tool is small
  • Dashboard refresh rate can be configured
  • Power BI works both on-premises and cloud

What needs improvement?

Adding paginated reports to this tool could be of great help for users who want to move away from SSRS. 

I would like to see built-in Git support, incremental loading of data, and a machine learning model for predictive analysis.

Custom colouring from the dashboard itself would be helpful.

For how long have I used the solution?

I have been using Microsoft BI, SSRS, and Power BI for four years.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
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
reviewer956955 - PeerSpot reviewer
Sr Dot Net Developer at a tech services company with 11-50 employees
Real User
Good platform for data analysis, needs help with big data
Pros and Cons
  • "It is a good platform for data analysis, organization, and all of the other interim performances that are necessary."
  • "It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."

What is our primary use case?

It is a good platform for data analysis, organization, and all of the other interim performances that are necessary.

What needs improvement?

It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved.

Also, we post NGDP data and manipulating this kind of data could be better.

What do I think about the stability of the solution?

The stability is good but sometimes we need to validate the data. 

How is customer service and technical support?

Tech support helped us handle the implementation to completion. They were helpful.

How was the initial setup?

I did not find any complexities with the setup. 

Which other solutions did I evaluate?

We are a Microsoft partner so we did not look at other solutions.

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: May 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.