day in the life at spotify working as a business analyst | data analytics tips, strategy meetings
Вставка
- Опубліковано 31 лип 2022
- 📖 my business analytics online course (5000+ students currently!) (pre-recorded online course, watch and enroll anytime!) www.pressplay.cc/link/CC46B569
supercharge your productivity at Coda for Free at:
coda.io/lillian
and we are back with another day in the life video..! (i know... took me long enough) Last week we had a team offsite in nyc and while it was fun seeing my coworkers, it also took alot out of me with all the social events, back to back meetings, and multiple 2-3 hour long brainstorm sessions especially as an introvert. With that being said, this past weekend I slept from 10pm-12pm...lol.. Anyway, let me know what types of work related topic you'd like me to dive deep into - thinking of doing a sit-down video for to share my tips!
#lilliandayinthelife
💻 desk set up:
monitor - LG 29” UltraWide Monitor: amzn.to/3LrnxFU
monitor arm - HUANUO Monitor Arm: amzn.to/34yiWkM
monitor stand (silver): amzn.to/3PQs2vx
👋 social:
IG - @lillian__chiu
💌 For Inquiries:
lillian.chiu.nyc@gmail.com
📫 send me mail:
PO Box 414
Jersey City, NJ 07303
👩🏻 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.
🎵 music (in order of appearance) via Epidemic Sound & Thematic
Sunny San Francisco - Oakwood Station
Naked Like This - Medite
Perdula - Justnormal
Balloons - I’MIN
Menino e fogo - Clara Mendes
Treat of the 70’s - Oakwood Station
Anja Kotar - June - thmatc.co/?l=26A93428
Cosme Velho - El Equipo Del Norte
FTC: This video is sponsored by Coda
*disclaimer: all thoughts & opinions are my own and not Spotify's
You writing your SQL query in your Spreadsheet was the most insightful thing I've got this entire year!
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! ♥️
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
想聽Lillian在資料分析實務方面的步驟是怎麼著手（例如：從拿到row data ->google sheet的圖表可能會跑哪些分析、常用的分析方式&公式、怎麼驗證自己的分析正確與否等等），因為也是分析初學者，特別想知道Lillian 是怎麼分析的！感謝！🙏
Please keep doing videos like these! it is so insightful 😍
很享受看Lillian的Vlog，能夠透過你的Vlog了解在海外的生活，btw你吃飯時候看起來非常可愛🥰
Your day in the life vlogs are so fun to watch, it makes me wanna pursue analytics! The "more kdrama part" tho! #relate 😆
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. ❤❤
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!
thank you! omg and thank you for being my first audience from day 1
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??!
Right?? As an introvert, being in meetings for such long lengths at a time would tire me out rather than doing the work LOL
@@Seolhwaneul right?? I hate physical jobs but at least I can work alone. Socializing this much seems exhausting
Lovely! Love your positive energy and vibes, all the best!
A new fan from UK ✌🏻
thank you!
Love your video and the Brazilian music with the coffee time ❤️
you made me so proud I don't even know why! u got a new subs!
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
Thanks for sharing! This will help anyone who is interested in the business analyst position. Have a great day.
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!
I just want to say Thank you for showing your process and how you organize your sheets. Just subscribed!
glad i found your channel, so few BAs to follow on youtube so thank you for making this content
fantastic video and good tips, pls keep showing more business/ data analysis tips
Brazilian music in you daily routine! I loved it. ☺️☺️❤
I'm Brazilian and I loved that you used MPB music in your video 😅💜
i work for the latam region so ofc i gotta do some MPB music hahhaha
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)
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.
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
Hey hi 👋 I too aspiring for that . Can you send me your LinkedIn id?
i love the query tab tip!
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! 😇
Loved the data analysis tips. Thank you!
Day in the life are always fun to watch. I also did one with my internship in the UN.
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! 👩🏻💻
coda VS notion？
top worth buy that boots your productivity when WFH? :D
love that foot bucket, great idea
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.
yayy tech girlies 🥰 ur acai bowl recipe looks so good hehe
it's my first time watching your videos. I am amazed because you have a nice content. 🙂
love life. happy life, free life.
自己是做音樂的看到妳分享Spotify分析其實真的很有趣，而且很喜歡妳影片節奏 ! 加油!
Another great video! Yes! Please create a video about your editing workflow! Thank you🌺
Stumbled upon your channel and subscribed. Great insights and helpful even if I’m not a BA. Well done and thank you.
thank you!
Really appreciated the excel and query explanation! More please!
thank you! more tips to come
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:)
或許.這樣形容誇大了!但~ 你完成了許多人的小小夢.Lillian你好棒.真的~
I wasn´t expecting a brazilian song in this video, it was a good surprise for me (I´m Brazilian)
Ela sempre coloca alguma música brasileira no background ❤
Same. I wasn’t looking all the time so for a second I thought the music was playing on my phone 😂
08:26 cute brazilian bossa nova song (: it matches the açaí bowl (btw you say açaí correctly, which is nice)
Thank you for Sharing Lilian!
Congrats on 100K 😍
The Brazilian song omg I’m obsessed
Love your videos! Was wondering if you would let us know what ur skin care routine is!!
thank you! mostly just drunk elephant and curology and I keep it v simple - will show that in a future video!
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 🇧🇷
love brazilian music~ i work for the latam region , fav artist: Anitta
You inspire me a lot a lottt!!!! wish to meet to you!!
Great video girl!!! Thanks for sharing! Have an awesome day!!!!!!😁👏
an exel queennn 👸 I learned something new today haha
You are so great, aunt.
I love the Brazilian music in the video!
Love how cracking the PM interview is what you consider “light reading” 😅
Great stuff as always!
This video is super Brazilian with the açaí bowl and one of the songs you used 🇧🇷♥️🥰
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!
ohhhh that's such a smart idea - will def try that next time!
Suddenly a Brazillian Song, Jeez, that was awesome
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.
I love this video!
Just accepted an offer as a Jr. BA and was waiting on a sushi order while watching this! Lol! Great video!
Thanks, Lillian share your tips ~I will replicate your tips straight away in my excel assignment today~ ❤
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
The salary my G
@@lofiboy6025 you'd be surprised :)
Tnahks for sharing you exprience. May i know if spotify has an internal data analysis tools like datawarehouse and OLAP tooling and also data mining tools.
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?
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 ❤️
Hi, may I ask where you got your straw and coffee cup?
Nice vlog, dude, I should try that açaí bowl I gotta start eating healthier 😢
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
I love the brazillian song in the video
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
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
I'm a simple guy... I see Final Cut Pro and I upvote 😄
Wow, unexpected the Brazilian music, greetings from Brazil!
I loved the "OST" of the video Menino e Fogo - Clara Mendes ahahahah kisses from Brasil
Hi Lillian, May I know which laptop is your work on? Is Apple Mac enough?
I loved the song in portuguese in the video 💖💖
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
Have a great day
i really enjoyed the brazillian music on this video :)
Hi Lilian, I`m brazilian, i love coffee, tech and data 😉
I like this❤️
She’s both working and chilling
Yes can you share how you edit on Final Cut? Would love to learn
Popular music Brasilians... loved!!! 😃
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
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?
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!
That book that you’re reading doesn’t help you sleep tho lol “PM interview” so intense 😆
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
which program do you use to manage your daily schedule at 2:08?
Can you explain the difference between business analysis and management consulting?
PLEASE SHARE WHAT KIND OF SKILL SETS I WOULD NEED FOR MY COURSE IN business Analysis in UOM.
9:11 a brasilian song ❤❤❤
Love
I loved the brazilian music (ps: i am portuguese, lots of love from Portugal)
aww thank you! i work for the latam region so gotta feature some brazilian music ofc🥹 also lovee Anavitoria and Anitta!!
@@LillianChiu101 uau, i love love love Anitta 🥰
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
wow, 8:28 it's Brazillian music samba
If I read the Cracking the Interview books in my bed like that, I would fall asleep in no time XD
hahah that's lowkey the point too - to fall asleep faster xD
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! :)
hi alexa! happy to hear you're on the BA journey - this video i did may help: ua-cam.com/video/9CGYmmHZq9Q/v-deo.html 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!
@@LillianChiu101 thx for the response, good luck!
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
Love your diet :)
can you link the table you used on the couch lol
好充實