{"id":10323,"date":"2020-06-01T13:54:58","date_gmt":"2020-06-01T20:54:58","guid":{"rendered":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?p=10323"},"modified":"2023-06-12T15:36:52","modified_gmt":"2023-06-12T22:36:52","slug":"metrics-that-matter-how-we-track-our-digital-transformation","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/insidetrack\/blog\/metrics-that-matter-how-we-track-our-digital-transformation\/","title":{"rendered":"Metrics that matter \u2013 how we track our digital transformation"},"content":{"rendered":"
This content has been archived, and while it was correct at time of publication, it may no longer be accurate or reflect the current situation at Microsoft.<\/p>\n<\/div>\n<\/div>\n
A big data visualization solution in Microsoft Power BI summarizes and tracks performance against business objectives while Microsoft Digital drives results. This solution refines large amounts of data into accurate and actionable insights for the entire organization. It improves satisfaction, enables growth, and drives operational effectiveness on Microsoft\u2019s road to digital transformation.<\/p>\n
At Microsoft Digital\u00a0(formerly Core Services Engineering and Operations, CSEO), we\u2019ve developed a solution to summarize and track our most important business processes and systems. Our Microsoft Digital Scorecard has transformed the way that we understand and manage our business. We\u2019ve integrated it with our regular processes. It supplies the most definitive source of operational truth for our organization. Taking enormous amounts of system and process data and refining it to supply accurate and actionable information helps us to quickly see how the entire organization is tracking against our business objectives. With the Microsoft Digital Scorecard, we\u2019re improving employee satisfaction, enabling growth, and driving operational effectiveness on our road to digital transformation.<\/p>\n
At Microsoft, data is everywhere. As we continue our progression to digital transformation, the data our digital systems produce and process borders on overwhelming. Our business processes produce logs and event data ranging from employee satisfaction to financial results to security compliance. At any point, our systems present thousands of individual points of data on running processes. There is no feasible way to represent each of those individual data points and provide a complete view of system process status for our organization. Even when we gathered, aggregated, and summarized important data and information, we lost the salient details in the immense number of averages and medians.<\/p>\n
Knowing what data is important presents another challenge to Microsoft\u2019s modern IT organization. Microsoft employs more than 140,000 people. Determining which data is important to our organization as a whole and to our individual business groups is an immense task.<\/p>\n
How can we gather and aggregate relevant data? How do we decide which data supplies visibility into our organization\u2019s most critical business processes? How can we better monitor, understand, and manage the way we do business? Our executive leadership asked us these very questions. This paper examines how we addressed them and transformed how we measure and track business outcomes and drive improvement across our organizational goals.<\/p>\n
Our executive leadership came to us looking for better insight into how the Microsoft Digital organization operates. They had a simple request\u2014 provide a dashboard that displays the top 35 metrics that demonstrate how well our organization runs. While the request seemed simple enough, fulfilling it was not. Selecting the 35 metrics that properly summarized the thousands of individual metrics that exist within the Microsoft Digital environment was critical. We had to ask ourselves some important questions. Questions like: What are our goals in Microsoft Digital and how are they measured? How do we determine what metrics are the right ones or the most important ones to put on our dashboard? Which metrics will strategically drive our business forward into digital transformation? It was this last question that supplied the direction for assembling what our dashboard might look like.<\/p>\n
We were already collecting a large amount of data throughout Microsoft Digital. Many of our business groups were already using that data to examine their own metrics and create their own dashboards and insights. After examining Microsoft Digital’s dashboards and metrics situations, we found several opportunities for improvement:<\/p>\n
We realized that we were going to have to start at the beginning and determine which metrics really mattered when measuring business goals and their key outcomes. Then, we needed to develop a solution to display the data and interact with it in a way that helped our entire business to respond and evolve.<\/p>\n
The most critical aspect to ensuring the success of our entire scorecard solution was creating a view of the metrics that mattered. Since metrics were the heart of the solution, it\u2019s where we started our journey. We worked with leadership and the business units to ensure that we found metrics that could relevantly measure our organization\u2019s business key results, user engagements, service excellence, and compliance.<\/p>\n
Working with stakeholders from every part of our organization, we asked for input from the system and process owners who knew what was important within their section of the business. They were our primary means to get metrics defined, collected, reviewed, and finalized through the iterative process illustrated below:<\/p>\n The initial process took us approximately three months to complete. The result was a dashboard and scorecard solution that gave our leadership an accurate and agile view of the entire organization, as shown in Figure 2. Our work to refine and improve the Microsoft Digital Scorecard continues.<\/p>\n One of the most important early steps was defining the criteria for our top-level dashboard metrics. We were given a target of 35 metrics that would comprise a complete view of our organization. To determine which metrics would fit on the dashboard, we developed these criteria:<\/p>\n In addition to the selection criteria, we also worked with the leadership team to establish the high-level reporting goals for the dashboard. Our leadership team wanted a solution that would truly help the business; something we could use to make Microsoft Digital meet its objectives. We produced three primary goals for the dashboard results:<\/p>\n When developing the scorecard, we considered the distinct parts of our organization that contribute to the whole. Breaking our organization down into primary business and functional parts enabled us to create usable metric categories. The categories include:<\/p>\n After we set our goals and metrics, we used Microsoft Power BI and Microsoft Azure Analysis Services to create the Microsoft Digital Scorecard.<\/p>\n Microsoft Power BI supplied an immediate solution to almost all our high-level solution goals. It supplies dynamic views on live data and, as shown in Figure 3, includes the ability to drill down into more granular, detailed views. It easily integrated with our cloud-based processes and business systems and it was intuitive and easy to begin creating data visualizations. In fact, the ease of the Microsoft Power BI implementation was one of the main reasons we were able to go from idea to solution in three months.<\/p>\n Continuing with the cloud-based nature of Microsoft Digital Scorecard, we used Microsoft Azure Analysis Services for data analytics. Because we pull our data from a huge dataset, we needed to be able to manipulate and represent that data using different models. Microsoft Azure Analysis Services supports the variety of drill-down capabilities we built into the Microsoft Digital Scorecard.<\/p>\n The Microsoft Digital Scorecard transformed the way we perform our regular organizational review meetings. With the dashboard presenting live data and the ability to drill down to specific metrics and results immediately, we are now able to streamline our monthly review process. Using the scorecard also improved our decision-making process. If a question came up in the review meeting, we no longer needed extra time to run more reports or consult with metric owners. With the Microsoft Digital Scorecard we could expose the necessary data, find the answer to improving our processes, and determine a business direction during the meeting.<\/p>\n We\u2019ve begun establishing a new rhythm of business with the Microsoft Digital Scorecard, with a monthly review and drill down into one of the metrics as core components. By creating a process and rhythm around the Microsoft Digital Scorecard we ensure we have the most relevant, accurate data. The Microsoft Digital Scorecard gives our metric owners time to confirm the results and supply commentary prior to moving into our monthly review meetings.<\/p>\n Our Microsoft Digital data analysts work to support the rhythm of business for the Microsoft Digital Scorecard. They create and manage the dashboards in the scorecard, perform the data analysis tasks, and work with the metrics owners to set the business and data standards for Microsoft Digital Scorecard metrics. At a high-level, the monthly rhythm of business looks something like this:<\/p>\n We encountered and overcame the following challenges (several times) while assembling the Microsoft Digital Scorecard:<\/p>\n We\u2019re using the Microsoft Digital Scorecard to achieve our primary goals of enabling growth, driving operational effectiveness, and improving satisfaction. The Microsoft Digital Scorecard has allowed us to realize the following benefits within our organization:<\/p>\n While the primary goal of the Microsoft Digital Scorecard is moving our organization forward, we\u2019re expecting changes and improvements to the dashboard to supply even more value. These changes include:<\/p>\n The\u00a0Microsoft Digital Scorecard has transformed the way that Microsoft Digital understands and manages our business. We\u2019ve integrated it into our regular processes, and it supplies the most definitive source of operational truth for our organization. We\u2019ve taken petabytes of system and process data and refined it into a tool that supplies accurate and actionable information to our entire organization. With Microsoft Digital Scorecard, we\u2019re improving satisfaction, enabling growth, and driving operational effectiveness on our road to digital transformation.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":" This content has been archived, and while it was correct at time of publication, it may no longer be accurate or reflect the current situation at Microsoft. A big data visualization solution in Microsoft Power BI summarizes and tracks performance against business objectives while Microsoft Digital drives results. This solution refines large amounts of data […]<\/p>\n","protected":false},"author":146,"featured_media":10325,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_hide_featured_on_single":false,"_show_featured_caption_on_single":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"coauthors":[674],"class_list":["post-10323","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","m-blog-post"],"yoast_head":"\nOur criteria to select metrics<\/h3>\n
\n
Establishing metric goals and categories<\/h3>\n
\n
\n
\n
\n
\n
\n
Creating the Microsoft Digital Scorecard<\/h2>\n
Microsoft Power BI supplies dynamic views of live data<\/h3>\n
Microsoft Azure Analysis Services for data analytics and modeling<\/h3>\n
Maintaining a rhythm of business<\/h3>\n
\n
Challenges<\/h2>\n
\n
Benefits<\/h2>\n
\n
Moving forward<\/h2>\n
\n
Conclusion<\/h2>\n