Microsoft Power BI


Microsoft Power BI Logo

 

701 Bewertungen (4,5/5)
 

Microsoft Power BI is a web-based business analytics and data visualization platform that is suitable for businesses of all sizes. It monitors important organizational data and also from all apps used by organizations. Microsoft Power BI provides tools to quickly analyze, transform and visualize data, and also share reports.

Microsoft Power BI offers SQL Server Analysis Services through which users can quickly build reusable models using the overall data. The software enables users to integrate their apps, so as to deliver reports along with real-time dashboards.

Microsoft Power BI also provides self-service access to major third-party cloud sources such as GitHub, Zendesk, Marketo and Salesforce.

Microsoft Power BI is available both in free and paid (Pro) versions. The free version is not limited by any time period; however data of only 1GB per user can be analyzed. Otherwise, it costs $10 per user per month for 10GB storage.

 

Microsoft Power BI - Metrics dashboard
 
  • Microsoft Power BI - Metrics dashboard
    Metrics dashboard
  • Microsoft Power BI - Public preview
    Public preview
  • Microsoft Power BI - Retail analysis sample
    Retail analysis sample
  • Microsoft Power BI - Sales manager
    Sales manager
  • Microsoft Power BI - Share dashboard
    Share dashboard
  • Microsoft Power BI - Travel analysis
    Travel analysis
Unterstützte Betriebssysteme:
Windows 7, Windows Vista, Windows XP, Mac OS, Webbrowser (OS-agnostisch), Windows 2000, Window 8, Windows 10

701 Bewertungen über Microsoft Power BI

 

Andrew B. Branche: Computer-Hardware Anzahl der Mitarbeiter:  10.001+ Mitarbeiter Mitarbeiteranzahl:  10.001+ Mitarbeiter

25.8.2019

25.8.2019

Quelle der Bewertung: Capterra

There are plenty of competitors, but Power BI is tops

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Kundenbetreuung

Power BI allows me to manipulate data and present it in visually appealing and flexible formats.

Vorteile

I have used Tableau and Google Data Studio - among other alternatives. Nothing has seemed to compare to the functionality that Power BI offers. Everything about the program is made with the full spectrum of analysis in mind - from the designer to the data 'wrangler' to the end consumer (ie. others within the enterprise). In this way, Power BI is extremely powerful because it can be used for so many different types of projects; the data-analysis intensive to the more visual 'data-presentation' dashboards.

Nachteile

Sharing dashboards and reports in Power BI is easy and it has a lot of options for doing so. However, the requirement that all users must have a Pro Account to view dashboards created in Pro is a bit of a hindrance in a global organization where it does not make economical sense for every employee to have a Pro account. It seems like it would be a great addition to allow limited sharing to everyone - even those without a Pro account, as most of my internal team does not have an account.

Deepak F. Branche: Computer-Software Anzahl der Mitarbeiter:  51-200 Mitarbeiter Mitarbeiteranzahl:  51-200 Mitarbeiter

7.2.2020

7.2.2020

Quelle der Bewertung: Capterra

The visualization and analytics product that is constantly evolving - for the better

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert

With Power BI we identify patterns, issues and opportunities in sales, marketing, operations, supply chain, people management and finance data. The ways to look at the data and the drilling capabilities make this a wonderful tool

Vorteile

1. Improves with new releases every two weeks
2. Powerful insight management
3. Integration with MS products
4. Online forums and learning zones

Nachteile

1. Not as intuitive as packaged applications, but getting there
2. Not a good IDE for Python / R
3. Connectors to social media need to be improved

Verifizierter Rezensent Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  51-200 Mitarbeiter Mitarbeiteranzahl:  51-200 Mitarbeiter

5.5.2020

5.5.2020

Quelle der Bewertung: Capterra

Best BI Tools for Microsoft Stack

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Vorteile

It was a no brainer to use PowerBI after trying Tableau and Qlik Sense. It was almost as easy to use as Excel, fit right into our Microsoft stack, and we already have licenses with our Office 365 org.

Nachteile

Since PowerBI is the new tool around, they are releases features so quickly that it's hard to keep up and understand if the documentation you are looking for is still relevant.

Verifizierter Rezensent Branche: Unternehmensberatung Anzahl der Mitarbeiter:  201-500 Mitarbeiter Mitarbeiteranzahl:  201-500 Mitarbeiter

18.3.2017

18.3.2017

Quelle der Bewertung: GetApp

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

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Kundenbetreuung

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.

Vorteile

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

Nachteile

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

Empfehlung für andere Nutzer

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.)

Carlos benjamin G. Branche: Informationstechnologie & -dienste Anzahl der Mitarbeiter:  10.001+ Mitarbeiter Mitarbeiteranzahl:  10.001+ Mitarbeiter

29.3.2020

29.3.2020

Quelle der Bewertung: Capterra

A great way to make Reports

Übersetzen auf: Deutsch
Bedienkomfort

 

Funktionalität

 

Produktqualität

 

Preis-Leistungs-Verhältnis

 

Kundenbetreuung

 

Bedienkomfort
Bedienkomfort
Funktionalität
Funktionalität
Preis-Leistungs-Verhältnis
Wert
Kundenbetreuung

Have been Great as a tool to Make any kind of Reports, Really Easy to use for Real, And If you think of a Report is Probably already Suggested and done by POwer BI.

Vorteile

That it is like a Database that Understands you, and It Automatically, get Ideas to what you maybe need on terms of Reports, it is really great for real.

Nachteile

You Need a Trainning It is Not a Plug and Use system, you need to have some experience and Trainning to use it. But Thats Ok