Microsoft Power BI

Microsoft Power BI

Visualisation et reporting de BI pour ordinateur de bureau, web ou mobile

4.5/5 (649 avis)

Microsoft Power BI - Présentation

Description du logiciel Microsoft Power BI

Microsoft Power BI est une suite d'outils d'analyse permettant d'analyser des données d'entreprise et de partager des informations via des visualisations enrichies. Les tableaux de bord personnalisables et prédéfinis unissent les métriques importantes en vues uniques et affichent les mises à jour en temps réel sur chaque appareil. Le service web centralisé assure l'interface avec les passerelles de Power BI pour se connecter aux données organisationnelles et les unifier, tandis que Power BI Desktop pour Windows fournit des fonctionnalités de fusion de données locales et de reporting. Les tableaux de bord dynamiques offrent une vue à 360 degrés instantanée sur la santé des entreprises et exploitent 59 connexions prêtes à l'emploi pour des applications ou services tels que Salesforce, Google Analytics, Azure, Facebook, GitHub, QuickBooks Online, Twilio et Zendesk. Power BI rassemble toutes ces données, peu importe où elles se trouvent, pour obtenir une image complète des indicateurs clés pouvant ensuite être interrogés à l'aide du langage naturel. Avec Power BI Desktop, les utilisateurs peuvent créer des rapports à l'aide d'outils intuitifs de glisser-déposer et les partager entre collaborateurs via le service Power BI en ligne. Intégrant le moteur de requête ainsi que les technologies de modélisation et de visualisation de données bien établis de Microsoft, la solution connecte, met en forme et crée des rapports pour centraliser un processus de reporting généralement dissocié. Sortis au format .pbix, ces fichiers de rapport peuvent ensuite être partagés manuellement comme n'importe quel autre fichier ou chargés vers le service partagé. De plus, cette possibilité de garder tous les utilisateurs sur la même page à tout moment s'applique à une suite de support mobile optimisée. Power BI Mobile assure la cohérence de la connectivité à distance entre les applications natives pour les appareils Windows Phone, iOS et Android et ajoute ainsi un fonctionnement intuitif basé sur le comportement. Les tableaux de bord dynamiques peuvent être visualisés à la volée, en plus des fonctionnalités complètes de partage de rapports et des alertes basées sur les données.

Microsoft Power BI - Présentation

Prix

À partir de
9,99 $US/mois

Types de licence

Essai gratuit
Gratuit
Abonnement
Rapport qualité-prix

Microsoft Power BI - Fonctionnalités

Appareils
Pour quelle entreprise ?
TPE PME GE
Disponible dans les pays suivants
Asie, Australie, Brésil, Canada, Chine et 5 autres, Europe, Allemagne, Inde, Japon, Amérique latine
Langues
arabe, chinois (simplifié), chinois (traditionnel), tchèque, danois et 22 autres, néerlandais, anglais, finnois, français, allemand, hébreu, hongrois, indonésien, irlandais, italien, japonais, coréen, norvégien, polonais, portugais, russe, espagnol, suédois, taïwanais, thaï, turc, ukrainien

Captures d'écran

Capture d'écran pour Microsoft Power BI : Microsoft Power BI Desktop shown on Thinkpad
Capture d'écran pour Microsoft Power BI : Microsoft Power BI Desktop shown on Thinkpad Capture d'écran pour Microsoft Power BI : Microsoft Power BI Executive Metrics Dashboard Capture d'écran pour Microsoft Power BI : Microsoft Power BI Mobile for iPad Capture d'écran pour Microsoft Power BI : Microsoft Power BI Query Editor Capture d'écran pour Microsoft Power BI : Microsoft Power BI reporting visualizations Capture d'écran pour Microsoft Power BI : Microsoft Power BI shown on Microsoft Surface Capture d'écran pour Microsoft Power BI : Power BI Desktop Welcome screen

Microsoft Power BI - Avis

Microsoft Power BI - Avis

Note globale
4.5
/
5 649 avis
Excellent
353

Très bien
253

Moyen
34

Médiocre
7

Mauvais
2

Rapport qualité-prix
4.4
Fonctionnalités
4.4
Simplicité d'utilisation
4
Support client
4.1
93% des utilisateurs recommandent cette application
Andrew B.

There are plenty of competitors, but Power BI is tops

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


Traduire avec Google Translate
Jerry A.

Very robust, though a little overwhelming

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.


Traduire avec Google Translate
Sri H.

Really good for aggregating data from multiple sources

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


Traduire avec Google Translate
Utilisateur vérifié

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

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.


Traduire avec Google Translate
Gedson S.

Amazing analytics tool

You'll struggle to find a better analytics tool that's this useful, easy to use and faster to integrate.


Traduire avec Google Translate
Andrew B.
Secteur d'activité: Matériel informatique
Taille de l'entreprise: 10 001+ employés
Traduire avec Google Translate

There are plenty of competitors, but Power BI is tops

Logiciel utilisé toutes les semaines pendant plus d'un an
Publié le 25/08/2019
Provenance de l'avis : Capterra

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

Avantages

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.

Inconvénients

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.

Note détaillée

Simplicité d'utilisation
Support client

Probabilité de recommander le produit: 7.0/10

Jerry A.
Secteur d'activité: Gestion d'organisme à but non lucratif
Taille de l'entreprise: 201-500 employés
Traduire avec Google Translate

Very robust, though a little overwhelming

