TrustRadius
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.Power BI is So Easy and So GoodWe started using Power BI a few years ago to spin up some simple reports from various sources. The great thing about the reporting is the automation. As long as I know where the data is coming from, and the source is something I can use for Power BI, I can create excellent, professional reporting that helps us make daily business decisions. It's also very reliable. Most often if there's a problem with our reports, it's due to the data source, not Power BI or its connectors.,Reporting, reporting, reporting. Power BI is great for reporting. I can create a number of different charts, views, and dashboards for a number of different audiences. It's very helpful for executives to see the big picture, but dynamic enough to take the same data sources and create detailed reports on very specific elements. Power BI is easy to use. We went from manual data entry and report creation in Excel to Power BI. There was a learning curve, but I was able to find enough training online to get started. Automating the report creation is wonderful. It takes all the manual work out of my old daily processes. My supervisors and bosses have been impressed too. They think it's magic, which makes me look good.,I can't automate a data source if the source requires a login and password to get into the resource. In the past we got around this issue by having vendors email us an exported .csv file, but for some sources that doesn't work. Maybe there's a better solution for this, but I don't know what it is. There are still some more advanced features that I'm trying to figure out, like machine-learning type of reports. It's not quite up to that level of reporting, but I also think if I had more skills or creativity i may be able to figure it out. Just need some more time with it.,10,Tableau Desktop,9,10,Tableau DesktopBeautiful Reports and Useful Data, but configuration is not easy!Microsoft Power BI is used primarily by the Project Management department at the company to keep track of all the project metrics within the whole company, covering everything from capital expenditure projects, to customer orders, and product development projects.The different departments that aren't authoring the data and reports have access to the reports to use within their planning and departmental reports. The problem that Microsoft Power BI addresses is that everyone has clear and easy access to well displayed dashboards that display key metrics on a per project basis.,Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways. Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products. Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.,Initial creation of reports, even from processed data sets is not simple. The on-premises reporting (crucial for a defense industry company) is extremely expensive, as it is only included in the Power BI Premium package. User training is usually required to ensure that full functionality of the dashboards and their built in features are utilized.,6,,10,10,TeamViewer, Siemens PLM Software, Siemens Solid Edge, WordPress, Mailchimp, OnshapePower BI - Excel on Steroids and So Much MorePreviously, we had no real business intelligence. We had all sorts of data in our database, but we had no way to make sense of it aside of downloading and manipulating it in Excel, but this proved difficult to process many hundreds of thousands of rows of data. Microsoft Power BI has helped us make this process so much easier by connecting to our database directly and run queries directly in the system and make beautiful charts based on that data, to make sense of what's going on.,Beautiful graphical models of your data Fast processing whether you're working with local data or pulling it from your database Very easy to share reports within your organization Surprisingly fairly easy to learn,It is such a powerful system that it can come across as intimidating for some without some Excel knowledge I'm not a database analyst or administrator, so calling the data in can be difficult (not necessary the fault of the software, but something that could be difficult for teams without someone with database knowledge) It can come across as confusing, when there is both a local Power BI and online Power BI components. They don't necessarily do the same functions. You'll definitely want to know how to use the online version as this is how you'll publish and share the results of your findings, but the local one has a lot of capabilities that don't appear to be directly available in the online version (and if so, it's not immediately apparent).,9,Periscope Data,9,9,Bamboo, Aha!Microsoft Power BI review: A way to optimize and improve visualizationPower BI is being used to create dashboards and company data reports. Currently, it is used in the financial and IT areas. We are working on planning to have a vision of what is to come, planning everything about the company through the visual representation of these sensitive data. And with it, the tool can generate great visualizations that we can take to meetings.,Similar to office 365 applications such as Excel and Access, that is, it facilitates the usability of those who already have advanced knowledge of these tools. Optimal ways of presenting data. Data collect. Control panel.,Sometimes the table relationship is not no simple to set up. Certain elements are very limited, in the visual part mainly. The tool is unnecessary in relation to the panel interface compared to Tableau.,9,Tableau Desktop,9,10,MS SharePoint, Notepad++, Skype for Business (formerly Lync)A highly efficient data visualization tool from MicrosoftI work as an information and communication technology specialist and my role requires me to work on support tickets created through ITSM. I use Power BI for visualizations based on the tickets data which includes information related to per user resolutions, region-wise sorting, most common issues, top performers, etc.,Visualizations Getting correct data from Excel formats Comparisons from different sheets,ArcGIS map still requires a lot of improvements. Live Data feed,9,Tableau Desktop,10,9,Elasticsearch, Terraform, Ubuntu LinuxPower BI: Great solution for reporting and dashboards!Power BI is actually being used by our entire organization. Each type of user has access to different views or reports, and they don't have to manually make the reports on another tool such as Excel, although later they can export it to Excel so they can manipulate the information or send them to another person.,Reports and dashboards complexity were greatly reduced. Easy drill-down on selected information. Different types of views for the same information.,The licensing cost might be a little high for some companies. It consumes a lot of resources. It's not very user intuitive on first use.,8,QlikView,8,7,OdooLook like a genius with your reports with PowerBIAs we are trying to understand the overall health of the organization there are various metrics around revenues, costs, etc that we want to be able to slice and dice. We have some contracts that are such severe outliers (both positive and negative) that they can greatly skew our numbers. We use PowerBI to better understand our metrics and quickly manipulate the inputs into our reports.,Easy to create beautiful charts that make the data very easy to understand. Ability to quickly add/remove certain contracts from the dataset and see the differences with and without these contracts. Mobile view is really nice too!,Can be difficult to import certain data sets like MySQL that is on-prem. Takes a bit of getting used to using. Once you're using to it you look like a genius with how fast you can create reports. Pricing can become a bit much at scale.,9,Google Charts,7,9Wonderful Data Visualisation Platform. Perfect for Smaller Organisations At Lower Price Point.We built out numerous dashboards in order to support the analysis post-data gathering for all our core discovery methodologies. This allowed us to quickly spin up are variable data sets mid- and or post-project in order to start validating results and identify areas required for cleaning etc. prior to analysis and presentation back to our clients with the results. The free visual market place really helped bolster the initially limiting range of visualizations it comes with out of the box.,Data Links, Visual Aid, and Wizard make the process very simple. We found we needed a two-way link 99% of the time but the default was a one-way link that needs changing each time you import etc. Terminology and usability are similar to Excel and Access making it easy to pick up and start creating for most advanced users of those applications. Very powerful out of the box, and even when using the free service it is incredibly capable if working on smaller data sets.,Limited visualizations out of the box, market place does help improve this. Some visuals, such as maps, are a bit limiting by default Method of creation is very different from Tableau or Spotfire increasing learning time when switching platforms. Many statistical elements cannot be visualized or calculated such as Confidence Levels, Intervals etc. This must be added.,9,Tableau Desktop and TIBCO Spotfire,9,7,Tableau Desktop, TIBCO SpotfireA great and interactive business analytics toolCurrently, Microsoft Power BI is being used by some departments on our organization. Basically, the financial department, and the IT department. Microsoft Power BI is very useful to build numerous dashboards in order to support post-data gathering for all core processes. Furthermore, Microsoft Power BI can build many possible charts. We can use them to show information or even full interactive presentations, that in Microsoft Excel we could not do. Microsoft Power BI has integration with the other Microsoft business tools, and this is really helpful.,The cost of it, really affordable. Power BI has a great integration with other tools like Office 365, Azure, etc. Navigation is very similar to Microsoft Excel, so if you are already acquainted with Excel, you'll have no problems with BI. Great variety of chart types, I think it is around sixteen different ones.,If you are not a Microsoft Excel power user, it can be a little challenging to use. Slow performance if you have a huge amount of data to analyze. Has a very bulky user interface.,8,Microsoft Office 365,8,8,Skype for Business (formerly Lync), Symantec Endpoint Protection, Microsoft Office 365, Microsoft TeamsPower BI is a great reporting tool, particularly for leadership teams that don't want to dive deep, but want accurate and timely information presented to them to make choicesWe use Microsoft Power BI to gather data and present it from our project management software Procore. It is used by two people in our organization to present data to our upper management. It helps to let our leadership have a real up to date high level overview of where each of our projects stand in terms of budget, schedule and many other metrics.,Data retrieval/mining Data presentation/visuals customization,Ease of use - this tool could be much more intuitive in its design,9,,9,10,Adobe InDesign, Adobe Photoshop, Adobe Illustrator CC, Microsoft AccessPower BI - Good, and Getting Better ConstantlyWe have just begun working with Power BI to do some data analysis of our student enrollment and certain operational benchmarks related to program participation and school safety.,Ease of constructing graphs. Always updated visuals being offered. Variety of data sources to be able to pull data.,Does not allow for parameters to be passed to the system as part of a user interaction. Cannot share data to our shareholders that are outside of our domain. Is not yet a complete solution. Still using other reporting tools in addition.,6,,8,6,Microsoft Office 2016, Microsoft Office 365, SAP CrystalData Visualization and Data AnalyzesGreat platform for data visualization and data analyzes. The organization is migrating to Power BI because of its integration with Microsoft applications. R is very well integrated with Power BI which makes statistical modelling easier to use. Report generation and sharing has become very simple. Very useful to create dashboards for the top management to make data driven business decisions.,Intuitive and User-Friendly R Statistical Modelling modules integrated Very well integrated with Microsoft applications.,Not very easy to make custom graphs and charts Requires some time to get used to the interface Documentation can be more detailed,8,TIBCO Spotfire and Tableau Desktop,8,9,CGI Exploration2Revenue (X2R), Azure CDN, AvidMobileA great tool for the analyst's toolbox and for sharing reporting within a team or department.We have three BI solutions within our business, Power BI, Qlik View and Qlik Sense. Primary management reporting, dashboards and report distribution are done with Sense, basic marketing views are done through View and most power analytics and ad-hoc analytical work is done via Power BI. We find Power BI is best when data resides in several places and mostly spreadsheets. Using Power BI to connect directly into source systems (even Microsoft branded products Azure SQL Server) cause the app to time out. So company-wide we use sense, and functional analysts across all departments have Power BI to dig deeper than Sense can go.,Data blending from several different files is a big hit with our Power BI users. We have so many excel and CSV files and many of them are not clean, so making use of the data cleaning and blending saves us from countless pivots and lookups to just get data worthy of analyzing. The visualizations are top notch, and available without additional cost. Everything is in vibrant colors and crisp, clear lines that whatever your produce is clearly pleasing to the eye. From mapping down to pie charts, the visuals are well done. The Beta preview is very helpful, not all software allows you to preview or use things in beta, but Power BI has a wonderful set of tools and visualizations you can add into your work with very little effort or complexity.,Power BI lacks in horsepower compared to other tools with more robust ETL components built in. Particularly if you connect to any type of source system database like SQL, you have to either have a SQL View built for you that limits the volume of data your bring in, or have solid knowledge of the SQL table structures to build yourself custom (and correct!) connections to the tables. Security is not as robust as other BI tools, like Qlik Sense. We often need to restrict subsets of data by customer and even functional position of an individual within a customer. Power BI’s security seems to be built for using just within a company, so if you leverage your work outside the firewall there can be issues when figuring out security streams. I do not like the pricing. It’s really a dirty trick, Microsoft goes around and says the product is free. Well, the stand-alone is free, yes, but you have to pay for the “enterprise” version so you can share files. They say it only costs $10 a month/user, which again is a white lie. You need much more IT infrastructure and people to build SQL views and Tabular Models so you can use the tool, and Microsoft does not tell you that. So we find it is a good stand-alone tool to analytics, but a fairly heavy cost structure if you roll it out enterprise-wide as compared to Qlik or Tableau (which are more expensive per license, but require less back-office support).,6,Qlik Sense, QlikView, Tableau Server, Pentaho and Business Objects SRC,5,5,Tableau Server, Pentaho, Qlik Sense, QlikView, Business Objects SRCNice dashboards and easy to adapt when you know Excel.I have used Microsoft Power BI to create automated reports, dashboards for our clients finance department. The reports were consisting of financial targets, actual and forecasts. Along with the reports, we used formula generation functionalities and made auto calculations. It is a good reporting dashboard when it comes to display most current values along with auto calculations. Before Power BI, excel reports or ppt presentations would be distributed within the organization. With Power BI, the dashboards and data visualization became more professional looking.,It has a free version offered with Microsoft Office 365. So businesses with this type of license can enjoy it free. Good dashboards, auto calculation and database connection capabilities. Easy to learn and use when you have familiarity with Excel. You can reach free training material on many platforms. Well integrated with other Microsoft programs (Excel, Access),Expensive if you want on premise version. Choose the best fitting license. There are some functionalities that require detailed learning. You need to have good experience with Excel, database connections, DAX. Data quality matters. If you have uncleaned data, then your work on Power BI can be frustrating as it is poor on providing suggestions. You may encounter with performance issues when your data is big.,7,Microsoft 365 Business and SAP BusinessObjects Business Intelligence (BI) Platform,7,6,Microsoft 365 Business, SAS Enterprise Guide, SAP BusinessObjects Business Intelligence (BI) PlatformGreat software for data visualizationIt is currently used for reporting and expected to replaced all the copy-paste jobs and cleaning data. User can create dashboards with data sources and the refresh data whenever needed. Much more efficient and faster to generate same reports every month/quarter. Many trainings available and it's free for standard users. So it's great for colleagues to try it and learn it at no cost upfront.,Connect to various data sources (online and offline) Ease to use and start training with no cost Best feature is to create template report and refresh it with new data every month,Connection to SAP Business warehouse or Oracle needs additional add-ons It's like Power point, difficult to put all charts in the same size or put in one line Can only insert 1 online data source at a time. If you have 1 online data source, cannot add additional sources in dashboard,9,Tableau Desktop,8,8,SAP Business Warehouse, Tableau DesktopMicrosoft Power BI: good free tool for analysisPower BI is used by developers for data analysis by creating graphs and reports. This tool is used lightly for quick and easy data visualization when Excel isn't good enough.,Cost effective graphing and reports Can create personal dashboards Can export to Excel Slicer tools for data filtering,Better built-in functions/formulas. Some are too limited. UI is a little bulky and can be slow to load.,7,,8,5King of Self Service Business IntelligenceWe have about 25 years of data. Microsoft Power BI is being used across the organization by various departments. Our accounts payables team uses it to monitor vendor activity, identify duplicate invoices, and ensure vendor compliance. Our internal audit team runs several reports to identify anomalies.,Microsoft Power BI is the best value for money, self-service business intelligence tool available in the market. It is intuitive to use and comes with a library of data connectors. It has fantastic data visualization capabilities and simplified user interface. We store most of our data on the Azure data lake and Power BI works seamlessly with it.,Most of our users prefer the desktop version compared to the web tool. Microsoft should put efforts into making the web tool robust and easy to use. The refresh cycles are less if you opt for the free version. We bought an enterprise edition to get over this. Free versions have less storage and are slower.,9,,10,9,Oracle Analytics Cloud, JIRA Software, Atlassian ConfluenceReally Great!We use Power BI in our IT dept, but the information and analytics gained are then provided company-wide to those who need it or could be helped by the information. It helps us easily visualize and conceptualize the data that we've always had. Insights gained are really quite valuable.,Correlation. Presentation. Visualization.,Dashboard customization. Sharing. Agility.,8,Tableau Desktop, Tableau Online and Tableau Server,8,8,Komprise, SwiftStack, Spectra nTier Deduplication ApplianceStrengths and Weaknesses of Microsoft Power BI1. It is used for Executive reviews for visualization and dashboards to provide insight in the business operations, marketing, finance. My organisation is using this because it comes free with Microsoft Office license. It provides similar services as other tools in the same field. 2. It is being used in my departmen,t but other functions are starting to explore this BI tool. 3. Visualization, dashboards, scorecards, easy to understand huge datasets through graphs and charts, flexible for users to connect withEexcel,Free license and tool is available in Microsoft office as an alternative to expensive tools in the same field Flexible to connect with multiple data sources and ERP systems Training modules are available for users with good detailed explanation Can publish review online for yourself and team-members and executives Multiple layout for visualization,Editing data is bit difficult -- it requires dataset to be formatted in a particular manner, otherwise it will give errors and the user will end up most of the time in fixing the issue himself. Everytime data is required to be refreshed, which leads to the issue of regenerating the visualization,8,,10,10,SAP Lumira, Tableau DesktopPowerBI is a great toolWe work on understanding consumer behavior and usage patterns. Traditionally Excel was used heavily and then the charts were built and published on PPT. However, with Power BI, the jump to interactive dashboards is much easier. Many people started using it and then they started connecting with other data sets and from different databases. They move towards visualizing the data, sharing with executives. We also use the map feature in there and publish online.,Easily load and integrate data from multiple sources. Integration with Office 365 is smooth. Same user Interface as other Microsoft tools so the learning curve is lower.,Lots to do and thus it is hard to be aware of all it does. Updates often so hard to keep on key developments. Sometimes data migration takes time.,8,Tableau Desktop and Qlik Sense,10,9,Tableau Desktop, ArcGIS, Qlik SenseMicrosoft Power BI for better visulization and data analysisOur Company is a Microsoft shop so naturally, we use all products from Microsoft. Microsoft Power BI is being used in all levels and all departments in my organizations. In our department alone, every team has on average of 5 power BI reports that we actively use everyday. We have created Power BI reports that are also consumed by the E class. The visual aspect of this tool is the most interesting part of the value it brings in providing information. As a Microsoft shop, we use Excel and have been creating enormous amount of reports from it. Because of this the transition to Power BI was not prolonged but rather adopted rather rapidly. Today we have training sessions, Knowledge articles and access to the experts when it comes to doing things thru Power BI. Although we do use other enterprise level reporting tools, power BI Is the most widely used in our company.,It is a great tool for Visualization. Microsoft always brings monthly updates to this tool. It is great to see the new features and functionalities that are being added constantly. Power BI is an excellent tool to create all kinds of reports and data visualization. It can go from very simple reports to complex ones. There are enormous amount of Knowledge articles , YouTube videos and the support community to answer any question one has on Power BI. This makes life much easier.,Compared to Tableau, it feels like Power BI can improve on the new templates for visualization.,10,Oracle Business Intelligence Cloud Service,9,8,Automation Anywhere, Oracle Business Intelligence Cloud Service, Microsoft SQL Server, vSphere, Snagit, Camtasia, Autodesk Inventor, Visual Studio Test ProfessionalMicrosoft Power BI was the best choice for our organizationOur organization uses Power BI across the organization and globally to our network of partners. Several problems were addressed by implementing Power BI. Report building: Reports can now be built by anyone in the organization with access to the data source where previously it required a developer. Time required: Along the same lines, the time required to release a new report or update an existing report has decreased significantly and can usually be done the same day.Embedding: Reports needed to be embedded in our partner portal and allow filtering based on the user so that we're showing the right data to the right people.One-off reports: There used to be an alarming number of requests for one time or monthly or weekly reports that were manually generated. The data is now accessible via Power BI in a controlled way that allows our users to find their own insights in the data.,Easy to build the reports you need. Allows users with any level of experience to start building reports. Users can interact with reports in a natural way allowing them to start using the reports with no/little training or guidance. Powerful enough to handle any report from any data source and size. Secure handling of data and able to ensure the right data is visible to the right people. Large community of users and resources.,Greater flexibility in formatting the look and feel or reports and dashboards. Embedding Dashboards the way reports can be embedded.,9,Looker, Tableau Desktop, Microsoft SQL Server and Google Analytics,10,9,Microsoft Visual Studio Code, Microsoft Dynamics 365 (formerly Microsoft Dynamics CRM), Microsoft Office 365Enterprise adoption of Power BIPower BI is used across the whole organization. Although our company uses many BI tools, there is currently a project to consolidate tools and make Power BI our official BI tool. It's used across each department to provide analytics and insight into each department's OKRs. Our IT team has a specific division that is the main driver behind adoption and consulting on dashboarding for each department.,Ability to build visuals with drag-and-drop makes creating dashboards easy for beginners Great training materials and videos online for self-training Ability to work across Microsoft's other platforms Easy sharing of dashboards and built in "usage metrics",Moving reports between the desktop version and Power BI can be cumbersome and lead to multiple versions,9,Tableau Online,10,10,Microsoft 365 Business, Adobe Acrobat DC, Mitratech TAP Workflow Automation, Smartsheet, ProductPlanEasy and simple BI tool that can perform complex operations.We use Power BI to visualize our transaction data and to generate real-time reports to better optimize our production.,Easy to use. Well integrated into the Microsoft ecosystem Share with anyone.,Bit pricey Getting used to it and learning might be long for someone new to all the options.,8,Tableau Desktop and QlikView,9,8,Google Hangouts, Visual Studio IDE, SnagitMicrosoft is one of the best tools for Data AnalysisA lot of Packages are available to represent the data. Predictive and Visualization representations are very useful. A lot of users are implementing new packages and share the same with other users which helps to find a quick solution to our requirements. The open Source community provides help in case of any issues or solutions needed. Such as issues with finding a central repository to find out the implementation of packages. More searches are needed for finding the details of any package, for example, any package needs to search a lot to find out the details. Recommendations to others considering the product are much needed in the understanding of our language to proceed with the tool. Data Representation, Analysis, Visualization, Detailing, Training purpose as well.,Lot of Packages available to represent the data Predictive and Visualization representation are very useful Lot of users are implementing new packages and share the same with users which helps in find quick solution to our requirements Open Source community as well provides help in case of any issues or solution needed,Issues with finding a central repository to find out the implementation of packages Search more needed for finding the details of any package, for example, any package need to search a lot to find out the details Tutorials for beginners to explain the navigation and details,10,Qlik Sense,10,10,Qlik Sense
Unspecified
Microsoft Power BI
496 Ratings
Score 8.2 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>

