Microsoft Power BI Reviews

Daily updated production indicators dashboard: We get production data (Number of pieces, downtime, and downtime reasons) from the shopfloor and input them on an Excel sheet. 

PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions.

With this solution, we were able to know which problems were critical and chronic. Once we used Power BI for production management, we realized that we could also use it for quality assurance, finance, and others types of management.

Interactive graphs are its most valuable feature.

Real-time updating needs improvement.

Two years.

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

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

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

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

Since its integration into SQL Server 2005, Microsoft has made a number of improvements and added many new features. It had a big overhaul in 2008 and acquired a bunch of new features with 2008 R2: KPIs, maps, sparklines, new functions, published Report Parts, and more.

Let me highlight some of the advanced features that keep people on the platform:

1. Drill-through reports. These are ones where links in the data presented take a report viewer to related reports. Information Builders is another BI platform where this is available, but not as customizable as in SSRS.
2. Highly customizable charts. The data-driven custom colors. The fact that almost every attribute of a component of a chart can be tweaked. Try doing some of those customizations on your flashy new cloud BI platform. Reports within reports. Sub-reports within tables of data and sophisticated charts within tables within sub-reports within reports. Go as deep as you want. See as much detail as you want.
3. User-accessible parameters. Reports can offer report users parameters like no other platform. This makes linking to and from reports easy and allows you to integrate SSRS reports into other business applications. Try sending parameters to an Excel spreadsheet, a Power View report, or a cloud-based dashboard – impossible.
4. Extensible. Programmers can extend the tool’s functionality. Custom data sources can be coded. Custom delivery extensions can be built. External DLLs can be referenced from within reports. Many companies do take advantage of these features.

The few things I mention below constitute very strong reasons why Microsoft has essentially abandoned the platform and why I agree with them.

• Lack of mobile support. Reports look terrible on mobile screens. They don’t have the ability to redraw themselves as with responsive UIs. Security remains a hassle on mobile because SSRS relies heavily on Active Directory.
• Speed of development is too slow. To be fair, each SSRS report has the potential to be its own business application, aware of who is viewing the report and customizing the output accordingly. Those that take advantage of the advanced features are in for a surprise – developers will spend countless hours squinting at the screen getting every pixel to fall exactly where they want it. Setting up data sources is still a thing for advanced SQL developers. It’s not like other modern BI platforms where stores of data sets are easily converted to dashboards.
• Antiquated IDE for code developers extending it. I really wish that the custom code windows provided richer programming assistance (like auto-complete, object-oriented constructs, Intellisense…) and support for other programming languages.

I have used it for two years.

We have not encountered any deployment issues.

• Long-running queries could take your system down. The desire of "I Want It All In One Report" should be avoided. All users should tune their reports and use parameters to get their reports in a light way.
• Internet Explorer could be tricky sometimes.

Customer service is 7/10.

Technical support is 7/10.

I switched from 2005 to 2008 in order to get more features.

It is easy to install and to integrate in an enterprise setting.

An in-house team implemented it.

The SQL Server Reporting Services works as a part of SQL Server license. If we have a licensed copy of SQL Server, we can run Reporting Services on the same server for no additional license fee. However, if we run Reporting Services on a separate machine that is not yet licensed for SQL Server, such as a Web server, we will need to purchase an additional SQL Server license.

https://www.microsoft.com/en-u...

https://www.brentozar.com/arch...

SQL Server Reporting Services is one of the most popular components of SQL Server, but it has always been surprisingly difficult to get from one place all the basic facts you need to get up and running from scratch, to the point of producing reports. My overall experience with Microsoft SQL Server Reporting Services is that it is easy to install and to integrate in an enterprise setting. Developing sophisticated reports, however, can be slow and tedious. Ultimately, getting information to business users is the name of the game. Doing it fast and doing it intuitively trumps fancy features.

We are a consultant company, so we use BI for project follow-up, sales and pipeline. We are partners with Microsoft and I'm the company's client director.

