How I Became a Data Analyst Without Experience

In this video, I show you how I landed a job as a Data Analyst without having experience or even a degree.
I'll also share some tips along the way AND even a strategy that no one talks about to break into data analytics.
Pssst... and what's not mentioned is how important building the RIGHT habits affected my journey. Learn how to build them like I did: amzn.to/3WWhIbE
🔗 LINKS MENTIONED:
Excel: bit.ly/3TuCQ5t
SQL: bit.ly/3PwtPru
Tableau: bit.ly/4aoOTsc
30% OFF Maven Analytics Annual Subscription: bit.ly/Maven30
Get your BONUS by signing up for my newsletter and get it in your inbox right away: ianklosowicz.substack.com/
MY SOCIALS:
📰 Newsletter - ianklosowicz.substack.com/
👨‍💻 Linkedin - / ian-klosowicz
💬 Discord - / discord
WHO AM I?
If we haven’t yet before - Hey 👋 I’m Ian, a self-taught Data Analyst and I have been helping thousands of people break into a career in data. Through my videos here on my channel, my newsletter, and LinkedIn, I share how you can become a Data Analyst and also be a more productive Analyst in a wide range of tools.
⌚️Timestamps:
0:00 - Intro
0:20 - About me / Background
1:04 - Tools / Courses
1:32 - Resume
2:11 - Portfolio
4:58 - Applying Strategy
6:55 - BONUS
PS: Some of the links in this description are affiliate links that I get a kickback from 😜

