day in the life at spotify working as a business analyst

day in the life at spotify working as a business analyst | my business analysis workflow

Рет қаралды 801,910

Күн бұрын

📖 my business analytics online course (5000+ students currently!) (pre-recorded online course, watch and enroll anytime!) www.pressplay.cc/link/CC46B569
Hi! welcome to the ~day in the life as a business analyst~ series (ty all so much for the support on the first one!). In today's video I'm sharing what it's like to do a business analysis and how I go about my day working from home.
#dayinmylife #vlog #lilliandayinthelife
---
❐ SOCIALS
IG - @lillian__chiu
💌 For Inquiries:
lillian.chiu.nyc@gmail.com
📫 send me mail:
PO Box 414
Jersey City, NJ 07303
--
❓commonly asked question:
monitor (LG 29” UltraWide Monitor - amzn.to/3LrnxFU)
monitor arm (HUANUO Monitor Arm: amzn.to/34yiWkM)
--
❐ Discount Codes:
I get all my asian groceries delivered via Weee! use my link for $10 off your first order!
s.ricepo.io?c=BD7CR-UNJY0&l=en-US&w=1
---
❐ About me:
I’m Lillian and I am a 25 y/o Taiwanese working as a business analyst. I moved to the U.S. 6 years ago for college and in my videos you will find me sharing my [early career] stories in tech, navigating through life in my 20s, and building my home away from home.
---
0:00 - 0:41 gotta eat breakfast!
0:42 - 0:57 GRWM
0:58 - 1:32 today's agenda
1:33 - 1:50 meeting #1: 1:1 with manager
1:51 - 2:54 my business analysis workflow
2:55 - 3:36 leftover lunch
3:37 - 4:27 meeting #2: 1:1 with new spotifier
4:28 - 5:08 u guessed it - coffee!
5:09 - 5:40 back to work
5:41 - 6:49 business analysis tip!
6:50 - 7:11 finishing up work
7:12 - 7:29 laundry debate
7:30 - 8:43 why am I so good at cooking?
8:44 - 9:06 eating my own food
9:07 - 9:35 packing for texas!
9:36 - mini night routine
--
❐ MUSIC:
Helkimer - icecream (feat. ThinkChill) - thmatc.co/?l=85AF9564
Lakey Inspired - The Process - / the-process
Lakey Inspired - Better Days - / better-days
Lakey Inspired - Warm Nights - / warm-nights
Lakey Inspired - Me 2 (Feat. Julian Avila) - / me-2-feat-julian-avila
Nicky Youre - Sunroof - thmatc.co/?l=87C08FA1
Lakey Inspired - Days Like These - / days-like-these
DRUBEATZ - Cart00ns & Cereal - thmatc.co/?l=592FCB70
YSO Blank - Orange Peel - thmatc.co/?l=4CD0E829

Пікірлер: 465

@andremember 2 жыл бұрын

You gave such a clear and easy to understand explanation of the business analysis process! More videos relating to that in the future please! And also tips you’ve picked up along the way (similar to the “why I use google sheets” comment you made down below)

@LillianChiu101 2 жыл бұрын

thank you so much!!

@yccn410 2 жыл бұрын

As a Taiwanese female who’s also working at a US tech company, I’m so pumped to see your video! Support ❤️

@jossaline 2 жыл бұрын

Liliian, thank you so much for making this series and putting so much effort into it.I love how you explain what you're doing with so much detail to help us have the closest possible understanding of what a day in your life looks like. Many other vloggers kinda just sit around and show themselves typing and doesn't explain much which is understandable, but not very interesting to watch and or informative. Just wanted to let you know how much your effort is appreciated :)

@LillianChiu101 2 жыл бұрын

Thanks Joss for your thoughtful comment! I'm glad you found it informative 🙏🙏

@soanna9394 2 жыл бұрын

I really appreciate that you take the time to go in details on the work that you do 💯💪🏾

@missm7234 2 жыл бұрын

