We changed our name from IT Central Station: Here's why

Microsoft BI Valuable Features

Operations & BI Analyst at American Hospital Dubai

I’m going to go cover my TOP 5 Features for getting you started on your own visualisations so you can be up and running and leveraging Power BI within your own business in no time at all. Power BI Desktop Sure you probably want to build some beautiful and interactive reports and dashboards to share all those insights from your data with your business, but perhaps lacking the experience that report designers, data queries specialists or Excel Power Users have? Well now all your end users can easily access data and build their own reports using a simple yet powerful interface, Power BI Desktop. Power BI Desktop is a free download which provides an excellent canvas for creating your own masterpiece’s or perhaps just a simple report or dashboard tile. Power BI Desktop with its monthly release cycle is constantly evolving with newly added features or enhancements that can ‘bring data alive’ often in just a few minutes or hours. Visibility Data is arguably one of most precious resource that businesses are generating today. The key aim to be able to manipulate and easily combine this valuable data with other datasets, and then have a simple way to gain a deeper understanding of their business. With data often residing across multiple systems and formats, a valuable resource that businesses need is to be able to collate the various datasets and generate different ways to visual and understand it. In order to identify trends and relationships which were not previously visible and help make those important DECISIONS that business need to make every day based on the right facts. With a deeper understanding that comes from interpreting data in a visual form, the data world has become even more important for a business to be able to leverage and gain the competitive edge it needs; so it’s no wonder that Microsoft’s BI can provide so much value with the data-shaping and modelling capabilities to unlock hidden insights. Custom Visualisations Every business has its own culture and way of doing things, sometimes the ‘standard way’ of doing something just doesn’t cut it and a need to customise it to make it work is needed. The same goes for visualisations that come as standard with Power BI tool, which for some may not provide the depth or complexity of visualisation that is needed in order to ‘bring data alive’. However by accessing the growing library of custom visualisations or even creating ones that meet a specific need is perhaps a way to find a competitive edge. Import Excel Data One of the recent improvements that was added was the ability to import data from Excel. It has a wizard for making it very straight forward so your Excel ‘Power User’s’ now have even greater functionality to make sense of the data. Power Q&A Have you wanted to be able to ask questions in your own language and have it answered? Now Power BI makes that very easy with the Dashboard Power Q&A and the underlying data models. You just start typing in your question and the data model provides the context and answer which can then be manipulated to suit your own visualisation needs.

View full review »
BL
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees

What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable. And that's what it takes.

It makes use of the ordinary things, and they'll sound familiar. Excel, Access, or SQL Server as the database, and the deployment techniques like Azure for it to be in the cloud.

It's very heavily like Microsoft promoting its own products, but I forgive it because this time it works. And I'm speaking from some experience; I worked in the data warehouse technology group at Oracle for three and a half years, and I was helping Oracle's clients put up a data warehouse with Oracle as the database, and to migrate data into the Oracle database. So that was my background. And for me to be persuaded that this collection of regular, already known, already used desktop tools could work just as well, but with the added value of the samples, the templates, frequent updates, and lots of support. That says a lot.

It also has other features that I like, especially regarding the designs in the set of templates for things that would perhaps be very puzzling to somebody doing it for themselves. It has pre-built tables to hold, during project lifestyle, maybe a small select amount of test data with the intention of the large amount of data going into production after deployment. And it has all the table designs that start out generic but that can be easily customized.

View full review »
Northern Europe IT Business Intelligence Manager at Adecco

The tool is very flexible so it allows for creativity. Power BI allows you to incorporate Microsoft Visio diagrams and other graphics from Microsoft tools. You can also integrate third-party visual graphics created from other tools, such as R or Python. It is useful to be able to obtain additional charts or different types of graphics developed by a third-party tool. This gives you more options for your end solutions. However, for some third-party tools and graphics such as Zoom charts, you have to pay for those separately. This is useful if you really wish to mesmerize your audience with dynamic, interactive visuals.

Alternatively, if you just want to use what is available to you, and with a little bit of UX/UI knowledge and creativity, you can build really cool stuff with it. For example, you can have dynamic dashboards on a screen that is connected in real-time. Users can interact directly with the data, so when they click the mouse, they can see the data changing. There's a lot of things that you can do with it. Let's say you develop a report, to put on a big touchable screen. Let's say the CEO is presenting to someone, and he's on a big screen. As soon as he touches a dialogue or a graphic on the screen, all the data changes. 

As an example, in CNN news, or any news, where they are presenting, and there are some dashboards and reports, journalist clicks on the screen, and everything changes instantly. That's what Power BI can do. If you have touch screens Power BI allows you to interact with your data.

View full review »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
565,689 professionals have used our research since 2012.
Vice President at Shiluv

Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly.

View full review »
Software Engineer at syntegra