Microsoft Power BI Reviews

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Microsoft Power BI
496 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Do you work for this company?

TrustRadius Top Rated for 2019
Show Filters 
Hide Filters 
Filter 499 vetted Microsoft Power BI reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role

Reviews (1-25 of 84)

Companies can't remove reviews or game the system. Here's why.
Richard Crane profile photo
Score 10 out of 10
Vetted Review
Verified User
Review Source
We started using Power BI a few years ago to spin up some simple reports from various sources. The great thing about the reporting is the automation. As long as I know where the data is coming from, and the source is something I can use for Power BI, I can create excellent, professional reporting that helps us make daily business decisions. It's also very reliable. Most often if there's a problem with our reports, it's due to the data source, not Power BI or its connectors.
  • Reporting, reporting, reporting. Power BI is great for reporting. I can create a number of different charts, views, and dashboards for a number of different audiences. It's very helpful for executives to see the big picture, but dynamic enough to take the same data sources and create detailed reports on very specific elements.
  • Power BI is easy to use. We went from manual data entry and report creation in Excel to Power BI. There was a learning curve, but I was able to find enough training online to get started.
  • Automating the report creation is wonderful. It takes all the manual work out of my old daily processes. My supervisors and bosses have been impressed too. They think it's magic, which makes me look good.
