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

Рет қаралды 16,153

Күн бұрын

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/zNJ6xW
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: info@agathakang.com
📄 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!

Пікірлер: 42

@agathakang 5 ай бұрын

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 2 ай бұрын

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 6 ай бұрын

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.

@ricardomayo8337 3 ай бұрын

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

@agathakang 3 ай бұрын

Thank you so much!! ❤️

@nicokelly6453 6 ай бұрын

This was a great overview, thanks for sharing!

@agathakang 6 ай бұрын

Thanks so much! Glad you enjoyed it!

@Madhu._.01 6 ай бұрын

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 6 ай бұрын

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

@EndlessLearner 6 ай бұрын

Great video!

@agathakang 6 ай бұрын

Thanks so much!

@kalMHe 14 күн бұрын

Thank you

@pedrockc 4 ай бұрын

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 3 ай бұрын

No i personally like not havin ppl in the office.

@MHb789 Ай бұрын

@@Bro77248whats your job?

@jadecom6 6 ай бұрын

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 5 ай бұрын

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.

@edwinb4201 14 күн бұрын

Becoming a data analyst PC or Mac? Being Mac user I feel the answer is PC plus my MacBook Ram if 5+ years old.

@johnnyfive1412 6 ай бұрын

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 6 ай бұрын

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

@mdsami4346 2 ай бұрын

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

@mohanreddy007 5 ай бұрын

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

@agathakang 5 ай бұрын

Yes I agree!

@withpikachu2402 6 ай бұрын

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 6 ай бұрын

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

@ribumom9474 4 ай бұрын

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 3 ай бұрын

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 5 ай бұрын

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

@agathakang 5 ай бұрын

Very true, and lots to be grateful for!

@musemohamed2563 6 ай бұрын

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

@agathakang 6 ай бұрын

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 5 ай бұрын

so luck beutiful ,dear share one video for data scientist

@agathakang 3 ай бұрын

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!

@ALANAMUL 6 ай бұрын

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

@agathakang 6 ай бұрын

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 6 ай бұрын

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

@luckykritya941 2 ай бұрын

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 2 ай бұрын

Haha 😆 yes seriously we’re always thinking!