day in the life at spotify working as a business analyst | data analytics tips, strategy meetings

[@vitorpereira7511]

You writing your SQL query in your Spreadsheet was the most insightful thing I've got this entire year!

[@garnettk]

[@rugiyyasaftarova3063]

i have been watching your videos in order and just realized one thing. your vlogs your lifestyle in nyc feels so different and so refreshing than influencer's. they make everything look like american style but you keep your version of things

[@shanomac]

Really appreciate you putting these videos together. Working as a BA, I've been battling to get my reporting workflow refined - and your tips on Google Sheets and using queries was amazing. Thank you! Keep well

[@alexmitchell5339]

Love your videos and what a fascinating insight into this kind of industry. I'm always shocked at the amount (and length of) the meetings/calls you have in a day. When do people find time to do the actual work??!

[@Seolhwaneul]

Right?? As an introvert, being in meetings for such long lengths at a time would tire me out rather than doing the work LOL

[@moccisimo]

@@Seolhwaneul right?? I hate physical jobs but at least I can work alone. Socializing this much seems exhausting

[@denislopesmoura]

I'm Brazilian and I loved that you used MPB music in your video 😅💜

[@LillianChiu101]

i work for the latam region so ofc i gotta do some MPB music hahhaha

[@claire1136]

想聽Lillian在資料分析實務方面的步驟是怎麼著手（例如：從拿到row data ->google sheet的圖表可能會跑哪些分析、常用的分析方式&公式、怎麼驗證自己的分析正確與否等等），因為也是分析初學者，特別想知道Lillian 是怎麼分析的！感謝！🙏

[@LillianChiu101]

if you're interested in organizing your files & docs more efficiently - check out Coda at coda.io/lillian let me know what other work tips you'd like me to talk about next! 👩🏻‍💻

[@JmyBd9RhG5sBVC5]

coda VS notion？

[@hadong7882]

top worth buy that boots your productivity when WFH? :D

[@paulitochan746]

I'm soo happy to see you enjoying the brazilian music, i'm from brazil and it's good to see people from other country enjoying this music. ❤❤

[@upondlite]

wow lillian you have come so far! you first popped up in my recs w/ less than 100 subs and now you have over 100k! congratulations 🎊 I am so proud of you!

[@LillianChiu101]

thank you! omg and thank you for being my first audience from day 1

[@tessa.herondale8486]

i really love your videos! i'm loving BA more and more, if you have time we'd like to see the workflow making your presentation/reports, from backend to dashboard/presentation part! thank you! ♥️

[@abao3010]

很享受看Lillian的Vlog，能夠透過你的Vlog了解在海外的生活，btw你吃飯時候看起來非常可愛🥰

[@noonereally586]

Starting tomorrow as a BA as a fulltime job for a client (allianz), was an apprentice in dev web before that ! Not sure french BA is exactly the same definition as BA in US but it has common tasks and this is motivating to watch this before my first day haha

[@fino11475]

Hey hi 👋 I too aspiring for that . Can you send me your LinkedIn id?

[@jeanhappyrock]

Brazilian music in you daily routine! I loved it. ☺️☺️❤

[@jymob_seo]

Your day in the life vlogs are so fun to watch, it makes me wanna pursue analytics! The "more kdrama part" tho! #relate 😆

[@bingoy.g9071]

love life. happy life, free life.

[@kcph.kelvin]

Lovely! Love your positive energy and vibes, all the best! A new fan from UK ✌🏻

[@LillianChiu101]

thank you!

[@nneo.2334]

Don’t you just love work from home!!! Haha this is a part of my day I look forward to. Fixing a quick lunch or snack.

[@analuiza9167]