Power BI is great for reporting of any type. The dashboards I create for my executive team are crisp and easy to understand. I often get complements on it, and suggestions on what other reports or data could benefit from Power BI. Power BI is still dependent on data sources, so if my data source connections break, then the report is no good. This isn't something that you can create and forget. It needs eyes on it to ensure the data is correct.
Read Richard Crane's full review
Rick Botha profile photo
Score 6 out of 10
Vetted Review
Verified User
Review Source
Microsoft Power BI is used primarily by the Project Management department at the company to keep track of all the project metrics within the whole company, covering everything from capital expenditure projects, to customer orders, and product development projects.The different departments that aren't authoring the data and reports have access to the reports to use within their planning and departmental reports. The problem that Microsoft Power BI addresses is that everyone has clear and easy access to well displayed dashboards that display key metrics on a per project basis.
  • Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways.
  • Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products.
  • Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.
Microsoft Power BI is well suited to the following scenarios:
  • Where a lot of data is available and, if processed, and displayed well, it will benefit efficiency and productivity across the organisation.
  • Where the results of processed data are used to convince clients of completed work.
Microsoft Power BI is not well suited to the following scenarios:
  • Where small organisations need to display their data for internal use, using a self-administered solution.
Read Rick Botha's full review
Steffany Winkelmann profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Previously, we had no real business intelligence. We had all sorts of data in our database, but we had no way to make sense of it aside of downloading and manipulating it in Excel, but this proved difficult to process many hundreds of thousands of rows of data. Microsoft Power BI has helped us make this process so much easier by connecting to our database directly and run queries directly in the system and make beautiful charts based on that data, to make sense of what's going on.
  • Beautiful graphical models of your data
  • Fast processing whether you're working with local data or pulling it from your database
  • Very easy to share reports within your organization
  • Surprisingly fairly easy to learn
