Agatha
Agatha
  • 46
  • 1 000 769
My honest advice for someone who wants to become a data analyst
Get certified as a Data Professional with Datacamp - Data Analytics certifications rated #1 by Forbes datacamp.pxf.io/4P43Nr
Data analyst roadmap with steps on how to become a data analyst and land a job. Many of you guys reach out me asking for tips on how to transition and change your career to a data role. So I decided to make a video with all of my top tips on how to become a data analyst. The points I make in this video are actionable and will help you stand out as you study data analysis, learn technical skills, and interview for data jobs.
📚 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
🔗 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 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
00:39 - tip 1
02:13 - tip 2
03:53 - tip 3
04:27 - tip 3 - test yourself
05:38 - tip 3 - projects
06:24 - tip 4
07:37 - tip 5
08:32 - 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!
Переглядів: 5 322

Відео

Realistic day in the life of a data analyst | why I left healthcare, job, tech
Переглядів 4,2 тис.День тому
🚀 Take control of your schedule and boost your productivity with time-blocking! Try Akiflow today: bit.ly/akiflowagatha 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 warehouse), and a data analyst. In this video, I talk about what my role is, who I support in the organization, what types of dat...
How I Became a Data Analyst & Got a Job! (No CS Degree)
Переглядів 33 тис.21 день тому
Data analytics course (free trial) for you to become a data analyst: bit.ly/free-data-tutorial Book a call to apply for the scholarship and learn more about the program: bit.ly/careerfoundry-changemaker-scholarship Check out CareerFoundry's Data Analytics program overview and curriculum: bit.ly/data-analytics-program-info Data roadmap I used to learn data analysis and become a healthcare data a...
EXPOSING how much I made as a remote data analyst
Переглядів 4 тис.Місяць тому
Get certified as a Data Professional with Datacamp - Data Analytics certifications rated #1 by Forbes datacamp.pxf.io/eKLNXr What is the data analyst salary? Data analytics is always listed as a top career but what is a realistic expectation of how much you can make from a data job? This video covers all factors that impact a data analyst salary and how much I made in my first job as a healthca...
Project Tips EVERY Data Analyst Must Know In 2024
Переглядів 11 тис.Місяць тому
A data analytics portfolio of projects is one of the best ways to get hired for a data analyst job. Projects also can be used to interview for jobs in place of work experience. But what is a project and portfolio and why do you need one? I talk about the steps to create a data analyst project including actionable tips and the technical skills needed for projects which include SQL, Excel, a BI V...
How to self-study technical things fast
Переглядів 5 тис.Місяць тому
How to learn technical skills fast and get a tech job. As a business intelligence engineer at Amazon, I am constantly learning new technical skills including cloud technology, data analysis, and AI. I talk about how I learn technical things fast and the tips that have worked for me to land my job in tech. 📚 Resources Excel: imp.i384100.net/jr6oAP SQL (I've personally used DataCamp to learn SQL)...
Top 5 Highest Paying Tech Jobs Without Coding (salaries revealed)
Переглядів 5 тис.Місяць тому
What is the salary of tech jobs that don't require any coding? Software engineers and data analytics is always listed as a top career but what other jobs in tech have the highest salary and what do they do? From UX designers to product managers, this video covers the jobs, salaries, and skills required to become one. 📚 Resources Excel: imp.i384100.net/jr6oAP SQL (I've personally used DataCamp t...
How long should you stay at your job? | Why I Quit
Переглядів 5 тис.2 місяці тому
I quit my consulting job after learning 5 lessons that made me realize the salary wasn't worth the job. This was my first job out of school and I really thought getting a good job was everything. This experience made me realize that I no longer wanted to be a consultant and pushed me to pursue a career change which is what started my data analyst career. Watch this video for signs of when it's ...
Business Analyst or Data Analyst? | Salary, Job, Skills
Переглядів 9 тис.2 місяці тому
What is a business analyst? Should you become a business analyst or a data analyst? By discussing the the jobs, responsibilities, salaries, and similar roles like a business intelligence analyst and a business intelligence engineer, I help you decide what role is best for you. 📚 Resources Excel: imp.i384100.net/jr6oAP SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/zNJ6xW Tabl...
*brutally* honest career Q&A | how to become a data analyst, certification, job
Переглядів 6 тис.2 місяці тому
What is the day in the life of a data analyst including the career path. I talk about my data analytics experience as well as the skills and tips on how to get a data analyst job. This video includes the skills and roadmap required to learn data analysis including (Excel, SQL, BI Visualization, Python, Statistics) and what you can do to become a data analyst. 📚 Resources Excel: imp.i384100.net/...
Top 5 Highest Paying Data Jobs (Salaries Revealed)
Переглядів 9 тис.3 місяці тому
What is the Data science and analytics job description? Data analytics is always listed as a top career but what jobs in data have the highest salary and what do they do? From data engineers to machine learning (AI) engineers, this video covers the data jobs, salaries, and skills required to become one. 📚 Resources Excel: imp.i384100.net/jr6oAP SQL (I've personally used DataCamp to learn SQL): ...
How I have time for everything with a full time job
Переглядів 4,1 тис.3 місяці тому
Productivity tips and how to self-study while working to achieve your goals. These 5 changes have increased my productivity so that I can maximize my time outside of work. As a business intelligence engineer at Amazon and part-time UA-camr, it's been challenging to managing my work and personal life. Today I discuss the simple tips that have worked for me that you can apply them to your own lif...
How To Answer Data Analyst Interview Questions to Get a Job
Переглядів 2,8 тис.3 місяці тому
To become a data analyst, you have to pass the data analyst interview questions. This video talks about using the CARL and STAR framework to talk about portfolio projects and work experience to answer interview questions. I also link my video to answer SQL interview questions and talk about the most common interview mistake when interviewing for data analyst jobs. 📚 Resources Excel: imp.i384100...
What I wish I knew before becoming a data analyst | salary, job, reality
Переглядів 28 тис.3 місяці тому
What I wish I knew before becoming a data analyst | salary, job, reality
Data Analyst Interview Questions | SQL questions and answers to get a job
Переглядів 4,8 тис.4 місяці тому
Data Analyst Interview Questions | SQL questions and answers to get a job
5 habits that made me become a data analyst
Переглядів 7 тис.4 місяці тому
5 habits that made me become a data analyst
Why it feels IMPOSSIBLE to get a data analyst job | AI, career, tech
Переглядів 50 тис.4 місяці тому
Why it feels IMPOSSIBLE to get a data analyst job | AI, career, tech
Remote data analyst desk setup (work from home)
Переглядів 8 тис.4 місяці тому
Remote data analyst desk setup (work from home)
the *harsh* reality of being a data analyst | career, job, interview
Переглядів 10 тис.5 місяців тому
the *harsh* reality of being a data analyst | career, job, interview
Think like a data analyst in tech | portfolio project
Переглядів 12 тис.5 місяців тому
Think like a data analyst in tech | portfolio project
What I *actually* do as a data analyst | salary, job, harsh reality
Переглядів 127 тис.5 місяців тому
What I *actually* do as a data analyst | salary, job, harsh reality
How I'd become a data analyst (if i had to start over) in 2024
Переглядів 316 тис.5 місяців тому
How I'd become a data analyst (if i had to start over) in 2024
I analyzed data for 4 hours everyday and it changed my life
Переглядів 9 тис.5 місяців тому
I analyzed data for 4 hours everyday and it changed my life
How To Write a Data Analyst Resume To Get A Job
Переглядів 26 тис.6 місяців тому
How To Write a Data Analyst Resume To Get A Job
How To Get Ahead of 99% of Data Analysts (Starting Now)
Переглядів 10 тис.6 місяців тому
How To Get Ahead of 99% of Data Analysts (Starting Now)
Day in the life of a data analyst (in office)
Переглядів 16 тис.6 місяців тому
Day in the life of a data analyst (in office)
Is data analyst a good career in 2024? | salary, AI, day in the life
Переглядів 16 тис.6 місяців тому
Is data analyst a good career in 2024? | salary, AI, day in the life
How I Changed Careers (my data analyst journey)
Переглядів 6 тис.7 місяців тому
How I Changed Careers (my data analyst journey)
day in the life of a data analyst | remote
Переглядів 4 тис.7 місяців тому
day in the life of a data analyst | remote
How to get a data analyst job with no experience (data analyst roadmap)
Переглядів 31 тис.7 місяців тому
How to get a data analyst job with no experience (data analyst roadmap)

КОМЕНТАРІ

  • @TheBlueHutch
    @TheBlueHutch 6 годин тому

    Good, but unrealistic to work with a manager on your current job, depending. Some are suspicious of you leaving the company. So that part not feasible for some folks.

  • @aaravbamba
    @aaravbamba 6 годин тому

    I’m an aspiring data analyst currently learning skills and this video was incredible! You have cleared up all my doubts about the work a data analyst does 😊

  • @ivanvinicios8509
    @ivanvinicios8509 День тому

    Amazing tips!! Thank you very much for the video, it helped a lot.

  • @tinatwine137
    @tinatwine137 День тому

    This video was so detailed and descriptive. I really enjoyed how you implemented the critical thinking skills on how to approach the dataset. And, the process of communicating with stakeholders, program manager, etc. Thank you so much for doing this video!!!

  • @Ajaytshaju
    @Ajaytshaju День тому

    Automate Data Solutions... what does this mean?

  • @mcctalks
    @mcctalks 2 дні тому

    Thanks for sharing, request ways how to talks stakeholder and clients. What questions need to asks

    • @AnalyticsRefresher
      @AnalyticsRefresher День тому

      Always try to understand the business needs. What are they trying to accomplish? Why are they analyzing the data? And always get continuous feedback on your work so you don’t waste your time working on something that they don’t need.

  • @mauricecioccato9818
    @mauricecioccato9818 2 дні тому

    thanks for the video, Is Python needed?

  • @jimh7628
    @jimh7628 3 дні тому

    This video was very helpful. Thank you, Agatha

    • @agathakang
      @agathakang 2 дні тому

      You’re welcome! I’m glad you found the video helpful

  • @uservnjcxxbo6544ghjgff
    @uservnjcxxbo6544ghjgff 3 дні тому

    Can a data analyst work remotely? Thanks

    • @agathakang
      @agathakang 2 дні тому

      Yes! My first data analyst role was remote

  • @Sandy-os2tx
    @Sandy-os2tx 3 дні тому

    Thank you for creating this video. It was informative and engaging, and I appreciate the effort you put into making it. Keep up the great work! And i don't have any work experience either i am a total fresher.. is there anything can i add to the resume instead of work experience??

  • @pejpm
    @pejpm 3 дні тому

    “Going into the office has been challenging” 😂

  • @skymore2948
    @skymore2948 3 дні тому

    can coffee drinkers opening the new block of focusing in good jab?

  • @taiwoadewumi7900
    @taiwoadewumi7900 3 дні тому

    Can softskills be taught to data professionals?

    • @agathakang
      @agathakang 2 дні тому

      Yes soft skills can definitely be learned through practice. It comes with experience as you use them more

  • @cjwsk12
    @cjwsk12 3 дні тому

    Amazing!! What I find most helpful is when you provide advice to those who are a complete beginner and when you provide resources like DATACAMP and direct LINKS. I don't see many youtubers do this where they provide direct resources so it feels like I'm thrown into the Ocean after learning how to swim on UA-cam. Please keep it up Agatha!!!

  • @jennykkk
    @jennykkk 3 дні тому

    Hi Agatha, I am actually currently self-learning SQL, PowerBI and Python thru Datacamp yay! Anyway, now I wish to start my own project, so I found some datasets I can use, but I have no SQL or PowerBI installed in my laptop (my current work company laptop).. Is there a way I can do up a project without installing the programs? 🥲

    • @astroemi
      @astroemi 2 дні тому

      have you tried using Google's Big Query for SQL?

    • @AnalyticsRefresher
      @AnalyticsRefresher День тому

      Hello there, to get started off, you can do analysis on excel if you don’t have SQL or Power BI. Excel is a very powerful tool that most people overlook. Try to import your data into excel, clean it up, run some analysis on it and create dashboards. Data analytics is as much an art as it is a science. Mastering the art of storytelling with excel will help you when you learn other tools like SQL and PowerBI.

    • @jennykkk
      @jennykkk День тому

      @@AnalyticsRefresher oh wow that is such a great idea! Thank you!!!

    • @AnalyticsRefresher
      @AnalyticsRefresher День тому

      @@jennykkk glad I could help. Looking forward to hearing back on your journey. Please check out our channel for byte sized analytics videos. We help beginners test their knowledge in SQL, and other analytics tools and techniques. Hoping to bring more content in the coming days to act as a one stop for those preparing for the interviews! Hoping for your support to bring this to more people and to help them in their journey.

  • @analyticsol9
    @analyticsol9 3 дні тому

    I have a company it's based on data analytics. The company is called biblical analytics inc. we contract work through our patreon site. It's not who you know it's how you work what you know 😊

  • @NameMe-y4w
    @NameMe-y4w 3 дні тому

    Can I stay relevant in the field of data for long term, only by learning Power BI. Can you suggest the role which only require BI as a tool

  • @nataliavieira9946
    @nataliavieira9946 3 дні тому

    Great tips, as usual. Thanks Agatha!

  • @manuelallensucaldito8580
    @manuelallensucaldito8580 4 дні тому

    Can we have the copy of the Design Document that you are using? Thank you so much, Agatha!

  • @Hotdads1
    @Hotdads1 4 дні тому

    Soft skills are so important. Being able to communicate your finding effectively is probably the most important part of the job!

  • @TheNguyenben85
    @TheNguyenben85 4 дні тому

    The code academy is a great place😊

  • @Adrianah28
    @Adrianah28 4 дні тому

    Thank you Agatha! The info you shared are really useful 😊

    • @agathakang
      @agathakang 2 дні тому

      So glad the video was helpful!!

  • @kawaiihikari0
    @kawaiihikari0 4 дні тому

    Rewatching this… I’m so confused about all these data roles titles don’t mean much on a job post so I have to read job description like you mentioned

  • @Mhizdammy
    @Mhizdammy 4 дні тому

    This video really helped me see how far I have come. Thank you so much for sharing✨

    • @agathakang
      @agathakang 2 дні тому

      You're so welcome! ❤️

  • @thaobui9357
    @thaobui9357 4 дні тому

    Thanks for this video. Can you share more about how to create portfolio to show projects in your next videos?

  • @kawaiihikari0
    @kawaiihikari0 4 дні тому

    Amazing! This was a good video I like the tips. I’ll keep these in mind. So far learning has been good. Sometimes frustrating 😂 but I’m trying to keep my eyes on the end of the road after obtaining these skills to apply them to real world job.

  • @user-nr6mt2hv6z
    @user-nr6mt2hv6z 4 дні тому

    Thank you always looking forward

  • @amanbhattarai3273
    @amanbhattarai3273 4 дні тому

    Agatha is it normal that even in sql easy join question stuck for hours to understand ?

    • @agathakang
      @agathakang 4 дні тому

      Yes there's things about sql that can be tricky. Don't feel discouraged that some parts take longer to understand!

  • @kumkumchakraborty2892
    @kumkumchakraborty2892 4 дні тому

    Hi Agatha your video always helpful..

  • @damoncdai5230
    @damoncdai5230 4 дні тому

    thank you for sharing your valuable experience. it definitely helps me better understand the daily affair of a data analyst.

    • @agathakang
      @agathakang 2 дні тому

      You’re welcome! I’m glad the video helped!

  • @coda_7976
    @coda_7976 5 днів тому

    I just remember this statement to keep track of the big 3 keywords: "SELECT data, FROM table, WHERE condition is true"

  • @vivimaslachaprimananda4828
    @vivimaslachaprimananda4828 6 днів тому

    I truly appreciated your video. The way you teach the audience is incredibly clear. You explain complex topics in a way that's easy to understand, and the language you use is straightforward and engaging.

  • @kawaiihikari0
    @kawaiihikari0 6 днів тому

    very useful making a whole google doc organized by your videos with urls and linking pages together lolzzz

    • @agathakang
      @agathakang 2 дні тому

      Haha that’s a great way to organize the videos!! I’m glad my content is helping!

  • @kawaiihikari0
    @kawaiihikari0 6 днів тому

    wow you are so knowledgeable omg im binge watching videos of yours such value img etting literally bookmarking everything

  • @kawaiihikari0
    @kawaiihikari0 6 днів тому

    wow this was an amazing video i was glued to the screen thank you wow...

  • @agathakang
    @agathakang 7 днів тому

    Get certified as a Data Professional with Datacamp - Data Analytics certifications rated #1 by Forbes datacamp.pxf.io/4P43Nr

  • @user-qz9il4ne1o
    @user-qz9il4ne1o 7 днів тому

    😅😅

  • @LifeofMonay
    @LifeofMonay 7 днів тому

    Do you not need a license to become an analyst? Sorry I’m new to this field. Must be a crazy question

    • @agathakang
      @agathakang 2 дні тому

      Hey not a crazy q! You don’t need a license. Just need to learn the skills and depending on the role they may require some different experiences but not a license

    • @LifeofMonay
      @LifeofMonay 2 дні тому

      @@agathakang thank you! I’m not sure if I should go back to school to get hired. Or something. But I’m glad to know there’s other routes!

  • @moonymoomoo5570
    @moonymoomoo5570 7 днів тому

    Okay, the walking back caught me off guard 😆 Anyway, love your videos!

    • @agathakang
      @agathakang 7 днів тому

      haha 😆 thanks for the love!!

  • @chefpengu6597
    @chefpengu6597 7 днів тому

    that's gotta be the best work environment to go

  • @kawaiihikari0
    @kawaiihikari0 7 днів тому

    I just found your UA-cam channel today and watched a few videos. I really like how you present the realistic side of data analysis. I’m 22, coming from an IT role, and I’m currently learning SQL from beginner to advanced level (I already know some basics). I’m also learning advanced Excel, Tableau, and Power BI, plus SQLite and Postgres, with the goal of starting to apply for data analyst jobs within the next few months, maybe sooner. I love what you do so thank you haha :)) you really inspire people whether you realize it or not

    • @agathakang
      @agathakang 6 днів тому

      Hey that's exciting! You're already taking the right steps to transition your career to a data analyst. And it means a lot that my content helps!! Thank you for the thoughtful comment and I'm excited for your data journey. Keep going! :)

    • @kawaiihikari0
      @kawaiihikari0 6 днів тому

      @@agathakang Thank you i will keep going! cant wait to see more content from you :))

  • @fionar6506
    @fionar6506 8 днів тому

    Do I need to know any management/business knowledge in making decisions? What if you were never in management/business knwoledge?

  • @fionar6506
    @fionar6506 8 днів тому

    How hard is it to decide, and what if you mess up?

  • @stldweller
    @stldweller 8 днів тому

    Your teeth are so pretty.

  • @mohamedsror6278
    @mohamedsror6278 10 днів тому

    thank you but i do not know where the resume

  • @naps_
    @naps_ 10 днів тому

    Where did you apply tho??? No matter where i apply all the sites bring me to scam pages

  • @danicaalota8094
    @danicaalota8094 10 днів тому

    Can i become a data analyst, I'm 19 btw and 1st year in college

  • @darshsaini988
    @darshsaini988 10 днів тому

    Hi I love your vids I’m in my senior year of high school and I want to be a data scientist so is a data science major good in college ?

  • @unyimeabasiibangalee6556
    @unyimeabasiibangalee6556 11 днів тому

    Good evening madam

  • @amanbhattarai3273
    @amanbhattarai3273 11 днів тому

    How much time it can take on an average to be good at sql at intermediate level. Tips while learning sql

    • @agathakang
      @agathakang 11 днів тому

      Learning the basic SQL syntax will take you 1-2 weeks but you'll want to practice and apply it to reinforce your learning. My tip would be to use sql hands-on like projects to really learn it.