The data modelling and the use of decks are key features. It is difficult to create financial statements using most BI solutions, with decks it is a bit easier to summarize data and to have cascading totals that you would find in an income statement or balance sheet. Most other solutions, you can not have a moving total but with this solution, we found it very easy to implement. 

I also find connecting to different data sources is quite simple. Other solutions we were using before were complicated. 

View full review »
Owner at Pranali Consultants

The solution offers many features, however, just the way in which that product is designed is quite useful for us. 

The way in which it can connect to multiple data sources is also very useful. The way in which data can be manipulated by using data analysis expressions has also been a good feature for us.

The solution is stable.

The solution is quite scalable. 

Our clients seem to be happy with the level of technical support they receive.

With our experience, the initial setup is straightforward.

Microsoft is often updating the solution adding new helpful features.

View full review »
BI Consultant at a manufacturing company with 1,001-5,000 employees

Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features. When I say "missing features", I mean it in the sense that, even if you don't have a direct feature to do something, there are quite a few workarounds that you can figure out with DAX and M Query to make different situations work. I think these two are really the soul of the tool because they make a lot of impossible things possible.

View full review »
Solutions Architect at a tech services company with 11-50 employees

As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. 

The data preparation features were great. I much preferred the Power BI with the Power Query type features - at least for the datasets that we were working with. They were helpful in preparing the data.

View full review »
NG
Managing Director at Streamline Strategies

It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view. We publish a report every morning for the government, and we got all the data into one place. The data can be refreshed. We are using the API to connect to various systems, such as the financial system, contract writing system, and workflow. We are able to bring things from NIPA, which is their budget and where they keep all their money. There are a lot of features, but the most important thing is it is very easy to use. It is not like Tableau. With Tableau, you've almost got to be a rocket scientist.

On the user side, it is quite simple. If you know how to run a pivot table, and then you can do almost anything. All the data is right there in the database. So, if you understand pivot tables and know how they are run, and you know the reports that you are looking for, then everything becomes very easy to run in your organization.

View full review »
Business Application Group Manager at OBASE

The solution has different licensing tiers.

The product can scale if you need it to.

Technical support is quite good.

With the cloud deployment, there's no setup required.

The product works well for small or mid-level organizations.

View full review »
President & Owner at Altrim Systems

It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis. People want to know, for example, which customers are purchasing which products over what time period. It's very simple to make visuals for them. We create a matrix that resembles a spreadsheet and then link it to various graphic visuals, pie charts, and other types of charts. They also get a visual sense of what's going on. Those features are fantastic.

View full review »
VK
CFO at Travel Food Services ltd

I like that the interface is very fluid in the sense that you can upload via Excel or you can attach via connectors, any software you like.

View full review »
Manager, BI & Analytics at Perceptive Analytics

Two valuable most features are the ability to create columns and create measures.

The create measures feature offers you a little bit more flexibility. You can define what kind of measure you need using a formula, and the way Power BI works is very similar to Excel. In fact, most of the functions that you use in Excel are present in Power BI as well. When you create measures or columns, you just write the formula as you would in Excel, which will allow you to visualize that data in the way that you want.

View full review »
AA
Solution Architect

The most valuable feature is the data flow related to the container and the control flow. Microsoft has recently introduced paginated reports in the status part. These are web-based and also mobile-based, depending upon the layout of the report. It can be easily printed in Word format as well as in layout format, regardless of size. 

View full review »
RP
VP Cloud Platform

I love the fact that it's got a very intuitive user interface. 

I like the fact that you can create aggregations and view measures and metrics on the fly. 

I like the visuals themselves as all of our customers are moving away from Excel and this gives them a very unique way to have their data represented in a more visual manner with active slicing and dicing data right there, with the time dimensions and different dimensions. 

I also like the automatic refresh mechanism that it can do. You can have the data refresh automatically every 30 minutes, for example.

The initial setup is pretty simple. 

The stability has been pretty good.

The solution can scale.

Technical support has been great.

View full review »
MS
Program Director Education Technology & Data Services at a government with 5,001-10,000 employees

I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice.

View full review »
RU
Chief Manager at a insurance company with 5,001-10,000 employees

The alert features are great.

The initial setup is pretty simple. It's a straightforward setup in our industry in particular.

The solution can scale.

We've found the solution to be stable. 

I learned data management and also visualizations on this product, and they are very interactive. Those two things are very strong points for Power BI.

View full review »
Director Comercial at Grupo Consultores

Constant collaboration is the most valuable. I can build a dashboard, and several co-workers can access this dashboard. We can share information that is important for decision-making.

It is a very easy-to-deploy solution. It is compatible with a lot of data sources. It is also very stable and scalable. There is also a very good forum and a lot of help and online training.

View full review »
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa

Its integration with the Microsoft Office Suite is great. I can easily connect it to any of the Excel or any CSV files, and I can immediately create a dashboard. 