Well suited for organizations that have a lot of client data. It doesn't necessarily mean you have a lot of clients, but rather that you've collected a large set of data-points that you can analyze, cross-compare, and report on and need higher functions than Excel. It would also be better-suited for organizations that have someone (preferably in-house) who can import & process that data into meaningful reports for other teams to use and build off of.

Less appropriate for smaller organizations that don't have someone in-house or don't have the strong ability to learn how to maximize on the abilities of this tool set. It requires knowledge of interacting with databases and someone who understands how to analyze and interpret business intelligence data. Also not very appropriate for organizations that don't collect much data on their clients, even if they have many clients.
Read Steffany Winkelmann's full review
Gabriel Oliveira profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
Power BI is being used to create dashboards and company data reports. Currently, it is used in the financial and IT areas. We are working on planning to have a vision of what is to come, planning everything about the company through the visual representation of these sensitive data. And with it, the tool can generate great visualizations that we can take to meetings.
  • Similar to office 365 applications such as Excel and Access, that is, it facilitates the usability of those who already have advanced knowledge of these tools.
  • Optimal ways of presenting data.
  • Data collect.
  • Control panel.
The recommendation for a company would be that with this free/low-cost tool for desktop it can help a lot in making decisions and thereby get a result that you can visualize if your company is on the right path. The user will also get some more creativity about the creation of the panels.
Read Gabriel Oliveira's full review
Nishant Arora profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
I work as an information and communication technology specialist and my role requires me to work on support tickets created through ITSM. I use Power BI for visualizations based on the tickets data which includes information related to per user resolutions, region-wise sorting, most common issues, top performers, etc.
  • Visualizations
  • Getting correct data from Excel formats
  • Comparisons from different sheets
