{"id":6238,"date":"2023-08-01T08:55:04","date_gmt":"2023-08-01T15:55:04","guid":{"rendered":"https:\/\/www.microsoft.com\/insidetrack\/blog\/?p=6238"},"modified":"2023-08-01T09:00:02","modified_gmt":"2023-08-01T16:00:02","slug":"analyzing-data-with-microsoft-power-bi","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/insidetrack\/blog\/analyzing-data-with-microsoft-power-bi\/","title":{"rendered":"Powering decision making at Microsoft by analyzing data with Microsoft Power BI"},"content":{"rendered":"

\"MicrosoftMicrosoft\u2019s drive to make more and better data-driven decisions is fueled by analyzing data with Microsoft Power BI.<\/p>\n

But how is it getting employees to analyze their data and build their own visualizations?<\/p>\n

They\u2019re teaching them. As the saying goes: if you teach someone to fish, you\u2019ll feed them for a lifetime.<\/p>\n

That\u2019s exactly what the Enterprise 360 Data Intelligence team in Microsoft Digital had in mind when it created trainings to help teams that are analyzing data with Microsoft Power BI.<\/p>\n

\u201cWe wanted to empower our partner teams with the skills, tools, and resources to generate and maintain their own Microsoft Power BI reports and gain access to data in a timely manner,\u201d says Sunil Venugopal, a senior program manager on the Data Intelligence team that helped develop the Microsoft Power BI training. \u201cThis also aligns with the expectations of Enterprise 360 Data Intelligence leadership, who wanted to empower partner teams to make data-driven decisions. Once you put data into Microsoft Power BI, it tells a story for itself.\u201d<\/p>\n

Using Microsoft Power BI\u2019s easily adaptable features, business users can quickly self-serve the datasets they need and build their own reports … They feel in complete control because they own and invest in it.<\/p>\n

\u2013 Srinivas Kanamarlapudi, senior software engineer on the Data Intelligence team at Microsoft<\/p>\n<\/blockquote>\n

This training was a powerful tool, especially for partner teams who wanted to gain data-driven insights that relied on the Data Intelligence team\u2019s data visualizations and reports.<\/p>\n

Take Tim Karel, a senior program manager who uses data visualizations to respond to system-generated issues or process changes. Karel submitted many of the dozens of requests from partner teams that were fielded by the Data Intelligence team. The Data Intelligence team would evaluate each request for feasibility, identify core metrics, find a data source, and build a data ingestion pipeline and visualization.<\/p>\n

As a result, employees on partner teams, like Karel, could wait several weeks before receiving a data visualization or report.<\/p>\n

\u201cBy the time I received a report, the business needs or data might have changed,\u201d Karel says. \u201cOur team wanted to be more proactive and use data to create a better customer experience up front.\u201d<\/p>\n

Now, thanks to the training developed by the Data Intelligence team, Karel is analyzing data with Microsoft Power BI. During the training, Karel and other employees on partner teams learned the basics of Microsoft Power BI and used the data team\u2019s standard template to create their own visualizations.<\/p>\n

\u201cUsing Microsoft Power BI\u2019s easily adaptable features, business users can quickly self-serve the datasets they need and build their own reports,\u201d says Srinivas Kanamarlapudi, a senior software engineer on the Data Intelligence team who was involved in creating the Microsoft Power BI training for partner teams. \u201cThis also improves their skillset, and they feel in complete control because they own and invest in it,\u201d Kanamarlapudi says.<\/p>\n

The initial training session drew in 80 participants, including Microsoft network engineers, software engineers, program managers, and even members of leadership who had beginner skills using Microsoft Power BI.<\/p>\n

\u201cThrough these trainings, employees learn the best practices for analyzing data and building out reports, which creates consistency across how these reports are built and enables other teams to easily grasp the visualizations in the reports,\u201d Kanamarlapudi says.<\/p>\n

In addition to offering data science trainings, the Data Intelligence team encourages the employees they work with to build Microsoft Power BI reports that source data from the Microsoft Digital\u2019s central Enterprise Data Lake, which offers a single source of trusted, connected enterprise data.<\/a><\/p>\n

\u201cBy leveraging the shared infrastructure, we\u2019re able to prevent duplication across multiple teams,\u201d Venugopal says.<\/p>\n

For employees like Karel, the training is already paying off.\u00a0Data continues to be a core part of decision-making on their team and using data visualizations to track trends has become a central part of that.<\/p>\n

\u201cThere were many philosophies about what constitutes a good customer experience, so we need data to drive impact and changes,\u201d Karel says. \u201cData tells us how customers interact with agents or get support, and we\u2019re able to make the best decisions possible for customers.\u201d<\/p>\n

By analyzing data with Microsoft Power BI, Karel has been able to create visualizations that identify customers who make repeat support calls and track agent utilization across product areas to see if the team needs to have more support agents during busier times of day.<\/p>\n

\u201cI had a fundamental understanding of my team\u2019s data, but the training taught me how to use a reliable data source to build data reports using Microsoft Power BI, and automate it,\u201d Karel says. \u201cIt saves me a lot of time, and it enables us to improve the customer experience.\u201d<\/p>\n

It\u2019s also making a difference for the Data Intelligence team, who now have more bandwidth to support partner teams by answering questions and helping them get the most out of their data.<\/p>\n

\"Tang
Colin Tang is a software engineer on the Data Intelligence team. (Photo by Colin Tang | Inside Track)<\/em><\/figcaption><\/figure>\n

Colin Tang, a software engineer on the Data Intelligence team who primarily creates datasets, data reports, and dashboards for network infrastructure teams, says that it\u2019s exciting to see teams taking the training and running with it. Tang recently worked with a partner team that manages the inventory for network parts.<\/p>\n

\u201cOur partner took the dataset and went ahead to build the dashboard for network device vendors, and it helps him drive conversations with vendors about cost savings,\u201d Tang says. \u201cIt would normally take our team two to three sprints, but he built his own and they can have conversations with vendors in half the time.\u201d<\/p>\n

[Check out how Microsoft designed a modern data catalog to enable business insights.<\/em><\/a> Learn how Microsoft enhanced its VPN performance.<\/em><\/a>]<\/em><\/p>\n

Building visualizations using Microsoft Power BI<\/strong><\/p>\n

Training has always been around, so what was different this time?<\/p>\n

The team brought a relevant, easy-to-follow Microsoft Power BI training directly to partner teams, each with their own data needs. This made it much easier for teams analyzing data with Microsoft Power BI to scrub their data and then build appropriate visualizations.<\/p>\n

\u201cA lot of trainings are complicated and don\u2019t focus on real-world scenarios that show up in the work of partner teams like mine,\u201d Karel says. \u201cThis is one of the best trainings I\u2019ve taken at Microsoft, and I appreciate that it\u2019s accessible to everyone without relying on a background in engineering and software development.\u201d<\/p>\n

\"Venugopal
Sunil Venugopal, a senior program manager, and his team on the Microsoft 360 Data Intelligence team created a Microsoft Power BI training that partner teams can use to build their own data visualizations. (Photo by Sunil Venugopal | Inside Track)<\/em><\/figcaption><\/figure>\n

To build a community, the Data Intelligence team continues to offer office hours, where employees could ask questions or refine their visualizations. The Data Intelligence team also created a Microsoft Teams channel where employees could ask questions and share their experiences and resources. They\u2019ve also found more success with offering trainings on the organization\u2019s meeting-free Fridays, which are specific days set aside for employees to catch up on email or dedicate time to learning.<\/p>\n

\u201cWe build on existing trainings and content about how to analyze data with Microsoft Power BI, which ensured that we didn\u2019t reinvent the wheel,\u201d Venugopal says. \u201cEven if someone has attended trainings in the past and built dashboards, they can still learn something.\u201d<\/p>\n

To get the most engagement and support on a training like this one, Tang says it was helpful to take a top-down approach and get leadership buy-in from the very beginning. At the time, Tang had been conducting dozens of one-on-one sessions with partners to go over their data needs and wanted to offer something at scale.<\/p>\n

\u201cWe went back to our leadership team and asked if we could offer Microsoft Power BI training that could reach more people at once and help them take advantage of all of its features,\u201d Tang says.<\/p>\n

There were many philosophies about what constitutes a good customer experience, so we need data to drive impact and changes. Data tells us how customers interact with agents or get support, and we\u2019re able to make the best decisions possible for customers<\/p>\n

– Tim Karel, senior program manager at Microsoft<\/p>\n<\/blockquote>\n

It also helped that the team had leadership buy-in and resources to create this training which has ensured that teams have consistency in the way they construct reports and dashboards. This has improved the user experience for partner teams and the Data Intelligence team alike, and they can focus on supporting partner teams and democratizing data instead of building reports.<\/p>\n

If you\u2019re on the fence about building your own data visualizations using Microsoft Power BI, or creating a team-wide training, here\u2019s Karel\u2019s advice:<\/p>\n

\u201cEmbrace Microsoft Power BI and other tools for building your own visualizations. And if you\u2019re creating a data training, start by teaching the basic components and build on that.\u201d<\/p>\n

\"Related<\/p>\n