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: imp.i384100.net/jr6oAP
SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/zNJ6xW
Get 25% off DataCamp using my link: datacamp.pxf.io/xkW3B1
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: instagram.com/agathaakang
🔗 LinkedIn: www.linkedin.com/in/agatha-kang/
🎥 TikTok: www.tiktok.com/@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 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