This is really interesting and gives me a greater appreciation of the Business Analyst role! You are also very engaging and can easily explain analytics!

@wrenchguy2937 2 жыл бұрын

Great video. I do the same thing for my job. Alot of queries and data analysis via excel into graphs. I think it's awesome how different roles business analysts are for different companies.

@zuri5719 Жыл бұрын

Lilian, Thank you so much for these insightful videos on business analysis career. I am currently doing a masters in business analysis and consulting, your videos get me excited to be in the analytics corporate world after graduation (PS: your channel is the only one that keeps motivating me to carry on and enjoy what i do) Good job!!

@georgiaho 2 жыл бұрын

loved both of your day in a life videos - I'm inspired to make some of my own! I've been taking a year break to do my own things so your videos are making me miss working with other people. (also your cooking looks amazing!)

@sanjanamehta8107 2 жыл бұрын

Girl you are LITERALLY out here living my DREAM LIFE!!!!!!! Love your content♥♥

@yi-jentu7778 2 жыл бұрын

Hey! Hi from Montreal, and also as fellow Taiwanese :) Way to go on starting your career at Spotify! Your video resonates a lot with my own experience working as a BI and Analytics analyst. Keep up the good work! Look forward to your new contents

@KhalilEats 2 жыл бұрын

very nice detailed vlog! Motivating!

@inliightsociety1549 2 жыл бұрын

very well done. Ive been looking for workflows for a while. im happy you brought it up!

@gabriellereut.9270 2 жыл бұрын

As a Lead IT consultant in Paris (FR) and a Woman in a masculin professionnal world, it is very refreshing to see your videos! Keep it up 😎

@feliciaiskandar Жыл бұрын

Just like everyone said. Lillian, you're the best at explaining how a business analyst works, especially when you explain your business analysis workflow at 1:51 and how is your thinking / analytical process to raise above the data and numbers to get the business insights at 5:53. I'm motivated to learn more about business analysis. Hope one day I can be a business analyst myself at an international company as you are.

@anushka___0809 2 жыл бұрын

I never in my life thought i would be a business analyst. I always watched your videos and liked your profession, and out of nowhere I'm promoted as Business Analyst in my office.. made me realise you legit attract things

@Leedah8 Жыл бұрын

What role did you start at before becoming a BA.

@ac9265 Жыл бұрын

Same! How are you liking the role?

@ltk7309 Жыл бұрын

I've always wondered if the role of a Data Analyst the same as a Business Analyst? Because I've compared the job descriptions of both roles and they're identical. Would greatly appreciate if anyone could clarify this. Thank you!

@DATA_MISS 8 ай бұрын

@@ltk7309okay, so. Based on my reading. Business involves ms word, excel, power point and sql. Data involves business analytics plus python

@diariesbydanika 2 жыл бұрын

Everything you cook looks so delicious! Love the energy you're bringing to this platform ❤

@julietlaney2776 2 жыл бұрын

Thank you for taking the time to explain a bit about your BA workflow and tools used! The visual and talking through the process is so helpful & interesting :)

@clarissa7724 2 жыл бұрын

Recently found you and loving these vlogs! Please continue this series 🙏🏻🤩

@minhvo6131 2 жыл бұрын

What a great video Lillian! I am from Vietnam and it's great to hear that you used to live in Vietnam. I am also interested in business and data analytics and I hope to work like what you are doing right now. I am actively seeking for full-time job after graduation, and your video is recommended to me, which is soooo helpful!

@LillianChiu101 2 жыл бұрын

cảm ơn Minh! goodluck on your job search and glad you found the video helpful! more to come ♡

@peytonq4745 2 жыл бұрын

Hi Minh Vo, r u doing for both?

@faroukmohammed6859 2 жыл бұрын

i am so glad i found ur channel. i develop interest in BA not long ago, i am a mathematics student currently and hopefully i can get to work as a business analyst by the end, also currently learn SQL and other data related applications. you make the career look so cool

@celine1196 2 жыл бұрын