Microsoft Power BI works well with most of the database formats and where the requirement is to visualize the data with multiple aspects. It gives the ability to get the maximum of the data by doing some analytics and answering some questions as well.
Read Nishant Arora's full review
Guillermo Villamizar profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Power BI is actually being used by our entire organization. Each type of user has access to different views or reports, and they don't have to manually make the reports on another tool such as Excel, although later they can export it to Excel so they can manipulate the information or send them to another person.
  • Reports and dashboards complexity were greatly reduced.
  • Easy drill-down on selected information.
  • Different types of views for the same information.
The fact that we don't have to use Excel to create awesome visual charts makes this a complete time-saver. Instead of spending hours and hours updating spreadsheets, Power BI integrates with other programs we use in the organization to pull the raw data automatically, and it looks awesome as well.
Read Guillermo Villamizar's full review
Chris Widner profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
As we are trying to understand the overall health of the organization there are various metrics around revenues, costs, etc that we want to be able to slice and dice. We have some contracts that are such severe outliers (both positive and negative) that they can greatly skew our numbers. We use PowerBI to better understand our metrics and quickly manipulate the inputs into our reports.
  • Easy to create beautiful charts that make the data very easy to understand.
  • Ability to quickly add/remove certain contracts from the dataset and see the differences with and without these contracts.
  • Mobile view is really nice too!
PowerBI is great for scenarios where you have raw data and quickly want to get insight into the trends within that data. If you're a small company or working on a small team that will consume this data you can move quite quickly and have everyone on the same page.

I wouldn't recommend using this to share data across a larger organization unless price isn't an issue. It can become expensive when you're talking 50+ users.
Read Chris Widner's full review
Peter Baker profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
We built out numerous dashboards in order to support the analysis post-data gathering for all our core discovery methodologies.

This allowed us to quickly spin up are variable data sets mid- and or post-project in order to start validating results and identify areas required for cleaning etc. prior to analysis and presentation back to our clients with the results.

The free visual market place really helped bolster the initially limiting range of visualizations it comes with out of the box.
  • Data Links, Visual Aid, and Wizard make the process very simple. We found we needed a two-way link 99% of the time but the default was a one-way link that needs changing each time you import etc.
  • Terminology and usability are similar to Excel and Access making it easy to pick up and start creating for most advanced users of those applications.
  • Very powerful out of the box, and even when using the free service it is incredibly capable if working on smaller data sets.
This is probably my favorite BI platform I have used to date. It feels a bit younger though, missing some features other platforms have. However, it makes up for this with its low price point for small businesses and great feature set that allows easy elimination of bugs and errors in your dashboards through to the ability to layer visuals on top of each other to get around things like limited numbers of Axis in certain visuals.