Logiciel utilisé tous les jours pendant plus d'un an
Publié le 10/12/2019
Provenance de l'avis : Capterra

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.

Avantages

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.

Inconvénients

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.

Note détaillée

Rapport qualité-prix
Simplicité d'utilisation

Probabilité de recommander le produit: 9.0/10

Sri H.
Secteur d'activité: Hôpitaux et soins de santé
Taille de l'entreprise: 5 001-10 000 employés
Traduire avec Google Translate

Really good for aggregating data from multiple sources

Logiciel utilisé toutes les semaines pendant plus de deux ans
Publié le 15/01/2020
Provenance de l'avis : Capterra

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

Avantages

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.

Inconvénients

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.

Note détaillée

Rapport qualité-prix
Simplicité d'utilisation
Support client

Probabilité de recommander le produit: 9.0/10

Utilisateur vérifié
Secteur d'activité: Conseil en gestion
Taille de l'entreprise: 201-500 employés
Traduire avec Google Translate

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

Logiciel utilisé tous les jours pendant 6 à 12 mois
Publié le 18/03/2017
Provenance de l'avis : GetApp

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.

Avantages

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

Inconvénients

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

Note détaillée

Rapport qualité-prix
Simplicité d'utilisation
Support client

Probabilité de recommander le produit: 2.0/10

Gedson S.
Secteur d'activité: Télécommunications
Taille de l'entreprise: 51-200 employés
Traduire avec Google Translate

Amazing analytics tool

Logiciel utilisé tous les jours pendant plus d'un an
Publié le 09/01/2020
Provenance de l'avis : Capterra

You'll struggle to find a better analytics tool that's this useful, easy to use and faster to integrate.

Avantages

* Very powerful analytics capabilities
* Broad support for data sources
* Lots of integrations
* Nice dashboards and visualizations
* Amazing reporting features
* Easy to get started

Inconvénients

* Complex analysis are harder to master
* Automation has room for improvement
* Incremental model support is tricky

Note détaillée

Rapport qualité-prix
Simplicité d'utilisation
Support client

Probabilité de recommander le produit: 9.0/10

Recommandation utilisateur
8.4/10
Basé sur 649 avis utilisateurs
Comparatif avec les logiciels similaires : recommandation utilisateur
Comparer avec les alternatives

Microsoft Power BI - Prix

Microsoft Power BI - Prix

À partir de
9,99 $US/mois
Essai gratuit
Gratuit
Abonnement
Rapport qualité-prix
Rapport qualité-prix
4.4/5
Basé sur 649 avis utilisateurs
Comparatif avec les logiciels similaires : rapport qualité-prix
Comparer avec les alternatives

Microsoft Power BI - Fonctionnalités

Microsoft Power BI - Fonctionnalités

API
Analyse des tendances
Analyse en temps réel
Analyse visuelle
Business Intelligence
Création de tableaux de bord
Données en temps réel
Filtrage des données
Graphiques
Importation et exportation de données
Interface glisser-déposer
Intégration de tiers
Monitoring
Outils de collaboration
Rapports ad hoc
Rapports et statistiques
Rapports personnalisables
Tableau de bord d'activités
Visualisation de données
Vues filtrées
Fonctionnalités
4.4/5
Basé sur 649 avis utilisateurs
Comparatif avec les logiciels similaires : note sur les fonctionnalités
Comparer avec les alternatives

Catégories

Vidéos et tutoriels

Vidéos et tutoriels

Microsoft Power BI - FAQ

Microsoft Power BI - FAQ

Voici quelques-unes des questions fréquentes sur Microsoft Power BI.

Q. Quels sont les types de licence disponibles pour Microsoft Power BI ?

Types de licences disponibles pour Microsoft Power BI :

À partir de: 9,99 $US/mois

Type de licence: Gratuit, Abonnement

Essai gratuit: Non disponible

Q. Quelles sont les principales fonctionnalités du logiciel Microsoft Power BI ?

Nous n'avons pas d'informations sur les fonctionnalités de Microsoft Power BI.

Q. Qui utilise Microsoft Power BI ?

Utilisateurs habituels du logiciel Microsoft Power BI :

Grandes entreprises, Entreprises de taille moyenne

Q. Dans quelles langues Microsoft Power BI est-il disponible ?

Langues dans lesquelles Microsoft Power BI est disponible :

arabe, chinois (simplifié), chinois (traditionnel), tchèque, danois, néerlandais, anglais, finnois, français, allemand, hébreu, hongrois, indonésien, irlandais, italien, japonais, coréen, norvégien, polonais, portugais, russe, espagnol, suédois, taïwanais, thaï, turc, ukrainien

Q. Quels sont les types de licence disponibles pour Microsoft Power BI ?

Types de licences disponibles pour Microsoft Power BI:

Gratuit, Abonnement

Q. Microsoft Power BI prend-il en charge les appareils mobiles ?

Appareils pris en charge par Microsoft Power BI :

Android, iPhone, iPad

Q. Avec quelles applications Microsoft Power BI peut-il s'intégrer ?

Applications s'intégrant à Microsoft Power BI :

Insightly, JustFoodERP, Meisterplan, Microsoft Project, Microsoft Teams, OneSoft Connect, Pro-Sapien, Projectplace, Smartsheet, Tagetik

Q. Quelles sont les ressources d'aide disponibles pour Microsoft Power BI ?

Ressources d'aide disponibles pour Microsoft Power BI :

FAQ, Forum, Base de connaissances, Support en ligne, Tutoriels vidéo