Microsoft Power BI reviews

Microsoft Power bij voor data analyse

Opmerkingen: Relatie aanbrengen en leggen waar nodig filteren of sorteren

Pluspunten:

Cross database en andere bronnen snel samen voegen

Minpunten:

Enige kennis van formules nodig en liefst Visual Basic programmering in kennis hebben is een must voor deze software goed te kunnen gebruiken

Onmisbaar tool voor duidelijke raportages

Opmerkingen: Wordt echt wekelijks gebruikt voor presentaties

Pluspunten:

Zeer aangenaam product om visueel aangeven van gegevens en data

Minpunten:

Soms moelijk om data te uploaden. Eist enige ervaring tot je onder handen hebt.

Ugly numbers to pretty pictures

Opmerkingen: Management loves it, I love developing with it but getting certain others to adopt it can be a bit of a challenge.

Pluspunten:

As the title says, it turns ugly numbers into pretty pictures. It is easy enough for a non-developer to use and turn a mess of data into an intelligent and understandable story.

Minpunten:

It literally changes every three months. You just get used to it and with the next update a lot has changed. I don't really see this as a con though because this is more like a Christmas present waiting to see what they will have made better this go around.

Great tool for Data Analysis and Dashboards

Opmerkingen: My overall experience is great, using it to compile, perform ETL, prepare reports and create Dashboards is simply powerful.

Pluspunten:

This is a great tool that integrates perfectly with Microsoft Excel (they are from the same family) it really makes life easy. Another great feature is the possibility to connect with a wide variety of sources such as Google Analytics, Facebook, SQL, data files, cloud files, and the list goes on. Free to use and very affordable price. Finally their visualization features are also impressive.

Minpunten:

Like any other tool, we found a high amount of the time required to train and master it, when you try to go beyond create reports, you would need to learn about additional tools like Gateways and Report Server. In addition, their language DAX is not the easiest language to work with, but nothing some training and research can't solve.

POWERBI - An affordable tool for dashboards and data virsualisation

Opmerkingen: My overall experience with powerBI is awesome . I higly recommend this product because it handles all type of data without any lag. I highky recommend powerBi

Pluspunten:

Simple to use . The application is extremely advanced and provide high level advanced business analytics with vast utilities. The interface is interactive . Business utilities are numerous and the business insights gained through data analysis are quite useful. Because the server is capable of handling any type of data load, the system does not lag or slow down. Making proper business decisions is aided by correct and accurate analytics.

Minpunten:

No issue. one of the top business intelligence and analytics tools available today. highly dynamic with a variety of features and tools. The tool can work in any type of corporate environment because it is stable and adaptable and backed by microsoft. It works nicely with all other dashboard types and IT platforms. With Power Bi, data pulling and pushing may be done instantly and accurately. No issues or difficulties at all

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of the Microsoft Landscape

Opmerkingen: In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular. This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft’s «Cloud First» Strategy. 1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters.
First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either. This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources.
With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.)
What’s really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft’s Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.)
In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials.
That’s a big limitation in Data Connectivity. 2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud. Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day.
Tough luck.
While you can publish your Report to Power BI Online and subsequently a broader audience, it’s a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew.
You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes. 3) The On-Premises Data Gateway is pretty useless for Web Services.
Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it’s pretty ironic to route web calls via on-premises infrastructure.
But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI.
Will you do that? At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job. However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in. For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure? My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there).
My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it’s your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.) Is it a Tableau destroyer? No. It’s a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.

Pluspunten:

pretty visuals Power Query On-premises Data Gateway responsible Pro Support

Minpunten:

lack of data sources pretty useless for 3rd Party Web Sources

Highly recommended intelligence and analytics tool for businesses and professionals !

Opmerkingen: Absolutely great experience so far. One stop solution for all our data analysis need with speed and accuracy. Easier to install and can be deployed anywhere, anytime. It functions with great accuracy and precision. Highly valuable tool for business analysts and businesses with big data and predictive modeling.

Pluspunten:

