Hire and other top marketing professionals on Advisable

How Bruno Soares Helped Microsoft Improve their New HR Model with BI

Pitch to work with you

This case study is a great fit for B2B companies that want to grow their value, as well as existing B2C companies that want to transition to a B2B model.
I'm a BI expert who's available as a freelancer on Advisable. In this case study, you'll learn how I helped Microsoft build dashboards to monitor and improve the efficiency of their freelance HR employees.
Built 10+ dashboards consisting of multiple KPIs
The client attained a comprehensive understanding of its resources
Greater efficiency across HR

A Major Tech Corporation Looking to Monitor the Success of their Freelance Employees

Microsoft were switching from a business model based on several outsourced HR providers to one where they hired freelancers. The task of these freelancers was to solve tech issues with Microsoft applications.

However, they didn't yet have the proper dashboards in place to monitor this, improve efficiency, and reach goals.

The aim of the project was to build dashboards with multiple KPIs to monitor performance of freelancers and improve efficiency using business intelligence.

Since I have a lot of experience as a freelancer myself and I am skilled in business intelligence, I was a good fit.


Understanding the context

Understanding the context

My initial goal was to understand the context of the situation, meaning both the previous HR set-up and what the client now had in place.

No items found.
Close Icon

Understanding the Goals

Secondly and more importantly, I had to understanding their goals. I wanted to know where they were heading, which I qualified in milestones: where did they want to be a year from now? And so on. This was important in order to build something with longevity.

No items found.

Mapping and exploring data sources

Next, I mapped out the data sources available to me.

I started by asking stakeholders about what data they had and how it could be accessed.

Then I started mapping and understanding the data, which came from many external providers. Sources included, for instance, invoices from platforms where they found some of their freelancers and active directory information from inside Microsoft's CRM ticketing software.

No items found.

World-class freelancers available to hire on Advisable

Access world-class marketing talent through our platform and improve your marketing.

Profile pictures of other freelancers in the Advisable network.

Discussing KPIs

At this point, I talked with the client about the KPIs they wanted.

Now that I had a deeper understanding of their data, I could add more value to this conversation, because I could already see what was possible and what additional data we might need. In short, I could help identify the gaps.

Through a series of bidirectional conversations, I was able to understand the client's specific needs — what was important for them to measure and assess. I also offered insights from my own experience as a freelancer. All of this enabled us to best define our KPIs.

No items found.

Implementation of KPIs and dashboards

You always need to understand who the end user of your reports is. If your end user is someone that likes to dive into the data, you won't provide them with the same tools as you would a business user. For different readers to understand the numbers you need to structure the information differently.

The best way to go about this is by using an iterative process. I start small using a few KPIs, then I build on top of that implementing feedback from the user. It's a process of continual adjustment.

No items found.
No items found.

World-class freelancers available to hire on Advisable

Access world-class marketing talent through our platform and explore successful projects.

Profile pictures of other freelancers in the Advisable network.

10+ Dashboards with Multiple KPIs and a More Efficient Workplace

In the end, I built over 10 dashboards, all consisting of multiple KPIs.

With these dashboards, Microsoft were able to understand their resources by tracking things like attendance, how many people were working during each hour of the day, different time zones, languages, and so on.

Once they knew what they had, they were empowered to make changes, ultimately becoming more efficient.

The need to be 'agile' is a cliché, but from my experience, it's true. The business doesn't wait for the technical team to build an infrastructure and it doesn't wait for you to establish your KPIs. Competitors may launch new products that you need to compete with. When things like this happen, you need to adapt fast.

I'm a Data Specialist that offers you the best of two worlds: a strong technical background with a critical sense to business needs.