It's like the higher level of pivot tables. For the people who mainly use Excel, this is like an advanced version. This is much more flexible and I don't have to train people to use it, as it's very user-friendly compared to Qlik. Qlik needs some expertise and a layman cannot immediately go to Qlik and do stuff unless he understands it. When it comes to Power BI it's a five minutes tutorial, he can definitely understand what needs to be done.

The solution is stable and scalable. So far I don't have any issues, however, it depends on the amount of data we use. I'm just running it on my PC.

The initial setup is straightforward. 

The solution is free as it's bundled with Office 365.

View full review »
Technical Director at Progetti e Soluzioni

It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. 

It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs. 

View full review »
BN
Compensation Coordinator at a computer software company with 1,001-5,000 employees

The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time.

It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet.

View full review »
Owner at BNS

The data visualisation is very attractive from the user's point of view. Users see their reports and think "Wow - that is amazing". 

However, it is much harder to prepare data for reporting. I would say 95% of your development time is spent gathering, cleaning, and modelling data. However once that is done reporting is easy.

View full review »
LB
Director of Sales and Marketing at a tech services company with 11-50 employees

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.

View full review »
Consulting Practice Partner - Data, Analytics & Artificial Intelligence at Wipro Ltd

What I like most is that I can do everything in Power BI that I can do in Excel. It is very compatible with Excel tools, and anybody who works with Excel can learn and use Power BI quickly. 

Writing formulas and data transformation are good features.

View full review »
KB
Managing Partner at a tech services company with 51-200 employees

The most powerful site of Power BI is the cloud site. You can do everything in power BI. There are lots of things that the solution provides. If you have a huge data warehouse in the cloud, Power BI fits. 

In some cases, there are some add-ons that you can put together in Power BI - for example, data factory, data bricks, and also data lakes. Some Microsoft solutions work together and are integrated already. You don't need to worry about that.  

If you know what you do, Power BI is a good solution.

The solution is stable. 

The product can scale. 

View full review »
Chief Data-strategist and Director at theworkshop.es

It's a great tool for visualization data, and it's free for engineers. Microsoft BI has a good online community. You don't need to be an engineer to use it. In Microsoft BI you can embed the visualisation and reports into your applications. Embedded items are much faster and cheaper to use. It's very easy to work with the customers using this kind of tool, rather than say, Oracle. I have used the personal edition, but some customers have been trained to use the professional version. Initially, I spent a lot of time learning the new system. As I was already experienced in other, similar technologies it was not difficult to understand the visualizations. I encouraged our clients to do more with Microsoft BI.

View full review »
FB
Project Leader at a tech services company with 1,001-5,000 employees

The solution is flexible and works across industries.

I do love the way a user can flexibly design items. You can add and use Docs, for example.

The initial setup is pretty simple. 

We have found the solution to be stable.

Our team finds the solution to be scalable. 

The solution has a robust online and blog community that's great for troubleshooting.

It has Power Automate available, however, I have yet to try it out. It's something I'll look at next.

View full review »
AS
Technical Analyst at a energy/utilities company with 10,001+ employees

Microsoft BI has a multitude of additional features. Overall it's an EDA tool, from which you can extract, transform, and load data. You can pull reports, visualize them in real-time, and connect them to a variety of other data sources.

When I compare other analytical tools to Microsoft BI, I believe Microsoft BI is far more accurate, and the frequency is also better.

It has additional features, which are very much useful. The most important thing I like is that it is just a data platform connecting to the overall process and it can be utilized in any sector.

View full review »
Technology Solutions Professional at OrchidaSoft

Defining the most valuable features would take a long time. While I cannot point to a specific feature, I feel the solution provides a full range of implementation capabilities. This allows for integration and modeling, for carrying out good transformations within the same platform, as well as visualization. There are not many products included inside and one can start from scratch. 

In respect of the customer, one can quickly implement phases. A person can start out with creating his data set on a miniscule amount of the client's work and, working solely with a sales team, make it agile, only involving three or four dashboards. At this point, completion is possible and progress may be made to the next one very quickly. We like the solution's ease of use, functionality range and ability to be quickly implemented. 

View full review »
SV
Consultant at a computer software company with 10,001+ employees

I think the visualization part is valuable. It's also very easy to build new dashboards. It's fairly intuitive for people who understand the Microsoft Power BI tool.

We're fairly happy with the product in terms of both configuring the Microsoft BI dashboards and making changes to them. It's fairly easy to make changes.

View full review »
RT
Information Architect at a government with 10,001+ employees

It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable. 

View full review »
KD
Senior Technology Architect/Strategist at a aerospace/defense firm with 51-200 employees

Its ease of use is most valuable.

View full review »
GB
Director, IoT and Connected Products Portfolio at a computer software company with 10,001+ employees

The solution has been stable.

We've found that the scalability meets our current needs.

It's good for data visualization and analysis. 

My understanding is that the initial setup is pretty easy.

Technical support has always been great for us, as strategic partners. 

