en en ms fi fi fi ms fi fi fi fi fi ms hbs_lat ms sl ms fi fi fi ms ms fi fi it fi en fi fi en fi fi fi fi fi fi fi fi fi fi fi fi fi fi sq fi en fi fi fi fi fi eu fi fi fi de id fi fi fi fi fi fi fi fi fi fi fi fi fi tr fi fi fi ms en en en en fi en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en fi fi fi fi fi fi fi fi fi fi fi fi fi fi ca en en id en en en en en en en en ms ms ms en en ml fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi fi en fi ms en en en fi vo fi fi fi fi fi ms sl fi fi en fi fi fi fi de fi fi id fi en fi fi sv fi fi fi 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 nb nl nl pl pt pt ru sv th tr zh zh ar he
Here’s how Microsoft executives are using Power BI | Microsoft Power BI – blogi | Microsoft Power BI
Office 365 + Power BI
The Customer Data and Analytics (CDnA) team at Microsoft enables strategic data insights that shape the entire organization, from high-level leadership policies to small product decisions. At its core, CDnA creates and monitors indicators, known as “Power Metrics,” for some of the key divisions and businesses in Microsoft. CDnA delivers Power BI dashboards to several teams, including the Windows and Devices Group (WDG), Office, Bing, Cortana and Microsoft CEO Satya Nadella’s Senior Leadership Team (SLT). The SLT leverages the Power BI dashboards to monitor progress on strategic initiatives at the company.
Both CDnA and the Power BI product have mutually benefited from a close relationship since the Power BI public preview in 2015. In fact, the early and ongoing input from this internal Microsoft team and its users has helped make Power BI the “enterprise ready”, robust, and feature-rich platform it is today.
The joint history of Power BI and CDnA
In 2013, the CDnA team started using an on-premises Microsoft reporting solution, leveraging PowerPivot integrated with SharePoint, Power View, and Excel Services. PowerPivot, for data modeling, and Power View, for data visualization, became the foundation used by Power BI. Greg Koehler, Senior Program Manager Lead for CDnA, was the first person to set up that early portal, and he began hearing about Power BI as the next big tool in late 2014.
At the time, Power BI was only in preview and still being developed to accommodate enterprise-level requirements. Koehler and colleagues teamed up with Power BI Product Managers in a strategic partnership to work on prioritizing new features and migrating key reports and dashboards from Power View to Power BI. This partnership resulted in the development of several enterprise features for large teams, such as support for sharing dashboards and reports to security groups, improved interactivity for visuals and slicers, performance optimizations, and user experience improvements for Power BI Mobile apps.
The partnership between the two teams continues today, and has helped encourage Power BI developers to create a truly enterprise-level service. CDnA has grown its BI portal to include additional teams, each of which maintains dashboards for audiences that vary from a dozen extremely busy executives to tens of thousands of curious monthly active users.
Measures and values in this dashboard example are purely sample data and for illustrative purposes only. Click to see large version.
Combining data from all sources
With a company as large and complex as Microsoft, simply identifying key metrics can be a challenge, let alone wrangling the data from hundreds of sources. Power BI helps by uniting this data into a single report interaction model for end users, whether the data is from a cloud service, streaming data, or on-premises location. For CDnA, a seamless migration from Power View to Power BI was possible because both supported their on-premises SQL Server Analysis Services (SSAS) tabular data. CDnA users interact with hundreds of different data sources via the Power BI cloud, with all the CDnA on-premises data hooked up to a single Power BI Enterprise Gateway (with a few extra gateways for load balancing and redundancy).
CDnA focuses on two types of data: usage and customer satisfaction. Customer satisfaction at Microsoft is often measured by Net Promoter Score (NPS), which looks at the proportion of customers that are most enthusiastic about a given product or service. A sample of users of all Microsoft products, from Cortana to Edge to Windows Calendar to, yes, Power BI, are asked for feedback, providing both numerical and anecdotal ratings. All new consumer desktop users of Windows 10 are sent similar ratings requests two weeks after installing the operating system. The data is stored in Microsoft’s internal data storage system, built on Azure Data Lake, and then aggregated into a more usable dataset that is ultimately processed into an Analysis Services tabular model.
While it might sound complicated, and it would be to most people, Senior Data Scientist Sanjay Ramanujan calls the whole process very simple to use. “We scale down the data by taking the highest top box (survey choice) of 5 and the overall NPS score.” Dashboards are updated daily and display numerical KPIs as well as feedback “verbatims”, or open-form written responses. NPS score breakdowns are also provided by geographic area and product. Sanjay’s CDnA NPS team has numerous dashboards that provide a very good indication of what is, and is not, being well received by customers.
Market share data is displayed in a dashboard known as OneShare, and supported by CDnA team members such as Karl Kreis, Senior Product Intelligence Manager. OneShare stemmed from the fact that Microsoft obtains many variations of market research data, from sources such as retail sales, competitive research, and distributors.
In the past, much of this data was maintained by separate teams in separate reports, each assigning their own share value – which led to some apparent contradictions. Now, one Power BI dashboard sits on top of all the data, creating a single source of truth and driving greater alignment across every team.
“By putting this dashboard in Power BI,” Kreis says, “we can change the mindset of how meetings are run with business users. Instead of using a static screenshot, they can just open up the dashboard in a meeting, [including from their phone], use some slicers, and look directly at their data.”
Measures and values in this dashboard example are purely sample data and for illustrative purposes only. Click to see large version.
Guiding executive decisions through data insights
Dashboards designed for executives may not have a huge audience, but their insights are extremely valuable and shape the future of Microsoft. The Windows and Devices Group (WDG) analyst team in CDnA, for example, supports 50 dashboards with thousands of users, but also one dashboard specifically for executives.
The analyst team, including Shweta Mittal, Director Technical Data Analyst, syncs closely with the Power BI development team for their needs. They recently started using a live report tile on their dashboards, making them more interactive and by extension more productive. Shweta says, “[Our executive dashboard] focuses on live discussion of analysis and insights. You don’t have to get back to somebody – the executive can answer a question, then and there in the meeting, and then move on to having a productive discussion.”
Kanchan Sachdeva is a Technical Data Analyst on the CDnA team who focuses on a very specific audience: the Senior Leadership Team, or SLT. This group is limited to about 30 of the most influential executives in Microsoft, and they base their decisions in part on a Power BI dashboard that is refreshed every day. The SLT dashboard focuses on 20-30 key metrics that drive Microsoft’s business, including break downs by region. This reporting solution is developed on top of a 2016 SSAS tabular model, and is redesigned every fiscal year to align with the most current company goals. The CDnA team keeps this dashboard very simple, without many details, and limits the use of “fancy” colors. For the upcoming fiscal year, they are using a Power BI custom visual, called Power KPI, to combine multiple visualization types into a single report tile.
Kanchan notes, “Executive expectations for dashboards are very different, compared to the average business user. They don’t have a lot of time, so they need most of their information in a single glance.”
The CDnA team’s collective work made up 25% of all Power BI usage within Microsoft in early 2017. John Kahan, General Manager of the CDnA, praises the amazing relationship they’ve formed over time with the Power BI development team. “We meet with the Power BI team weekly to share our most recent requirements, and they’re super responsive to our needs as customers. I haven’t seen a development team operate like that before!” Kahan praises Power BI’s visualization layer as the key for organizations that want to quickly understand trends and answer questions on the spot.
James Phillips, CVP of the Microsoft Business Applications Group and the executive in-charge of the Power BI product, agrees that the close relationship between the two teams benefitted not only Microsoft but the whole Power BI community. “The CDnA team led the charge on the use of Power BI for data-driven decision making, within Microsoft. Their use of Power BI as an early adopter in large scale, highly visible, mission critical scenarios helped make Power BI an enterprise grade solution for all our customers.”
Power BI is the tool of choice for Microsoft’s usage data, satisfaction metrics, and executive KPIs. If Power BI can help run one of the world’s largest and fastest moving companies, imagine what it can do for your business!
Driving Power BI adoption in your organization – Learn how Microsoft does this at scale
Microsoft Finance Leverages Power BI to Transform Reporting
Microsoft's top execs use this app almost as much as they use e-mail
How Microsoft uses Power BI to run its growing cloud business
Creating a Data Culture at Microsoft
Tilaa Power BI -uutiskirje
Rekisteröidy alla, niin saat uusimmat Power BI -tiedot suoraan Saapuneet-kansioon.
Maa Afganistan Ahvenanmaa Alankomaat Albania Algeria Amerikan Samoa Andorra Angola Anguilla Antarktis Antigua ja Barbuda Argentiina Armenia Aruba Australia Azerbaidžan Bahamasaaret Bahrain Bangladesh Barbados Belgia Belize Benin Bermuda Bhutan Bolivia Bonaire Bosnia ja Hertsegovina Botswana Bouvet'nsaari Brasilia Brittiläinen Intian valtameren alue Brittiläiset Neitsytsaaret Brunei Bulgaria Burkina Faso Burundi Cabo Verde Caymansaaret Chile Cookinsaaret Costa Rica Côte d'Ivoire Curaçao Djibouti Dominica Dominikaaninen tasavalta Ecuador Egypti El Salvador Eritrea Espanja Etelä-Afrikka Etelä-Georgia ja Eteläiset Sandwichsaaret Etelä-Sudan Etiopia Falklandinsaaret Fidži Filippiinit Färsaaret Gabon Gambia Georgia Ghana Gibraltar Grenada Grönlanti Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard ja McDonaldinsaaret Honduras Hongkong, erityishallintoalue Huippuvuoret Indonesia Intia Iran Irlanti Islanti Israel Italia Itävalta Jamaika Jan Mayen Japani Jemen Jerseyn voutikunta Jordania Joulusaari Kambodža Kamerun Kanada Kazakstan Kenia Keski-Afrikan tasavalta Kiina Kirgisia Kiribati Kolumbia Komorit Kongo Kongon demokraattinen tasavalta Kookossaaret Korean tasavalta Kosovo Kreikka Kroatia Kuwait Kypros Laos Latvia Lesotho Libanon Liberia Liechtenstein Liettua Luxemburg Macao, erityishallintoalue Madagaskar Malawi Malediivit Malesia Mali Malta Mansaari Marokko Marshallinsaaret Martinique Mauritania Mauritius Mayotte Meksiko Mikronesia Moldova Monaco Mongolia Montenegro Montserrat Mosambik Namibia Nauru Nepal Nicaragua Niger Nigeria Niue Norfolkinsaari Norja Oman Pakistan Palau Palestiinalaishallinto Panama Papua-Uusi-Guinea Paraguay Peru Pitcairn Pohjois-Makedonia Pohjois-Mariaanit Portugali Puerto Rico Puola Päiväntasaajan Guinea Qatar Ranska Ranskan eteläiset alueet Ranskan Guayana Ranskan Polynesia Réunion Romania Ruanda Ruotsi Saba Saint Barthélemy Saint Kitts ja Nevis Saint Lucia Saint Martin Saint Vincent ja Grenadiinit Saint-Pierre ja Miquelon Saksa Salomonsaaret Sambia Samoa San Marino São Tomé ja Príncipe Saudi-Arabia Senegal Serbia Seychellit Sierra Leone Singapore Sint Eustatius Sint Maarten Slovakia Slovenia Somalia Sri Lanka St. Helena, Ascension, Tristan da Cunha Sudan Suomi Suriname Swazimaa Sveitsi Syyria Tadžikistan Taiwan Tansania Tanska Thaimaa Timor-Leste Togo Tokelau Tonga Trinidad ja Tobago Tšad Tšekin tasavalta Tunisia Turkki Turkmenistan Turks- ja Caicossaaret Tuvalu Uganda Ukraina Unkari Uruguay Uusi-Kaledonia Uusi-Seelanti Uzbekistan Wallis ja Futuna Vanuatu Vatikaanivaltio Venezuela Vietnam Viro Yhdistyneet arabiemiirikunnat Yhdistynyt kuningaskunta Yhdysvallat Yhdysvaltain Neitsytsaaret Yhdysvaltain pienet erillissaaret Zimbabwe
Haluan saada seuraavan Power BI -uutiskirjeen. Tietosuojatiedot.
Osallistuminen edellyttää henkilökohtaisten tietojesi siirtämistä muihin maihin, joissa Microsoft toimii, muun muassa Yhdysvaltoihin. Lähettämällä tämän lomakkeen suostut tietojesi siirtämiseen Kiinan ulkopuolelle. Tietosuojalauseke.
Mikä on Power BI?
Power BI on yritysanalytiikan työkalupaketti tietojen analysointiin ja merkityksellisten tietojen jakamiseen. Seuraa liiketoimintaa ja hanki nopeasti vastauksia monipuolisista raporttinäkymistä, joita voi käyttää kaikissa laitteissa.
Hanki viimeisimmät uutiset Power BI -blogista
Tilaa sähköpostitse Sinun on annettava kelvollinen sähköpostiosoite Olet antanut henkilökohtaisen sähköpostiosoitteen. Anna työpaikan tai oppilaitoksen sähköpostiosoite. Tapahtui virhe. Yritä myöhemmin uudelleen.
Näytä kaikki ladattavat tiedostot