There are a few things you have to tweak constantly, tucked away in dropdown menus, that could be much more intuitive actions by clicking on components in visuals, like changing a title, axis name, etc. But the foundations are solid.
Read Peter Baker's full review
Adriano Rosa profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Currently, Microsoft Power BI is being used by some departments on our organization. Basically, the financial department, and the IT department. Microsoft Power BI is very useful to build numerous dashboards in order to support post-data gathering for all core processes. Furthermore, Microsoft Power BI can build many possible charts. We can use them to show information or even full interactive presentations, that in Microsoft Excel we could not do. Microsoft Power BI has integration with the other Microsoft business tools, and this is really helpful.
  • The cost of it, really affordable.
  • Power BI has a great integration with other tools like Office 365, Azure, etc.
  • Navigation is very similar to Microsoft Excel, so if you are already acquainted with Excel, you'll have no problems with BI.
  • Great variety of chart types, I think it is around sixteen different ones.
Just like Microsoft Excel, Microsoft Power BI has many types of graphs and charts, but when it comes to creating a tableau of information, the data can be transformed into maps and gauges. There is even a KPI visualization and one called R visualization. Of course, the scenario in which the user has advanced experience in Microsoft Excel is the best scenario—Power BI makes data analysis extremely easy for them. And more, you can see the raw data behind the visualization opening Excel.
Read Adriano Rosa's full review
Che Odom profile photo
Score 9 out of 10
Vetted Review
Verified User
Review Source
We use Microsoft Power BI to gather data and present it from our project management software Procore. It is used by two people in our organization to present data to our upper management. It helps to let our leadership have a real up to date high level overview of where each of our projects stand in terms of budget, schedule and many other metrics.
  • Data retrieval/mining
  • Data presentation/visuals
  • customization
We love the Power BI integration, so we have seen it built out for specific integrations with specific other software, like Procore, successfully, with little to no effort required by the end user. We feel that if you have data that you would like to dig through and present to a large group in a meaningful way, Power BI is for you.
Read Che Odom's full review
Scott Herring profile photo
Score 6 out of 10
Vetted Review
Verified User
Review Source
We have just begun working with Power BI to do some data analysis of our student enrollment and certain operational benchmarks related to program participation and school safety.
  • Ease of constructing graphs.
  • Always updated visuals being offered.
  • Variety of data sources to be able to pull data.
Quick visual representation of datasets is the strong point here when working with reasonable sized files.
Large dataset files are problematic in quickly giving that representation due to application limitations.
Internal operations being guided by the dashboards is a well suited scenario, but as is the case when working in a collaborative environment, external users will lack your functionality that you have internally.
Read Scott Herring's full review
Maria Carver profile photo
Score 8 out of 10
Vetted Review
Verified User
Review Source
Great platform for data visualization and data analyzes. The organization is migrating to Power BI because of its integration with Microsoft applications. R is very well integrated with Power BI which makes statistical modelling easier to use. Report generation and sharing has become very simple. Very useful to create dashboards for the top management to make data driven business decisions.
  • Intuitive and User-Friendly
  • R Statistical Modelling modules integrated
  • Very well integrated with Microsoft applications.
For generating value out of data, the dashboards are very intuitive and showcases a great volume of data. Very easy to make decisions out of it. Also, report generation and sharing has become very easy which makes it easier for the top management. Production reports are generated daily, weekly, monthly and yearly.
Read Maria Carver's full review
No photo available
Score 6 out of 10
Vetted Review
Verified User
Review Source
We have three BI solutions within our business, Power BI, Qlik View and Qlik Sense. Primary management reporting, dashboards and report distribution are done with Sense, basic marketing views are done through View and most power analytics and ad-hoc analytical work is done via Power BI. We find Power BI is best when data resides in several places and mostly spreadsheets. Using Power BI to connect directly into source systems (even Microsoft branded products Azure SQL Server) cause the app to time out. So company-wide we use sense, and functional analysts across all departments have Power BI to dig deeper than Sense can go.
  • Data blending from several different files is a big hit with our Power BI users. We have so many excel and CSV files and many of them are not clean, so making use of the data cleaning and blending saves us from countless pivots and lookups to just get data worthy of analyzing.
  • The visualizations are top notch, and available without additional cost. Everything is in vibrant colors and crisp, clear lines that whatever your produce is clearly pleasing to the eye. From mapping down to pie charts, the visuals are well done.
  • The Beta preview is very helpful, not all software allows you to preview or use things in beta, but Power BI has a wonderful set of tools and visualizations you can add into your work with very little effort or complexity.
Power BI is great for power Excel users and what I call “data archeologists” or people who dig up old data and clean it up for modern usage. It strings many files together and lets you customize the connections and format of the data. It does not work well with large data set or pull data from large databases, you will find it timing out unless you limit the data set first with a SQL View or Tabular Model before going after it. Also, large data sets take forever to refresh and update, so if you have a lot if iterations, you will spend a lot of time going out for coffee while the data reloads. Other BI tools allow you to localize the data with the first load (Qlik QVD’s) so you can refresh quicker. Comparatively, a refresh of SQL data on Power BI took 45 minutes, the exact same data set would refresh in 30 seconds using Qlik Sense.
Read this authenticated review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source
I have used Microsoft Power BI to create automated reports, dashboards for our clients finance department. The reports were consisting of financial targets, actual and forecasts. Along with the reports, we used formula generation functionalities and made auto calculations. It is a good reporting dashboard when it comes to display most current values along with auto calculations. Before Power BI, excel reports or ppt presentations would be distributed within the organization. With Power BI, the dashboards and data visualization became more professional looking.
  • It has a free version offered with Microsoft Office 365. So businesses with this type of license can enjoy it free.
  • Good dashboards, auto calculation and database connection capabilities.
  • Easy to learn and use when you have familiarity with Excel. You can reach free training material on many platforms.
  • Well integrated with other Microsoft programs (Excel, Access)