08:26 cute brazilian bossa nova song (: it matches the açaí bowl (btw you say açaí correctly, which is nice)

[@FelipeAugusto-xq6ol]

I wasn´t expecting a brazilian song in this video, it was a good surprise for me (I´m Brazilian)

[@RenataOliveira-dw1vl]

Ela sempre coloca alguma música brasileira no background ❤

[@vyrnaabu]

Same. I wasn’t looking all the time so for a second I thought the music was playing on my phone 😂

[@larissadecarvalhotavaressa2492]

Love your video and the Brazilian music with the coffee time ❤️

[@mompreneurlife]

Thanks for sharing! This will help anyone who is interested in the business analyst position. Have a great day.

[@thelittleflowerthatcould]

Please keep doing videos like these! it is so insightful 😍

[@Lau-td9bc]

Just discovered you and I LOVEEE your tips!! ❤❤

[@dmd2803]

Can you share how you maintain motivation in your job? Is it because the work you're doing align with your interest, the people you work with, the product, etc.? Would love to hear

[@lofiboyM3P]

The salary my G

[@dmd2803]

@@lofiboyM3P you'd be surprised :)

[@nezhasdiki77]

you made me so proud I don't even know why! u got a new subs!

[@syuhadasabri1866]

Hi Lillian! I am your new subscriber. I just starting to explore data analyst field and I find that your videos are very insightful. Keeps me motivated too. Thanks!

[@minniechang7576]

It’s hot at these days. Kimchi is also the best choice for the summer recipe for me. Ha~ And thanks for your sharing, it sometimes inspires me to work more actively. Hope you have a nice day:)

[@cesarsampaio4598]

Suddenly a Brazillian Song, Jeez, that was awesome

[@missMiracle7]

That book that you’re reading doesn’t help you sleep tho lol “PM interview” so intense 😆

[@LillianChiu101]

hahaha i'm not a big reader so reading puts me to sleep so easily but also i was skimming through the book mostly. I like the framework it teaches on answering product Qs but not necessarily everything

[@henriqueferreiradasilva2657]

The Brazilian song omg I’m obsessed

[@ricocaswell6287]

love that foot bucket, great idea

[@Victorhbertani]

I love the Brazilian music in the video!

[@maosenhuang3994]

或許.這樣形容誇大了!但~ 你完成了許多人的小小夢.Lillian你好棒.真的~

[@paulsu5134]

自己是做音樂的看到妳分享Spotify分析其實真的很有趣，而且很喜歡妳影片節奏 ! 加油!

[@aprilannroman726]

I just want to say Thank you for showing your process and how you organize your sheets. Just subscribed!

[@sarahpan]

yayy tech girlies 🥰 ur acai bowl recipe looks so good hehe

[@ivanperez2067]

She’s both working and chilling

[@tedanthonytarona8355]

Thanks for this Lillian! I'm currently planning to transition from telecom to Business Analyst that this gives me an idea of what the work is like

[@Windysyoutube]

Really appreciated the excel and query explanation! More please!

[@LillianChiu101]

thank you! more tips to come

[@maeunicecodaste5911]

it's my first time watching your videos. I am amazed because you have a nice content. 🙂

[@TSUKILORD]

Hi, I really follow and enjoy your stories/vlogs. Please be aware of the canned/jarred food, they have a high concentration of preservatives/salt. Salt is probably the reason that you are so addicted to it - I am also addicted to salt :D

[@giovaneramos8629]

I just loved the fact that you put Bossa nova to play at 08:30. I’m not sure if you know this but it’s a Brazilian music style. Btw love your videos. Hugs from Brazil 🇧🇷

[@LillianChiu101]

love brazilian music~ i work for the latam region , fav artist: Anitta

[@Amoramorim1]

hi, i'm from brazil and love so much your vlogs videos. to tell the truth im at the colloge and i really wanna be a data scients as you are and see your week and how dinamical is your job i get so excited about it. thanks for sharing and inspire peoples from around the world (sorry for bad english i dont trust google translator)

[@grainofsalt2113]

glad i found your channel, so few BAs to follow on youtube so thank you for making this content

[@emilyk7851]

i love the query tab tip!

[@WilliamRandomUploads]

Congrats on 100K 😍

[@fenixrock]

Loved the data analysis tips. Thank you!

[@marcelogarcia7382]

I think thats amazing when i'm watching some randon video in another language beyond braziliam portuguese and some braziliam music starts playing out of nowhere

[@instaSHINOBI]

