day in the life at spotify working as a business analyst | data analytics tips, strategy meetings
ฝัง
- เผยแพร่เมื่อ 4 ต.ค. 2024
- 📖 my business analytics online course (5000+ students currently!) (pre-recorded online course, watch and enroll anytime!) www.pressplay....
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=2...
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 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
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 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
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 是怎麼分析的！感謝！🙏
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
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
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! ♥️
Your day in the life vlogs are so fun to watch, it makes me wanna pursue analytics! The "more kdrama part" tho! #relate 😆
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 😂
很享受看Lillian的Vlog，能夠透過你的Vlog了解在海外的生活，btw你吃飯時候看起來非常可愛🥰
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. ❤❤
Lovely! Love your positive energy and vibes, all the best!
A new fan from UK ✌🏻
thank you!
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?
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.
Please keep doing videos like these! it is so insightful 😍
08:26 cute brazilian bossa nova song (: it matches the açaí bowl (btw you say açaí correctly, which is nice)
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
@@lofiboyM3P you'd be surprised :)
Thanks for sharing! This will help anyone who is interested in the business analyst position. Have a great day.
Just discovered you and I LOVEEE your tips!! ❤❤
Brazilian music in you daily routine! I loved it. ☺️☺️❤
Love your video and the Brazilian music with the coffee time ❤️
love life. happy life, free life.
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:)
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!
you made me so proud I don't even know why! u got a new subs!
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
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)
Really appreciated the excel and query explanation! More please!
thank you! more tips to come
The Brazilian song omg I’m obsessed
it's my first time watching your videos. I am amazed because you have a nice content. 🙂
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
或許.這樣形容誇大了!但~ 你完成了許多人的小小夢.Lillian你好棒.真的~
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
Suddenly a Brazillian Song, Jeez, that was awesome
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
自己是做音樂的看到妳分享Spotify分析其實真的很有趣，而且很喜歡妳影片節奏 ! 加油!
I just want to say Thank you for showing your process and how you organize your sheets. Just subscribed!
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
I'm a simple guy... I see Final Cut Pro and I upvote 😄
I love the Brazilian music in the video!
glad i found your channel, so few BAs to follow on youtube so thank you for making this content
love that foot bucket, great idea
She’s both working and chilling
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 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
yayy tech girlies 🥰 ur acai bowl recipe looks so good hehe
I loved the "OST" of the video Menino e Fogo - Clara Mendes ahahahah kisses from Brasil
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
Loved the data analysis tips. Thank you!
Nice vlog, dude, I should try that açaí bowl I gotta start eating healthier 😢
i really enjoyed the brazillian music on this video :)
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.
fantastic video and good tips, pls keep showing more business/ data analysis tips
I love this video!
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 the query tab tip!
Day in the life are always fun to watch. I also did one with my internship in the UN.
Just accepted an offer as a Jr. BA and was waiting on a sushi order while watching this! Lol! Great video!
an exel queennn 👸 I learned something new today haha
Love how cracking the PM interview is what you consider “light reading” 😅
Great stuff as always!
Congrats on 100K 😍
Wow, unexpected the Brazilian music, greetings from Brazil!
Hi Lilian, I`m brazilian, i love coffee, tech and data 😉
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!
You inspire me a lot a lottt!!!! wish to meet to you!!
This video is super Brazilian with the açaí bowl and one of the songs you used 🇧🇷♥️🥰
You are so great, aunt.
Thank you for Sharing Lilian!
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
I loved the song in portuguese in the video 💖💖
Another great video! Yes! Please create a video about your editing workflow! Thank you🌺
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?
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 ❤️
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
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! 😇
Have a great day
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
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?
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
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: th-cam.com/video/9CGYmmHZq9Q/w-d-xo.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!
Can you explain the difference between business analysis and management consulting?
wow, 8:28 it's Brazillian music samba
Yes can you share how you edit on Final Cut? Would love to learn
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 🥰
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!
9:11 a brasilian song ❤❤❤
can we have more chinese words in Spotify, so is better to search for a song, just a suggestion as i saw a few listeners were feedbacking on this area. Question aside, can we have what you eat or whip in a week?
Achei que eu seria um dos poucos BR assistindo, mas até a Lillian escuta musica em PT hahaaha
Tava procurando um BR aqui 😂
@@KarineCamposAlexandre ahahahhahah estamos em todos os lugares
I was wondering what are the critical technical skills for you position(sql and what else)?🤓
拿Fellow EKG澆花 😆
我也會拿手沖壺澆花 超好控水，後來就回不去一般的澆花壺了
Great video girl!!! Thanks for sharing! Have an awesome day!!!!!!😁👏
I like this❤️
which program do you use to manage your daily schedule at 2:08?
Love
PLEASE SHARE WHAT KIND OF SKILL SETS I WOULD NEED FOR MY COURSE IN business Analysis in UOM.
Popular music Brasilians... loved!!! 😃
Love your diet :)