Easy to operate and understand. The application is highly advanced and provide high level advanced business analytics with huge utilities. The dashboard is interactive and is not boring at all. The business insights from data analysis is of great use and has wide business utilities. Server is good enough to manage any kind of data load due to which no lag or no slow down of system is observed. Correct and accurate analytics helps in driving accurate business decision making.

Minpunten:

No problem. One of the best analytics and business intelligence tool in current era. Highly dynamic with wide features and numerous utilities. The tool is versatile and stable to function across any kind of business environment. It integrates well with any kind of other dashboards or other IT platform . Pulling and pushing of data is instant and accurate through Power Bi. No hassle or problem at all.

Using Business Intelligence to Its Full Potential

Opmerkingen: Overall, Microsoft PowerBI is a well-known business intelligence application that is extensively utilised by businesses of all kinds. Its robust data visualisation features, data connection choices, and capacity to find insights using AI and machine learning make it a useful tool for organisations looking to extract more value from their data. However, for certain users, the steep learning curve, restricted data preparation capabilities, and convoluted licencing approach may be disadvantages. Furthermore, the restricted third-party connection may be inconvenient for enterprises that employ a range of tools and systems. Regardless of these restrictions, PowerBI is a highly rated programme that is extensively used and trusted by enterprises seeking a comprehensive business intelligence solution.

Pluspunten:

PowerBI enables users to connect to a wide range of data sources and generate visually beautiful visuals that bring data to life and make it easier to comprehend. The programme is also extremely customisable, allowing customers to design dashboards and reports that are tailored to their individual requirements. PowerBI's mobile capability and connection with Microsoft products like as Excel make it an excellent alternative for enterprises that require on-the-go data access and interaction. Furthermore, PowerBI's AI and machine learning features enable users to quickly uncover insights and trends in their data, making it a useful tool for businesses of all sizes.

Minpunten:

PowerBI has a steep learning curve, making it difficult for new users to rapidly become acquainted with the product. For some users, particularly those new to business intelligence and data analysis, this might be a barrier to entrance. Because PowerBI lacks a powerful data preparation tool, users may find it difficult to clean, process, and prepare their data for analysis. This might be a disadvantage for those that require more complex data preparation operations.

Simplifying Data Analysis and Presentation

Opmerkingen: while Power BI is a powerful tool for data visualization and analysis, there is room for improvement in terms of collaboration, mobile accessibility, and ease of use for advanced features. Nevertheless, it has been a valuable addition to my toolkit, and I would recommend it to anyone looking to enhance their data analytics capabilities

Pluspunten:

I like its interactive dashboards and its built-in AI capabilities, it allows me to bring data to life and share insights with stakeholders in real time. The dashboards are highly customizable, making it possible to tailor them to meet specific business needs. and it aids my ability to perform predictive analytics and natural language processing, making it easy to gain insights from data.

Minpunten:

In terms of difficulty of use, I have found that some advanced features, such as predictive analytics and natural language processing, can be challenging for users who are new to data analysis. However, Power BI has a large online community and offers extensive tutorials and training resources to help users get up to speed quickly.

Power BI - next level in story telling

Opmerkingen: i am extremely happy using this tool. id recommend it to any one who wants to make their excel report a bit more fancy

Pluspunten:

the soft is versatile. as it is most frequently used for business intelligence report. i found it can be used for project management tracking. its easy for me to do a live feed as well

Minpunten:

the error pop up could be alittle more detail as to what error we are facing and the support team gives us reasonable solutions

Best business intelligence tool

Opmerkingen: I used Power BI with other Microsoft products, such as Excel and Azure. It easily import data from these products and combine it with data from other source.

Pluspunten:

It is user friendly, it has the drag-and-drop interface that makes it easy for users to create interactive reports and dashboard.

Minpunten:

It still requires some level of technical knowledge to use effectively.It may be difficult to connect to non-Microsoft products.

Business Intelligence Tool for Businesses

Opmerkingen: Without technical knowledge, even new employees can use Microsoft Power BI to generate interactive visualizations and reports thanks to its user-friendly interface.

Pluspunten:

Data input from many sources is made simple by Power BI's integration with other Microsoft products including Excel, SharePoint, and Azure.

Minpunten:

Despite the variety of visualizations offered by Power BI, we perceive the selection to be limiting when compared to alternative BI tools.

' Data Visualization and Business Analytics is just a click away with Microsoft Power Bi "

Opmerkingen: Its amazing till date. One of the best analysis and visualization software in the market with high credible name of Microsoft and high trust built there. One of the most dependable and accurate software for data visualization and analytics. One of the best analysis softwares for businesses to bring the best data insights on the table for making accurate business decision making.

Pluspunten:

High end accurate data visualization and its easy and comprehensive reporting to management AI and ML driven data insights for better business decision making in holistic manner. The quick and accurate data insights helps businesses to scale and expand with good operating efficiency.It is available for both web and Mobile data visualization work and is quite comprehensive in providing output.We have recently started with Data Discovery and predictive and embedded analytics for high end data analysis of complex data inputs in easy and flawless way.

Minpunten:

No hassle with the software as its one of the best and keep improving their features time to time. Also, we would only request for slight reduction of sign up and annual renewal costing as its on higher end and bit difficult for small and marginal organizations to continue with long term engagement due to burden of expense

Very robust, though a little overwhelming

Opmerkingen: We're moving from having staff creating Excel reports or Access database reports to having Power BI do it all for us. We spend some time cleaning up the user's data, streamlining how they enter it (and where - we still use Access, some SQL, some Sharepoint), and Power BI does the rest after that. Our staff loves that they no longer have to manually create reports, and they love the way Power BI looks for them. We are enjoying it overall.

Pluspunten:

The dashboard creation is amazing. Give it a data source, design how you want to see your data, and it shows it to you. I enjoy creating dashboards for our different departments. And once our staff sees the reports and dashboards they get from this, vs how they used to get it in an Excel spreadsheet or an Access Report, they are hooked.

Minpunten:

Overwhelming in the back end. Sometimes you just cannot get the data to display the way you want. There are so many options, features, methods. It gets overwhelming. My biggest gripe is that the back end is not as user friendly as other programs. And, comparing it to something that one of my users would create in Excel, it's difficult for me to get the exact data reported that they want. I have to figure out how to display it, and because the Power Bi is just so robust, it's a little overwhelming in that respect.

Really good for aggregating data from multiple sources

Opmerkingen: Power BI has helped us go from random spreadsheet reports to consolidated dashboards that are pleasing to look at and easy to interpret.

Pluspunten:

The interface is beautiful and easy to navigate. Once data sources are all connected, it's pretty easy to create a new dashboard/layout if you know how to analyze your own data. Nearly every integration that we needed was already included.

Minpunten:

It's hard to build some more complex reports. If you want to combine two different data sources into one view/metric, you will need some advanced skills.

Power BI, widely used Tool

Opmerkingen: Concluding or summing it all up, I think this is by far the most convenient tool out there for performing various things such as extract data from different sources, clean, visualize, create colorful dashboards and reports. All in all, a great way to present what we have to say in words. With the use of Artificial Intelligence too, its clever enough to handle certain tasks really well.

Pluspunten:

Most of what I like about this is the outcomes of it, it is simply brilliant as to how we get such clarity on insights with this tool. This can make businesses take the correct decisions that drives them into good decision making that profits them. A one stop BI solution tool.

Minpunten:

While creating complex relationships among data, it can be a little tedious to do it because if there are multiple links amongst the tables/data, POWER BI cannot handle them quite well at times. The factor of modeling the data in the right way comes in picture.

Analytic Superman

Opmerkingen: Power BI has been a game changer for us when it comes to how we see and break down the analytics of our business. Its a platform that integrates all parties to one sheet and allows us to break the data down visually and analytically. Only drawback is when you need to make an update it could take the builder some time to update.

Pluspunten:

I love the way Power BI is able to show the data in a very eye friendly way. If you have a business that has markets, districts, and locations that need to show data then Power Bi allows you to break this down to any analytics you need to see with graph representation. Its great!

Minpunten:

It does take some knowledge around formulas and excel. If you don't have an analytic data team that can make these repots for you on Power BI then it will take you a longer time to see the analytics from it.

The Ultimate Data Visualization and Analysis Tool

