Day in the life of a data analyst (in office)

Day in the life of a business intelligence engineer at Amazon. Currently my role is very similar to a mix of a business analyst, data engineer (I use ETL - extract, transform, load and data warehouse), and a data analyst. I talk about the pros and harsh reality of being a data analyst, what a data analyst does, and what types of tasks they do using microsoft excel, sql, python, bi visualization.
📚 Resources
Excel: imp.i384100.net/jr6oAP
SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/PynDkY
Tableau: imp.i384100.net/xkoGb5
Python: imp.i384100.net/Gmdz5m
Google Data Analytics Certificate: imp.i384100.net/9gqYQy
Interview Query (similar questions to the ones I’ve seen in my interviews): shorturl.at/lyLNT
🖥️ My Desk Setup
Keyboard: amzn.to/3Sny1fw
Mouse: amzn.to/47aYpgM
Cable Management: amzn.to/47hQz5b
Dell Dock: amzn.to/3tNVahv
🙆🏻‍♀️ Connect
📫 Newsletter w/ Free Resume Template: agathakang.com/subscribe
📸 Instagram: / agathaakang
🎥 TikTok: / agathaakang
Business inquiries: [e-mail]
📄 ABOUT ME:
My mission is to help you grow your career, especially in the world of data analysis. Switching careers to become a data analyst from a non-tech background was overwhelming. I made a lot of mistakes and wasted time trying to figure it out. But having been a manager of data analytics and now a senior business intelligence engineer at Amazon, I've learned a lot and I'm excited to use my experiences to help you navigate your career path. I hope this channel gives you the clarity and motivation to get started!
⌚️Timestamps
00:00 - Intro
01:01 - What Do I Do?
01:39 - Sprint Meeting
02:38 - What Is A Business Intelligence Engineer?
03:13 - Engineer Meeting
04:28 - Pros of Data Analyst
05:32 - Cons of Data Analyst
07:15 - Outro
Content is for educational and entertainment purposes only. Some links are affiliate links that support the channel at no cost to you. As an Amazon Associate I earn from qualifying purchases. Thanks for your support!

[@agathakang]

Thanks so much for the thoughtful comments! Feel free to connect with me on 📷instagram: instagram.com/agathaakang/ and through my 📬newsletter: agathakang.com/subscribe (free resume template in link)

[@vaishnaveegothandaraman6700]

Just finished watching all your videos. All your tips are so useful and It's also helping me a lot as I am looking for an entry-level data analyst job. Can you make a video on how to create a portfolio and also a video on a hands-on project using Excel, SQL, and Tableau? Thank you for your effort, Appreciate that.

[@agathakang]

What do you think about the pros and cons of being a data analyst? I hope this video gives a realistic view of what it's like to be a data analyst.

[@nicokelly6453]

This was a great overview, thanks for sharing!

[@agathakang]

Thanks so much! Glad you enjoyed it!

[@ricardomayo8337]

Kudos to you. I was wondering where this was! Youre doing an Awesome job!

[@agathakang]

Thank you so much!! ❤️

[@Madhu._.01]

Love your videos . Please share about how u stay productive and how you tackle distractions. I have been doing a data analyst course btw and loving it 💜

[@agathakang]

That's great! I too took a data course which helped me transition my career too. I will be releasing a video on this, this week so stay tuned!

[@MHb789]

Hi ,loving your videos..Dont you have to give presentations to your team in the office?

[@frankiedee3122]

I like your video. I’m currently working on my bachelor degree in health services management, minor in data science. Also undergraduate certificate in health information management & data analytics. I will also take my CHDA certification to be a certified health data analyst. At my organization, there’s a vacant business data analyst position so I’m hoping to grab that position

[@pedrockc]

The office seems so empty! Is it always like that? I personally hate this kind of days I find it somewhat depressing to not having ppl around the office

[@Bro77248]

No i personally like not havin ppl in the office.

[@MHb789]

@@Bro77248whats your job?

[@EndlessLearner]

Great video!

[@agathakang]

Thanks so much!

[@jadecom6]

This was recommended to me by the algorithm. I am interested in BI but not sure of the diff between BI, DA and DE. I have a background in backend dev, and various vendor apps.

[@agathakang]

Honestly there's a lot of overlap between BI, DA, and DE and it varies a lot by company. As a BI Engineer, I would say that I do almost all 3 roles lol but the biggest difference would be a BI works much closer to the business than a traditional DA and DE would. It sounds like with a dev background a DE could be a good fit for you but if you enjoy working on business problems a BI is a good mix of the 2 as well.

[@johnnyfive1412]

No alerting when data jobs fails? I no longer deal with on call duty, but have had my share of figuring out if a restart fixes the issue or if there was a change in data structure that I did not expect.

[@agathakang]

The joys of on call haha luckily I was not on call during this video and it didn't alert me directly

[@mohanreddy007]

Power BI and Sql is enough to start carrier as a data analyst

[@agathakang]

Yes I agree!

[@ribumom9474]

Hi Agatha, Your video is really helpful,, I have a query: Am I eligible to become a data analyst being an ARTs student(GEOGRAPHY Hons.) in 2024? I have learned SQL, Power BI, Python, and Excel. please reply thanks.

[@agathakang]

Hey! I'm so glad the video is helpful. Yes I have a video on this next week talking about different paths to becoming a data analyst. As long as you have the skills and can show your data analyst experience (projects, work, volunteer) then your degree doesn't matter as much. You can even look into industries where you can leverage your data and ART background for data roles.

[@ustherein]

A cute little office job, a 9 to 5 never hurt nobody

[@agathakang]

Very true, and lots to be grateful for!

[@withpikachu2402]

Can you take work laptop home? No worry about data loss? I could only work during work hours while my screen being monitored. In finance.

[@agathakang]

All our work is stored in the cloud so i don't have to worry so much about data loss and can take my work home to finish up

[@mdsami4346]

My dream is. One day I am job in data analytics

[@musemohamed2563]

Thank you Agatha, what skills are mostly used in data analyst job in our role

[@agathakang]

The technical skills mostly used are SQL, Excel, and a BI Visualization tool. As for soft skills, data analysts use communication and problem solving skills heavily.

[@user-cl3bc5qd3b]

so luck beutiful ,dear share one video for data scientist

[@agathakang]

Thanks so much! I don't have much of a background in data science to do a day in the life 😅 but thanks for the comment!

[@luckykritya941]

Being a BI engineer myself I can totally relate to the part where you keep thinking about a solution to solve a problem at work even in bed. 😅 That happens so often.

[@agathakang]

Haha 😆 yes seriously we’re always thinking!

[@ALANAMUL]

If not confidential can share some of your project and make video on that?

[@agathakang]

All of my projects are confidential as they are for the companies but I am working on a separate project video for you guys to give some ideas!

[@ALANAMUL]

@@agathakang thanks.Hope we will get video soon.

[@2Wiix]

kids?

[@agathakang]

No kids yet!