I like that implementation is very quick and that the solution is very user-friendly and easy to work with. The solution has provided us with speedy insight and faster effects on the table. It's a smooth product. 

I think that automation could be improved and performance enhanced. Documentation for developers could also be improved. 

The solution is stable. 

Scalability is very good. It can be pricey to move to the P1 licenses for $5,000 a month for smaller companies, but there are workarounds using A1 to A6 licenses which are cheaper and more flexible in the pricing. We have 50 users in the company. 

When we deployed five years ago, the setup was very complex. Since then, it's become much easier. 

Compared to competitors like Tableau, Microsoft BI is not so expensive.

I recommend this solution. Microsoft BI has matured a lot in the last year.

I rate this solution nine out of 10. 

Our primary use case of this product was for financial reporting and dashboard reporting. I'm a business development executive and our company is based in Belgium. 

The solution is stable with reasonable performance. The initial setup is relatively easy. 

The quality of the performance is dependent on the data source. If you have to pull multiple data sources performance is somewhat lacking. 

I've been using this solution for over a year. 

The solution is stable. 

The initial setup was straightforward and we had around 25 users in the company. 

We are fading out the use of this solution and we're switching to Tableau. 

I would recommend this solution if you have good knowledge of DAX. 

I am using this solution for official purposes and for my personal needs. I use it to sort my documents.

I have yet to experience all of the useful applications. I need to experience a lot more.

I would like to see better, undisturbed stability without any interruptions.

I have been working with Microsoft products for three decades.

I believe we are using Version 10.

Because our internet here is not constant, it fluctuates, which is why I don' use the cloud-based version.

It is not stable. The stability could be improved.

Microsoft BI is scalable.

We have more than 50 users in our organization. More of the users are technical people.

We have an IT technical expert in our organization. If we have any issues, he is the person who resolves them.

The initial setup is straightforward. It is very easy to install.

I completed the installation myself. I did not need the help of an integrator or consultant.

I am considering personalization but I don't know what the possibilities and the advantages of it are.

I would recommend this solution to others who are considering it.

I would rate Microsoft BI an eight out of ten.

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

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.

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.

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

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

My experience with technical support has been good.

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.

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.

We are using this tool for different departments. Mainly, it's connected with the ERP to show our users information that comes from data in different areas. For example, we are using Power BI in production on quality and logistics. We have created the appropriate package of data that is connected with Power BI to show our end-users the graphics, the figures, the key indicators.

It has helped us to have the information in a visual format, using graphical tools. Until now, we had to view the information on paper or in Excel files. With this tool, we can view the company's and departments' situation graphically.

It also gives us the flexibility to interact with the data. For example, we can see information for one year, or one month, or a given project, or two projects. And it produces the information very quickly.

• Easy to use. 
• End-users can make changes to the graphics.
• The tool runs very fast.

I am a SAP user and I would like this tool to have more connectors - and to more easily connect to - the ERP or SAP environment.

Also, I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data. Power BI, this global solution from Microsoft, is shared with multiple companies. I would like that the content that I create, my data, be available only for me, not shared with other companies.

It's very stable. I'm very satisfied with the tool.

For me, the scalability is sufficient.

I would rate technical support for this solution at nine out of 10.

As the IT manager in my company, I oversaw the resources and the setup of the solution but I was not involved on the technical side. But I think that it was really easy. It was not complex to set up.

My team did have to read a lot of technical documentation. We also contacted a company that knows this solution, one that has implemented it for other companies, consultancy-based.

Still, I have installed more complex tools in my company. This was one of the easier tools to put into production in my company in the last four or five years.

When selecting a vendor or product, the most important criterion for me is the usability - it must be easy to use. It must be one that end-users can learn to use on their own, so that the IT department does not have to make changes or solve problems for the end-users.

It's a good tool, easy to  use, Microsoft is adding more and more functionality.

My advice would be, always compare with other tools. In part this is own our internal rule, we must compare with others, to make sure we have the best tool.