View full review »
AG
Digital Strategy Manager at a energy/utilities company with 10,001+ employees

The solution overall works quite well, especially if you have a Microsoft-heavy ecosystem.

The ease of creating the dashboard is quite good. 

The analytics are very strong when we couple it with Azure. It offers very good Big Data Analytics that work perfectly well. 

Scalability is not at all a problem. 

You can perform the role-based access perfectly. It gives you everything you need with a single sign-on authentication due to the fact that we are in the Microsoft environment.

You don't have to worry about security. That is very robust.

What matters most is the turnaround time to create a solution, which is quite fast. This is due to the fact that it's quite intuitive in nature. Even those new to the solution can create solutions very quickly. There isn't a high learning curve.

The initial setup was not difficult.

The pricing has been pretty good. 

Technical support is quite responsive.

Overall, the solution is quite intuitive.

View full review »
BI Analyst at Infosys Technology

I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it.

View full review »
Lead Technical Instructor at codehub

I consider the solution to be quite good. In contrast to what we were using before I think that Power BI has given us more extensive results. It's more intuitive and it is better for understanding the whole process without much code. We're only using the user interface, not writing code.

We find it to be easier and it provides a better understanding of the results, both for us and our customers.

View full review »
NA
Portfolio manager at a transportation company with 5,001-10,000 employees

Microsoft Power BI is a very powerful tool. It allows us to extract data from Excel or Share Point. 

We can send various project reports from the dashboard to management. It allows us to set up our own preferences. 

We can work with all sorts of data from the previous year or two. With that native data, we can have everything in one dashboard that accurately reflects the reporting. The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible. 

The solution has been very stable so far.

We find the product to be quite scalable. 

View full review »
CEO at Finanblue

Power BI has a unique set of APIs to connect different databases on different systems. It means that I can extract data from a variety of sources and systems. It's very flexible. I work with numerous systems. We have new systems, super fast systems, and I have very old systems that run very well. They don't need updating because they run so well. Power BI has the power to connect with different sources, and I have a data scientist that orchestrates all that data because it's also about understanding the data, the application of intelligence and strategy on the data, and exposing it on the dashboard. 

View full review »
BV
MI Manager at a recruiting/HR firm with 1,001-5,000 employees

It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation.

Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution.

Their technical support is very good. They are extremely responsive, helpful, and hands-on.

View full review »
AB
CEO Gerente General at a tech services company with 51-200 employees

There's not one specific feature we prefer. I would say it depends on the customer and the processes. What is important to one user may not be as important to another. There's no one feature that excels over another so that we don't see it like second place.

The product offers very good efficiency.

The solution is very stable.

The solution can scale well.

The documentation on offer is good.

We found the initial setup to be straightforward.

View full review »
Data Science Intern at Clockworkx Gmbh

I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data.

View full review »
SA
General Manager at a tech services company with 51-200 employees

The stability is good.

It's pretty easy to set up the product.

For the most part, users can scale the solution.

Technical support is okay.

It's a great option if a business is already heavily involved with other Microsoft tools. 

View full review »
Cognos Consultant at Surtel technologies

When we have done training in the cloud previously, I have a long experience in BI tools. I've worked on Cognos BI, Informatica, and other tools including QlikView. 

The solution is stable.

The scalability is good.

There are some great automation elements in the product.

It's a good tool and designing dashboards is easy.

View full review »
BG
Data Analytics Specialist at a pharma/biotech company with 10,001+ employees

The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with. 

View full review »
Advisor to the Zambia Revenues Authority at GIZ
Microsoft BI was choosen among different proposed solution due to the fact that there was a local knowledge by the staff. Its integration with other Microsoft products used by the administration was also taken into account as being easy. The "already seen" effect was ensuring the staff trust; precious when making a big organisational change : we have observed that staff was more confident to stick to something they have already seen in the past rather that a totally revolutionary approach. The self-service tool is much appreciated. View full review »
Co-Founder at Beta Edge Technology Limited

The most valuable feature is shareability, where we can publish work to the cloud and share it with team members. If you want to build a dashboard then you can publish it to the cloud, and then add people. This will give them access to the dashboard where they can review it, and modify it as well.

They have a mobile option that allows you to see the dashboard from your mobile phone, rather than having to look at your laptop.

View full review »
BI Consultant at a manufacturing company with 1,001-5,000 employees

There are many good features in this product.

The most valuable features are a combination of the DAX and the inquiry capability, plus the visual gallery that we have. I think that these three things, or the combination of them, is the best that we have found.

View full review »
SH
Project Manager at a computer software company with 5,001-10,000 employees

The product is very user-friendly.

The solution can be used with any BI tool you have.

The initial setup is pretty straightforward.

The solution has been very stable for our customers.

It appears the solution has the capability to scale, although we have yet to try to do so.

View full review »
TB
Solutions Architect at a tech services company with 11-50 employees

