Microsoft – Innovative Analysis of Market Research Data

Microsoft Data & Analytics Platform

Even though market research is not a new thing, an innovative and diverse analysis of market research data in the way Microsoft’s Data & Analytics Platform team has done it, is unique both in Finland and globally.

Six years ago, around the time when Microsoft acquired the mobile phone business of Nokia, the team founded in Microsoft got a mission to take ownership on the market research data of the whole company. Having already worked together at Nokia, the posse rolled up their sleeves and built top-notch data analyzing processes based on their previous learnings, to help the decision-making of executive managers at Microsoft.

"We have been able to build a customized team of top-skilled experts. We have created a cooperation model with Siili where people are capable of functioning as individuals as well as team members, contributing for the whole platform. Siilis are proactive, curious people who can work independenty but also as part of the team."

Ilana Saarikko, Senior Data & Applied Scientist, Microsoft

“Traditionally market research has been very vendor driven, meaning that a company specialized in market research conducts e.g. a consumer survey where the interviewees are asked whether they have seen specific ads of Microsoft or what do they think of our certain products. The results of these surveys are then handed out to the customer in a finished form, typically as PowerPoint slides. We wanted to have ownership on the data collected by market research vendors and store it by ourself so that the re-use and combining of data are possible, and that we can do explorative analysis on the data by ourselves”, tells Ilana Saarikko, the Senior Data & Applied Scientist of Microsoft’s Data & Analytics Platform team.

Curated data to support decision-making

The core task for the team is to help the decision-makers at Microsoft, who often are marketing and product directors, to get up-to-date information on the wishes, behaviour, and opinions of consumers to support sales and target setting.

Besides creating an ownership on the data, it first needs to be brought into an easily read form.

“The survey data coming from market research vendors is very raw, so it needs to be “cooked”. The aim of the team is to make the raw, scattered, and sometimes even partial data into as understandable and current as possible for business decisions”, says Matti Uronen, Senior Data & Applied Scientist of the team.

The team has thus developed effective tools and processes to process and confirm the validity of the research data coming from the vendors, to forward it to cubes, and finally get it into digestible reports to various dashboards and analysis services, such as Power BI, and to databases.

Interactive data with top processes

Besides analyzing the market research data produced by 3rd parties, the team’s business intelligence tools are used on analyzing the telemetry data collected via Microsoft’s hardware, and also financial data. Additionally, the team produces its own surveys, which means there are plenty of data sources to be analyzed and they can be combined. Outsourced market research data can be enriched with the internal data owned by Microsoft, and this makes the scale of analyzed data advanced compared to other companies.

The entity of tools and processes developed by the team is extremely efficient despite the huge amounts of data, as the processing and curating of the raw data file coming from a market research vendor, and then making it available for the Microsoft personnel to read in the forms of metrics and KPIs, is mostly automated and can take just a couple of hours.

“When the data analysis is ready, we will send a notification to our users on the new data being available. After this, our decision-makers examine the data directly from the databases or e.g. from Power BI. Compared to static PowerPoint slides the decision-makers can directly create comparisons, edit values, and explore with the analytics tools how different choices effect on values”, Saarikko describes.

"In this team, you need to be interested in learning new technologies and adapt. This has actualized greatly with Siili’s experts. There have also been people who have changed positions completely to learn something new. Together we have found ways to execute that in a functioning way."

Matti Uronen, Data & Applied Scientist, Microsoft

What we did:

  • DevOps
  • Infrastructure
  • Security
  • Data Storages
  • Data Processing
  • Machine Learning
  • Front and Back End
  • Semantic Model
  • Visualization
  • Software development

Tech & Methods

  • Azure DevOps
  • Jenkins
  • Virtual Machine
  • Kubernetes Services
  • Azure Active Directory
  • Azure Data Warehouse
  • Azure SQL Database
  • Azure Datalake
  • Azure Databricks
  • Azure Data Factory
  • Python
  • R
  • React
  • Typescript
  • D3.js
  • NodeJS
  • Azure App Service
  • Analysis Services
  • Power BI

Innovative analysis and use of tools

Additionally, the team has developed new, innovative ways to combine different types of data and to create new kinds of metrics by taking advance of Microsoft’s own products, especially Azure.

“We have yearly projects where our internal customer needs new kind of metrics or there appears a need for us to produce text analysis in an easier way. Our team is flexible, so if someone wants new KPIs or data in their use, we think how to do it and how we can take all out of our tools”, Saarikko says.

“Microsoft has collected understanding, according to the terms of use, of the profiles of its customers, so innovation can thus mean enabling better samples. It is very different for results to interview customers of whose behaviour and opinions there already exists understanding, compared to researching the views of completely random people. For example, we can do a targeted surveys and give decisions-makers information on whether marketing or some product’s features need some development. We also do plenty of prototypes and our projects don’t last for months or years – instead, we react quickly”, Uronen continues.

Siili has cooperated with the development work from the beginning

Siili has been working together with the Microsoft Data & Analytics Platform team from the beginning as one of two main suppliers. The team has 80 members across globe and 3 members in Finland, plus there are 30 external consultants working on the platform, of which half are Siili’s experts. The experts work in the positions of full-stack developers, data scientists, BI specialists, and big data architects.

The cooperation has worked straightforwardly, as Microsoft has been able to build a customized team consisting of top experts, according to its wishes.

“We want a proactive, curious attitude and independency from people ­– and at the same time, you should know how to maintain the efficiency of the platform. Siilis have fitted in to these criteria well, and we have managed to get us experts who function great both in team and by themselves. We have also been able to create a cooperation model where people have adopted and assumed themselves the right roles”, Saarikko praises.

“We have wanted to take in people who are interested in learning new and trying out new things, instead of getting stuck with what it says on their CV or certificate. With Siili this has succeeded very well. We also have people in the team who have expressed their interest to learn completely different topics, and together we have found a nice way to execute that, as it’s important for us to enable development for people”, Uronen adds.

Siili is Microsoft Gold Partner

Need a similar system custom-built for your needs?

AnttiHeinilä

Antti Heinilä

Email: antti.heinila@siili.com
Phone: +358 44 0337841

icon-send-us-message

How can we help you? Send us a message

What's next

Our latest cases

National Land Survey of Finland – Revolutionizing Digital Real Estate Business

National Land Survey of Finland – Revolutionizing Digital Real Estate Business

To many home owners, an old fashioned, vintage styled paper share certificate on residential property is probably a familiar one – it’s the one you usually only get a glimpse of when finalizing a real estate deal in your...

Upcoming events

RPA with Robot Framework

RPA with Robot Framework

The aim of this course is to get a feeling of the best practices in developing RPA solutions with open source tools. Emphasis is put on extending Robot Framework with own Python libraries.

Create the next version with us

Andreas Strandman

Andreas Strandman

Helsinki

Manufacturing & Service sectors

+358 50 581 7523

andreas.strandman@siili.com

Olli Sorvari

Olli Sorvari

Helsinki

Finance & Insurance, Siili Solutions Oy

+358 40 0977078

olli.sorvari@siili.com

Paavo Koskelin

Paavo Koskelin

Helsinki

Public Sector, Siili Solutions Oy

+358 40 4850 180

paavo.koskelin@siili.com

Pasi Ropponen

Pasi Ropponen

Helsinki

CCO, Siili Solutions Oy

+358 10 2819 011

pasi.ropponen@siili.com

Väinö Leskinen

Väinö Leskinen

Helsinki

CEO, Siili Auto Oy

+358 50 472 9955

v.leskinen@siili.com