We basically use this tool as a means of analyzing the maintenance data base in …
We basically use this tool as a means of analyzing the maintenance data base in …
Before starting to use Power BI, …
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
- Customizable dashboards (136)9.090%
- Drill-down analysis (136)8.585%
- Report sharing and collaboration (132)8.484%
- Formatting capabilities (135)7.979%
Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Microsoft Power BI, and make your voice heard!
Power BI Pro
Power BI Premium
Power BI Premium
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Starting price (does not include set up fee)
- $9.99 per month
- Tech Details
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.
- 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
|Deployment Types||Software as a Service (SaaS), Cloud, or Web-Based|
We basically use this tool as a means of analyzing the maintenance data base in SAP.
Because of this tool we can easily be able to find out the insights and bottle necks in the SAP Data.
With Certain filters and query this dashboard can be easily shared to the higher management and can be able to find out where to improve by quickly analyzing the data.
- Dynamic Charts
- Queries and filters
- Dashboard should be easily sharable
- Online Editing should be possible without downloading the app.
Where data keeps uploading on a regular basis and it needs to be shared with a team and all the team members are involved in updating the datasets and charts, so it becomes difficult to manage.
- Excel integration, allowing users more familiar with Excel to transition over with relative ease.
- Inexpensive license model, compared to Tableau which can get very expensive depending on your needs.
- Updates, by far Power BI is one of the most updated apps currently. With monthly releases of new features and fixes.
- Poor interface, not as intuitive as Tableau and very typical of Microsoft where it can easily get you 80% of the way there, while getting the last 20% is seemingly impossible.
- Not enough flexibility in formatting, whereas in Tableau getting something to look 'pixel perfect' takes a lot of effort, in Power BI in a lot instances 'pixel perfect' is not even an option given the lack of controls in formatting.
- Reliance on Excel means data related best practices are naturally hindered by the kind of 'dirty' data that is typically used in Excel as opposed to cleaned up tables sitting in data warehouses.
- no training
- Ability to crunch large volumes of data
- It has a ton (and growing) number of data source connections
- The visualization opportunities get better each month
- The cost model could improve for the premium tier
- Power BI desktop of a VM is pretty cumbersome
- Power BI desktop doesn't work for Macs
- Create workspaces for the assigned data source with security
- Publish and share data across team members
- Publish embedded reports within a given URL or web portal.
- The new UI should be simpler to view from an admin side of view.
- The gateway servers within power bi gateway management should be moved to the previous view for better administration. However, the current new view is different but better enhanced
- ETL tool query editor gives one of the best data cleansing tools inbuilt into the Microsoft Power BI desktop.
- It has more than 200 plus visuals in store and use.
- It has great user community.
- It has ample amount of training videos for users to learn.
- It is very cheap BI tool in Market.
- Visual Formatting should increase by giving more easy to use option like Excel.
- Page level security should be expected.
- Cell merge is required to show heading in visuals.
- For big data like from the past 2-3 years, It will give you an easy visualization of that data with required fields
- The competitive study between the two market cases for example past data of supplier and their costs
- We can also review and visualize our sales with a particular Product ID and in which region it has the most demand
- The query editor is the first thing that can be improved as sometimes it takes more time to show what the exact query is.
- Many sudden bugs keep coming which should also avoid
- An easy way for the formatting as it is somewhat critical...One within one set of commands
- Data Visualization
- Integration with other Microsoft office app i.e Excel
- User Interface is Easy
- Sometime it is hard to work with non Microsoft Applications
- Compatibility issues With Mac
- Leaning curve
- Easy to use.
- Easy Integration with Microsoft office.
- Data Visulisation made
- Data analysis.
- Access levels management.
- Graphical display possibilities.
- Very often desktop app works slow.
- More edit possibilities while using the model in web browser.
- Deal with different sources at the same report (CSV, Excel, SQL, etc).
- Easy to load and refresh the Data.
- How that data is displayed in a visual, is super easy and fast to do it.
- Easy to add new visuals other than the built-in ones.
- Make a way for multiple people to collaborate in the same file.
- Create a tool that you can design and create your own visual.
Before starting to use Power BI, there were a lot of work needed for some meetings (as you had to do same slide for all the possible scenarios) and there were not much flexibility during the discussions.
Now all the flexibility can be addapted during the conversations, making faster and clearer decissions as you can visualize everything with a couple of clicks.
Also it is superflexible in terms of connection to different data providers, so you can combine a lot of information from various places in just one dashboard.
- Data visualization
- Different data connectors
- Speed when big volumes of data
- Selflearning from the data
We have created kind of an internal "App Store" based on Power BI where you have a lot of different dashboards for different solutions (cost, cash, health and safety, sales, factories, distribution centers...) and you as an user just need to get in that "App Store" and enter in whatever tool can be useful for you. It is open to all the operations employees and can use on demand.
Also it has raised the imagination of our colleagues, as they are not only working by themselves creating new reports, but also raising fantastic ideas that can be extended for the usage of all the community.
I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.
- Quickly filter and view granular data sets with easily configurable reporting figures.
- The ability to quickly switch between tabs allows for historical data comparisons and progress tracking.
- It's helpful to dive into the data and break it down from high levels to small.
- Achieve actionable insights faster by using real-time data. It's incredible to have online access to reports.
- The pricing model for the premium tier has room for improvement and a learning curve.
- One must have a solid data analysis background to use Azure integration in some configurations.
- Power Query is unnecessary and can be replaced by database queries and procedures.
- Manage data
- Import data
- Publish to Teams
- Aggregate information from many sources
- The load time could be shorter
- Better connections to non Microsoft sources of data
- Easier to use and manipulate data already in BI
- Quick real-time information
- Streamlined publications and distribution
- Row level security and element of machine learning and AI
- Ability to connect to SAS datasets
- easy to learn
- Analysis and presentation of data
- Report generation
- Simple and effective GUI; easy to learn
- Few customization options
- Icons are small and hard to read at times
- Handling of complex relationships between tables could be improved
- Easy to slice and dice data.
- Familiar theme for those familiar with other Microsoft products.
- Integrates with SharePoint & OneDrive to easily share intelligence across the team.
- It's intimidating for first time users.
- It's "heavy" in that it takes up a lot of processing power.
- Of course, it's only as good as the underlying data.
We import these CSVs to a central data source (SQL Server) and then use Power BI Desktop to transform this data into phenomenal interactive drilldown reports for the executive and financial departments to easily review and take immediate decisions, the transformation is fairly easily and intuitive and the outcomes are very satisfying.
On the [Microsoft] Power BI Pro side, we have it connected to a few online data sources from the cloud, with its automated refresh functionality, we are getting fresh and up to date reports and analytics that help our management make decisions quickly and effectively, [Microsoft] Power BI is an amazing product!
- Easy to setup and develop solid reports
- Supports a substantial number of data sources to import from and connect to
- Great reports designer with many chart types and customizations
- Intuitive interface
- Desktop and Pro versions are reasonably priced
- The desktop app is great but needs a lot of performance improvements
- No MacOS Version for the Desktop app, this is a big limitation for business since executives prefer Macs
- Premium Cloud Version of Power BI is awfully expensive
- On-Premise Version of the Power BI Reports Server is bundled only with SQL Server Enterprise License and cannot be purchased separately and requires Software Assurance Subscription
- On-Premise Power BI Report Server doesn't support ADFS, AzureAD or any Claims-Based authentication platform, a sad disadvantage for enterprises
If you have scattered data left undiscovered, or need solid reporting and analytics, or even just simply want to impress your management with detailed, beautiful and organized reports that are automatically refreshed with fresh content, Power BI is absolutely the tool to go for.
It can import data from an overwhelming amount of sources, such as Excel, SQL Server, Adobe Analytics, Google Analytics, Sales Force, MySQL, Amazon Redshift and many others, and it allows you to quickly and easily build and publish beautiful reports that always impresses the executives and management.
[Microsoft] Power BI is one of a few products that I would recommend to literally anyone who uses a computer, there is always a use case for Power BI, especially the desktop version, the moment you create your first report you realize how much time and effort it saves and how much insights it gives on your data, personally, Power BI is an essential part of my work and I truly enjoy building reports and gathering/transforming data using it.
- Actionable insights
- Subscriptions for scheduled reports to your email.
- Easy to use with different types of data sources.
- Manipulating standard views can be more challenging for less experienced users.
Power BI reports and charts makes it easy to visualize problem areas in production and distribution and where to make necessary improvements in the future. It is great for collaborating with coworkers with dashboards.
- Microsoft Power BI is great for creating reports and charts for data visualization
- It can integrate very easily with excel and SQL server database
- It is easy to learn and use
- It is cheaper compared to other options
- It can sometime take a long time to load the data
- Not enough options to share dashboards externally
- Custom visuals are not easy to configure and manage
- DAX can be difficult to understand and write
- Easy Navigation
- Statistical/ Analytical Analysis
- Easy Data Modeling
- Large volume data handling
- DAX usability
Low training required. Easy to share reports.
- Data connects many other products
- Easy to manipulate data to suit different uses
- Very robust, yet still easy to navigate
- Sometimes the web app version moves slowly or doesn't seem to update effectively
- There is some functionality only available in desktop version
- Interactive tool with great user interface
- Different types of visualization possible
- Custom reports can be created
- Not self learning tool
- A small change in one input file, can have huge impact on the report and it is very difficult to test it
- Need to learn coding for advanced reporting
Not suitable for simple visualization as MS Excel pivot tables are equally good with less hassle and effort.
- Dashboard Reports
- Drilldown Reports
- Predictive Analysis and Charts
- Scheduled Reports Feature
- Needs some training to be able to use it
- Can sometimes be slow if the report has large data
- Using features like Power Query, which is in itself like a tool like Excel, you can clean and preview data before using it for analysis purposes. If you have used Excel in the past, Power Query will, for the most part, be a cakewalk for you.
- The predominant feature one comes to Power BI is the ability to create automated formidable dashboards that everyone refers to before or during meetings to encourage and substantiate decision-making.
- If required, based on specific data points, reports are triggered automatically to certain people as well.
- Off the top of my head, I don't have many areas of improvement to suggest. I have experienced it improving day by day, adding and fixing features.
- I have noticed that if you have data from many sources linked and a lot of data representing figures on the dashboard, it can feel a little bloated in terms of responsiveness. Inline data takes some time to pop up if you hover your mouse over a figure, and changing the data on any table/figure takes time to reflect on the other linked table/figures.
- The earlier they match the functionalities between the online and offline versions, the better. I would like to have a seamless experience irrespective of the platform or environment.
- Very quick and easy to filter down and look [at] granular sets of data.
- Easy to switch between various tabs for quick ad-hoc reporting.
- Easy to read and analyze the charts that we set up.
- Real time, or near real time data, which allows us to make actionable insights easier.
- Since it's a complex system, need a technical team or administrator to manage.
- I don't like being locked out. Make it easier to stay log[ged] in and not fill in password.
- SSO login would be huge! This would save a lot of time and improve security.