The Latin America marketing team for Microsoft Office implemented a dynamic dashboard solution to visualize sales performance from a variety of perspectives. Built on Microsoft Visio Professional 2013, the solution combines data from multiple sources and publishes visualizations of it through Microsoft SharePoint Server 2013. Now, the group saves 300 labor hours a month creating reports, and stakeholders have immediate access to actionable performance information.<\/p>\n\n\n\n
Effective regional marketing teams are key to the global success of Microsoft, and tracking sales performance is an important part of promoting that effectiveness. Recently, the Microsoft Office marketing group, which is responsible for Microsoft Visio and Microsoft Project, in Latin America wanted to streamline how it gathers performance information (primarily focused on revenue) and to disseminate that information in more meaningful, actionable ways.<\/p>\n\n\n\n
\u201cWe wanted a way to easily look at the status of sales performance\u2014a snapshot of how well we\u2019re meeting goals at any given time\u2014from several perspectives,\u201d says John Perez, Latin America Project Marketing Manager for Microsoft Project and Microsoft Visio. \u201cOne perspective might be to look at performance from a regional standpoint. Another perspective might be to look at performance in various business segments. We also wanted to track the performance status of individual product teams and reps.\u201d<\/p>\n\n\n\n
Performance data is stored in various databases, spreadsheets, and other data sources, and the group\u2019s methods for generating performance reports were highly manual. For example, a rep might gather sales performance information from a database or Microsoft Excel spreadsheets and distill it into relevant metrics. The rep might then put the metrics in Microsoft PowerPoint and present it to upper management. And that report would likely look at only one performance perspective. \u201cThe driver for streamlining tasks like these was time savings,\u201d says Perez. \u201cReps don\u2019t want to waste time. Stakeholders want to visualize data in different ways. Everyone wants data to be up-to-date, and no one wants to wait for it.\u201d<\/p>\n\n\n\n
To address these challenges, the Visio team worked with IT partner Infoshot to develop a visual reporting solution that gives the product group\u2019s team members an at-a-glance view of sales, revenue, and other performance metrics. Based in Sede Belo Horizonte, Brazil, Infoshot is a Microsoft Partner Network member with nine Gold competencies. \u201cWe chose Infoshot because they had worked closely with our team in the past and because they were familiar with the technologies that we needed to make this project work,\u201d says Perez.<\/p>\n\n\n\n
With the new solution, sales performance is visualized in Microsoft Visio Professional 2013, in real time, on dynamic dashboards that use multiple data feeds from Microsoft SQL Server 2012 databases. Because the Visio team can easily view the information they need on the dashboards, creating time-consuming static reports is no longer necessary. The dashboards are published to Microsoft SharePoint Server 2013, where stakeholders view them on continually updated SharePoint sites through a web browser. The publishing process is made possible by Visio Services in Microsoft SharePoint Server 2013, which runs as a service application in SharePoint.<\/p>\n\n\n\n
The solution displays diagrams and shapes that represent high-level performance of the product group, and with a couple of mouse clicks, users can see deeper analysis for performance of specific subsidiaries, teams, or even individual employees. \u201cParts of it work like a simple stoplight,\u201d says Perez. \u201cGreen elements represent performance goals that are being met or exceeded. Yellow elements merit attention, and red indicates falling short of goals. With this simple display, we can quickly identify deficiencies in our strategic planning or sales execution. We can also identify successes to establish best practices and share these with our teams.\u201d<\/p>\n\n\n\n
Using the Visio-based dynamic dashboard solution, the Microsoft Office marketing group saves time and boosts productivity for sales and marketing reps and managers alike. The solution can also be replicated to support other groups and regions as necessary.<\/p>\n\n\n\n
The Visio solution saves time in two ways: team members can create performance reports faster, and all stakeholders can access and use the information more quickly and easily. Says Perez, \u201cWith ready access to multiple data sources and a simple-to-use interface, the Visio\u2013based dashboard solution helps reps create better, richer reports in only a fraction of the time that we needed before.\u201d Perez estimates that each rep is saving about two and a half hours a week. \u201cMultiply this for 30 reps, every week, and the result is up to 300 labor hours saved per month in our group alone.\u201d<\/p>\n\n\n\n
The new solution also brings detailed performance information to anyone who needs it. Perez continues, \u201cPerformance diagrams are published to a readily available SharePoint site where people in the field, for example, can use a browser to see if they are achieving sales goals.\u201d To emphasize the point, he adds, \u201cYou can see what your status is right now, not just what it was last month or last week, which means you know where to focus your efforts.\u201d<\/p>\n\n\n\n
In the same way, the new solution brings the information to mobile devices. \u201cI have done a lot of testing from Windows Phone devices and Surface tablets because I often work remotely,\u201d says Perez. \u201cIt\u2019s a perfect solution for use on mobile devices.\u201d<\/p>\n\n\n\n
The Visio dashboards make sales information easier and faster to analyze by gathering that information from all data sources at once and presenting a visual interpretation of it. \u201dPreviously, we had to dig through Excel worksheets or wait for paperwork to come from the finance team to know our sales status. With Visio, we see red, yellow, and green indicators on an intuitive display that\u2019s always up-to-date, in real time. That\u2019s why people like this solution so much.\u201d<\/p>\n\n\n\n
The product group in Microsoft Latin America has had so much success with the Visio-based dynamic dashboard solution that other groups and regions will soon adopt easily modified versions of it. Perez concludes, \u201cThis first implementation is top notch, and we expect it to work just as well for other groups. It\u2019s inspiring to know that our work will go on to help boost the performance of teams like ours around the world.\u201d<\/p>\n\n\n\n
The new Visio makes it easier than ever to create and share professional, versatile diagrams that simplify complex information. It includes updated shapes, templates, and styles, as well as enhanced support for teams, including the ability for several people to work on a single diagram at the same time. For more information go to: Visio.microsoft.com<\/p>\n\n\n\n
For more information about Microsoft products and services, call the Microsoft Sales Information Center at (800) 426-9400. In Canada, call the Microsoft Canada Information Centre at (877) 568-2495. Customers in the United States and Canada who are deaf or hard-of-hearing can reach Microsoft text telephone (TTY\/TDD) services at (800) 892-5234. Outside the 50 United States and Canada, please contact your local Microsoft subsidiary. To access information using the World Wide Web, go to: cm-edgetun.pages.dev<\/p>\n\n\n\n
For more information about Infoshot products and services, visit the website at: www.infoshot.com.br<\/p>\n","protected":false},"excerpt":{"rendered":"
The Latin America marketing team for Microsoft Office implemented a dynamic dashboard solution to
\nvisualize sales performance from a variety of perspectives. Built on Microsoft Visio Professional 2013,
\nthe solution combines data from multiple sources and publishes visualizations of it through Microsoft
\nSharePoint Server 2013.<\/p>\n","protected":false},"author":843,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"categories":[1496],"post_tag":[],"content-type":[1492],"coauthors":[4309],"class_list":["post-850","post","type-post","status-publish","format-standard","hentry","category-manufacturing-and-mobility","content-type-news-and-announcements","review-flag-1593580429-205","review-flag-alway-1593580311-297","review-flag-new-1593580249-279","review-flag-partn-1593580285-60"],"yoast_head":"\n