A new subscriber :) I am currently in my first semester at university and wish to be a business analyst in future. I don’t know what exactly a business analyst does, but watching your videos makes me understand more about it. I feel like I would enjoy this role and I wish I can have a career like yours. Seeing you as a role model now!

@LillianChiu101 2 жыл бұрын

thank you celine! glad this was helpful. i think what i love the most about being a business analyst is that i get to work on so many different types of projects with all types of teams. i like the 'generalist' role aspect of it as opposed to a 'specialist' role. my manager used to call us ninjas and i love that

@eatsbyrachel 2 жыл бұрын

So interesting, love seeing this peek into your life!

@just__nimo 2 жыл бұрын

new subscriber :) I just binged your content, and it's so motivating! It's so detailed and the editing is *chefs kiss

@duongg4986 2 жыл бұрын

Excellent video Lillian, this video makes me feel a lot better, and also really good tips to kill awareness :D. Keep goingggg

@vacant19 2 жыл бұрын

以爲是一般台灣觀眾為主的旅外生活頻道，但是發現觀眾更國際化，很厲害的創作者。

@LillianChiu101 2 жыл бұрын

謝謝你～～

@yesstasisno Жыл бұрын

韓國好像也很多創作者是講英文的，就會很多人收看👍🏻我也是第一次看到這個頻道

@user-gd8nv4ir5t Жыл бұрын

好意外妳也是台灣人然後小時候在越南長大。

@sassyreaderj 2 жыл бұрын

I love your videos! You are engaging and informative. Also, I love the sass between you and your bf! Thank you for posting, hoping to see more!

@anushka___0809 2 жыл бұрын

Love these type of videos so much ❤️also loving your channel alot❤️❤️

@Nekoshih 2 жыл бұрын

You are amazing!! Love u sharing ur daily routine, it help me learning English from you❤️❤️

@cookie7241 2 жыл бұрын

Loved this !! Please keep videos like this coming.

@linglee6415 2 жыл бұрын

As a local Taiwanese, I learn a lot of interesting English(of ingredients) and some knowledge about business analysis from this video! Also your video looks so cozy and motivated at the same time! Happy belated Lunar new year~

@LillianChiu101 2 жыл бұрын

謝謝你！新年快樂🥺

@Taskade 2 жыл бұрын

It takes time and effort. Each bit of experience counts towards something!

@candidlyvivian 2 жыл бұрын

Great video Lillian, even more informative than your previous one, congrats on the growth of your channel! 🥳

@LillianChiu101 2 жыл бұрын

aw thank you!!

@amyprofitspecialist 2 жыл бұрын

You are so productive. Great job!

@chebiesera 2 жыл бұрын

Love this content, this feels different from the other day in my life vlogs that I see on yt. I mean you really gave us a view of what it's like wfh, only a few vloggers do this I think. And really appreciate how you explain to us the works or tasks of a business analyst. Can't wait to see more videos from you

@Tartiniss Жыл бұрын

At first, I was inspired by your video about business field but just knew you grow up in Vietnam which makes me love to watch you more (i’m from Vietnam btw)

@MinhAnh-gi1em Жыл бұрын

From Vietnam, by accident I knew your KZfaq channel, I am working as BA like you, you inspire me a lots sis

@HeyItsDena 2 жыл бұрын

omg i'm so glad youtube brought me here. this is SO interesting to me!!

@jameschen3414 2 жыл бұрын

Omg, Taiwanese fella! I have a final round for a business analyst role tmr.I also been in America for 6 years. It’s super inspiring to see your vlog!

@YuanQ 2 жыл бұрын

yess please do more! Also the braised chicken looks sooo good!

@archit617 2 жыл бұрын

I'm currently pursuing BA for ECBA. Hope to become BA one day. You gave me a big motivation. Thanks and keep up the good work.

@joycekuo6933 2 жыл бұрын

天啊...第一次看妳的影片目前就讀統計系看到資料分析、數據圖表、excel試算表那邊整個驚呆了神奇的演算法帶我來這邊向妳看齊和學習偶像🤩

