Think like a data analyst in tech | portfolio project
I critically think to problem solve a data analyst project in Tech. As a business intelligence engineer at Amazon, my role is a mix of a business analyst, data engineer (I use ETL – extract, transform, load and data warehouses), and a data analyst. I talk about how to do analytical thinking and what types of tasks can be done using excel, sql, python, and a BI visualization tool. This video goes through a SQL project for a data analyst and is helpful for anyone trying to understand what data analysts do, how to become a data analyst, and analytical data project (portfolio) ideas.
📚 Resources
Excel: https://imp.i384100.net/jr6oAP
SQL (I’ve personally used DataCamp to learn SQL): https://datacamp.pxf.io/zNJ6xW
Get 25% off DataCamp using my link: https://datacamp.pxf.io/xkW3B1
Tableau: https://imp.i384100.net/xkoGb5
Python: https://imp.i384100.net/Gmdz5m
Google Data Analytics Certificate: https://imp.i384100.net/9gqYQy
Interview Query (similar questions to the ones I’ve seen in my interviews): https://shorturl.at/lyLNT
🖥️ My Desk Setup
Keyboard: https://amzn.to/3Sny1fw
Mouse: https://amzn.to/47aYpgM
Cable Management: https://amzn.to/47hQz5b
Dell Dock: https://amzn.to/3tNVahv
🙆🏻♀️ Connect
📫 Newsletter w/ Free Resume Template: https://learn.agathakang.com/resume
📸 Instagram: https://instagram.com/agathaakang
🔗 LinkedIn: https://www.linkedin.com/in/agatha-kang/
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 in tech (FAANG), 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
00:20 – Problem
04:34 – Data
07:28 – Reporting
09:31 – Use cases
09:58 – 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!
