day in the life at spotify working as a business analyst | data analytics tips, strategy meetings
HTML-код
- Опубликовано: 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!
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
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! ♥️
很享受看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 😆
Please keep doing videos like these! it is so insightful 😍
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!
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
想聽Lillian在資料分析實務方面的步驟是怎麼著手（例如：從拿到row data ->google sheet的圖表可能會跑哪些分析、常用的分析方式&公式、怎麼驗證自己的分析正確與否等等），因為也是分析初學者，特別想知道Lillian 是怎麼分析的！感謝！🙏
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!
Just discovered you and I LOVEEE your tips!! ❤❤
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. ❤❤
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!
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
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
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
I just want to say Thank you for showing your process and how you organize your sheets. Just subscribed!
i love the query tab tip!
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?
Loved the data analysis tips. Thank you!
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)
love that foot bucket, great idea
Stumbled upon your channel and subscribed. Great insights and helpful even if I’m not a BA. Well done and thank you.
thank you!
yayy tech girlies 🥰 ur acai bowl recipe looks so good hehe
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.
Thanks for sharing! This will help anyone who is interested in the business analyst position. Have a great day.
或許.這樣形容誇大了!但~ 你完成了許多人的小小夢.Lillian你好棒.真的~
it's my first time watching your videos. I am amazed because you have a nice content. 🙂
Congrats on 100K 😍
自己是做音樂的看到妳分享Spotify分析其實真的很有趣，而且很喜歡妳影片節奏 ! 加油!
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
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:)
Really appreciated the excel and query explanation! More please!
thank you! more tips to come
Brazilian music in you daily routine! I loved it. ☺️☺️❤
I love this video!
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.
Great video girl!!! Thanks for sharing! Have an awesome day!!!!!!😁👏
Thank you for Sharing Lilian!
You inspire me a lot a lottt!!!! wish to meet to you!!
Another great video! Yes! Please create a video about your editing workflow! Thank you🌺
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! 😇
Just accepted an offer as a Jr. BA and was waiting on a sushi order while watching this! Lol! Great video!
08:26 cute brazilian bossa nova song (: it matches the açaí bowl (btw you say açaí correctly, which is nice)
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!
love life. happy life, free life.
an exel queennn 👸 I learned something new today haha
You are so great, aunt.
Day in the life are always fun to watch. I also did one with my internship in the UN.
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 ❤️
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 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
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!
The Brazilian song omg I’m obsessed
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 😂
Nice vlog, dude, I should try that açaí bowl I gotta start eating healthier 😢
Love how cracking the PM interview is what you consider “light reading” 😅
Great stuff as always!
I loved the "OST" of the video Menino e Fogo - Clara Mendes ahahahah kisses from Brasil
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.
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 :)
This video is super Brazilian with the açaí bowl and one of the songs you used 🇧🇷♥️🥰
I like this❤️
Thanks, Lillian share your tips ~I will replicate your tips straight away in my excel assignment today~ ❤
I love the Brazilian music in the video!
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.
I love the brazillian song in the video
Suddenly a Brazillian Song, Jeez, that was awesome
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
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
I'm a simple guy... I see Final Cut Pro and I upvote 😄
Hi, may I ask where you got your straw and coffee cup?
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 really enjoyed the brazillian music on this video :)
She’s both working and chilling
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
哈哈 解锁了fellow手冲壶的新功能😂
Have a great day
Wow, unexpected the Brazilian music, greetings from Brazil!
Yes can you share how you edit on Final Cut? Would love to learn
Hi Lilian, I`m brazilian, i love coffee, tech and data 😉
PLEASE SHARE WHAT KIND OF SKILL SETS I WOULD NEED FOR MY COURSE IN business Analysis in UOM.
Hi Lillian, May I know which laptop is your work on? Is Apple Mac enough?
I loved the song in portuguese in the video 💖💖
Can you explain the difference between business analysis and management consulting?
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
which program do you use to manage your daily schedule at 2:08?
Love
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!
Popular music Brasilians... loved!!! 😃
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
Love your diet :)
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
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: ruclips.net/video/9CGYmmHZq9Q/видео.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!
at first you were Jennie of Blinks! Pretty! Just subscribed! More power Dear.
can you link the table you used on the couch lol
I was wondering what are the critical technical skills for you position(sql and what else)?🤓
拿Fellow EKG澆花 😆
我也會拿手沖壺澆花 超好控水，後來就回不去一般的澆花壺了
9:11 a brasilian song ❤❤❤