Some of the most valuable features of this solution are the ability to take your data and have the possibility to combine them into datasets and have synchronization. 

You are able to synchronize the data without additional cost eight times a day and you can set when you want to synchronize it. For example, during business hours, we synchronize the data once an hour and during the night I do not synchronize it at all. 

The capability to add custom visuals and create Power BI apps. You can package datasets, synchronization details, and dashboards into a single app.

Microsoft is open to suggestions for improvements in future releases. We requested to allow Python Notebooks to be displayed as visuals on top of the datasets, which now available and was not five versions ago.

View full review »
Assistant Vice President at a tech services company with 10,001+ employees

Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python. 

View full review »
CB
Business Intelligence Developer at Kathmandu

The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on. But I need a way to work on getting the data showing correctly and be able to drill down into a worksheet like Excel, as people like to know what the top-level information means. It's important to be open and show them what they want. The number of visualizations is great. So many different options to choose from like heat maps to pie charts.

View full review »
MK
Executive Vice President at a security firm with 201-500 employees

The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities.

View full review »
ND
Business Intelligence Manager at a tech services company with 51-200 employees

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.

View full review »
Senior data Engineer at a tech services company with 1,001-5,000 employees

The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything.

View full review »
IH
Advisory Software Engineer at a tech services company with 1,001-5,000 employees

The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. 

I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use.

View full review »
Principal System Developer at a government with 51-200 employees

What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily.

The best thing about Power BI is that you can manipulate the data within Power BI, so you don't have to update the data source to have filtration or conditional formatting. You can easily do those things under Power BI.

It is easy and has rapid development.

It is stable and scalable as well.

View full review »
Summer Intern at a financial services firm with 10,001+ employees

Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard.

There is a lot of self-help content available from a lot of different platforms, such as YouTube. So, whenever I faced an issue, it was not difficult. I could always find a solution to the issue I was facing.

View full review »
Senior Oracle Application Consultants at a comms service provider with 10,001+ employees

It is stable.

It has good functionality and is fully integrated with Microsoft products. If you have already a direct connection or direct integration with Microsoft products, it is very good actually. In some cases, we just developed our BI dashboard and sent it to PowerPoint, for example. It'll be published as the power BI format, which is very good as a feature, to have that capability to just easily populate everything in PowerPoint.

Like all Microsoft products, it is very easy to set up initially.

It's pretty user-friendly.

The product can scale.

View full review »
MJ
Global Director - HR Technology & Platforms at a manufacturing company with 10,001+ employees

In general, we are pretty pleased.

The ability to combine the data and to connect with pretty established platforms has been the solution's most valuable aspect to us. 

The fact that you can visualize items is great. The visualization power is very good.

The initial setup is straightforward.

View full review »
TS
Cloud business Director at a tech services company with 51-200 employees

The amount of customization that you can do is good, and it's relatively straightforward to do. People with limited experience in terms of coding can implement this themselves. If an organization doesn't have a high amount of skill, internally, then it's something that they can still spin up themselves, relatively well.

View full review »
Inovation Manager at SoCalGas

My favorite feature is the power query editor, where it can do the data transformations.

View full review »
Inovation Manager at SoCalGas

The standard BI visualization capabilities are great. It makes all the visualizations and has a drag and drop builder. It also has a power query data modeling capability that's excellent.

View full review »
CA
Contact Center Consultant at a consultancy with 51-200 employees

Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau.

You can set Microsoft BI up for administration to use it and then you can set up views for your end-users to look at. For example, if you are a report analyst you could have your marketing person wants Microsoft BI to report on how many widgets the East Coast sold in five years, if you set Microsoft BI up the right way, they can retrieve that information themselves. You save manpower from your IT staff.

Microsoft BI is a lot easier to analyze data than with other solutions, such as Excel.

View full review »
AE
IT Service and Strategy Consultant, Facilitator at BCAP SOLUTIONS

BI is very easy to use including the desktop version. The visualization is valuable, it's easy to select visualizations and show your data in different views. It opens up a lot of possibilities that weren't previously available and it's versatile. We're integrating with other solutions and if you look at Power BI pulling information from the data warehouse, it's integrated to an Oracle warehouse and works well.

View full review »
PC
Senior Consultant at a computer software company with 10,001+ employees

The product has a very defined, well-prescribed format to it. It's easy for everyone to use for the most part.

The training is pretty good. It's well-described so that users can navigate the solution easily and follow the correct steps to initiate tasks effectively.

The user interface is pretty good.

The technical support on offer is excellent.

We've found the scalability to be quite good.

The solution's initial setup isn't too complicated.

View full review »
Lead Senior Engineer at a manufacturing company with 10,001+ employees

The solution serves its purpose. When you have the recurring cost every year on this other project, Qlik Sense didn't fit with it as you'd have to have Qlik Sense plus something else. 

As long as you don't need the data in real-time, it's okay.

The solution is stable.

