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: [ Ссылка ]
SQL (I've personally used DataCamp to learn SQL): [ Ссылка ]
Get 25% off DataCamp using my link: [ Ссылка ]
Tableau: [ Ссылка ]
Python: [ Ссылка ]
Google Data Analytics Certificate: [ Ссылка ]
Interview Query (similar questions to the ones I’ve seen in my interviews): [ Ссылка ]
🖥️ My Desk Setup
Keyboard: [ Ссылка ]
Mouse: [ Ссылка ]
Cable Management: [ Ссылка ]
Dell Dock: [ Ссылка ]
🙆🏻♀️ Connect
📫 Newsletter w/ Free Resume Template: [ Ссылка ]
📸 Instagram: [ Ссылка ]
🔗 LinkedIn: [ Ссылка ]
🎥 TikTok: [ Ссылка ]
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!
![](https://s2.save4k.ru/pic/QHYUUBawrnc/maxresdefault.jpg)