- Deep Integration with Microsoft Office Suit, Excel, Access, Power Point.
- API compatible
- Robust query design from basic to advance consults
- UX sometimes can be overwhelming, can be more intuitive
- Free features always can receive more attention to gain client fidelity
- Solutions like Power BI can always do better with their Mobile version
- Price: The biggest advantage of Power BI is its price. All other data visualization tools can cost thousands of dollars per year, but Power BI would cost way less than $100/month. Most companies have Power BI in their agreement with Microsoft, so it might be even free for most of you.
- It's a Microsoft tool: Well, all of us are used to Microsoft Excel, right? So, the learning curve to use Power BI is not steep since we are all used to how Microsoft organizes their software, especially compared to other tools such as Tableau.
- Powerful cloud: Running a lot of data can be an expensive task for many computers. Since Power BI is cloud-based, all the processing power is done on powerful servers, so you can run complicated graphs and tool will handle super well and fast!
- Add-ins: Power BI has a good stand library of standard features. However, if you need more advanced graphs, such as heat maps, correlation charts, and Sankey charts, they are all available for free.
- Connectivity with non-Microsoft tools: Power BI is great to integrate with other MS tools, but if you want to connect it with statistical or machine learning tools (R, Python, Mathlab, JMP, etc.) you might get in trouble. Tableau, for example, has an easy integration with R and Python.
- Not all features are available in the online version: If you want to use more advanced features, you will probably need to download the desktop version of Power BI.
- No desktop version for Mac: So, I use a Mac and I needed to use some extra features on Power BI. When I tried to download the more complete desktop version, I realized that there's no desktop version of Power BI for Mac! I had to borrow a PC from a colleague to run the analysis I wanted.
- The best scenario to use Power BI is if your organization already has an agreement with Microsoft and you can get it for super cheap or even for free;
- Another good scenario is to make your organization more data-driven since it is usually very user-friendly. Or, if your organization is extremely focused on Excel and you want them to improve their data visualization skills.
- You might want to look somewhere else if you have a lot of datasets coming from several different systems (Oracle, SAP, Nielsen, Neogrid, etc) and you want to integrate them under the same umbrella;
- If you have a team of analysts/consultants experienced in analytics you might want to use another tool since Power BI does not integrate well with other analytics tools.
- Power BI integrates seamlessly with PowerQuery which allows you to easily manipulate source data and add calculated columns for your data model.
- Producing a data model is very easy as Power BI makes visualizing the model schema and joins simple.
- Producing data visuals is so much more user-friendly than in Tableau. Customizing and producing visuals is very intuitive and there are tons of built-in visualizations to choose from ( however some are not explicitly Power BI approved and may not work properly).
- Sharing the dashboards is very easy and end-users can interact with the visualizations.
- Data and visualizations smoothly integrate with other Microsoft products such as PowerPoint and Access.
- Although BI is making great updates on a daily basis, there are still some limitations involved with the data modeling and certain visualizations.
- Power BI is great for interactivity, the various aspects of your dashboard work well together with minimal tweaking
- Power BI is easy to use and design on, the drag and drop or double click features work smoothly and normally auto-generate an appropriate chart type. If you do need to change the type, that is done with the click of a button.
- Power BI makes it easy enough to add custom formula fields to your data set, this could probably use some improvement, but it is easy enough to still be a plus for the tool.
- Power BI lacks slightly in the customization options you have for a chart. You can probably do most of what you need, but it's not as smooth as other tools
- Power BI needs to get the functionality that Tableau has for map "grouping" options. Power BI has a lot of plug-ins available for maps and map types, but grouping data into chunks is difficult. Tableau allows you to lasso a "region"/"group" and report on that, it would be AWESOME if Power BI gets that feature as well.
- Building/cleaning your data set is a process, the Wizard is helpful, but the process is slow. This could be an environment issue though and not a Power BI, but from my experience, while the steps to build a data set are helpful, they take more time than I would like to see.
Power BI is probably not going to be the best tool for a very specific report that someone might as for, with the report being pretty static. Think of something like a template design, Power BI will not be the tool for that.
- One of the most important features in Microsoft Power BI is its minimal learning curve required. excel proficiency would be enough to get even a non BI person to build powerful dashboards
- Powerpivot DAX functionalities are prevalent in Power BI which allows us to perform time series data manipulation. It also allows to
- Excel is versatile and Microsoft Power BI allows integration with office 365 and excel. Management often loves to view numbers on excel and with the help of plugins and publishing fixed pivot tables online, Microsoft Power Bi brings the functionality of excel to interactive dashboards.
- Multiple data source integration is quite powerful and robust.
- Microsoft Power BIis very modular if a functionality is missing a third-party app can be downloaded to fill the gap, this is particularly a powerful feature as not all tools can have all the features in place.
- Every month there are updates to the software and it allows for a free one year trial subscription
- The natural language query and machine learning support to analyze graphs and quickly summarize data is a fancy plus to have.
- The community is vast and open source communities are active to build apps and help to debug errors and aid in workarounds.
- The drilling functionalities on dimension allow the dashboards to be more interactive.
- The data can be manipulated step by step in the backend to arrange the data in the required format. Each step can be manipulated or isolated to achieve the desired result. Example Transform, Transpose, Reverse rows etc
- Dashboards are quite fast and interactive as the data is stored in the cloud in the backend instead of hitting the database
- It can connect to plenty of third-party online services to draw data like Google Analytics, Salesforce, and Sharepoint etc.
- One of the major drawbacks of Power BI is its inability to do incremental data loads effectively. The data needs to be refreshed in its entirety, consuming a lot of resources., even when the same data is required in multiple tables. The query is fired for each instance of the table.
- Lacks external input capabilities within the dashboard. There are no forms infrastructure to input and play around with the dashboard.
- Time-based KPIs need improvement and needs modeling and constant debugging is required to get DAX based functions right.
- The Q&A feature is far from being usable. The questions are often hard to put across.
- The pivot functionality is highly under-utilized. The excel pivot tables can make Microsoft Power BIi a very powerful tool to use.
- Hosting Microsoft Power BIi on portals akin to Tableau online is not available
- Minute details on formatting still needs to improve.
- Data level security and user group specification needs to improve
- On premise power bi report server are expensive option when compared to BI Tools
- Want cool graphs for your next board deck? Great interactive graphs and charts!!
- Detailed reports with easy to use filters help you quickly find segmented info
- Easy drill down into deeper data. We use it to see trends by rep or customer type.
- The app is great but you can only use a few reports otherwise it is hard to read
- It would be great to layer reports or graphs to provide more information in one graph
- It would be good to be able to lock reports so others don’t change them “by accident”.
- Data visualization (dynamic graphics, for example).
- Connecting and fetching data from different sources accross the internet.
- The possibility of publishing reports online, which makes it really easy to share conclusions and insights.
- The management of databases should be easier, more flexible like Excel.
- The Q&A feature is not easy to use.
- The pricing is not ideal. At least, the free version has some big limitations.
- You do not need advanced knowledge to create your own dashboards and reports. Simply build, edit, publish and share to collaborate with whoever needs it.
- Represent your data with amazing, animated infographics or if you prefer something more traditional, use the usual graphics, but with a more attractive presentation than usual.
- It has native applications for mobile phones and tablets. Whether your operating system is iOS or Android.
- One of the main limitations of the BI Power is that it does not have the capacity to publish reports with all the associated data. This means that some data may be left out of visualizations.
- It allows you to easily load and integrate data from multiple sources
- It uses the same UI as other MicroSoft tools so the learning curve is lower
- Integration with Office 365 is smooth
- It can do so much, it is hard to be aware of all it does
- It seems it is primarily to be used with spreadsheets, could use better database integration
- We need curriculum for college students to use it like we have for other Microsoft tools
- Intuitive and Interactive dashboards can be easily constructed
- Many custom visuals available in the PowerBI library
- Import of data in any format is quick and simple.
- Online PowerBI lacks a lot of the functionality that is present in the desktop version
- There are other visualization software that offers a larger breadth of functionality
The online version of PowerBI prevents the creation of custom fields such as fields based on conditional logic etc. and you have to make do with default fields in your dataset.
- Power BI is strong in visualizing data from different sources into easy to navigate dashboards.
- If you are familiar with MS Excel's Power Query and Power Pivot, Power BI will be very easy for you to use.
- The data load is limited to 2GB at a time, which is somewhat limited.
- It has a very good user interface
- Power BI can easily be used by individuals who are not analytically inclined
- Has a large user community where your questions can be answered
- There is not some documentation for some data sources
- Power BI is a build up on excel but some Excel features are kind of lost
- Not all reports can be shared with colleagues as they have to get a pro-licence to work collaboratively
- Because of a strong relationship between Power BI and Excel, Excel power users should find that the Power BI learning curve isn't too steep. Anyone familiar with Power Query, in particular, will find Power BI to be happily similar in many ways.
- It's very easy to import and massage data from a wide variety of sources. The interface allows for some powerful data cleaning and wrangling without the need to learn the underlying M language.
- Microsoft appears to be committed to Power BI; improvements and new functionality are added frequently.
- Advanced Modeling with composable measurement definitions - makes it easy to answer business questions faster and move beyond basic SQL querying to allow us to ask new questions, or to model measurements across different slices of data, very quickly.
- Data Visualization options are rich without being overly complicated. Chart types are structured and limited to those that are really valuable, and custom visualizations make it easy to add some visual "bling" when it's important or needed.
- Easy to publish groups of data, reports, and dashboards in an "app" that users in the business can easily find and consume. Publishing model has gotten much simpler, and we can ship updates to apps very quickly to our entire organization.
- Disparity between web- and desktop- app experience. You can only do "deep" modeling and analysis using power bi desktop, which complicates the authoring and publishing process.
- Dashboards vs. reports is often confusing to end users, and the Q&A feature in the dashboards never quite seems to work like people expect it to.
- Reports' interactive components (slicers especially) have a clunky user experience that makes them hard to get "right" for truly immersive interactive reporting experiences.
- Time-based slicing of data is improving, but still needs to mature more. Difficult to slice to things like "two months ago" still.
Not as accessible for cases where you want analysts to be able to do open-ended analysis and exploration of datasets and models, or when end users need to be able to also create/extend with their own reports over a dataset.
- Easy to use, intuitive
- Inexpensive licencing
- Option to deploy to cloud or on-premise
- Variety of visualizations
- Ability to deploy on top of any data source
- Heavy use of DAX as a programming language for measures/KPIs
- Confusion around the variety of products that serve same/similar purpose from Microsoft
- No ability to create a portal with Power BI
- Top reason to use Power BI is its capability for "natural language query", where users simply type in words of a query to search real-time for financial data in either number format or in charts.
- The second great feature is its monthly updates of 10+ new features, vs quarterly or semi-annual updates with a couple of features by other vendors.
- The third great feature is its efforts to build in customized formulas (or DAX) for rookies.
- Online sharing is a bit difficult for the freemium user who does not sign up for Azure paid accounts.
- Monthly updated software installation voids prior month's installation - with the shortcut button pinned to the taskbar no longer working.
Dashboarding, KPI broadcasting/publishing, trending, real-time data applications, pull reporting information services, dynamic data availability.
Presentation of static information, push information, report repository.
Basically, we use Microsoft Power BI for getting insights from large financial data (stand-alone or multiple relational databases) related to various investors in the entity. Insights related to investment patterns of various categories of financial instruments, impact on investor allocations, decision making based on risk averse investors and financial analysis of overall impact on the portfolio at a micro and macro level with additional insights in drilling down the details at a granular level.
Various departments are using them in silos with the future possibility of integrating the results and applying the insights the at whole organization level.
Earlier, the scope for detailed review was not possible, but due to development in the Power BI features, users at any level can get insights at a granular level.
- First thing is, Power BI belongs to the Microsoft family, which makes it easy for the user to acquaint with the advanced features and implement them to get insights faster on the available data.
- Issues in the application can be resolved faster due to the expert availability at Microsoft.
- The ability of the application to connect to various sources (internal and external) helps to get real-time updates faster, based on user requirements.
- Technology is always evolving, you cannot get the final product in one go. Need constant review to meet the unique & changing business requirements.
- Need to focus on similar applications of competitors, and try to embed features, which are more robust and advanced.
- Need more Data Visualization (Statistical & Built-in graphs) with various categories to pick and choose from. So that even the average user can also use the too.
There is no "One Size Fits All" approach for anything in this world, What might be good for some, ends up irrelevant for others. So, it purely depends on the business requirements, based on size, user level and industry involved in.
Definitely suitable for various fields in the financial services industry (insurance claims, audit services, tax services, etc.).
Review: "Microsoft Power BI - Organise your data and create powerful visuals to assist with business decisions"
- You can use dashboards to clearly show the general picture but very easily drill down into a lot of detail.
- The program is constantly being updated with new features, new ways of displaying data and new UI experience.
- There is good help and community support which helps in learning how to use the tool.
- Sharing reports and dashboards is a bit of a complex system and could be improved.
- Better tutorials around building a clean dataset and joining tables in the best way would be helpful.
- We find that the per-user pricing is a bit restrictive and would prefer to have a company subscription.
- You can't save versions of a report/dashboard.
- The number of scheduled refreshes per day is limiting although seems to be improving over time. It would be good to have the option of refresh every 5 minutes at least (depending on the amount of data needing refreshing).
We currently use it to import templates of Excel files, and visual the data with its graphs. We also pull multiple data points from other applications we use to track VDI and other latency issues. We also have used it to show our managed service customers a custom dashboard they can dig into to see what we services we are performing in their environment.
- The data input from multiple sources, such as excel, Salesforce, odbc connection. It handles data connections and data imports very well.
- The ability to take static data and query it to make it dynamic is vital to the data scientist, this is something Power BI does very well.
- Th e
- The learning curve isn't huge, I was able to get some basic graphs up and running, and learn as I went.
- Power Bi currently doesn't let you add your own connection packs, like we would like one for connectwise, but that is handled by the microsoft team.
- Power Bi currently does not support Mac client and I have a hard time using it in my virtual machine.
- The Power BI documentation and sample reports are not available for download and it is hard to recreate what they have done.
With connecting Power BI directly to the database, we can build very nice visuals on dashboards and then potentially share them with other employees across the organization.
- It's able to connect with a wide array of data sources.
- The number of different options for visualizations is impressive.
- Because some of the functionality resembles those in MS Excel, the learning curve is a little less steep.
- Loading data can sometimes take a long time - would be nice if that could be faster.
- Using Power BI's browser to find the specific tables you need in your data is not easy for someone unless they are very familiar with databases or their data is very neatly laid out and labeled well.
- The UI could use a little modernization, but it's not bad.
- Easy to build layouts.
- Easy to understand fields (values, axis, etc.).
- The support and development from Microsoft.
- It can be a bit slow at times.
- An option for pop-up tutorials would be nice. Perhaps it could recognize what you're working with and recommend something.
- The back end can be fuzzy -- how to import data and keep it updated.
- 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
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.