We have found the product to be scalable. 

View full review »
BI Solution Engineer at DataSelf

It is a little easier at buildings charts and graphs than Tableau.

View full review »
RA
Manager Technical Architect at Legato Health Technologies

It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well.  

View full review »
VC
CEO at a tech services company with 201-500 employees

The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter.

View full review »
ST
New Build Completion & Commissioning at a energy/utilities company with 1,001-5,000 employees

The solution is a wonderful tool overall. 

Power BI is very powerful and very easy to use. Its user-friendliness is one of its most valuable aspects. It has a very nice user interface that makes everything easy to navigate.

The product can go easily go and extract data and it can put it into any format.

It's a very good data analytic tool.

The initial setup is pretty easy. It's pretty straightforward in general.

View full review »
LC
MBA, MS Business Analytics at a consultancy with 1,001-5,000 employees

The most valuable feature of Microsoft BI is its visualization and its ease of use.

View full review »
Senior Analyst at a tech services company with 10,001+ employees

Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.

We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.

View full review »
SU
Head of Digitalization at a mining and metals company with 5,001-10,000 employees

Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable.

View full review »
PH
System Specialist at a government with 201-500 employees

The interface is great.

The DAX function center and integration with Asia have been great. 

It's a powerful platform.

The product is robust and stable. 

You do not have to maintain the product. It's very low-maintenance.

Technical support is helpful. 

View full review »
JG
Associate Data Analyst at a financial services firm with 10,001+ employees

The most valuable feature is the infinite possibilities when it comes to visualizations. If a particular visualization is not available as a default or in the market, you can just load in a Python nr script and get a visualization from that. It's very flexible in that respect and opens up a plethora of opportunities. The huge number of connectors that are available is also a big advantage - BI can connect to various things, even competitors like Google's Data Studio, and it is even able to connect to various Google data sources and be a powerful alternative to Data Studio. It's also a data modeling tool, so it keeps everything within the app, which is really convenient, allowing the pipeline to complete itself in a more fluid way.

View full review »
BK
Manager - Customer Success at a tech services company with 10,001+ employees

The solution isn't hard to use. It's very user-friendly. 

The product is stable. 

The product is easy to install.

View full review »
Business Intelligence Coordinator Latam at a construction company with 5,001-10,000 employees

I like how it has the capacity to share the contents of the report easily. The data validation is great, too. It's easy to learn, so it's easy to teach how to use the Power BI for a team, and it's easier to build the parts.

View full review »
OZ
Business Intelligence Developer at a manufacturing company with 51-200 employees

What I like about Power BI compared to Tableau, for example, is that Tableau is mostly a visualization program, but Power BI is a more complete solution, because it has DAX, Power Query, and a presentation and graphic layer. So, I use it not only for reporting and graphic purposes on the frontend, but also for doing things like modeling. It is very flexible, a lot more flexible for than Tableau for what I need.

One of the things that I appreciate is that premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month. I'm investigating in that because I think the price is good. 

View full review »
RH
Head of Analytics Director at a tech services company with 51-200 employees

It is low-cost and easy to deploy. It is fully-featured.

View full review »
Director at Decision Science

I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story.

Data Modeling is very simple and powerful for an experienced user, but I think it needs some improvement for the non-technical people. Besides this, it allows us to save a lot of time in data "massaging" prior to the analysis phase.

Reports are quite easy to build, even when some programming concepts are needed. Some users struggle with DAX a lot!

View full review »
ES
Founder & CEO at a tech services company with 1-10 employees

There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly.

View full review »
Chief Technical Officer at Value Partners

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.

View full review »
Assistant General Manager at ELEVATE Solutions Limited

The customization and management are very easy. 

We have found that the reporting and publishing are great. Sometimes people like to use the report for their teams.

The initial setup is quick and easy.

The solution is scalable.

It's reliable and the performance has been good.

The cost of the product is not too high.

View full review »
SM
Data Warehouse Engineer at a government with 1,001-5,000 employees

The solution is very stable.

The product is easy to use and simple to navigate.

The product has proven to be quite flexible.

It is quite scalable and it is doing the work that we want it to. 

View full review »
CK
Analyst Operations with 5,001-10,000 employees

In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well.

View full review »
SS
Graduate Engineer at a transportation company with 5,001-10,000 employees

One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably. 

View full review »
AE
Junior Data Scientist at a university with 5,001-10,000 employees

The transforming data before you start with the visualization comes in pretty handy.

It is quite easy to use and it helps me to achieve the projects that I've been assigned.

I have never had the inability to perform the tasks I've been assigned with the software. 

It's very useful because you can create helpful reports, which assist you to analyze data in a very organized way.

View full review »
FM
MCSE at a financial services firm with 501-1,000 employees

I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology.

There are plenty of visualization tools, a lot of functionality, and documentation.

View full review »
RB
Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees

We like the drag and drop interactability visualization. We really like that. It's user-friendly.

View full review »
NN
Functional Consultant at a manufacturing company with 1,001-5,000 employees

The solution is very stable.

The scalability overall has been quite good.

We found the initial installation to be very straightforward.

View full review »
MF
PMO at a consultancy with 10,001+ employees

What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand.

View full review »
RD
Senior Manager.Marketing Strategy & Analysis. at a marketing services firm with 10,001+ employees

The solution integrates with other Microsoft solutions very well. 

When it comes to security Microsoft BI can integrate well with Microsoft Domain Services, you are able to make it as secure as you want.

There are useful visualizations available in the dashboards.

View full review »
AN
Senior Manager: ICT Compliance at DEPARTMENT OF PUBLIC SERVICE AND ADMINISTRATION

The solution is stable.

It's a pretty scalable product.

Overall it's a good product. It is still rather new, therefore, for now, it's still a learning curve as we get used to all of the features and capabilities.

View full review »
LL
Head of Product at a financial services firm with 51-200 employees

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.

View full review »
AB
Data Science Leader at a tech services company with 11-50 employees

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.

View full review »
IT Project Manager at a manufacturing company with 10,001+ employees

The most valuable feature of this solution is real-time report tracking. For example, we have a report for a human body and the human body is populated with injury data. In real-time, we can see where most of the injuries have occurred. 

View full review »
SK
Project Manager at GlaxoSmithKline

I like the toggling feature, the ability to switch from one page to another. 

View full review »
WK
Managing Director at Innovative Business Analytics

The virtualization of Microsoft BI is very good.

View full review »
Managing Director at IDMdev Tech Solutions®

The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable.

View full review »
Team Leader at Eurobank EFG Bulgaria AD

It's similar to Excel, but it's much more powerful than Excel. I love the unlimited number of rows that can be processed, the grant server application, and the strong security.

It produces a very nice picture — very nice graph managers that are very attractive.

The way you prepare your reports is very intelligent and intuitive. 

It's very easy to operate and the dashboard is great.

View full review »
MB
Power BI Technical Specialist at a manufacturing company with 1,001-5,000 employees

We are able to collaborate on things and get insightful data visualizations.

View full review »
GS
Operations Center Technician at a renewables & environment company with 501-1,000 employees

I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use.

View full review »
AK
OBIEE/ODI senior consultant at Kastech

The visualization part and its inclusion in a cloud-based application are valuable features. 

View full review »
SK
Partner at a tech services company with 1-10 employees

The solution is easy to use.

View full review »
RR
Accounting Services Finance Manager M&S at a hospitality company with 10,001+ employees

We're making a dashboard that can show specific details and can be easily customized. It's very useful for creating dashboards.

The reporting is good.

The solution is stable. 

We can scale it if we need to.

It's a very easy-to-use solution. The product is quite user-friendly.

View full review »
DB
MIS Specialist at a agriculture with 201-500 employees

Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it.

View full review »
Business Analyst at a non-tech company with 10,001+ employees

Microsoft BI is easy and but not very user-friendly. But you can directly connect it to an Excel file. You can find out how many sites to look at and do it yourself directly. The Microsoft Power BI app is very good. It's also very flexible. 

View full review »
BS
Engagement Professional at a consultancy with 51-200 employees

The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive.

View full review »
YS
Head-IT/SAP at Barista Coffee Company Ltd.

The solution overall is very useful. The reports that are generated and the reporting functionality management are beneficial.

View full review »
Sales Director at Expeditus (Pty) Ltd

Microsoft BI's dashboards are helpful.

View full review »
CM
Technical Director, Information Management at a construction company with 5,001-10,000 employees

Reports, dashboards, and visualizations are most valuable.

View full review »
Founder/CEO at Data.tac Nigeria Limited

Microsoft BI allows us to connect to any database or any dataset. It automatically renders some of the information which makes things a lot easier for us.

View full review »
Innovation & Project Portfolio Management Practice Director at FACTUM

We only use it for export and import, but that suits our purpose, along with the dashboards.

View full review »
Lead Business Analyst at a media company with 501-1,000 employees

Power BI allows you to create user-defined charts which is really useful. 

The Power Query button in the power tabs is a unique selling point and is very useful.

View full review »
SS
Data Analyst at a tech services company with 201-500 employees

The user interface is easy to work with.

View full review »
Technical Manager at a computer software company with 201-500 employees

Microsoft BI is easy to implement, as it is a web-based product that doesn't need to be installed.

This product has a lot of features and most of them are user-friendly.

The visualizations are pretty easy to create. In fact, if you want to create anything new, it is pretty easy to do.

The reporting capability is good.

View full review »
Manager, BI & Analytics at Perceptive Analytics

Microsoft BI is easy to use and simple.

View full review »
CW
Certification Division at a manufacturing company with 11-50 employees

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

View full review »
CM
Project Business Analyst RPA at a consultancy with 11-50 employees

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.

