Reviews (1-25 of 91)
There is also a dashboard for observing the ongoing projects status and stages. Every department uses Power BI with different data sources but all solutions are targeting data visualization and ease of implementation.
Microsoft Power BI is a quick-to-implement software that makes it easier to deal with large datasets and create relationships between different data sources.
- Importing data sources: Very intuitive way to import data, with pop-up wizards to guide the process.
- Creating charts and graphs: It is possible to create charts and graphs just by dragging data fields, no programming required.
- Power BI online is still very limited and also requires that every user has a pro license to see published dashboards.
- If you need to make advanced changes to the imported data, it is required to learn the M-Query, which is a Power BI programming language.
Less Appropriate: Small data sources, which do not require a second software to display information in a visual way. Using/buying Power BI for small data sources is overkill and is going to generate unnecessary expenditures.
- Allowing various datatypes/sources
- Simple and intuitive UI
- 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.
- 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.
- 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.
- Where small organisations need to display their data for internal use, using a self-administered solution.
- 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).
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.
- Saves time as regular reports do not need to be created every time.
- The tool has several grafts and charts that can be created by the click of a button.
- It is easy to analyze data by dwelling deeper in each data set.
- Can be interfaced with several systems.
- The system is useful in data analytics but there is a learning curve.
- It is difficult to understand the linking of datasets while organizing data in the beginning.
- You need to work with an IT person to interface Power BI with existing systems.
- While the tool runs the required metrics, it does not tell a story to connect all the metrics. Human intervention is required in this phase.
Like I mentioned before, there is a learning curve to understanding this tool. It needs practice. Microsoft organizes free in house training for Power BI. Anyone can sign up and learn. The training materials are very useful and the staff is very knowledgeable and polite. The information can be obtained within the tool updates.
- 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.
- 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.
- 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.
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.
- 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.
- 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).
- 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.
- 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
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.
- 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.
- 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.
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
Scenario where it is less suited - User who does not know how to handle big data and cleaning data requirements of BI.
- 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.
Microsoft Power BI Scorecard Summary
Feature Scorecard Summary
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.
- 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