en en ms fi da da da da ca da da da ms hbs_lat ms ms ms en da da ms ms da es da de ro en da da da da de da da de en it da da da es da da en da da da en da sv de da en da en en en en en da pt fr fr en de en sv da da da da sv da da en en en de en it en en en en en en en en en en en en en en en en en en en en en en en da da da da da en da da da da da en tr da ca en en id en en en en en en en en ms ms ms en en ml da nl en en nl nl da en da de de en en nl en en nl nl sv en da de de en en nl en en nl nl sv en da de de en en nl en en sv nl da en da de da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da da da en en nl en en nl nl sv en da de de en en nl en en nl nl da en da de de en en nl en en nl nl da en da de de en en nl en en nl en da ms en en en sv da fr da it de en ms ms en it da da de en en en sv da en da en da da en da da da hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko da nl nl pl pt pt ru sv th tr zh zh ar he
How Microsoft uses Power BI to run its growing cloud business | Microsoft Power BI-blog | Microsoft Power BI
Office 365 + Power BI
How Microsoft uses Power BI to run its growing cloud business
Principal PM, BAPI Business Analytics and Operations
Today Microsoft is hosting an online event called Data Amp to share how to make te most of data to accelerate te pace of business innovation. Internally, we run every aspect of te company using data, providing te power of data to every employee. We refer to this as our “Data Culture”. As te lead for BI and analytics for James Phillips, te Corporate Vice President that leads te Business Applications, Platform and Intelligence (BAPI) organization, I am often asked how Microsoft uses Power BI and analytics to run its growing cloud business.
With this post, I would like to start sharing our best practices with te internal story of Microsoft’s BAPI organization, which has thousands of team members across te globe. James’ teams build and operate a wide range of products and services. They include Azure App Service, PowerApps, Microsoft Flow, Azure Portal, te Dynamics ERP family of products (AX, NAV, GP and SL), and Microsoft's business intelligence product line — including Power BI, Power BI Desktop, Power BI Mobile (iOS, Android and Windows apps), and SQL Server Reporting and Analysis services.
Running BI and Analytics for James Phillips, te same leader that owns our portfolio of BI products, is no easy feat! On my first day he explained te strategy we have for BAPI, and challenged me to surprise him with a concept for a data fabric to run such a vast organization. We had just a few weeks of time and a couple of resources to start. Luckily, we did not have to select te tools, as Power BI and a range of Azure services had everything we needed.
We built a system of widely used dashboards all driven off a single dashboard that provides a 360 degree view of te business, called BAPI KPIs:
Visual 1: Data and trends have been obfuscated. Click image for more detail.
This is our main dashboard, seen and used constantly by te vast majority of James’ organization. Every tile here depicts a product, and for every product there's a GM who drives two metrics: usage, and user satisfaction, most often measured by Net Promoter Score, or NPS. We wanted this dashboard to be used on PCs and hallway monitors, so we optimized for both high quality visuals and information density. On top of a wide range of standard and community visuals, Power BI allows for easy development of custom visuals, and in just a few weeks we developed a ‘Dual KPI’ custom visual, which is now available in te gallery for everyone to use.
As we prepared for our grand reveal, we considered our audience. What does James do every morning and every evening? He looks at these numbers. But where does he look at them? On his mobile phone, of course.
Visual 2: BAPI KPI Dashboard we use, but actual data and trends have been obfuscated
Once you have your PowerBI dashboard ready, it is immediately available on all smartphone platforms, and with less than 10 minutes of extra work you can create a completely customized mobile optimized version. Executives love to have this live access to their dashboards via mobile – we know from experience that they glance through te numbers with almost addictive passion.
James may also want to inspect every business in more detail. Across our organization we have a lot of data, so in order to avoid a “boundless sea of data” where users get lost finding what they are looking for, we spent some time coming up with an appropriate information architecture. We defined core KPIs that are relevant to all products in te organization for te top-level dashboard, and product-specific KPIs for product dashboards. Each product has a full dashboard that is easily accessed by selecting any of te associated tiles.
We created a few of these product dashboards initially, and defined a standard layout for everyone to use. These dashboards look at essentially all of te content needed to run a thorough product review, including overall usage, engagement, partners, content, delivery velocity of new features, service quality, and NPS. Our dashboard ecosystem is powered by hundreds of data streams coming from many different sources from many databases and technologies, including HDInsight and Azure Data Factory, Azure Data Lake, quite a few directly from SQL Azure, and some through multiple Enterprise Gateways as well as from Excel files on SharePoint.
I've talked about James, but keep in mind that whatever te organization's leader wants to see, everyone wants to see. So we gave access to all of our organization, effectively giving thousands of people a look at te same view of data. We’ve found that when people look at te same data, they understand te decisions better, they collaborate more, they do not need to waste time searching for data, and they are more productive. This also greatly enabled our Advanced Analytics efforts, as data scientists now have well described, clean, and maintained data streams to start with for ML projects.
At Microsoft, we can clearly see te influence this dashboard ecosystem has had on our culture, te quality of data, and on data reuse between teams. People agree faster as they all look at same data, and everyone is clear about their focus and performance, while also expanding data science and experimentation. When everyone in te organization, from executives to analysts, is looking at your data daily, it helps inspire us to maintain a high quality of content and presentation.
Imagine what this all could mean for your own organizational data strategy!
To hear more about how we incorporated Power BI, see me speak at te Big Data Innovation Summit in SF on April 19th and then in our own Microsoft Data Insights Summit on June 12th.
Slawomir leads business intelligence, data science and advanced analytics for te Microsoft BAPI Engineering group. Until 2015 he served as a Director of Consumer Intelligence at Microsoft after 11 years with Procter and Gamble, where among other assignments he was a CIO in Central Europe, spearheaded use of Business Analytics and led all digital marketing and CRM operations in 100+ countries of EMEA. He enjoys speaking and writing about enterprise data transformation, data science and NPS.
Tilmeld dig Power BI-nyhedsbrevet
Tilmeld dig nedenfor for at modtage de seneste nyheder fra Power BI direkte i din indbakke.
Land Afghanistan Albanien Algeriet Amerikansk Samoa Andorra Angola Anguilla Antarktis Antigua og Barbuda Argentina Armenien Aruba Aserbajdsjan Australien Bahamas Bahrain Bailiwick of Jersey Bangladesh Barbados Belgien Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnien-Hercegovina Botswana Bouvetøen Brasilien Brunei Darussalam Bulgarien Burkina Faso Burundi Cabo Verde Cambodja Cameroun Canada Caymanøerne Chile Cocosøerne (Keelingøerne) Colombia Comorerne Congo Cookøerne Costa Rica Côte d'Ivoire Curaçao Cypern Danmark De Amerikanske Jomfruøer De Amerikanske oversøiske øer De Britiske Jomfruøer De Forenede Arabiske Emirater Den Centralafrikanske Republik Den Demokratiske Republik Congo Den Dominikanske Republik Det Britiske Territorium i Det Indiske Ocean Det palæstinensiske selvstyre Djibouti Dominica Ecuador Egypten El Salvador Eritrea Estland Etiopien Falklandsøerne Fiji Filippinerne Finland Frankrig Fransk Guyana Fransk Polynesien Franske Oversøiske Områder Færøerne Gabon Gambia Georgien Ghana Gibraltar Grenada Grækenland Grønland Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard- og McDonaldøerne Honduras Indien Indonesien Iran Irland Island Isle of Man Israel Italien Jamaica Jan Mayen Japan Jordan Juleøen Kasakhstan Kenya Kina Kirgisistan Kiribati Korea Kosovo Kroatien Kuwait Laos Lesotho Letland Libanon Liberia Liechtenstein Litauen Luxembourg Madagaskar Malawi Malaysia Maldiverne Mali Malta Marokko Marshalløerne Martinique Mauretanien Mauritius Mayotte Mexico Mikronesien Moldova Monaco Mongoliet Montenegro Montserrat Mozambique Namibia Nauru Nederlandene Nepal New Zealand Nicaragua Niger Nigeria Niue Nordmakedonien Nordmarianerne Norfolk Island Norge Ny Kaledonien Oman Pakistan Palau Panama Papua Ny Guinea Paraguay Peru Pitcairn Polen Portugal Puerto Rico Qatar Reunion Rumænien Rwanda Saba Saint Barthélemy Saint Kitts og Nevis Saint Lucia Saint Martin Saint Pierre og Miquelon Saint Vincent og Grenadinerne Salomonøerne Samoa San Marino São Tomé og Príncipe SAR Hongkong SAR Macao Saudi-Arabien Schweiz Senegal Serbien Seychellerne Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakiet Slovenien Somalia South Georgia og De Sydlige Sandwichøer Spanien Sri Lanka St. Helena, Ascension, Tristan da Cunha Storbritannien Sudan Surinam Svalbard Sverige Swaziland Sydafrika Sydsudan Syrien Tadsjikistan Taiwan Tanzania Tchad Thailand Timor-Leste Tjekkiet Togo Tokelau Tonga Trinidad og Tobago Tunesien Turkmenistan Turks- og Caicosøerne Tuvalu Tyrkiet Tyskland Uganda Ukraine Ungarn Uruguay USA Usbekistan Vanuatu Vatikanstaten Venezuela Vietnam Wallis og Futunaøerne Yemen Zambia Zimbabwe Ækvatorialguinea Østrig Ålandsøerne
Jeg vil gerne modtage Power BI-nyhedsbrevet. Erklæring om beskyttelse af personlige oplysninger.
Deltagelse kræver, at dine personlige oplysninger overføres til andre lande, som Microsoft driver forretning i, herunder USA. Når du sender denne formular, accepterer du overførslen af dine data uden for Kina. Erklæring om beskyttelse af personlige oplysninger.
Hvad er Power BI?
Power BI er en pakke med virksomhedsanalyseværktøjer til dataanalyse og vidensdeling. Overvåg din virksomhed, og få hurtigt svar med omfattende dashboards, der er tilgængelige på alle enheder.
Få de seneste nyheder fra Power BI-blog
Abonner via mail Du skal angive en gyldig mailadresse Du har angivet en personlig mailadresse. Angiv din arbejds- eller skolemailadresse. Noget gik galt. Prøv igen senere.
Beskyttelse af personlige oplysninger og cookies