Opmerkingen: Power BI is a powerful and popular tool, it may not be the best fit for everyone, depending on their needs and budget. Power BI is a powerful and flexible tool for data visualization and analysis that is widely used by businesses and organizations of all sizes. Its ability to connect to a wide range of data sources, and to collaborate and share insights with others, make it a valuable tool for anyone working with data.

Pluspunten:

One of the best features of Microsoft Power BI is its ability to quickly and easily connect to a wide variety of data sources, including Excel spreadsheets, databases, cloud services, and online services. Power BI can pull data from these sources, process it, and visualize it in a variety of ways, including interactive charts, graphs, and dashboards.

Minpunten:

Power BI can be complex and overwhelming to learn, especially for those who are new to data visualization and analysis. Power BI includes a wide range of features and tools, and it can take some time and effort to become proficient in using them all.

Powerful BI tool

Pluspunten:

If you have worked with Office tools, you would grasp the basic functionality very quickly. It's very user-friendly. The power comes from a plethora of data source connectors that it provides out of the box. I am also impressed by its data visualization capabilities. It also integrates well with other Microsoft products. Best of all - it's free for most use cases. The cloud version offers a lot more options for storage and collaboration at a modest price. It's also easy to switch between the desktop and cloud versions.

Minpunten:

The desktop app can be sluggish at times, especially if you are dealing with large and varied data sets. Also, to utilize its more powerful features, you need to have a greater learning curve than competing products. Cloud integrations are also not very easy to configure and connections to on-prem and SaaS data sources can be challenging.

It brings the power of BI down to non-tech users

Opmerkingen: My job is to collect and process all sorts of data in my organization and present them to the highest management committee for policy level decision making. We are heavily dependent on MS Excel for this. I handle excel worksheets with thousands of entries every day. A year ago, I tried Power BI to see whether it can help me in my job or not. And i am hooked till now. I am most impressed with the processing power of Power BI. Huge worksheets can be processed very fast using Power BI. It also updates the reports automatically which improves my productivity significantly.

Pluspunten:

1. Ease of Use: Unlike other BI software’s, Power BI's interface is friendlier especially to MS Excel users. You will not feel overwhelmed rather it will look familiar. 2. Powerful engine: Users who need to tackle very large datasets with thousands of entries know that MS excel gets horribly slow processing such a large file. Power BI is a God sent for these users. Its processing engine is super-fast and the speed is more noticeable when you let it handle such large datasets. 3. Excellent data presentation tools: For regular MS Excel users Power BI is a PowerPivot on steroid but a lot smarter one. Even those users who are not familiar with the complexities of PowerPivot feels less intimidated by its simple and user friendly design. 4. User friendly but powerful DAX language: To write formulas you have to use DAX language in Power BI which in my opinion is a fancy name of just natural language formula writing. However, DAX is super easy to learn and pretty much intuitive but at the same time very much powerful. 5. Schedule refresh option: Power BI has an option to auto update the report at fixed interval of time which is very helpful if you need to prepare and submit reports weekly or monthly. 6. Option to control users of the report: In Power BI you can share your reports with other users and also control how much of the report can they see. If you want you can allow only a part of the report to be seen by some user which is super convenient.

Minpunten:

Honestly, in my opinion, Power BI is by far the best software made by Microsoft. But considering I am a heavy user of MS Excel, it is easier to me. I think learning curve of Power BI for a beginner with no prior skill in MS Excel will be a bit steep. Then again, BI is a complex thing itself. So master any kind of BI software will be tricky by its own merit.

Microsoft Power BI has changed the way we report - and it's been great!

Opmerkingen: We have begun to use this for all business reporting - from the Executive team all the way to the daily front-line workers. It has replaced outdated Excel files and labor intensive reporting methods of the past. It has become invaluable as a daily tool for the entire team and saves an extensive amount of hours from redundant report generation.

Pluspunten:

It is so easy to use once you understand the premise of it. We have super users that create functional dashboards so that anyone can go in and get real-time updates without having to rewrite queries. We use this for our daily sales reporting and it lets you drill down and really understand the numbers.

Minpunten:

It was a little intimidating to use at the start as there is so much functionality. Once you get the hang of it, it makes perfect sense. Just take your time to learn and focus on one aspect at a time and it will all make perfect sense.

Miscrosoft Power BI for Federal Acquisition Spend Analysis

Opmerkingen: All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.

Pluspunten:

Power BI simplifies the process of combining different types of data sources to create a single data model. There are also many built-in Extract, Transform, and Load (ETL) functions that help reduce the time required to prepare data. Creating reports and dashboards is as easy as drag and drop. The Power BI User Groups are strong and plentiful, so you can always read through blogs to get answers to questions that you may have. The Power BI Desktop application is used to perform ETL, create reports and is free. The reports are published to the Power BI cloud service for sharing, which is also free with limited capabilities. For more capabilities, such as security groups and scheduled data refreshing, there is a subscription fee. Microsoft will be releasing an on-premise solution for sharing Power BI content via an update to SQL Server 2016 hopefully within the next few months.

Minpunten:

It's not always easy to speak directly with a MS Power BI expert, so that is a bummer. Also, you have to sign up to the Power BI service using an email address in order to share and view Power BI reports and dashboards, but Microsoft doesn't yet support personal (.cox, .gmail, et.) or government (.gov, .mil, etc.) email addresses which is a real bummer.

Great, Simple Vizualization Tool!

Opmerkingen: Overall I have had an excellent experience with power bi as someone coming from a Network engineering role into data science and visualization. Power bi does a great job with ease of learning the product.

Pluspunten:

Free desktop tool for modeling is great to try out for anyone. Excellent customer support. Using the power bi web dashboard is a great way to gain the visibility that you need to make this Business intelligence valuable. Being able to send reports on a schedule makes it a great tool for displaying and sharing data. The level of features and third party visualization also makes this a versatility tool that any data driven groups could benefit from. Publishing from the desktop to the web version is extremely simple.

Minpunten:

When creating measures and columns there can be some slowness or odd reactions while using the measures/columns as filters. Not able to choose a theme for the background colors.

BI tool with the coolest features

Opmerkingen: I have been using PowerBI from the past 3 years and have never looked back. It has helped me as an analyst to draw my clients into my stories. The automation aspect of PowerBI is hard to ignore. I have shared my dashboards and collaborated with teams which was a nightmare before. I love the addition of new features resulting from a dedicate community of PowerBI users (with very responsive Microsoft developers jumping in to solve issues). Mobile version of PowerBI is convenient and a hit with clients.

Pluspunten:

I love everything about PowerBI! I like to think of it as a revamped version of MS Excel but with features that exceed all expectations. PowerBI lets you create data models, use DAX to manipulate and summarise and finally display these summaries in fancy (yet easy to understand) visualisations. The best feature might however be the ability to share and collaborate on dashboards. PowerBI can take data from almost all possible sources - text, excel, SQL databases etc etc and integrate it all together to form dashboards that can be shared online in the form of webpages as well as workspaces.

Minpunten:

There is absolutely nothing to dislike about PowerBI. The free version of PowerBI is a great learning tool and lets you accomplish almost all your reporting tasks while the paid version lets you automate all your reporting.

User-friendly and with a relatively quick dataset load time, data-driven business insights

Pluspunten:

The greatest business intelligence and data analytics software is Microsoft Power Bi Desktop, which guarantees that accurate data-driven insights are retrieved for corporate decision-making and smooth implementation. We can analyze, analyze, and even build dashboards using data in a variety of formats that have greater processing capability for rows and columns than Excel. Additionally, the visuals are considerably more exquisite and diversified. When I get stuck with DAX code, Power BI community articles and the DAX language's simplicity come in handy. Power BI is far more user-friendly and intuitive, in my opinion. I would strongly advise any organization seeking a BI solution to use this.

Minpunten:

Power BI's inability to produce bespoke infographics as quickly as Tableau is its main drawback. Direct connections may be made between Power BI Desktop and PostgreSQL DB. However, we are unable to directly link PostgreSQL DB with the Power BI service. Additionally, the cost of the program has to be drastically reduced so that more small and underutilized enterprises may benefit from it and use its features to their best potential.