Microsoft BI Valuable Features

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 »
Sai Krishna J
Manager, BI & Analytics at a consultancy with 11-50 employees
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 »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,301 professionals have used our research since 2012.
Gary Gonsalves
Consultant at a consultancy with 11-50 employees
Our most valuable features are the dashboard and the reporting feature because, before that, our organization used to only use Excel. There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too. The end user also had an opportunity to alter the reporting as per requirements with Power BI. View full review »
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 »
Oscar Estorach
Chief Data-strategist and Director at
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 »
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 »
Jose Barbosa
Board Member at GTI Digital
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 »
Samuel Kamau
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 eInfochips
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 »
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 »
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 »
Idrees Hussain
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 »
Praveen Chaudhary
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 »
Jorge Barroso
Consultor at Scitum
One of the features I really like is that there are a lot of different graphics that are very nicely presented. The uploading of information is very easy, as you just use an Excel sheet to start work right away and obtain the benefits of Power BI. When you start, right from the beginning it can help you. Once you upload the data you can start to play with the different options you have from the graphics available, and also from the different mathematical and logical conversions that it offers. I also work with other data processors and the facilities that Power BI offer can help to better understand the traditional database tools such as SQL, or others. Another advantage is that you don't have to have a lot of knowledge about databases. This is because you use Power BI knowing your goal and what you want to achieve with respect to the data that you are processing. View full review »
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 »
Alberto Guisande
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 »
Rohit B
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 »
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 »
Marian Petkov
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 »
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 »
Data Analyst at a tech services company with 201-500 employees
The user interface is easy to work with. View full review »
Mark Cunningham
Regional PDS - Director of Business Intelligence at JLL
* 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. View full review »
BI Analyst at eVision Industry Software
If you are not very technical this tool could be very useful. The most valuable features are: * Self service * Inbuilt analytics * Custom visualization * Printing of dashboard helps a lot * Dashboard scheduling * Easy collaboration with other users on Power BI * Learning curve for this tool is small * Dashboard refresh rate can be configured * Power BI works both on-premises and cloud View full review »
Data Scientist at Packen SAS
The most valuable features are the automation of analysis and already prepared tools to do the analytic work rapidly. View full review »
Microsoft Dynamics Specialist at Strategix Business Solutions
The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website. Data that is not classified as confidential can very easily be exposed to customers, vendors, or even just visitors to the web site. View full review »
Alfonso Gordillo
Director Research and Development at Projects Factory
Power BI is always updating. I receive multi mail from Power BI with new visualizations, new analytics, new webinars and I'm going to Microsoft here locally in order to have a updated presentation about the new features of Power BI. For me it's very versatile. I can publish on my iPad. I have a Power BI application in order to manage the visualization of my report and my dashboard. Also I can speak to Power BI and ask about production and Q&A. But, I don't have compilation with other tools yet. For me, Power BI is the best. View full review »
Diógenes Eloi
Consultor at PwC Brasil
Interactive graphs are its most valuable feature. View full review »
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 »
Balaji Ram
IT & Projects Development at Mohamed Hilal Group
* Mobility. * It's easy to use. * Multiple data sourcing. * Quick development and deployment. * Mobility and ease of use. 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 »
Bart Witteveen
ERP Consultant MS Dynamics Nav at Witteveen Logistics & IT
Great performance. View full review »
Learn what your peers think about Microsoft BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2021.
455,301 professionals have used our research since 2012.