I'm a simple guy... I see Final Cut Pro and I upvote 😄

[@juliafei]

an exel queennn 👸 I learned something new today haha

[@michellechuang6917]

It's been a year since I am back in Taiwan and I miss the Costco chicken!!!! I used to make Sichuan style mala chicken by pulling off meat from the chest. It is extra tasty with cucumber, carrots, and cold noodles. Worth to give it a try some day!

[@LillianChiu101]

ohhhh that's such a smart idea - will def try that next time!

[@maribethel]

I loved the "OST" of the video Menino e Fogo - Clara Mendes ahahahah kisses from Brasil

[@sanianaeem8311]

Day in the life are always fun to watch. I also did one with my internship in the UN.

[@leonamoon594]

I love the brazillian song in the video

[@agami5547]

Hey Lillian, Thanks for your nice inside. I have already finished some SQL, advanced excel and VBA courses now I feel like I have to work on real-life guided projects to implement that knowledge and get ready for the industry. Could you suggest to me some affordable guided project or anything like this? Thanks in advance

[@amandabarbosa160]

heyy, I think you are more than ready to go to the industry. We learn even more in real-life projects than in a guided course, just go girll! you got this

[@alanlisboa9]

i really enjoyed the brazillian music on this video :)

[@nasilemike]

Love your videos! Was wondering if you would let us know what ur skin care routine is!!

[@LillianChiu101]

thank you! mostly just drunk elephant and curology and I keep it v simple - will show that in a future video!

[@fuadhasanapiglotis]

fantastic video and good tips, pls keep showing more business/ data analysis tips

[@carolinaalvarez1775]

This is very interesting bc Im a Sr. Data analyst for a Healthcare company. I applied for Spotify and not even a call. Your job is way easier than mine. Where I work my title is part of what I do but my role is more of a Data systems engineer. I do data (excel, tableau), data base managemen(sql) , flows (power automate), use tools to improve our processes (coding), I want to work for a company with a more detailed and central role. I think now Im not being paid enough lol

[@GoodBoyFx]

haha.. woa.. i dunno why but i liked ur videos.. 2nd video after dog sitting.. its so casual n so ease.. such an easy going life..u seem to be very good at your work..what do you think made u this good at your work? what else.. foood..kdrama... food.. n more food... haha is it me or every other asian girl is a foodie! yet u guys don't get fat...grrrr .. u look so chill n easy going n fun to hang around.. so leme ask u something im curious about: answer these questions 1) do you ever get angry? what angers or annoys you? 2) what is your passion n purpose in life? 3) do you ever want to get married n have a traditional family? 4) describe your ideal bf/husband?

[@관망자-w7u]

I love this video!

[@ara682]

Nice vlog, dude, I should try that açaí bowl I gotta start eating healthier 😢

[@GuilhermeVarago]

Wow, unexpected the Brazilian music, greetings from Brazil!

[@Ktavonne]

Just accepted an offer as a Jr. BA and was waiting on a sushi order while watching this! Lol! Great video!

[@dcjohnson2490]

Great video. I am looking to in transitioning to Business Analysis and have been watching vids like this see get insight on what I can expect in in a role like this.

[@gianthara9067]

You are so great, aunt.

[@joddietaylor]

Another great video! Yes! Please create a video about your editing workflow! Thank you🌺

[@jpgunlukleri]

You inspire me a lot a lottt!!!! wish to meet to you!!

[@jashintakresnasenja8727]

Thank you for Sharing Lilian!

[@michellechuang6917]

If I read the Cracking the Interview books in my bed like that, I would fall asleep in no time XD

[@LillianChiu101]

hahah that's lowkey the point too - to fall asleep faster xD

[@HCTW566]

Your content is interesting and the way you share your life is really nice. Quick question: why don’t you put English in your tile as well? The tile In both Chinese and English will help you getting much more viewers from non-Chinese speakers

[@toptrading7309]

your music taste is awesome and also your videos making me feel switch on mode kind of "less mess, more structure by the soft power way". So thanks! 😇

[@HoangLamThanh]

