Тестовое задание
на аналитика данных
MuseGroup

Whether you’re a dev, a designer, or a salesperson, we want to see how you work.
It shows your thinking, how you deal with a practical task, and your technical skills.
We believe every test task should be done while respecting the candidate’s time and effort.
Look at it like sending your demo to a record company. Show us your best work and how you work, so we can both see if it’s a good fit. If it is, we’ll be making music together in no time.

Our Test includes 3 different Tasks, please pay attention that Task 1 and Task 2 must be completed in writing. Please prepare them first, and send us a written version.
After we check Task 1 and Task 2, we will ask you to prepare Task 3 and present it on the next interview round, so we will have some content for discussion with the next Interviewer.

Pick any format — presentation, Google Docs/Notion — anything that works best for you. 

We believe 3 days is enough to find time, but not too long for us (and we don't expect that you will work on weekends).

Task 1. SQL - *written

Our services heavily rely on subscriptions, we have 2 types of subscriptions that cost $19.99 / year and $39.99 / year. All data are stored in 2 tables:

• traffic - source & date of sessions
• transactions - monetary transactions

You can get data here: ug_test 

Task 2. Modeling - *written

We’re selling subscriptions and always experimenting with new prices. We had an experiment with 2 sets of prices (data Task 2 analyst Set 1 vs Set 2) and we want to launch another experiment with new prices (Set 3).

Tasks

1. Please copy the doc and fill in all yellow cells
2. You need to estimate first revenue (revenue we get from the first payment) for Set 1 and Set 2
3. You need to estimate overall cohort revenue (revenue for the whole lifetime) for Set 1 and Set 2
4. You need to model results for Set 3 based on results of the first experiment, is it possible to get 25% growth over Set 2? Why or why not?

Requirements

• We need a link to the model with filled formulas
• We want you to express your thinking while you prepared the model, please add comments

Task 3. Hypotheses*

We have several products: ultimate-guitar.com, Ultimate Guitar iOS and Android app, musescore.com, MuseScore iOS and Android app. Feel free to select any product you like or want to test.
Please research the product you selected and provide 3-5 hypotheses how we can improve monetisation of the product you selected.

Tasks

1. Please specify the product you researched (ultimate-guitar.com, Ultimate Guitar iOS and Android app, musescore.com, MuseScore iOS and Android app)
2. Please describe your hypotheses about user behavior and provide a simplified model of how this will impact revenue
3. For each hypothesis please describe minimum version to be tested to find out unknowns in your simplified model

Requirements

• We understand that you don’t have any numbers, fee free to insert any, we’re looking at the way you think more than at how you can use Google Sheets to multiply numbers

Тестовое задание на продуктового аналитика в MuseGroup . Ознакомьтесь с примерами реальных тестовых заданий, которые предлагаются кандидатам. Узнайте, какие задачи могут встретиться и как они связаны с будущей работой. Это поможет лучше подготовиться к собеседованию в MuseGroup и понять ожидания работодателя.