It actually depends on the size of the organization and person who will work with Power BI. If you have a big organization, need many reports and need dashboard visualization. Choose it. But be sure the user has good knowledge on Excel, database connections and DAX. If you are a small business you may want to stay on Excel. In any case you can try.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
It is currently used for reporting and expected to replaced all the copy-paste jobs and cleaning data. User can create dashboards with data sources and the refresh data whenever needed. Much more efficient and faster to generate same reports every month/quarter. Many trainings available and it's free for standard users. So it's great for colleagues to try it and learn it at no cost upfront.
  • Connect to various data sources (online and offline)
  • Ease to use and start training with no cost
  • Best feature is to create template report and refresh it with new data every month
Best case: design dashboards with queries/data sources and then update them whenever you need. Live connection is also possible (depends how fast is the connection/back-end data). It is the best for data exploration and visualization.

Not so appropriate: when you need to do tons of calculations with back-end data or clean it in advance, other program like Alteryx would be more appropriate. Power BI is more for data visualization.
Read this authenticated review
No photo available
Score 7 out of 10
Vetted Review
Verified User
Review Source
Power BI is used by developers for data analysis by creating graphs and reports. This tool is used lightly for quick and easy data visualization when Excel isn't good enough.
  • Cost effective graphing and reports
  • Can create personal dashboards
  • Can export to Excel
  • Slicer tools for data filtering
Doing data analysis for Database's data to Excel spreadsheets is appropriate when using Power BI. Excellent for things like comparing data across years/months/days, building aggregates, and/or finding trends in data. This is not for integrating any of this functionality into an application, this software runs on your machine only.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have about 25 years of data. Microsoft Power BI is being used across the organization by various departments. Our accounts payables team uses it to monitor vendor activity, identify duplicate invoices, and ensure vendor compliance. Our internal audit team runs several reports to identify anomalies.
  • Microsoft Power BI is the best value for money, self-service business intelligence tool available in the market. It is intuitive to use and comes with a library of data connectors.
  • It has fantastic data visualization capabilities and simplified user interface.
  • We store most of our data on the Azure data lake and Power BI works seamlessly with it.
Our data is stored in an Azure data lake. Hence, Microsoft Power BI is the best fit for us. It works seamlessly. We use other enterprise software from Microsoft's stable. Power BI is well integrated with the Microsoft ecosystem. Our users are well versed with Microsoft technologies, hence feel comfortable using Power BI. There was minimal training required. Further, there is a pool of qualified Power BI experts available at reasonable prices in the market.
Read this authenticated review
No photo available
September 15, 2019

Really Great!

Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Power BI in our IT dept, but the information and analytics gained are then provided company-wide to those who need it or could be helped by the information. It helps us easily visualize and conceptualize the data that we've always had. Insights gained are really quite valuable.
  • Correlation.
  • Presentation.
  • Visualization.
It's really helpful in the world today, as big data has taken over the data center and IOT has really caused a massive influx of data coming in. And without a way to visualize and correlate the information into logical, sortable data, it's basically worthless. Power BI helps bring value to the data you already have.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
1. It is used for Executive reviews for visualization and dashboards to provide insight in the business operations, marketing, finance. My organisation is using this because it comes free with Microsoft Office license. It provides similar services as other tools in the same field.
2. It is being used in my departmen,t but other functions are starting to explore this BI tool.
3. Visualization, dashboards, scorecards, easy to understand huge datasets through graphs and charts, flexible for users to connect withEexcel

  • Free license and tool is available in Microsoft office as an alternative to expensive tools in the same field
  • Flexible to connect with multiple data sources and ERP systems
  • Training modules are available for users with good detailed explanation
  • Can publish review online for yourself and team-members and executives
  • Multiple layout for visualization
Scenarios where it is well suited- User with Excel experience and needs to analyze the data via visualization without spending huge money on license subscription of other software

Scenario where it is less suited - User who does not know how to handle big data and cleaning data requirements of BI.
Read this authenticated review
No photo available
September 13, 2019

PowerBI is a great tool

Score 8 out of 10
Vetted Review
Verified User
Review Source
We work on understanding consumer behavior and usage patterns. Traditionally Excel was used heavily and then the charts were built and published on PPT. However, with Power BI, the jump to interactive dashboards is much easier. Many people started using it and then they started connecting with other data sets and from different databases. They move towards visualizing the data, sharing with executives. We also use the map feature in there and publish online.
  • Easily load and integrate data from multiple sources.
  • Integration with Office 365 is smooth.
  • Same user Interface as other Microsoft tools so the learning curve is lower.
Power BI is well suited to anyone with a deep understanding of Excel and Excel Pivots. I also recommend it to anyone who doesn't already know and use similar tools. It is quite quick in terms of the amount of time from knowing nothing to building a reasonably functional dashboard is shorter with Power BI than the other products. It can also be also a good introduction to BI tools in general as it can help to reduce the complexities of a process and help to see the bigger picture.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
Our Company is a Microsoft shop so naturally, we use all products from Microsoft. Microsoft Power BI is being used in all levels and all departments in my organizations. In our department alone, every team has on average of 5 power BI reports that we actively use everyday. We have created Power BI reports that are also consumed by the E class. The visual aspect of this tool is the most interesting part of the value it brings in providing information. As a Microsoft shop, we use Excel and have been creating enormous amount of reports from it. Because of this the transition to Power BI was not prolonged but rather adopted rather rapidly. Today we have training sessions, Knowledge articles and access to the experts when it comes to doing things thru Power BI. Although we do use other enterprise level reporting tools, power BI Is the most widely used in our company.
  • It is a great tool for Visualization.
  • Microsoft always brings monthly updates to this tool. It is great to see the new features and functionalities that are being added constantly.
  • Power BI is an excellent tool to create all kinds of reports and data visualization. It can go from very simple reports to complex ones.
  • There are enormous amount of Knowledge articles , YouTube videos and the support community to answer any question one has on Power BI. This makes life much easier.
