- Running a team to build end-to-end BI solutions for large enterprises.
- Data typically stores in SQL Server. Some ad-hoc data pulled from SharePoint lists or Excel files.
- Use of SSAS Tabular in some models.
- Currently, no deployment of premium. A large deployment of PBI Pro.
- We also use Tableau Desktop and on-prem server, but Power BI was a go-to product.
Regional PDS - Director of Business Intelligence at JLL
I like it's ability to do almost anything to create the necessary calculated fields and measures (DAX)
What is our primary use case?
How has it helped my organization?
- An easy learning curve for analysts. If they know how to use Excel pivot tables, then they can self-serve building visitations on curated data.
- Full stack end-to-end ETL and viz in one tool.
- Power Query for ETL, and externally easy to use. Majority of activities are low or no code.
- Creating a model and augmenting with additional calculations and measures extremely easily.
- Viz layer build is super fast. Very much like a PowerPoint experience.
- All elements together allowed for the rapid deployment of PoC products that could be tested and validated by businesses before being deployed.
What is most valuable?
- Power Query: The data prep tool allows for very easy ingestion, shaping and prepping of the data before loading into the model.
- DAX: Its ability to do almost anything to create the necessary calculated fields and measures.
- Viz layer: It's just easy to lay out a page.
What needs improvement?
The only real need is a lower tier pricing plan around premium. It’s a big step-up unless you have a very large user base (1000).
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.
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.
Interim Manager Supply Chain / IT at a consultancy with 501-1,000 employees
It is connected to every database: Whatever and wherever it is
Pros and Cons
- "It is easy to work with and very chic."
- "Its connection to every database: Whatever and wherever it is."
- "The look is simple, and could be a little more professional."
What is our primary use case?
Its primary use case is for CIPs from the purchasing department. It performs perfectly. It is very quick and easy to use.
How has it helped my organization?
We approve it for use with SAP BI, so it has been more effective for our users and much cheaper. So, the costs are small and the benefits are high.
What is most valuable?
Its connection to every database: Whatever and wherever it is.
It is easy to work with and very chic.
What needs improvement?
The look is simple, and could be a little more professional.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
The stability is very good. We have no problems.
We receive an update every month with new functions, so we are not missing anything.
What do I think about the scalability of the solution?
The scalability is good. It works for a large community just fine.
How are customer service and technical support?
We have not needed to use technical support. We are able to do everything by ourselves. That is one of the main reasons that we like the product.
Which solution did I use previously and why did I switch?
We have SAP BI working. It has cost us more than a million Euro, and it does not work. This was one of the reasons to change.
Power BI is very easy to use and much sleeker.
How was the initial setup?
The initial setup was straightforward. 30 minutes, and it runs perfectly.
What other advice do I have?
I would recommend Power BI as the best working solution.
Most important criteria when selecting a vendor: Usability of the solution.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
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.
Principal at a tech services company with 1-10 employees
Gives business power users the ability to do their own work, without help from IT
Pros and Cons
- "In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
- "Allows business users with a mission to solve their own problems, without an IT person."
- "One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
What is our primary use case?
I have started a consulting business. So my use case is typically what my clients are doing. I've used it for healthcare analysis, headcount analysis, financial and performance analysis.
How has it helped my organization?
One thing it's doing in the early stage of an implementation is, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected.
What is most valuable?
The ability for business users with a mission to solve their own problems, without an IT person.
What needs improvement?
One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes.
What do I think about the stability of the solution?
It's not only stable but it's constantly improving.
What do I think about the scalability of the solution?
The scaling is dependent on the data source itself, so it's not dependent on the solution. SQL Server, which is one of the strongest enterprise databases, makes that a good thing.
Which solution did I use previously and why did I switch?
We were previously using Excel, and Excel did not have the ability to deploy nor did it have the ability to easily do some of the things that people were asking for. The switch was driven by being overwhelmed in the Excel world.
My most important criteria when selecting a vendor are
- usability
- the ability to develop solutions in an agile fashion
- the ability to have power users on the business side able to do their own work.
How was the initial setup?
It's very, very easy to get started. The complexity is the typical complexity in deployment, in that you have to have people make decisions on who has rights to what data. As far as the implementation, it's quite easy.
What's my experience with pricing, setup cost, and licensing?
Pricing, that's where Microsoft beats Tableau. It is priced much cheaper.
Which other solutions did I evaluate?
The short list was really only Tableau and Microsoft, and frequently clients have Microsoft products already installed so they have the security, the Active Directory, as well as the use of Excel, and the use of the collaboration tools like O365.
What other advice do I have?
I'd say that Microsoft and Tableau are both nine and a half out of 10, and it's per the requirements I already mentioned. They both are very high-quality, easy to use, stable, they both allow business users to do a level of development, and they're both highly deployable.
My advice to a colleague would be that they actually do short trials with each of the products they're considering and the check the vendors' support.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
BI Expert with 501-1,000 employees
Taboo? Microsoft in Higher Education
In a recent post, I discussed the changes in the business intelligence landscape as outlined by Gartner in their 2013 Magic Quadrant. Today, I wanted to focus solely on Microsoft as a vendor in this space. Yes, I mentioned Microsoft – and I work in Higher Education!
In working with a number of higher education institutions over the years, I often hear direct concerns about “Microsoft.” In the academic world, we are concerned about the most open way of doing things. We like to share – and you may have noticed by the adoption of Sakai and the Open Source Portfolio (OSP).
The emergence of open-source tools was prevalent over the last few decades. You now see many organizations running miscellaneous versions of Linux, open source wiki tools, Drupal-type content management systems – and now many have implemented Google (Google Drive, Google Docs, GMail). If you mention “Microsoft” – you’d better start running. You’ll have someone from IT chasing after you pretty quickly – and not in a good way!
Ok – you’re not Jack Sparrow, so you can relax a bit! But, you can imagine the feelings of many of these IT organizations when you start to implement enterprise-level software that holds a significant cost and the source is proprietary. Think Sungard’s Banner (now Ellucian), or PeopleSoft, and maybe even Workday now in some cases. Somehow, Oracle has slipped through the cracks as many of these large ERP vendors require Oracle’s database platform. Oracle was also smart and acquired mySQL – so they have an almost natural support of the open source community. Oracle is an investment, too.
You’re probably asking – what’s your point? My point is that Microsoft isn’t bad. It’s actually very, very GOOD! Besides the educational licensing, and the obvious love for Microsoft Office (Excel, Word, PowerPoint, et al) – let’s look at some of the benefits of Microsoft’s SQL Server platform. Let’s start with a basic point that is often overlooked. It is a suite of tools, not simply a database platform. I have listed a basic table below, but you can read more on Microsoft’s website.
Server components | Description |
---|---|
SQL Server Database Engine | SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, and the Data Quality Services (DQS) server. |
Analysis Services (SSAS) | Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications. |
Reporting Services (SSRS) | Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications. |
Integration Services (SSIS) | Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data. It also includes the Data Quality Services (DQS) component for Integration Services. |
Master Data Services | Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data. |
The great part of purchasing Microsoft SQL Server is that these tools come out of the box – and are included with the license for the database platform. There are several different editions which provide more or less horsepower as your project requires, but this is an added bonus that Microsoft bundles these tools.
Here are a few thoughts from my experience and why I enjoy working with Microsoft BI tools:
Technical Benefits:
- Relatively easy to deploy and installation is wizard-based
- Learning curve to adopt SSRS and SSIS is reasonable in comparison with other tools
- Direct integration with Windows operating system and Active Directory (this is great if you have a nice active directory structure already in place; not so helpful if you do not).
- Direct integration with Team Foundation Server (TFS) for version control
- Platform is sophisticated enough to handle complex tasks (i.e. stored procedures, SSRS data driven subscriptions)
Functional Benefits:
- All-in-one solution (combine with SharePoint for full functionality)
- End-user tools are intuitive and within a familiar Microsoft interface
- SharePoint can be used to pull information together in a one-stop-shop
- Office integration (i.e. Excel, PowerPivot)
Cost Benefits:
- Educational and non-profit discounts are a nice way for Microsoft to give back.
- License costs, on average, are lower than combining multiple tools from multiple vendors (this always depends on your situation and the license agreements that you have in place).
- Total cost of ownership (TCO) tends to be lower. This is due to the license fees and also the availability of technical resources that are familiar with the Microsoft platform. Again, this is completely dependent on your situation, but this is what I have seen with other clients. It may also be indirect, but by having all of these tools with one vendor, you spend less time managing 4 or 5 invoices for maintenance and renewals as well. And, if you need to renegotiate anything – it is again done with a single vendor not 4 or 5.
My Favorite Features:
- SQL Server Management Studio (SSMS) – it seems silly, but this a great tool and I enjoy testing my queries within SSMS prior to loading them into SSRS. It has some really nice features built-in for ETL developers as well (i.e. the ability to script the creation/deletion of a table with a mouse click)
- SSIS Package Variables – I use them frequently to make dynamic filenames in my SSIS routines. They are flexible and allow SSIS routines to handle a number of complexities that would otherwise be very difficult to address.
- Data-driven subscriptions – this is a great way to deliver tailored content to your user base. Same report…different content. In a previous consulting organization, I used data-driven subscriptions to improve internal processes and implementation times for external projects.
- PowerPivot – Let’s be honest. It’s just cool! In-memory BI is a hot topic. We also like tools like Tableau and Qlikview.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Expert Data Quality Management at a financial services firm with 1,001-5,000 employees
Stable product with efficient data updation features
Pros and Cons
- "It offers a lot of information and is very flexible and interactive."
- "The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."
What is our primary use case?
We use Microsoft Power BI to automate dashboards to present information to our senior management. It helps us extract the relevant data from the dashboard.
What is most valuable?
The product’s most valuable feature is data updates after modifying and refreshing the dashboard. It offers a lot of information and is very flexible and interactive.
What needs improvement?
The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version. It would be a very useful functionality.
For how long have I used the solution?
We have been using Microsoft Power BI for about a year and a half.
What do I think about the stability of the solution?
The product is stable. It works perfectly, and we haven’t encountered any issues working with it.
What do I think about the scalability of the solution?
It is a scalable product. We have around 100 Microsoft Power BI users in our organization. We are expecting growth in the number of users.
Which solution did I use previously and why did I switch?
We have worked with SAP BusinessObjects. Power BI is better because it has more flexibility and functionalities.
What other advice do I have?
I rate Microsoft Power BI a nine out of ten. I recommend it to users who want to pursue a career in data engineering. It will be very helpful and provides a lot of guides on the Internet, especially on YouTube. They can gain knowledge about its advantages and disadvantages.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Information Technology Architect at a financial services firm with 201-500 employees
A good solution that supports the Microsoft ecosystem and is easy to install
Pros and Cons
- "It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
- "The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
What is our primary use case?
We are using Power BI for reporting.
What is most valuable?
It is very good, and it supports the Microsoft ecosystem, including Excel, etc.
What needs improvement?
We have been using it only for a couple of months, and we are at the beginning of our learning. The area of improvement is difficult to say. The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective.
For how long have I used the solution?
I have been using this solution for a couple of months.
What do I think about the stability of the solution?
It is stable.
What do I think about the scalability of the solution?
We are not sure because we currently have a simple installation on the PC, but the idea is to scale it via Office 365 cloud implementation.
It seems suitable for small, medium, and large enterprises. It should be able to scale up. Based on the marketing slides, it should be able to handle all kinds of enterprises.
How are customer service and support?
We have not had any problems, so we had no requirement to use technical support.
How was the initial setup?
It is quite easy. You just need to install a program and use the connectors and drivers, and that's it.
What about the implementation team?
I did it myself.
What's my experience with pricing, setup cost, and licensing?
We are end-users, and we don't take care of the prices and accounting. We get a product and pay the fee to our internal service provider, but its price should be reasonable. Otherwise, they wouldn't have bought it.
What other advice do I have?
We are not very experienced in it. So, I don't know if I can recommend it, but we are using it because it is very good.
I would rate it an eight 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.
Chief Technical Officer at Value Partners
Offers simple licensing, good pricing, and an easy setup
Pros and Cons
- "We find the solution offers good stability."
- "Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."
What is our primary use case?
We are a consultant company so we use the many tools, just for our customers. However, we have professional services on, for example, Microsoft Power BI.
What is most valuable?
The initial setup is easy.
The solution is cloud-native.
It works well with Microsoft products.
The licensing is very simple.
We find the solution offers good stability.
You can scale the solution if you need to.
Technical support has always been helpful and responsive.
Pricing is quite reasonable.
What needs improvement?
They should improve the connector to on-premises data. Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources. You have a gateway. It's not very easy.
What do I think about the stability of the solution?
The solution offers good stability. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
The product scales well. If a company needs to expand it, it's not a problem.
How are customer service and support?
We use a couple of professionals from Microsoft directly for our clients, and we are really satisfied with them.
Which solution did I use previously and why did I switch?
We use SAS BI and Microsoft BI. I prefer Microsoft BI as, from a licensing point of view, it's easier as it's a per-user licensing. If Power BI is the right tool for companies, it's a shorter time-to-market approach to business intelligence.
How was the initial setup?
The initial setup is very straightforward. It's not overly complex or difficult. A company should have no issue with the process.
What's my experience with pricing, setup cost, and licensing?
We find the licensing to be very straightforward. It's easier to understand than other options on the market.
The pricing is fairly inexpensive. It's not a costly solution.
What other advice do I have?
We have a business relationship with Microsoft. We are a Microsoft Gold Partner for cloud products. In the past, we've used a lot of Microsoft products and also some of our clients have used them directly.
I'd rate the solution at a nine out of ten.
I'd advise that new users should take care of the technical architecture in order to connect in the right way to the data sources to extract data.
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
Head of Product at Bitz
Stable, easy to set up and scalable
Pros and Cons
- "The initial setup is easy."
- "The solution doesn't integrate well with third-party tools."
What is our primary use case?
We use that solution to provide all the KPIs for the software development to manage the business, et cetera.
What is most valuable?
The solution is very helpful for managing the business.
The initial setup is easy.
We have found the scalability to be quite good.
Stability is excellent overall.
Technical support is good.
What needs improvement?
For managing the business, it's okay, however, as a product management tool, it's lacking. I would like to use BI to provide services for the customers eventually. Microsoft's solution is not good for improving the product for the customers. It's just good for managing the business, and not supporting the customers.
The solution doesn't integrate well with third-party tools.
I'd like them to add to the knowledge base, or at least to offer more documentation about how to use the solution.
It would be helpful if more AI was integrated into the solution.
For how long have I used the solution?
I['ve used the solution since 2013.
What do I think about the stability of the solution?
I find the product to be quite stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.
What do I think about the scalability of the solution?
The scalability of the product is quite good. If a company needs to expand it, it can.
How are customer service and support?
We get technical support from a third party, however, they offer very good support and we have been quite happy with their level of service. They always have enough staff.
How was the initial setup?
The implementation process is straightforward. It's not overly complex or difficult.
Deployment took less than a month.
Which other solutions did I evaluate?
I'm also aware of Power BI, which has better integration with third-party tools.
What other advice do I have?
We do not sell Microsoft products. We just use them.
I'm not sure which version of the solution we're using.
We use both cloud and on-premises deployments.
I'd rate the solution at an eight out of ten. I'd recommend the solution to others as the management portion of the solution is very easy.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Popular Comparisons
Teradata
Amazon QuickSight
IBM Cognos
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
Salesforce Einstein Analytics
TIBCO Spotfire
ThoughtSpot
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?
I am a fan of Microsoft and totally love this write-up. Thanks Robert. Giving back to education and organizations that run for non-profits is a good way of giving back to the society at large.