@DarrylLee-cz5rv 2 жыл бұрын

awesomely organized day! Thanks for the well explanation of the BA 💪

@josiesu9761 2 жыл бұрын

Thank you for sharing a real day in the life of a business analyst. It helps me to understand more about this role and makes me want to step in it :))) Could you share more details about how to prepare to become a business analyst and work portfolio?

@stephaniec.9335 Жыл бұрын

love this video and how you explained how you do business analysis. ❤

@bonniehung1312 2 жыл бұрын

Sending the love from Taiwan 🇹🇼. Great content let me know lots of things in data analytics, it definitely helps a lot for my future career thanks🥰

@LillianChiu101 2 жыл бұрын

thank you bonnie!!

@fabercastellcabj18 9 ай бұрын

Really good video. I'm currently pursuing my masters in Business Information Systems and this video has clarify more about what a Business Analyst day to day look like.

@snowliezzz 2 жыл бұрын

Hey! Nice to bump into your channel. So I'm a Vietnamese, but currently living and working in Taiwan so I feelllll so related when you mentioned about Taiwan Vietnam eventho it's not really related 😂 I had a good time watching your video, have a good time, take care and 新年快樂 🍾️

@LillianChiu101 2 жыл бұрын

that's so cool!! chúc mừng năm mới to you too!!

@dinhduytran7930 2 жыл бұрын

Very nice sharing vlog! I'm also on a journey toward becoming a BA! Great to hear that you grew up in Vietnam, cuz I'm Vietnamese ^^ Looking forward to seeing your next videos :D

@su1ayman Жыл бұрын

Love your videos - you inspired me to create my own channel talking about my journey as a business analyst in the UK :)

@mosesose6426 2 жыл бұрын

Wow..this is real business analytics on display here. Cool...i am on the journey. Transiting to a Business Analytics role cos i have been a business analyst for software dev coy for a while. Stay blessed.

@stupidhotdogbob 2 жыл бұрын

This is awesome. Good to see a business analyst do their thing. Love to see that eating is a highlight of the day xD

@yingtzuchen2765 2 жыл бұрын

Hi from Taiwan, and I’m so glad to see ur video cuz I’m majoring in big data and also dream to work in Spotify!!! Look forward to ur videos☺️☺️

@LillianChiu101 2 жыл бұрын

thank you Whitney!

@hidniadriana1995 2 жыл бұрын

I’m a BI analyst, but i just started out(aka junior). The thing about being a junior is i dont really have structure set yet on my “workflow process” and i think im always not doing something enough, but seeing your workflow, im 98% sure im subconsciously doing that already, and feel a bit better now😆 Thank you for the chill video and well explained process!🌟

@explorewithCK 2 жыл бұрын

love your lifestyle videos! keep it up and you got a new subscriber because of the variety of your content and your energy :)) - also...I grew up in Vietnam too and currently abroad. it's interesting to see how you are living your life now!

@ChyanSie 2 жыл бұрын

This is probably what I do too on a daily basis. Lovely!

@peachy4098 2 жыл бұрын

i just found your channel and absolutely love it

@quietasamouse 2 жыл бұрын

Your videos are super interesting! I watched them all :)

@HowardLinca 2 жыл бұрын

Love what you are doing! Support from Taiwan!

@bljacky007 7 ай бұрын

thank you for such videos that help me a lot. from Vietnam with love!

@ZoeysMusings 2 жыл бұрын

I really enjoyed this day in the life. You made a business analyst job look so easy 😁 Money in the pocket of an apron is such a mood 😂You're so sweet and the editing was on point 👏🏽TJMaxxx should sponsor you loool

@Omar-vc6ws 2 жыл бұрын

I would probably fall asleep if I had a job like yours 😴 I need more excitement than just looking at charts and emails all day. Still you’re really good at your job so congrats!

@yawantwi8050 2 жыл бұрын

First time on your KZfaq Channel and I love it...keep going

@nin5153 2 жыл бұрын

