Before starting to use Power BI, …
Before starting to use Power BI, …
Customizable dashboards (137)
Drill-down analysis (137)
Report sharing and collaboration (134)
Formatting capabilities (136)
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
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
Frequently Asked Questions
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
- Reports generation and sending it to teammates using power automate.
- Automation of repetitive tasks using M code.
- Use of Q&A to generate visualizations.
- Bulk visualization automation.
- DAX and M code is little tricky to learn and understand.
- Power BI desktop hangs sometimes on 4GB RAM system.
- 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
- Quick real-time information
- Streamlined publications and distribution
- Row level security and element of machine learning and AI
- Ability to connect to SAS datasets
- 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.
- easy to learn
- 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.
- 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.
- Configurable reporting figures that can be set and adjusted to meet your needs.
- Historical data comparisons and progress tracking.
- Ease of access. Being able to access the reports online is awesome.
- Being able to dive into the data and break it down from high levels to small is helpful as well.
- There is a bit of a learning curve to fully use the software.
- It requires a pretty strong data analysis background to be able to use.
- Troubleshooting data issues is not super easy.
- Nice graphic reports
- Sharing reports on the web to be embedded with iFrames
- Friendly interface and simple steps to make a report and publish it on Power BI Service on the cloud
- Easy and simple integration with Microsoft Ecosystem
- Shared web reports (to external users via iFrame) are not really responsive, they can just resize automatically
- The integration with Azure is tricky to achieve some configurations (for example, security settings)
- Power Query is a waste of time and can be replaced by database queries and procedures
- [Microsoft] Power BI is very useful to make cool reports from the scratch with just a little of knowledge, gathering data from a lot of sources.
- Power Query is not the most efficient tool to prepare data neither to analyze it. Power Query language is very complex an the final result can easily be achieved using standard SQL [when] working on a database source, or using other tools like [Python] with Elastic Search.
- It's ability to store massive amounts of data allowed it to be a useful resource for multiple teams
- Multiple different charts and graphs were available, making it far more visually stimulating than Salesforce native functionality
- Data pulls are seamless and show up in easy formatting
- A slightly clunky user interface, makes most end users fear building anything themselves
- 3rd party api syncs seem to be a pretty heavy lift to set up
- The overall set up when building a report is intimidating, and some buttons aren't clear, so hovering over all of them to see their labels can be time consuming and annoying
- 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
- Data loading
- Data manipulation
- Can be slow
- Premium/pro licence required to share dashboards
- DAX language required for more complicated queries
- Load large volumes of data quickly and efficiently.
- Great visualizations to provide insights into your data.
- Table view provides quick at a glance to trouble shoot issues with data.
- Sharing and publishing can be done in minutes.
- Overlay objects or being able to insert an object into another object.
- Make it easier so different groups of people have access to different tabs.
- Improve connections to data source when accessing via Sharepoint.
- 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
- 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.
- 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
- Data from multiple sources can easily be imported and processed using in-built connectors in Power BI.
- Auto ML capabilities are inbuilt helping people create predictive models without an in-depth knowledge of coding and algorithms.
- Reports and dashboards can be accessed on the go via mobile apps.
- Learning to create dashboard on Power BI is a bit intimidating for a new user and takes a long time to learn different functionalities.
- Documentation is not great and links are broken at times.
- No support Mac based devices.
- UI design.
- Easy to plug into database.
- Not exactly intuitive for users unfamiliar with BI tools.
- Big learning curve to set up dashboard.
- It's an excellent tool to integrate tables from different databases into one report.
- The visual indicators are mostly complete and easy to use.
- You can edit/manage/transform your tables to do almost whatever you want.
- The UX is clean and simple, but powerful enough to deliver great results.
- When you get too many tables, it might get a bit slow, it would be great if it could be more performant.
- There aren't as much statistic tools or add-ons as one would want. Now, you can only do descriptive analysis but if you wish to do statistical tests there aren't functions or integrations that help you easily do that.
- Formatting of some elements is a bit limited.
- Sharing a dynamic report is not as smooth as I would like (to do so you need to pay for a license for the visitor or give access to your information to Microsoft, which I legally can't do).
- The integration with R is not as good as I would like, it has many issues with the imports and the versioning of R and its packages.
- It excellently manages the relationship connections between tables.
- It is easy to transform the data using power query.
- Power BI lets you connect to multiple data sources at the same time.
- Using DAX formulas helps you to create new measures using existing fields.
- Power BI could have more charts and visual representations.
- Easier way to manipulate the data.
Less appropriate scenario would be when explaining through different graphs, it doesn't have a lot of options to choose from.
- Ability to consume data from multiple sources.
- Both mobile app and Teams connection available for quick views and collaboration.
- Difficult as a marketer to find data or create reports.
- Need additional training options to view capability and how to or where to find data.
- Search bar functionality not intuitive, at least keep it sticky rather than needing to hover over the bottom of a list.