{"id":6818,"date":"2021-05-27T09:00:25","date_gmt":"2021-05-27T16:00:25","guid":{"rendered":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?p=6818"},"modified":"2025-10-02T13:20:08","modified_gmt":"2025-10-02T20:20:08","slug":"revamped-microsoft-business-intelligence-platform-boosts-data-handling-and-builds-trust","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/insidetrack\/blog\/revamped-microsoft-business-intelligence-platform-boosts-data-handling-and-builds-trust\/","title":{"rendered":"Revamped Microsoft business intelligence platform boosts data handling and builds trust"},"content":{"rendered":"

\"MicrosoftWe periodically update our stories, but we can\u2019t verify that they represent the full picture of our current situation at Microsoft. We leave them on the site so you can see what our thinking and experience was at the time.<\/em><\/p>\n

Imagine an important meeting where you spend most of your time discussing the accuracy of metrics and reports. Too often, that was the reality for many Microsoft teams before we launched Microsoft Sales Experience (MSX) Insights, a Microsoft business intelligence platform.<\/p>\n

Now MSX Insights provides a single source of truth to more than 40,000 users, including salespeople, their managers, leaders, and multiple operations and finance teams across Microsoft. Based on Microsoft Fabric, a suite of Microsoft Azure technologies that includes OneLake, Data Factory, Synapse, Azure Analysis Services, and Power BI, MSX Insights is a project of the Microsoft Commerce and Ecosystem team, which powers, transforms, and protects our organization.<\/p>\n

\"Toomey
Michael Toomey, senior director of business operations and programs for Microsoft Worldwide Sales Engineering, led the creation of the innovative internal Microsoft business intelligence platform known as MSX Insights.<\/figcaption><\/figure>\n

\u201cOnce we began using Azure and then Power BI, the technology limitations that had been holding back our data unification were eliminated,\u201d says one of the project sponsors, Michael Toomey, senior director of business operations and programs for Microsoft Worldwide Sales Engineering. \u201cWas it finally possible to get to a single view of our commercial business that everyone could understand?\u201d<\/p>\n

That\u2019s exactly what happened when Microsoft Customer and Partner Solutions (MCAPS), Microsoft Finance and Data Experiences, and Customer Experience Data Engineering (CX Data) collaborated to create today\u2019s comprehensive Microsoft business intelligence platform: MSX Insights.<\/p>\n

Reports and metrics that didn\u2019t add up<\/h2>\n

At Microsoft, it\u2019s critical that decision makers have access to data they can trust across the sales pipeline, contracts, revenue, and consumption. But when they pulled reports from separate systems or used data updated at different times, the numbers and results often didn\u2019t match.<\/p>\n

\u201cWe used to have a lot of complaints,\u201d says RJ Smith, principal group engineering manager with Microsoft Commercial Business. \u201cI talked to people in Paris, Munich, Sydney, and they said that those reports wouldn\u2019t load or that they didn\u2019t show the right data.\u201d<\/p>\n

Praveen Vittalrao Ambekar, a principal group program manager for CX Data, also analyzed the MSX customer experience to find out what was driving the support volume.<\/p>\n

We needed a 360-degree view of our customer to correctly evaluate key metrics. We wanted end-to-end visibility.<\/p>\n

– Michael Toomey, senior director of business operations and programs, Microsoft Worldwide Sales Engineering<\/p>\n<\/blockquote>\n

\u201cMultiple data platforms powered these reports,\u201d Ambekar says. \u201cThe insights weren\u2019t aligned across sellers, managers, and leaders, and that was causing a lot of churn for the team. The groups were looking at the data from different angles.\u201d<\/p>\n

Those weren\u2019t the only problems. The scope of the available reports didn\u2019t fulfill the needs of senior executives.<\/p>\n

\u201cWe needed a 360-degree view of our customer to correctly evaluate key metrics,\u201d Toomey says. \u201cWe wanted end-to-end visibility.\u201d<\/p>\n

Although we empower our teams extensively to develop their own reporting platforms, we were seeing broad duplications of effort and cost. \u201cIt was a highly federated budget model,\u201d Toomey says.<\/p>\n

It was also risky. As people developed one-off solutions using copies of datasets, it became harder to secure the information and enforce compliance with standard data-handling practices.<\/p>\n

\u201cThe more replication you have, the less likelihood that everyone\u2019s compliant with the rules,\u201d Ambekar says.<\/p>\n

The insular systems also impacted engagement and satisfaction levels for our partners and customers.<\/p>\n

\u201cClose coordination across sales teams, partners, marketing, and operations is critical for our customers to get a connected experience,\u201d Toomey says. \u201cIt\u2019s impossible to achieve that if we have multiple datasets with mismatched data on opportunities, consumption, licenses, revenue, and other kinds of information.\u201d<\/p>\n

Multiple waves of data-handling improvements<\/h2>\n

After we began using a standardized system, teams could migrate from competing products and use the same software regardless of department. The solution has stood the test of time.<\/p>\n

\u201cPower BI as a product is almost 12 years old and so is our platform,\u201d Toomey says. \u201cIt has successfully adapted through the transitions of Microsoft\u2019s core business model and the priorities of multiple engineering leaders\u2014and our commercial business as a whole. We always need a central place to go and get insights.\u201d<\/p>\n

Then we launched Microsoft Azure cloud computing services, making it easier for users in different departments to access the same source of data.<\/p>\n

\u201cWe started to take the approach of giving people what they needed based on their roles,\u201d Toomey says.<\/p>\n

That might be a seller who wants to see their scorecard broken down by account, a manager who needs an aggregate of the entire team\u2019s pipeline, or a leader looking for patterns and trends over time. Microsoft Azure was a major enabler for this new direction, and Microsoft Power BI was the team\u2019s choice of a front end for the evolving business intelligence platform.<\/p>\n

\u201cWe had a quarterly business connection, an event where we bring all the executives together, area by area, segment by segment,\u201d Toomey says. \u201cSeveral of us got together and worked for six weeks to automate the data handling. We moved everything into Power BI and ran visuals there.\u201d<\/p>\n

That proof of concept was a success, so the next step was to make a cultural shift to get to an aligned environment. To that end, the team built a community around Microsoft Power BI practitioners in the field. This BI round table community gets together a few times a month to share best practices, what they\u2019re doing locally, and what has the potential to scale up.<\/p>\n

\u201cWe tried to connect with the people building the tools and explain that this was a better way for them to be successful,\u201d Toomey says.<\/p>\n

The team also focused on increasing the tool\u2019s speed for users around the world.<\/p>\n

\u201cIt\u2019s not a problem anymore,\u201d Smith says. \u201cIn fact, performance metrics have improved 50 percent. We spent a lot of time on performance to make sure the JavaScript implementation in the browser works well.\u201d<\/p>\n

In November 2020, representatives from the teams who were most involved in creating MSX Insights came together to address one remaining issue: getting the data right.<\/p>\n

\u201cIt was a result of partnership and alignment between the three different teams\u2014MCAPS, Finance and Data Experiences, and Microsoft Commerce and Ecosystems,\u201d says Diego Ulloa, a data strategy lead with Microsoft Worldwide Enablement and Operations who works on MSX Insights. \u201cTogether we consolidated data, set business rules, and designed the architecture.\u201d<\/p>\n

Power BI as a self-service tool has enabled more consumption of the insights. You don’t need layers of people to pull it into Excel.<\/p>\n

– Praveen Vittalrao Ambekar, principal group program manager, Microsoft Partner and Sales Experience Business Insights<\/p>\n<\/blockquote>\n

\u201cWe had to make hard decisions,\u201d Ambekar says. \u201cWe had to align to one or the other\u2019s hierarchy.\u201d<\/p>\n

The team divided the rules and definitions up by functional area. In the first six months after the launch of MSX Insights, we eliminated 80 percent of the user complaints associated with data hygiene and report accuracy. We\u2019re also improving its ease of use over time.<\/p>\n

\u201cPower BI as a self-service tool has enabled more consumption of the insights,\u201d Ambekar says. \u201cYou don\u2019t need layers of people to pull it into Excel.\u201d<\/p>\n

Collaboration continues to improve data quality and integrity<\/h2>\n

The group that built MSX Insights isn\u2019t done yet. There\u2019s a robust roadmap planned for the coming months and years.<\/p>\n

More trends and customer reports are on the agenda. MSX Insights and the Partner Sales Experience are still evolving, and several other teams are now contributing to these platforms.<\/p>\n

\u201cWe\u2019ll continue to evolve the user experience,\u201d Ambekar says. \u201cWe want the user interface to really match how and where people are working, embedding insights more directly into the experience.\u201d<\/p>\n

The collaboration across teams is helping avoid the duplication of efforts.<\/p>\n

\u201cBecause we hold each other accountable when we go through and talk about the designs, we\u2019re doing it once and doing it well,\u201d Smith says. \u201cIt\u2019s better by virtue of us working on it together.\u201d<\/p>\n

The path ahead for MSX Insights includes continuous rollouts of additional services and functionality using the latest capabilities in Microsoft Fabric and Power BI. We\u2019re also looking at ways to integrate AI throughout the experience in an effort to enable faster decision making.<\/p>\n

\u201cBy introducing these abilities to partners, we\u2019re allowing more teams to create a comprehensive set of reports,\u201d Ulloa says. \u201cWe\u2019re taking our narrow vision and extending it to a One Microsoft model.\u201d<\/p>\n

\"Related<\/figure>\n