Microsoft Power BI may not be suitable for information and reports where governed data is paramount. For instance, statutory reports or information that is needed by the regulatory or government body may not be suitable thru Power BI. For day to day business, there is no other better alternative than Power BI. For instance, to see the status reports to run your departments business, Power BI is a great choice.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Our organization uses Power BI across the organization and globally to our network of partners. Several problems were addressed by implementing Power BI.
  1. Report building: Reports can now be built by anyone in the organization with access to the data source where previously it required a developer.
  2. Time required: Along the same lines, the time required to release a new report or update an existing report has decreased significantly and can usually be done the same day.
  3. Embedding: Reports needed to be embedded in our partner portal and allow filtering based on the user so that we're showing the right data to the right people.
  4. One-off reports: There used to be an alarming number of requests for one time or monthly or weekly reports that were manually generated. The data is now accessible via Power BI in a controlled way that allows our users to find their own insights in the data.
  • Easy to build the reports you need. Allows users with any level of experience to start building reports.
  • Users can interact with reports in a natural way allowing them to start using the reports with no/little training or guidance.
  • Powerful enough to handle any report from any data source and size.
  • Secure handling of data and able to ensure the right data is visible to the right people.
  • Large community of users and resources.
Power BI is the best / easiest option when:
  1. You want to be able to leverage non-development staff to author reports
  2. You need to be able to embed your reports
  3. You need security around the data you are presenting
  4. You need to be able to access a wide variety of data sources
  5. You want to have access to a large online community for support/learning
Microsoft Power BI may not be the best choice if you have a limited dataset, few reports you are interested in, don't require much functionality in the report, and don't have resources familiar with Power BI.
Read this authenticated review
No photo available
Score 9 out of 10
Vetted Review
Verified User
Review Source
Power BI is used across the whole organization. Although our company uses many BI tools, there is currently a project to consolidate tools and make Power BI our official BI tool. It's used across each department to provide analytics and insight into each department's OKRs. Our IT team has a specific division that is the main driver behind adoption and consulting on dashboarding for each department.
  • Ability to build visuals with drag-and-drop makes creating dashboards easy for beginners
  • Great training materials and videos online for self-training
  • Ability to work across Microsoft's other platforms
  • Easy sharing of dashboards and built in "usage metrics"
Power BI is a really good value for your money and I think it is well suited to all scenarios. In the age of data, we can glean metrics from ANYTHING and having PowerBi allows a quick return on your investment. You can very quickly create valuable visuals and dashboards. I went from never having used the software to a power user very quickly, just by viewing the robust training videos and instructions provided by Microsoft.
Read this authenticated review
No photo available
Score 8 out of 10
Vetted Review
Verified User
Review Source
We use Power BI to visualize our transaction data and to generate real-time reports to better optimize our production.
  • Easy to use.
  • Well integrated into the Microsoft ecosystem
  • Share with anyone.
Well, when you're database is running on an SQL server and you want the convenience of the Microsoft ecosystem.
Read this authenticated review
No photo available
Score 10 out of 10
Vetted Review
Verified User
Review Source
A lot of Packages are available to represent the data. Predictive and Visualization representations are very useful. A lot of users are implementing new packages and share the same with other users which helps to find a quick solution to our requirements. The open Source community provides help in case of any issues or solutions needed. Such as issues with finding a central repository to find out the implementation of packages. More searches are needed for finding the details of any package, for example, any package needs to search a lot to find out the details. Recommendations to others considering the product are much needed in the understanding of our language to proceed with the tool. Data Representation, Analysis, Visualization, Detailing, Training purpose as well.
  • Lot of Packages available to represent the data
  • Predictive and Visualization representation are very useful
  • Lot of users are implementing new packages and share the same with users which helps in find quick solution to our requirements
  • Open Source community as well provides help in case of any issues or solution needed
Dashboard Sharing and Auto refresh data in shared environments. Sharing of a report based on the target audience Customize the reports to filter what should be shown in the report.
Read this authenticated review

Feature Scorecard Summary

Pixel Perfect reports (71)
8.0
Customizable dashboards (84)
8.6
Report Formatting Templates (77)
8.3
Drill-down analysis (84)
8.5
Formatting capabilities (83)
8.2
Integration with R or other statistical packages (58)
8.2
Report sharing and collaboration (81)
8.5
Publish to Web (78)
8.8
Publish to PDF (69)
8.1
Report Versioning (58)
8.4
Report Delivery Scheduling (56)
8.3
Delivery to Remote Servers (38)
8.0
Pre-built visualization formats (heatmaps, scatter plots etc.) (78)
8.5
Location Analytics / Geographic Visualization (71)
8.4
Predictive Analytics (59)
7.9
Multi-User Support (named login) (69)
8.4
Role-Based Security Model (56)
8.0
Multiple Access Permission Levels (Create, Read, Delete) (62)
8.3
Single Sign-On (SSO) (42)
8.8
Responsive Design for Web Access (67)
8.2
Dedicated iOS Application (51)
8.3
Dedicated Android Application (53)
8.3
Dashboard / Report / Visualization Interactivity on Mobile (67)
8.2
REST API (37)
8.1
Javascript API (29)
8.2
iFrames (30)
7.8
Java API (24)
7.5
Themeable User Interface (UI) (33)
8.0
Customizable Platform (Open Source) (23)
7.9

About Microsoft Power BI

Microsoft Power BI is a business analytics service from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.

Key features

  • Free initial setup with no required training
  • Connectivity with Excel spreadsheets, cloud services, streaming data, on-premise databases, and more
  • Dashboards that update in real-time
  • Natural language processing for data visualization tools
  • Shareable reports and datasets
  • Collaborative framework
  • Remote accessibility
  • Integrates with most applications and services using REST API
  • Publish data directly from service with publish-to-web feature

Microsoft Power BI Technical Details

Operating Systems: Unspecified
Mobile Application:No