Пікірлер: 95

  • @alexanderschafer1461
    @alexanderschafer1461Ай бұрын

    Rare youtube find of non-annoying channel that explains something to you in detail without shoving a sponsorship or paid course down your throat 👍

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    Thanks man!

  • @khilafat9468

    @khilafat9468

    13 күн бұрын

    ​@@IanKlosowicz Ian where I found your resume template plzz tell

  • @loriwidel7636
    @loriwidel7636Ай бұрын

    Clear and concise! Thanks, Ian!

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    And thank you for watching! :D

  • @mimie537
    @mimie53728 күн бұрын

    Very good video, detailed and straight to the point! Thanks!!

  • @IanKlosowicz

    @IanKlosowicz

    28 күн бұрын

    Thanks for watching!

  • @bengill1980
    @bengill1980Ай бұрын

    Thanks Ian for real insights and helpful resources.

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    Thanks for the continued support!

  • @alejocercato740
    @alejocercato740Ай бұрын

    Very good video! Good luck with the new channel 🎉

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    I really appreciate it friend!

  • @fidesarellano5835
    @fidesarellano583514 күн бұрын

    I appreciate this content, concise, informative and helpful.

  • @IanKlosowicz

    @IanKlosowicz

    14 күн бұрын

    Glad it helped! Can't wait to share more

  • @gsilagan7117
    @gsilagan711710 күн бұрын

    Ian, thank you for this very clear and helpful video! Liked and Subscribed! Have a good weekend!

  • @IanKlosowicz

    @IanKlosowicz

    9 күн бұрын

    Thanks! I really appreciate it! Glad you enjoyed it and there will definitely be more to come

  • @theoni4026
    @theoni402614 күн бұрын

    I'm only a few days into a certification course but I'm having tons of fun learning so far. This video gives me a clearer idea of where I should expect to be when I start my job hunt.

  • @IanKlosowicz

    @IanKlosowicz

    14 күн бұрын

    Stay focused friend. You'll get there quicker that way

  • @phiosopher8712
    @phiosopher871215 күн бұрын

    This was surprisingly good!

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    Glad you enjoyed it!

  • @brindhaganesan3580
    @brindhaganesan3580Ай бұрын

    Good luck with your new adventure, I have been following your videos. Could you talk about Data Analyst and Business Intelligence Analyst role and how they are different?

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    Adding that to the list right now! Thanks for the suggestion and thank you so much for the support.

  • @armansidd4785
    @armansidd4785Ай бұрын

    Great video!

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    Glad you enjoyed it

  • @taha5754
    @taha57546 күн бұрын

    Hi Ian, informative content! I think if you could share the portfolio projects that you did for these tools and where to find those datasets will be helpful for many looking to build credible industry level projects😊

  • @uavtechgirl5735
    @uavtechgirl573511 күн бұрын

    I don’t normally comment on videos! I will tell you this has been the most informative concrete and concise video about how to become a data analyst that I’ve ever seen! Thank you so much for your insight and willing to share your knowledge. Kudos to you. 🎉❤❤❤❤

  • @IanKlosowicz

    @IanKlosowicz

    11 күн бұрын

    Wow thank you so much! More to come!

  • @kekemokwena1046
    @kekemokwena104627 күн бұрын

    Love this video

  • @IanKlosowicz

    @IanKlosowicz

    27 күн бұрын

    Thanks! More to come!

  • @ssrk369
    @ssrk36912 күн бұрын

    Inspiring 👏✨

  • @IanKlosowicz

    @IanKlosowicz

    12 күн бұрын

    Glad you enjoyed it!

  • @jonaswetzel9213
    @jonaswetzel921312 күн бұрын

    Great video 👍

  • @IanKlosowicz

    @IanKlosowicz

    12 күн бұрын

    Glad you enjoyed it

  • @labcdel4384
    @labcdel43845 күн бұрын

    Trying to do the same, earned a Sub. Thank you Ian.

  • @la4692
    @la469227 күн бұрын

    Great video! I loved the way you discussed how to make a good portfolio. Anyways, can I have your resume template? I find it neat and concise. Thank you!

  • @IanKlosowicz

    @IanKlosowicz

    27 күн бұрын

    Yea add me on LinkedIn. Happy to share

  • @Sunflower_729
    @Sunflower_7299 күн бұрын

    thank you sir

  • @IanKlosowicz

    @IanKlosowicz

    9 күн бұрын

    Most welcome

  • @i_h.m.a.Rahman
    @i_h.m.a.Rahman10 күн бұрын

    great video

  • @IanKlosowicz

    @IanKlosowicz

    9 күн бұрын

    Glad you enjoyed it

  • @BYim-zc6fn
    @BYim-zc6fn18 күн бұрын

    Thanks for your inspiring video. May I know what kinds of Excel project do you recommend? Where can you find those datasets?

  • @IanKlosowicz

    @IanKlosowicz

    16 күн бұрын

    Well you can take any dataset and create a dashboard within excel if you'd like! I normally just use it to clean data or manipulate it a bit before I import it into a BI tool

  • @frederickjabagat6765
    @frederickjabagat676520 күн бұрын

    Hi where can i use a similar resume template,it looks really neat! great video btw

  • @IanKlosowicz

    @IanKlosowicz

    19 күн бұрын

    Hey! I used a website called enhancv

  • @JasonIz-kb7zf
    @JasonIz-kb7zf12 күн бұрын

    Hi great video, thanks for sharing! Any chance, you could check on the newsletter Link? It seems like it shows error when i sign up.

  • @IanKlosowicz

    @IanKlosowicz

    12 күн бұрын

    I'll check it out now. Here is the link just in case ianklosowicz.substack.com/

  • @T_Da_Law
    @T_Da_Law10 күн бұрын

    I’m currently a project administrator in construction with a BBA and looking to transitioning into an analyst position in Fintech. You have provided the best insight for someone without experience to show. Thank you so much!!

  • @IanKlosowicz

    @IanKlosowicz

    10 күн бұрын

    Good luck friend! You probably have more skills than I did when I transitioned so just focus on applying all you can

  • @DevangsRana
    @DevangsRana10 күн бұрын

    Thanks for giving such a real information, I want to become DA, In future I need your help, will you....

  • @IanKlosowicz

    @IanKlosowicz

    10 күн бұрын

    Add me on linkedin and shoot me a message if you ever have questions

  • @byronjava3542
    @byronjava35427 күн бұрын

    This was a really informative video, thank you so much. I have a question, I have been doing the Google Data Analytics Professional Certificate, do these certificates equip you to be job ready or you have to supplement them with other courses?

  • @IanKlosowicz

    @IanKlosowicz

    6 күн бұрын

    100% will have to supplement unfortunately. That course will give you a great foundation of everything data, the tool specific courses will get you GOOD at the tools.

  • @byronjava3542

    @byronjava3542

    6 күн бұрын

    Thank you so much Ian, I will try to do that. Do you take any mentees whom you guide throughout their journey?

  • @JamieJohnson-mr1lq
    @JamieJohnson-mr1lqАй бұрын

    Great video. FYI your newsletter sign up doesn't work for me - it says something went wrong

  • @IanKlosowicz

    @IanKlosowicz

    21 күн бұрын

    Did you ever get this working?

  • @davidmills2900
    @davidmills290021 күн бұрын

    how do I get that data analyst check list? the link is not in the description like the video said it was, and I subscribed to the newsletter and still no checklist.

  • @IanKlosowicz

    @IanKlosowicz

    21 күн бұрын

    Once subscribed, I have it to where it automatically sends you a Welcome Email where the link to the spreadsheet is. Try checking the spam folder? If you still can't find it, let me know

  • @ClaUDiishmoO
    @ClaUDiishmoO15 күн бұрын

    Do you know if there are some part time roles in this space? I just don’t know what sites to look at for job roles that are part time like this

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    Well you can use LinkedIn and filter for part-time. But I have never heard of a part-time data analyst usually because there is a lot to do. There could be a whole bunch of roles though I just never looked into part-time

  • @himaj7173
    @himaj717316 күн бұрын

    Hi.Iam currently stuck in the tutorial hell.I see somuch videos and information and topics regarding these tools and get overwhelmed seeing how much there is to learn..I am not able to move to further topics thinking I need to go deep and into complex problems to be job ready and Im stuck forever. Were these courses and certificates you took were enough for you when you landed the job and in the real work environment ,how complex can the tools usage can go?

  • @IanKlosowicz

    @IanKlosowicz

    16 күн бұрын

    Bare with me... These courses absolutely were enough to land me my first job. The only struggle you will come across is passing a technical interview so you need to be proficient enough to solve these questions. They are not difficult if you've been a data analyst for a while but to a new person, they can be so your best bet is to practice like crazy (NOT meaning to learn in-depth or advanced courses). I can't tell you what your interview questions will be because every company is different but for the majority if its Excel (know xlookup, sumifs, and pivot tables), SQL (know joins, case statements, CTEs, and aggregations), BI tool (know how to create a clean dashboard) Complexity in the tools will go up after you land your job but that's ok because you will be paid to learn it AND that will be the only thing you focus on so it's a lot easier to manage.

  • @peter8261
    @peter826115 күн бұрын

    Would you say knowing Python and demonstrating strong programming skills in data analytics would make an applicant more competitive in the job market than someone who doesn't know Python and maybe only has the typical data analytics skill set (excel, SQL, etc)? Thank you for the video.

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    Yes and no. So it definitely would if the job required or said "nice to have" Python experience but if Python is not mentioned, it would have 0 advantage. I look at it as a ROI on time invested. By the time you are proficient enough at Python, you could have become way more skilled in SQL or a BI tool making you more valuable to the company. But if it's a tool you really want to do, go for it! There are plenty of jobs that are looking for it so do what you truly want

  • @JamieJohnson-mr1lq
    @JamieJohnson-mr1lqАй бұрын

    Great video. The newsletter sign up form didn't work. It says something went wrong.

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    I just tested it out.. Seems to be working on my end. Here is the link again: ianklosowicz.substack.com/ I guess if it doesn't work, send me a dm with a screenshot on LinkedIn. I'll do my best to help you out

  • @matttroughton7391
    @matttroughton73913 күн бұрын

    I dont see the google sheet you mentioned in your video. where is it?

  • @IanKlosowicz

    @IanKlosowicz

    3 күн бұрын

    You will need to sign up for my newsletter. It is within the welcome email that you should get automatically. Let me know if you don’t receive anything and I’ll help get you sorted out

  • @madhuv1968
    @madhuv196812 күн бұрын

    Hi It’s tough to get job in this job market couldn’t even get interviews ..is that really there are looking for junior data analyst ? Cz wherever I see it’s about senior level what about when people got career gap ?

  • @IanKlosowicz

    @IanKlosowicz

    11 күн бұрын

    You’ll have to use filters and only look at entry level. There are less entry level than senior positions so you’ll have to keep looking

  • @aashsus09
    @aashsus098 күн бұрын

    Is it important to have a strong communication skills for becoming data analyst because as a analyst you need to explain the insights of data to everyone. also is there any free courses available regarding the sql, power bi ,etc

  • @IanKlosowicz

    @IanKlosowicz

    8 күн бұрын

    Communication is SO important! This will help you in your interviews as well as on the job as you will be expected to work with others and present findings or talk to clients. For free courses, I am not sure. You will have the best luck looking here on KZread. I preferred the paid course route since they are usually more structured.

  • @ChristopherCordero-up7xq
    @ChristopherCordero-up7xq10 күн бұрын

    How long it takes you? thanks for the info!

  • @IanKlosowicz

    @IanKlosowicz

    10 күн бұрын

    To do what?

  • @ChristopherCordero-up7xq

    @ChristopherCordero-up7xq

    10 күн бұрын

    @@IanKlosowicz to break into data analyst?

  • @sabrinafarzana524
    @sabrinafarzana5242 күн бұрын

    i don't find checklist

  • @IanKlosowicz

    @IanKlosowicz

    2 күн бұрын

    Hey! I think you are the same person asking in the Discord. I replied there

  • @welljoneshate
    @welljoneshate3 күн бұрын

    I'm done subscribing to your Newsletter but didn't receive those Google sheet Data Analyst Checklists. Kindly help please I really need those. Thank you.

  • @IanKlosowicz

    @IanKlosowicz

    3 күн бұрын

    Hey! You should have received a welcome email that contains a link directly to the Google Sheet so you can make a copy. Please check your spam folder just in case. If it’s not there, let me know and we will get it sorted out

  • @welljoneshate

    @welljoneshate

    2 күн бұрын

    @@IanKlosowicz Thanks Ian I just got the google sheet checklist and It really helps me a lot to see my overview roadmap. Thanks for having you here your videos truly inspiring and clear 💌

  • @khushboomehta8611
    @khushboomehta861115 күн бұрын

    Amazing 😍, i am your new subscriber. On point video wihtout any promotions. I just have one doubt what do you mean by star questions? And one request as well. Can you please share your resume for reference?

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    STAR questions is a method of answer behavioral questions. It's a framework to help you not ramble on and on. For my resume, add my on linkedin and I'll share with you

  • @lye4931
    @lye4931Ай бұрын

    Thank u man. Do u recommend learning Power BI or Tableue? Also, in what order would you learn these skills?

  • @IanKlosowicz

    @IanKlosowicz

    Ай бұрын

    I prefer Tableau but that's because I have tried both out. Both are free so go ahead and download them, try each one out, and choose one. Don't focus too much on this so it's best to make a decision and stick with it. Put your focus into building projects

  • @joamitch
    @joamitch15 күн бұрын

    Love the video, but the average cost of a 4-year degree is NOT $104,000. Lots of great tools mentioned here.

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    A lot of sites say something totally different so I just picked one that repeated a few times figuring it was more accurate 😅

  • @joamitch

    @joamitch

    15 күн бұрын

    @@IanKlosowicz 🤣😂🤣 Fair enough. Private online colleges for sure can wrack up an invoice, and sadly, those are the ones paying for the highest positions on a Google search! Also, love the checklist!

  • @IanKlosowicz

    @IanKlosowicz

    15 күн бұрын

    @@joamitch Haha yea I'm sure that's the case. Either way, for less than $50 to be on par with someone who has a degree is pretty cool and makes it easier for people to transition into data. Glad you like the checklist! I wanted to create something super simple so it's easier to stay on track

  • @remilekunfolohunso8785
    @remilekunfolohunso8785Ай бұрын

    Great content. Can I get a sample of your resume?

  • @IanKlosowicz

    @IanKlosowicz

    27 күн бұрын

    Add me on LinkedIn and I'll send one over

  • @ashutoshtripathi-rx3hs
    @ashutoshtripathi-rx3hs12 күн бұрын

    Thank you Ivan Klosowicz sir for your informative video. Your wall frame piece is very good, one day i will purchase that from somwhere.Respect from Bangalore, Karnataka.🥦🥦🥦🥦🥦🥦

  • @paulnyagah181
    @paulnyagah18112 күн бұрын

    can i like twice

  • @IanKlosowicz

    @IanKlosowicz

    11 күн бұрын

    I wish you could!

  • @aR-dm3ns
    @aR-dm3ns10 күн бұрын

    The real answer is: it probably happened more than 5 years ago. You can't do it now unless hyper connected, genius or willing to risk waiting 2 years to get a job while doing many courses and certificaTIONS and building a portfolio for a chance at a junior role that now requires what a senior did 5 years ago. Be careful with misinformation!

  • @IanKlosowicz

    @IanKlosowicz

    10 күн бұрын

    I’ve been in data for only 2 years and every student I have had has became a Data Analyst with this exact method. I actually show you in this video a way to get a job without needing to be hyper connected. Be careful with negative people!

  • @ManuelLopez-ev7ud
    @ManuelLopez-ev7ud28 күн бұрын

    Great video Ian! I truly liked the advice you gave on showing your portfolio with Maven Analytics. Do you mind if I add you on Linkdeln?

  • @IanKlosowicz

    @IanKlosowicz

    28 күн бұрын

    Of course!