Thank you for your video. It's very helpful. I wonder if you could share with us the way you improve your domain knowledge in your daily job.

[@julesmariee]

I have to try the chicken and kimchi dish! 😍 Also, I'm not sure if you're aware already but there's a recall on the Oatly milk, don't want you getting sick ❤️

[@jpiantoni-5861]

Hi Lilian, I`m brazilian, i love coffee, tech and data 😉

[@MelissaAlbuquerque]

This video is super Brazilian with the açaí bowl and one of the songs you used 🇧🇷♥️🥰

[@tedchang7312]

拿Fellow EKG澆花 😆 我也會拿手沖壺澆花 超好控水，後來就回不去一般的澆花壺了

[@jvbretana]

Have a great day

[@catsbangel]

I loved the brazilian music (ps: i am portuguese, lots of love from Portugal)

[@LillianChiu101]

aww thank you! i work for the latam region so gotta feature some brazilian music ofc🥹 also lovee Anavitoria and Anitta!!

[@catsbangel]

@@LillianChiu101 uau, i love love love Anitta 🥰

[@GMEspeleta]

Love how cracking the PM interview is what you consider “light reading” 😅 Great stuff as always!

[@Matias67893]

I loved the song in portuguese in the video 💖💖

[@MatheusRodrigues-oe2zf]

wow, 8:28 it's Brazillian music samba

[@chapisaarunyapairoj7123]

which program do you use to manage your daily schedule at 2:08?

[@saulgoodman6710]

May I ask how much do you get paid? give us an approx range (probably tight), just to correlate with work at startups, since I work at a new startup which was quite new. Thanks!

[@bachpregil5902]

at first you were Jennie of Blinks! Pretty! Just subscribed! More power Dear.

[@Riddingwithvivian]

Whats everyone favorite excel formula...I love the =rept because I can write all work and no play makes jack a dull boy a 100 times then drag it down the spread and everyone in the meeting thinks im crazy

[@kanikasingh889]

PLEASE SHARE WHAT KIND OF SKILL SETS I WOULD NEED FOR MY COURSE IN business Analysis in UOM.

[@sampraszhou4492]

哈哈 解锁了fellow手冲壶的新功能😂

[@paolapsantos]

That`s amazing u listen Brazilian music! I`m from Brazil. By the way I dont get to use google sheets prefer a lot of microsoft excel 365

[@candacenicole1111]

Great video girl!!! Thanks for sharing! Have an awesome day!!!!!!😁👏

[@Babyk4315]

Do you think if you were working in the office, the workload will be less because you won't have to make a lot of calls and you would be able to talk things out quickly than working remotely?

[@clarielealmeida6225]

9:11 a brasilian song ❤❤❤

[@GabrielMartins-qx8ki]

Achei que eu seria um dos poucos BR assistindo, mas até a Lillian escuta musica em PT hahaaha

[@KarineCamposAlexandre]

Tava procurando um BR aqui 😂

[@GabrielMartins-qx8ki]

@@KarineCamposAlexandre ahahahhahah estamos em todos os lugares

[@xiaoandbao]

Yes can you share how you edit on Final Cut? Would love to learn

[@alexaistraveling]

Hi 👋 I’m currently learning and getting more info about BA, could you recommend any courses or/and resources that will be helpful for a beginner / entry-level BA? Thanks a lot in advance! :)

[@LillianChiu101]

hi alexa! happy to hear you're on the BA journey - this video i did may help: kzbin.info/www/bejne/b3SqiqCjfb-kb7M I talked about the 3 core skills I had to learn when I started this job and mentioned some resources too. but lmk if there are specific topics you'd like me to cover more on!

[@alexaistraveling]

@@LillianChiu101 thx for the response, good luck!

[@soolistic]

Hi, may I ask where you got your straw and coffee cup?

[@LovingSoul61]

Can you explain the difference between business analysis and management consulting?

[@willyh1272]

Hi Lillian, May I know which laptop is your work on? Is Apple Mac enough?

[@zhuzhujin9481]

I was wondering what are the critical technical skills for you position(sql and what else)?🤓

[@minkyulee8057]

Love your diet :)