View full review »
SK
System Engineer at a financial services firm with 10,001+ employees

Power BI is more powerful than other tools because it is new for us. Each new version has more capabilities, and we're expecting AI and ML features in the next version.

View full review »
RZ
Head of Global Services Business Performance Management at a comms service provider with 10,001+ employees

The most valuable features of Microsoft BI are the variety of possibilities to connect to various data sources. The visualizations are easily done, have useful rollover functions, and there are continuous updates being made to the system. You can benefit from the various improvements.

View full review »
WH
BI and data chief consultant at a media company with 11-50 employees

The ability to create dashboard presentations for various sectors is a valuable feature. It's an excellent product.

View full review »
TS
Manage Client Partner at a tech services company with 501-1,000 employees

I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs. As for now, I am able to do a lot of operations but not with much proficiency. I am just getting started with it. I am not very good at doing dashboard creation or writing reports but sometimes I do it during office hours to understand and learn the analytical tools.

View full review »
BY
Senior Data Engineer at a computer software company with 1,001-5,000 employees

Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports.

View full review »
Data Scientist at a tech vendor with 201-500 employees

The most valuable features are the easy creation of reports, dashboards, and the ability to perform analysis. It is important for us to create reports because we have some operations during certain hours and we can use this tool to track the information. Additionally, it is a benefit they are adding more features all the time, such as machine learning.

View full review »
JS
Consultant at a training & coaching company with 201-500 employees

I like the flexibility it offers.

View full review »
RJ
Vice President & Head at a tech services company with 501-1,000 employees

It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite.

View full review »
Head of Offshore Operations & Solutions at Techcarrot

I have found the quick reporting and the conductivity with all the data sources valuable.

View full review »
IS
CEO at a tech services company with 1,001-5,000 employees

It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly.

One of the advantages of Microsoft BI is that it's easy to integrate it with any databases.

Another is that it doesn't need a lot of technical support because it's easy to use.

View full review »
KR
Strategic Market Development Sr. Manager at a pharma/biotech company with 201-500 employees

The solution is easy to use and flexible.

View full review »
NH
Director of Analytics and Cognitive Computing at a consultancy with 11-50 employees

The solution is easy to use and charts can be built quickly with the tools.

View full review »
MR
Senior Manager at a comms service provider with 501-1,000 employees

Microsoft BI is very friendly.

The interface is very easy to use.

The integration with other data sources is very easy and very handy.

View full review »
Chief Information Officer at Sensilab

The most valuable feature would be the abundance of connectors. It is also easy to use.

It is a very powerful platform for BI. It has everything that you want from BI. 

View full review »
JV
Part Owner at a tech services company with 11-50 employees

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

View full review »
PA
Research & Development Expert at a energy/utilities company with 11-50 employees

The most valuable feature is integration with Python.

View full review »
RD
Owner at a consultancy with 11-50 employees

It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on. 

View full review »
Enterprise Architect at a tech services company with 5,001-10,000 employees

I like Microsoft BI's drill-down feature and its overall ease of use.

View full review »
TS
Senior Manager Analytic & Insights at a hospitality company with 10,001+ employees

The visualization and reporting are the most valuable features of this solution.

It is quite flexible for reporting purposes.

View full review »
RH
Head of Internal Control at a tech company with 51-200 employees

The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily. 

View full review »
CP
Senior Product Manager Data Science at a insurance company with 1,001-5,000 employees

It is useful for bringing visualization to data. It calculates counts, ratios, etc.

View full review »
WV
Project Consultant at a financial services firm with 501-1,000 employees

Our customers really like the dashboard. They can click on whatever they want for an in-depth view. Microsoft BI is very easy to set up and use. 

View full review »
EG
Responsable Industrie 4.0 at a engineering company with 10,001+ employees

I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it.

The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. 

Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person.

View full review »
DJ
Director at Magnamious Systems Pvt. Ltd.

I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI.

View full review »
BI Expert at a financial services firm with 1,001-5,000 employees

It's very fast and user-friendly.

View full review »
PT
Business Development Executive at a tech services company with 51-200 employees

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

View full review »
Consultor at PwC Brasil

Interactive graphs are its most valuable feature.

View full review »
HO
Consultant en Business Intelligence

I like this product because it's a free software, very intuitive and very easy to use.

View full review »
AV
Solutions Architect at a tech services company with 10,001+ employees

The dashboard features are really valuable, you can connect to multiple data points. Overall, the solution is easy to use.

View full review »
PC
Associate at a financial services firm with 10,001+ employees

Compared to Cognos, Tableau and Power BI are pretty fast. 

View full review »
Vice President - HSE Engineering at Reliance Industries Ltd

The most valuable features are the visualization and integration with Office365.

View full review »
HD
Senior Operations Coordinator at CambriLearn

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

View full review »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
565,689 professionals have used our research since 2012.