Project Tips EVERY Data Analyst Must Know In 2024

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 Visualization tool, and Python.
📚 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
Get certified as a Data Professional with Datacamp - Data Analytics certifications rated #1 by Forbes: datacamp.pxf.io/eKLNXr
🖥️ 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: / agatha-kang
🎥 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
00:23 - What is a project
01:02 - Project Step 1
03:13 - Project Step 2
04:34 - Project Step 3
06:02 - Where to present portfolio
07:30 - Share your project
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
    @agathakang27 күн бұрын

    Thanks so much for watching the video. Feel free to connect with me on instagram: instagram.com/agathaakang/ and through my newsletter: agathakang.com/subscribe (free resume template in link)

  • @gabrielle8571
    @gabrielle857121 күн бұрын

    Incredibly helpful. You're like our data mom. 😂 Thank you! 🎉💐

  • @BigHeadAvenger
    @BigHeadAvenger22 күн бұрын

    Great video. I like your delivery method. Down to earth, no fluff, with actionable steps. Look forward to your channel taking off.

  • @agathakang

    @agathakang

    22 күн бұрын

    Thank you 🙏 I really try to keep it simple and actionable :)

  • @davidlewalski2292
    @davidlewalski229221 күн бұрын

    Wow, what an excellent video. Thank you so much for taking the time to produce it.

  • @markspin4596
    @markspin459614 күн бұрын

    Straight to the point advice. Nice one....

  • @Userm2040
    @Userm204012 күн бұрын

    Great video! Very honest approach! Straightforward! I appreciate you very much!

  • @muneebbolo
    @muneebbolo20 күн бұрын

    Thank you so much Agatha for sharing helpful tips!

  • @jguerr562
    @jguerr56221 күн бұрын

    Your videos are very helpful and informative. Learning a lot.

  • @soheilpalermo491
    @soheilpalermo49122 күн бұрын

    Thanks heaps Agatha. Your work and content absolutely priceless ❤🙏🌿

  • @dianaandrade7229
    @dianaandrade722918 күн бұрын

    Amazing video again Agatha. You are killing it. 🔥🔥🔥

  • @user-nr6mt2hv6z
    @user-nr6mt2hv6z22 күн бұрын

    Thank you Agatha.Portfolio really help me years back…I thought no video this week because you were on vacation lol😂thank again for doing all this research for us

  • @srs8734
    @srs873422 күн бұрын

    Thank you so much for this video I just need this to motivate me

  • @agathakang

    @agathakang

    22 күн бұрын

    You're welcome! You got this!!

  • @Madhu._.01
    @Madhu._.0119 күн бұрын

    love the video, so informative 😍 please make a video on your planning system

  • @minanabil1035
    @minanabil103522 күн бұрын

    great video. thanks.

  • @odunayoemmanuel8522
    @odunayoemmanuel852215 күн бұрын

    Well done thank you

  • @muskaanrathore5999
    @muskaanrathore599921 күн бұрын

    I find your videos really helpful, thankyou for educating us. Can you suggest some good already built projects that we can refer as a fresher to build our own?

  • @newenglandnomad9405
    @newenglandnomad940522 күн бұрын

    Great video. I'm still learning and applying. I was guilty of making pre-school, level visualizations thinking it showed my skills. I like the what topic, what data, what did I learn model. I don't feel I can solve an actual business problem from a kaggle data set. I definitely prefer to share what learned instead. I try to document not only the sql i use, but what issues I ran into like typos and column names that didn't work, or column names with spaces. I felt it was insightful to admit what issues I ran into and what research i did to get around it. Thanks for being supportive, helpful, and guiding out journey. I'm trying to change jobs from remote help desk because it's a dead end job. I struggle with focusing on an industry for data analytics, because if I get hired, I really don't care where it is.

  • @agathakang

    @agathakang

    22 күн бұрын

    The visuals don't have to be fancy but should support the problem you are solving. I'm glad the framework helps! And yes I think as long as you have a project that is practical and you solve it using data, you're fine. Keeping an open mind with the industry is a good idea as it opens up more opportunities to get your foot in the door!

  • @jaqui_Sue24
    @jaqui_Sue2422 күн бұрын

    Hi Agatha, thank you for this helpful video. I'm trying to build my portfolio. I would like to know how yours look like, just wanted to make as guide. Thank you.

  • @painc2241
    @painc224122 күн бұрын

    Thanks agatha❤

  • @krystalbrantley4996
    @krystalbrantley499619 күн бұрын

    Hi Agatha, Thanks for continuing to share helpful information. How would I present/ showcase a Power BI report I created as a portfolio project? I'm not sure how to share work I create with Power BI.

  • @MikeJones-ql3db
    @MikeJones-ql3db21 күн бұрын

    Your skin looks incredible.. That color top with your skin complexion is elite

  • @seanflores3811
    @seanflores381111 күн бұрын

    Hey! What laptop would you recommend for data analytics?

  • @sadiqashraf3988
    @sadiqashraf398822 күн бұрын

    Thanks mama Agatha ☺️ I'm ASHRAF from NIGERIA A newbie in Data analytics I just want to appreciate you and say your videos have been of help 🎉❤

  • @agathakang

    @agathakang

    22 күн бұрын

    Hi Ashraf! Thank you and so glad the videos are helping!! ❤

  • @gellirollz
    @gellirollz11 күн бұрын

    Question did you know what industry you wanted to work in? If so how did you come to the conclusion to the industry that you lived to do or have you worked in many industries so you have a bigger portfolio or a more diverse portfolio?

  • @agusdharmawan4672
    @agusdharmawan467222 күн бұрын

    thanks Agatha. i am agus from indonesia. i love your video. nice to see you 😀🙏

  • @agathakang

    @agathakang

    22 күн бұрын

    Hi agus! thank so much 😃

  • @juniomanuel3081
    @juniomanuel308115 күн бұрын

    Hi, can you pls share the CV template you used in your video ?

  • @saudmir24
    @saudmir2417 күн бұрын

    Mam, any good KZread channel to learn python for data science?

  • @JL-iw5kx
    @JL-iw5kx14 күн бұрын

    Is this only for new people without experience? I've personally never needed this. The company usually gives you a task to solve and present anyway before hiring you.

  • @agathakang

    @agathakang

    14 күн бұрын

    Yes a portfolio is used in place of work experience. If you have work experience then you may not need one. It helps people showcase their data skills to land their first data job.

  • @joce7469
    @joce746921 күн бұрын

    Is there opportunity in data analysis? I just don't want to waste more my time. I have a CS degree struggling to get a job. 😢

  • @Ray00083

    @Ray00083

    16 күн бұрын

    Just start learning, work on standard projects and build a good portfolio. At least six months into learning with good projects and start applying. Also, volunteer and intern for free if possible to gain more experience And you are good, I am not a CS and with no background in tech but now a data analyst

  • @balaroxx2700

    @balaroxx2700

    15 күн бұрын

    bro can u give any suggestions to me aswell

  • @balaroxx2700

    @balaroxx2700

    15 күн бұрын

    ​@@Ray00083i am currently learning power bi can h give me the suggestions which are the main topica i should ne strong 😊

  • @dragusinsilviu4862

    @dragusinsilviu4862

    10 күн бұрын

    @@Ray00083can you share with us your portofolio (if you made it public) and the industry you work in?

  • @user-ti3we7ll9k
    @user-ti3we7ll9k19 күн бұрын

    Are you Mongolian?

  • @user-fi2lr5io7c
    @user-fi2lr5io7c13 күн бұрын

    @Dilrabo_876 . Hallo sister. My name is Dilrabo. I'm from Uzbekistan. Sister . I won the scholarship for studying in the Italy. And I have two choices. I mean, I have Data analysis and Business management. Both of them I have scholarship for studying. But I am struggling to choose. To be honest, I don't have enough knowledge in the field of Mathematics. Can you give me some suggestions to choose. Which is better for me. One day , I am going to back my hometown and live happily together with my lovely profession. I need your help. What is the best for me... Thank you sister....❤