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.

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

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
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
Buyer's Guide
Microsoft Power BI
April 2024
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,857 professionals have used our research since 2012.
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
it_user553431 - PeerSpot reviewer
Chief Tecnical Officer at a tech services company with 51-200 employees
Consultant
​​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.

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 technical 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
Business Intelligence Consultant at a tech services company with 51-200 employees
Real User
Helps to create the board report pack for financial reporting. The graphical and dashboard reports must have tabs.

What is most valuable?

It is good for highly formatted reports.

How has it helped my organization?

It helps to create the board report pack for financial reporting.

What needs improvement?

There is need to improve the graphical and dashboard reports; they must have tabs. This gap is usually compensated by QlikView.

For how long have I used the solution?

I have used this solution for five years.

What do I think about the stability of the solution?

The product is stable. At times, it is slow when you use relational database as a data source, however it is fast when you use multidimensional cubes for high volume data.

What do I think about the scalability of the solution?

It’s easy to integrate with the other Microsoft products. However, it is not as easy when connecting to other data sources like SAP ERP.

How are customer service and technical support?

Technical support is good, I would give it an 8/10 rating.

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

As implementors or consultants, we use different tools.

How was the initial setup?

The setup was straightforward.

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

It’s free if you have MS SQL database license. It comes together with SSIS, SSRS, SSAS and other tools.

Which other solutions did I evaluate?

We looked at other solutions, namely Crystal Reports and Oracle BI Publisher.

What other advice do I have?

It’s cheaper to implement in terms of the licensing.

It works well, especially when implementing the whole stack of Microsoft BI solution including SSAS for data modeling and SSIS for ETL.

Disclosure: My company has a business relationship with this vendor other than being a customer: We are a consulting company. We implement projects on behalf of the clients and provide support.
PeerSpot user
it_user221220 - PeerSpot reviewer
Analyst in XBRL Projects at a financial services firm with 1,001-5,000 employees
Vendor
Poor support for XML, but it has good integration with other Microsoft products.

What is most valuable?

All the features are valuable.

How has it helped my organization?

We empower users with Enterprise BI and Self Service BI by Microsoft BI.

What needs improvement?

Microsoft has poor support for XML.

For how long have I used the solution?

I've used it for four years.

What was my experience with deployment of the solution?

There were no issues, and it has good integration with other Microsoft products.

What do I think about the stability of the solution?

We do have issues, but we can solve them ourselves.

What do I think about the scalability of the solution?

We do have issues, but we can solve them ourselves.

How are customer service and technical support?

Customer Service:

It's good.

Technical Support:

We are more expert than they are.

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

We used Infobeacon and then we added Microsoft BI to Cognos. We are currently looking for a better product and are evaluating Tableau.

How was the initial setup?

It is easy to implement Microsoft BI.

What about the implementation team?

Several projects we implemented through vendors and most we implemented in house. We are more expert than they are.

Which other solutions did I evaluate?

We didn’t have another option.

What other advice do I have?

Quality of data, flexibility and the performance of the tool(s) are the critical aspects of BI. Test the critical aspects by doing a proof of concept using a huge amount of data.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Project Business Analyst RPA at a consultancy with 11-50 employees
Real User
Compatibility with different databases, complete tool, helpful technical support
Pros and Cons
  • "The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information."
  • "The solution could improve by simplifying the user interface and adding integration or compatibility with APA."

What is our primary use case?

We use Microsoft BI primarily for analyzing data to construct indicators and dashboards. We use the information to better understand our business to make effective decisions about our business for the future, such as keeping competitive with other companies.

What is most valuable?

The most useful features are the ability to connect different databases to Microsoft BI and explore them. Once the database information has been extracted, you have the ability to construct indicators and dashboards from the information.

Microsoft BI is a complete tool, it has all the functions needed for its purpose.

What needs improvement?

The solution could improve by simplifying the user interface and adding integration or compatibility with APA.

For how long have I used the solution?

I have been using Microsoft BI for many years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable. We are able to see the users and the capability from the cloud platform.

How are customer service and technical support?

Microsoft provides good technical support.

How was the initial setup?

The installation is easy. However, there are many options and areas to configure that can be difficult.

What other advice do I have?

I would recommend those wanting to use this solution to take some courses to at least learn the minimal knowledge to analyze and construct indicators. This is a very powerful tool and if you understand it you can get the most out of it.

I rate Microsoft BI a nine 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
it_user825114 - PeerSpot reviewer
Senior Manager with 10,001+ employees
User
Ease of development and maintenance
Pros and Cons
  • "Ease of development and maintenance."
  • "Needs single sign-on."

What is our primary use case?

  • P&L
  • Revenue
  • Logistics
  • IT services
  • Stock control
  • Costs
  • Sales

How has it helped my organization?

  • Established a culture of management by indicators.
  • Improvement of services
  • Greater visibility of results

What is most valuable?

  • Predictable cloud environment
  • High performance
  • Ease of development and maintenance

What needs improvement?

  • Delta update
  • More than 10 GB of space
  • Single sign-on
  • More than 30 Windows to update by Power Bi gateway.

For how long have I used the solution?

One to three years.
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: April 2024
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.