weekly life of a Business Manager at Spotify | how I lead business analysis (at the office)

Entrepreneurial Edge
21 followers
Nov 22, 2024
Can I get a computer photo?
This is Netflix's analysis.
Data can be transferred to the inside.
I'm taking my mom to the office today.
This is the dress of our office.
Welcome to New York.
I will take her
eat breakfast
in the office
Arrived
super beautiful
This lady has a lot of food.
Hot.
Latte with oat milk
Single shot
Ice matcha latte with oat milk
As I juggle between my job
and content creation
My schedule can look pretty hectic
But I've been using Motion to manage my to-dos
and downtime all in one place
Motion is basically a tool that tells you what to do
and when to do things
like a Google Calendar combined with your to-do list
So this is my Motion
and I want to show you why it's worked out so well
for my workflow
All my tasks are in Motion
I've synced my job calendar and my content creation calendar
So my Spotify job calendar is in green
and content creation is in purple
You can sync multiple calendars
from different emails
so they all live in one place
And if something urgent pops up on my calendar
Motion reshuffles my tasks
so I don't have to move my tasks around
on my calendar manually to a later time
Or let's say I'm really heads down and focused
and don't get a task done
like an IG real script
Motion will just move the tasks
into the future automatically
But if I do get it done
I just check it off like a to-do list
and I love that sense of accomplishment here
Motion has a fine-tuned algorithm
so it's consistently running
to make sure your calendar is up to date every second
I also love Motion's focus on users' well-being
I set times like lunch
and Motion will automatically find the right time
for me to do that
in the time slots I've selected
So I remember to take good care of myself every day
After using Motion
my days feel so much more structured
and I'm not always worried about
Okay, what do I do next?
Or did I forget something?
And there's still room to breathe
So if you also have a very busy lifestyle
and want to take control of your schedule
I have a special 7-day Motion free trial
just for you and my viewers only
Check it out in the link in the description box
Thanks everyone for adding your thoughts and questions
Just a quick reminder of how this will work
So on Mondays
So when I do data analysis
I always make sure my data can turn into business insights
And this is where my learning agenda comes in
Let's assume that you're the business analyst for Netflix
The marketing team has a $1 million marketing budget for 2024
To promote a show and drive engagement in the United States
And the marketing team has asked you to analyze which show to promote
That's a big task, right?
And let's assume that you've clarified with the marketing team
When they say engagement
It means total number of hours watched
So you can think of the learning agenda as an outline
That keeps you focused on answering the business question
Without getting lost in a sea of data
First, always start with the business objective at the top
Every data you pull should tie back to answering this question
Now on to the main part
Let's start brainstorming some data questions
So we can pull the right data
Here's my first data question
What are the most streamed shows in the US?
Let's focus on the top 10 for 2023
Given our $1 million budget
We cannot be promoting many shows at the same time
The next thing I do is
And this is where the business insight kicks in
I ask myself the question
So what?
What can the marketing team do with this?
What actions or strategies can they develop based on this data?
So my business thinking is that
By knowing what are the most streamed shows in the US
We are basically promoting an already popular show
And we can build on its existing momentum
Making our marketing investment more effective
The exercise of asking yourself the so what behind each data pull
Helps you stay focused on the business question that you're trying to answer
Next, the second question I want to ask is
Which of these top 10 shows has the highest completion rate?
So what's the so what here?
A high completion rate means viewers are engaged from start to finish
Promoting shows with high completion rate
Aligns perfectly with our goal of increasing content hours
And even potentially retaining users
Which is another added bonus of reaching another business goal
That might be relevant for the marketing team as well
So how would I visualize this so far with our two data questions?
I would put all the top 10 shows by two metrics
The number of streams on the x-axis
The completion rate on the y-axis
And do a gridline system to categorize them
So you can easily see that we should focus on either show A or show B
Since they are the star performers on both streams and completion rates
Let's say you've shown this graph to the marketing team
And they want to go with show A
The third data question I want to have is
For show A, which US state has the least saturation
In terms of percentage of current subscribers
Who have started to watch the show
What's the so what here?
What is the business goal of pulling this data?
Because from a marketing investment point of view
We don't want to waste our marketing budget
On people who have already watched the show
So instead we should focus on states or locations
With low viewer saturation to target new audiences
For them to watch the show effectively
Based on this graph we can see
We'll focus on New York when it comes to promoting show A
Since New York has the lowest percentage of current subscribers
Who have watched the show
Through this exercise, you might realize that
Each data question builds on the previous one
Guiding you naturally through the data
Even to this day, I still build my learning agenda
When I start any data analysis
Even with all these AI tools like ChatGPT on the market
Because a lot of big tech companies are really strict
On not using these AI tools
Especially ChatGPT
To prevent confidential information from being leaked
And I remember in my first two years as a business analyst
Halfway through the analysis, I would get so lost
I would end up with like 20 or 30 graphs and different slides
But this approach of listing your data questions
And thinking it through the so what
Before you pull the data
Helps you stay focused on the business goal from start to finish
And interestingly, the learning agenda
Has also helped me establish leadership at work
Because in a way, you are kind of project managing the analysis
My first manager once told me
The more senior your role becomes
The more thinking it will be
And the less doing
Especially in an analytical role
Where you will have data analysts or data scientists
To help you pull the data down the line
By the way, I created this segment of the video
Based on the feedback I've gotten from you guys
On my Instagram story
Let me know in the comments
What topics you want me to cover next
Can be business analytics or something completely different
This is Arcade Room.
You can play this dancing machine.
Wow, it looks delicious today.
Wow.
The kitchen is here.
have everything
Snacks are healthy snacks
Just eat them all directly.
And then there's fruit in it, too.
Eggs with virtue
Beverage
I'm gonna take a photo at this photo booth
it looks good
Cute
What do you think you're doing in my office today?
Feelings
Experience ah amazing
Alarmed
My mother always said
You don't have to work this way.
Feeling very light.
Then she can come every day
Also can sit here.
It should be said that this environment
I think it makes people creative.
Playful
Playful world
Many places are fun
My mom's home cooked meal
She's momming
We got home and we're super tired
But she's on autopilot to cook
As soon as you come back, you'll be ready to cook.
Because I have a bean meal today.
Wow, thank you
We have a special guest today
Look
Right Bella
Spicy
This is the smell of my work when I was a kid.
We're at a mini bar in Williamsburg
Right on the water
Thank you for inviting me
Oh my god
Hi
Nice
Don't be so intentional.
That I
Usually called knock bar
In the coffee section.
I am working
I'm typing up an agenda
for a new business analysis we're doing
And my mom is just like on her phone
Your husband is two days.
Come and share with me.
I think you
You've grown a lot.
I came to study with Lily
You miss you
Have you realized anything?
You see, I'm having a meeting.
I realized
I think you've arranged a lot.
Something in order.
A lot of complicated things.
Arrangements are justified.
But I realized that was
Leaders are doing.
Usually as a leader.
You don't go on doing a lot of things
You're thinking instead
Think about that strategy.
Then think about who I want to use.
Then how to talk.
I think it's the talk.
Yes
I see every meeting you have.
different will.
I found that there are different harvests.
I don't feel it myself.
Different harvest.
I don't feel tired every day.
Will the head burn?
It hurts my head.
My colleagues are also very smart.
Anyway, there are ideas
I feel like my experiences will stop me.
That is to make you strong.
Let every man be his long.
I am very old
I am 27 years old
Laugh a lot
Laugh
I left home at 18.
It's a shame.
Can be alone.
I think I can be a mother.
I'm making my mother's spaghetti now.
I want to show her my cooking skills.
You should have been sitting there.
I make you food.
Then you also come to help me cook.
Delicious
The powder is delicious
These are today's clothes.
We're going to Soho
buy some clothes
All white
Very pink today.
Then you look at her
Why wear so much this time?
35 degrees today.
Because to guard against
I want this lead.
I chose this.
My mother and I decided to wear the same clothes
I told her to buy this.
good and lovely
Hi.
I bought it.
Iced Matcha Coffee
super sweet
Is it nice?
nice
I'll eat everything you cook
What is this?
Sauerkraut
How is this turn
This is Qingjiang cuisine
Bought this pile.
How much does it cost
$10
Wait a minute, it's 80.
The answer is revealed.
69 to 58.
The last dinner my mother cooked.
Rich
It was noon when she steamed the fish
This shirt is for her in Taiwan
I made it while in Taiwan.
You can't learn Albert's Diet.
Because he doesn't eat at all.
Back to Taiwan
See you next time