blocking off your calendar when you’re going to be OOO is sooo satisfying 😍

@LillianChiu101 2 жыл бұрын

i know rightt *auto declines all meetings* uhhhh

@2012staytrue 2 жыл бұрын

Great video! Would like to see a tour of your work from home set up and where you got everything :)

@samho6777 2 жыл бұрын

So awesome to find out you lived in Vietnam as well!!!!! That's a very lovely and gorgeous dress along with those MIU MIU heels!!!! Supporting all da way from Hong Kong here!!!!

@LillianChiu101 2 жыл бұрын

thank you!!

@meejmuas8686 2 жыл бұрын

I work on transactions systems for a car manufacturing company. I do the similar with extracting data and presenting data. Simple pivot tables in excel surprisingly gives me a quick overview and analysis on what the issue is

@rahuldelhi2510 2 жыл бұрын

Very informative, keep making videos on business analytics

@thaiking8031 2 жыл бұрын

daily but not mundane. go Lillian!

@Swordyfiish 2 жыл бұрын

Wow thank you this was so informative! :)) About how long does it take to finish creating the QBR and how much of that is past queries/dashboards you have? I also work as a data analyst and I feel like every day is so random and it's just like multiple stakeholders asking me for random datapulls and fixing broken things :( to the point where we can't focus on big picture stuff like this

@MrCrazy6312 2 жыл бұрын

The youtube algorithm brought me here. I'm a Taiwanese working in data science related job, too. your video looks interesting and chill. Please take more video to let me understand the work in NY, and Spotify. =)

@mandoball1980s 2 жыл бұрын

Lillian you are blessed (:

@YasinNabi 2 жыл бұрын

wonderful story and worth watching !

@moehtet802 Жыл бұрын

that trick of mentioning weather to avoid awkwardness is quite smart one

@christinahumtsoe1262 2 жыл бұрын

Hahah the small talks with weather is so TRUE 😂

@LillianChiu101 2 жыл бұрын

ikr🙄🙄

@9m_curves 2 жыл бұрын

gahd i love you 😭

@elyasjazayeri 2 жыл бұрын

Awesome video! The video about how you make videos and gears would be great!

@AndreasRobby 2 жыл бұрын

nice vlog, i got some insight of what it feels to be business analyst at spotify

@personallyjoua 2 жыл бұрын

oOoooooooo love that Mac lip color!!

@lenahmiah 2 жыл бұрын

I start at Spotify in NYC on the 14th. These videos were great!

@LillianChiu101 2 жыл бұрын

congratz and welcome to the band! ping me when you start!

@riceball1232 2 жыл бұрын

could you share your make up routine? your skin looks so good!!

@user-vj8qo3so4r 2 жыл бұрын

不管後面我會不會看完，但從水煮蛋沾醬油的那刻，你就得到我的贊了

@yclin1802 Жыл бұрын

演算法真厲害，我現在在學的就是資料科學，感覺從這裡能了解到一些未來的方向。光看到螢幕上的視覺化圖表就覺得好酷!

@yutingtsai3466 2 жыл бұрын

突然發現這個頻道！好喜歡💛 新年快樂🐯

@LillianChiu101 2 жыл бұрын

新年快樂!

@rish8357 2 жыл бұрын

You’ve inspired me so much. I’m an aspiring business analyst/consultant I’m currently pursuing my masters in the states for the same :)) Subscribed, notifications turned on! 🔔

@LillianChiu101 2 жыл бұрын

hahah thank you! you got this - cheering for you!

@funwithoprah 2 жыл бұрын

皮膚真的美到爆炸耶!!!! 看你影片超療癒

@samanthaflanigan1434 2 жыл бұрын

Interviewing for a Senior BA role today, and this video is definitely helping my nerves, helping me to relax a little! Thank you!

@LillianChiu101 2 жыл бұрын

hope the interview went well Samantha! cheering for you 👊

@Osky305 2 жыл бұрын

As a business analyst . I never knew my job seemed so exciting 😳😳😳

