Visualisation et reporting de BI pour ordinateur de bureau, web ou mobile4.5/5 (465 avis)
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.
Overall good software for beginners and can be explored to get the best efficiency from the software
below are a few pros
• Sharing dashboard in a group
a. Sharing can be done once you have the Pro version of Power BI. Dashboard can be shared with the respective department members or your own team members.
b. Since you have prepared the dashboard you will be the owner and you can decide whether you want to give the other members only viewing rights or editing rights as well.
c. With this feature reports will always be on the cloud server and can be viewed as and when required
d. Reports can be downloaded as and when required.
• Viewing dashboard in Mobile/ tab and preparing phone layout
a. Once a dashboard has been prepared and saved, the same can be accessed on Power BI App with the same login.
b. Since the screen is small compared to laptop, all the dashboard elements can be redesigned to suit the phone screen.
c. The other features remain the same and the dashboard is interactive on the phone as well however it cannot be edited on phone.
• Export dashboard to PowerPoint, PDF
a. This is one of the most important features of Power BI. Reports or dashboards prepared can be exported on PowerPoint or PDF with a click of a button.
b. Hence Management reports and department reports can be automated on Power BI and once you refresh the data, the report will be ready to share.
c. One problem is that few images which are not compatible with PowerPoint don’t show post downloading.
• Narratives for dashboard
a. This is one of the recent features offered by Power BI. With the help of narratives you can get the insight of the dashboard in a story form.
b. Narrative uses its intelligence to study the data and give output in pointers, paragraphs etc which can be customised.
• Importing visuals to suit your need
a. Apart from the general visualizations available in Power BI, there are additional visualizations released by Power BI from time to time. These visualizations enhance the visual appearance as well as the adds to further analytics in different ways.
b. Visualizations which have downloaded and used in the dashboard are Infographic designer, Narratives for Business Intelligence, KPI Column chart, and Timeline.
• Edit interactions in dashboard
a. It is important to understand the interactions and groupings in power BI since with the help of these you can control which graphs you want to automatically change by clicking on the other.
b. With the help of grouping you can define groups and sub group which can be viewed together as a group if required.
• KPI Column Chart
a. This is a recent custom visual developed by Power BI. With the help of this visual you can put the KPI target against the actual on a monthly basis.
b. Forecasted revenue/ cost can also be put in this visual which will be shown in different colour.
c. Individual monthly targets can also be put which can be interchanged by putting variance.
d. Data can also been viewed in a table form along with graphical.
• One of the important features of exporting report in PowerPoint does not allow custom visual to be exported. Hence if there are custom visuals in your report then the same will show error once exported.
• Arranging dashboard is a bit tedious and takes a lot of time
• To share reports, we need to publish to MS Cloud. We cannot share report from Power BI Desktop
• For sharing a report even members to who report needs to be shared have to get Power BI Pro. Since the department to whom report is shared is just to view giving them a Pro license might not be useful.
All in all, for the price, this is an excellent tool for helping your organization turn mounds of data into useful insights.
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.
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.
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.
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.
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.
Data is the new petroleum, Information is the new combustible; and Power BI will boost this challenging new world of information and analysis.
For the last 30 years I have been using Excel to work with Tables, Filters, Functions, Formulas, Conditional formatting, Graphs, Pivot tables, Segmentation and VBA to register data and analyze information.
That was great. But now, with the huge amount of data, available from many sources and Excel limitations, we needed something more robust and Microsoft launched Power BI.
I have been using it for more than a year. Now I don’t use pivot tables and graphs for analysis anymore, I use Power BI visualizations to represent and summarize the data.
With it’s impressive tools including geolocalization, I have found more effective ways to convert, transform, represent, analyze and make better decisions and planning with Power BI.
It’s ecosystem composed of Power Bi Desktop, Power BI Services (in the cloud) and Power Bi apps, has allowed me to find very innovative and productive ways to monitor the performance of my business and improve communication with my clients
It is in continuous development.
The first week of each month, Microsoft releases a new version of Power Bi, so we have to keep us updated to use the program efficiently.
But the pros outweigh the cons.
Overall, Power BI has been a game changer. The time saved on creating visual reports is immense and it makes up for some of the cons with software. They are constantly improving and adding new features which shows that they are listening to their customers.
The vast no.of data sources available means it has got all the bases covered. You can connect to SQL Server Database or an analysis service database which is vital for us. Apart from this, the ability to connect to excel and text files means we can make the legacy report more visual and fit it into our dashboard.The best of Power BI is the possibility of collaborating and sharing dashboards and dynamic reports so everyone is singing of the same hymn sheet. The large community of developers means there are constantly new visuals available which can used to awe the customers.
Power BI could involve steep learning curve for non-tech savvy people. It is difficult t convince managers to use Power BI over traditional pivot tables as it could be daunting to learn.
Unless you can play around with DAX queries, Power BI could be limited to the insights it can provide.
Voici quelques-unes des questions fréquentes sur Microsoft Power BI.
Types de licences disponibles pour Microsoft Power BI :
À partir de: 10,00 $US/mois
Type de licence: Gratuit, Abonnement
version d'essai gratuite: Non disponible
Nous n'avons pas d'informations sur les fonctionnalités de Microsoft Power BI.
Utilisateurs habituels du logiciel Microsoft Power BI :
Grandes entreprises, Entreprises de taille moyenne
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
Types de licences disponibles pour Microsoft Power BI:
Appareils pris en charge par Microsoft Power BI :
Android, iPhone, iPad
Applications s'intégrant à Microsoft Power BI :
Insightly, JustFoodERP, Meisterplan, Microsoft Project, Microsoft Teams, OneSoft Connect, Pro-Sapien, Projectplace, Smartsheet, Tagetik
Ressources d'aide disponibles pour Microsoft Power BI :
FAQ, Forum, Base de connaissances, Support en ligne, Tutoriels vidéo