@cuongtrinh6126 2 жыл бұрын

thanks you for your sharing. I love it.

@hesterng22 2 жыл бұрын

Hi, Lillian. Thank you for making your vlog for us. Would you mind sharing tips on how native Mandarin speakers can improve their English speaking skills? Thank You, Lillian. ❤️❤️❤️

@-H30 2 жыл бұрын

Idk how I got to your videos but you should know the youtube algorithm is working in your favor :) love your videos

@thaodydu2727 2 жыл бұрын

Hi! I'm from Vietnam. Please continue this series @@@

@bee9536 2 жыл бұрын

This was so nice! i love seeing information neatly laid out! also where did you get your blue hoodie from? it looks super comfy~

@LillianChiu101 2 жыл бұрын

thank you! it's the Stadium Half Zip Hoodie from Alo Yoga

@SY-fs3dw 2 жыл бұрын

love this content and peep into your work! just subscribed and hope to see more! :) cheers!

@ryanwong6735 2 жыл бұрын

Your videos inspire me to be more productive in my work. Also, has anyone told you that you kinda look like Jennie from blackpink? Great video!

@cchahader6790 2 жыл бұрын

Im from Taiwan, u r the one I appreciate~ good good good ~

@iAmtHeViRuZ 2 жыл бұрын

Awesome vlog! Keep it up :) Cheers from Mexico!

@LillianChiu101 2 жыл бұрын

hola! actually got to visit mexico for Spotify Awards in 2020 and absolutely LOVED the place

@XXGREENQWERTYXX 2 жыл бұрын

Hey lillian, nice video! I love how you go into detail about your workflow. I'm a current M.S. in Business Analytics student and I'm looking to become a business analyst after graduation. I have a few questions regarding your general workflow and hope you could provide some insight: how many times a week do you create the analysis decks? Does your manager provide you with a scope as to what you are trying to find? Or do you have complete control over the data discovery part of the analysis process? Have you ever run out of ideas as to what your scope is or where to start the analysis?

@LillianChiu101 2 жыл бұрын

hi! ofc-happy to help. answering your questions in order: -it depends on the scope of the analysis, but i'd say 1 major analysis and 3-5 small analyses per month. -not necessarily. my manager (and her manager) would usually come to me with high level/ambiguous business question, (i.e. why are we seeing user decline) and my job is to consolidate data-driven insights to help inform business strategies. they aren't involved in the data discovery, more on the 'so what' side of things. But after I send my analysis over, they will sometimes dig deeper or look at it from a diff pov . I personally love it bc that way I have the full autonomy on data but also get to learn how they leverage the data to drive biz decisions. -when i first started yes, alot of times i'd feel lost in how to 'start' the analysis, i rmbr i'd ask my manager how he/she would break down the problem. (i.e. what type of info should i look for to understand user decline?) and then based on that, I'd speak to data scientist and see how they'd go about crunching that data. I think this comes down to time & exp on the job - 1 year in i knew both the business and the data really well, so now when i get an 'ambiguous' question, i can break down the question, structure a framework, crunch the data, consolidate the insights. hope this helps and goodluck on your BA journey!

@阿禾禾 2 жыл бұрын

@@LillianChiu101 好熱心

@tusharyadav3299 2 жыл бұрын

I just found your video to get some idea about the job role but apart from job stuff I really like your food review and cocking. : ) And you are great in narration. Can you tell me in detail (if possible) how to be a good storyteller like you? Actually, I'm an introvert by the nature but I really want to build my career as an analyst, and the analysis field required a good storyteller. Thanks in advance : )

@georgetang3877 2 жыл бұрын

Great video. I also work in Vietnam, and my children study in CIS and SSIS. But we still need go back Taiwanese education system soon.

@eason777662893 2 жыл бұрын

sometimes I look forward to the corporate world and the lifestyle. Since I fly for the air force but with a background in chemical engineering, maybe I can look into business consulting, so that one day I can make my own decaf latte at 1PM while watching the snow from my downtown apartment in NYC. haha