How I Became a Data Analyst Without Experience

[@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]

Thanks man!

[@khilafat9468]

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

[@theoni4026]

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]

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

[@loriwidel7636]

Clear and concise! Thanks, Ian!

[@IanKlosowicz]

And thank you for watching! :D

[@linnicalv]

Super helpful video. Clarifying and motivating. Thank you so much!

[@IanKlosowicz]

Glad you enjoyed it! And thanks for watching

[@uavtechgirl5735]

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]

Wow thank you so much! More to come!

[@trev1463]

Very clear and helpful, thank you!

[@phiosopher8712]

This was surprisingly good!

[@IanKlosowicz]

Glad you enjoyed it!

[@bengill1980]

Thanks Ian for real insights and helpful resources.

[@IanKlosowicz]

Thanks for the continued support!

[@alejocercato740]

Very good video! Good luck with the new channel 🎉

[@IanKlosowicz]

I really appreciate it friend!

[@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]

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

[@mimie537]

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

[@IanKlosowicz]

Thanks for watching!

[@gsilagan7117]

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

[@IanKlosowicz]

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

[@fidesarellano5835]

I appreciate this content, concise, informative and helpful.

[@IanKlosowicz]

Glad it helped! Can't wait to share more

[@taha5754]

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😊

[@la4692]

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]

Yea add me on LinkedIn. Happy to share

[@mosamaloka5961]

Thank you!

[@IanKlosowicz]

My pleasure! 😊

[@T_Da_Law]

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]

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

[@ssrk369]

Inspiring 👏✨

[@IanKlosowicz]

Glad you enjoyed it!

[@armansidd4785]

Great video!

[@IanKlosowicz]

Glad you enjoyed it

[@ryanreach3710]

When you said reach out to the recruiter, how would you do that? If you don't have LinkedIn premium you can't message directly right? Thanks

[@IanKlosowicz]

Hey sorry for the late reply! So yes it wasn’t always like this, but you can keep a list of who you connected with and when they accept, reach out to them. Not the most efficient way but it’s really the only way since LinkedIn did that..

[@kekemokwena1046]

Love this video

[@IanKlosowicz]

Thanks! More to come!

[@and3311]

Thank you so much for this video, which was super helpful! I was curious, do you think that a master's program is necessary for an undergrad with a non-technical background to transition into an entry level data analyst role? Or is it sufficient to get a certificate & build specific skills (like SQL) with a portfolio? Any advice would be greatly appreciated! 🙏🏻

[@labcdel4384]

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

[@Sunflower_729]

thank you sir

[@IanKlosowicz]

Most welcome

[@i_h.m.a.Rahman]

great video

[@IanKlosowicz]

Glad you enjoyed it

[@ELFBDS]

Thank you Ian for the insights! 1Q why do you consider Python optional in your checklist? Honestly it is my biggest obstacle in my learning journey.

[@IanKlosowicz]

Because most entry level positions do not require it. Sure some do but majority do not. It’s going to take you just as long to learn Python as it does to use Excel, SQL, and a big tool.

[@ELFBDS]

@@IanKlosowicz Thanks for the reassurance. That's good news for a beginner like me 😁

[@FrancesBenson-ji9ru]

Hi please does anyone know where to get sample practice excel tests and projects for free

[@ribumom9474]

can an art student become a data analyst in 2025? thank you

[@IanKlosowicz]

It doesn’t matter your background. Anyone can become a data analyst. I was a warehouse worker before my first data job (without a degree) :)

[@DevangsRana]

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

[@IanKlosowicz]

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

[@sabrinafarzana524]

i don't find checklist

[@IanKlosowicz]

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

[@matttroughton7391]

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

[@IanKlosowicz]

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

[@vaibhavbhore]

Hi can you please give me advice for my career? I just finished my master degree in electrical engineer. I want to be data analyst and I am ready to learn, however I have no coding background. Should I take this step of changing my career? Is it possible for me to become data analyst?

[@IanKlosowicz]

Hey! Well I can answer that yes it is possible to become a data analyst as I didn’t have any formal education. Now the answer to should you make the career change, that is completely up to you to find out since you know your life best

[@BYim-zc6fn]

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

[@IanKlosowicz]

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

[@aashsus09]

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]

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 KZbin. I preferred the paid course route since they are usually more structured.

[@jaredbisla8723]

hey brother know you're busy, I have a github and resume and have been applying, could I get some feedback if you have 5 mins? thank you either way for the info

[@IanKlosowicz]

Hey! I’m no resume expert and not the biggest fan on GitHub for portfolios. I’d suggest building a great looking portfolio on Maven Analytics (it’s free). At least that would be my suggestion and then for resume, try to replicate formatting with what you find in google. Use ChatGPT to help with words and put it in your own words

[@jaredbisla8723]

@@IanKlosowicz thank you Ian, i've been applying and can't even get a phone screen. Got to keep my head up, signed up to Maven and getting to work. Just feel discouraged sometimes because i've been putting in the time

[@IanKlosowicz]

@@jaredbisla8723​​⁠yea it definitely sucks sometimes. In reality it could be down to luck. I know people who took 2 months to land a job and others where it took 8 months. Chances are it’s not your fault

[@JasonIz-kb7zf]

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]

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

[@julietanaetoh385]

Where's the check-list please. Nice one!

[@IanKlosowicz]

So in the description you can sign up for the newsletter and it will be in the welcome email. Please check spam if you don't see it!

[@Mariobitme]

Great video but i havent had my coffee yet and im having trouble finding the google sheet checklist you mention. Can someone point me to the right direction?

[@IanKlosowicz]

Haha no worries! If you sign up for my newsletter it will be in the welcome email and you can make a copy of the sheet. Make sure to check spam!

[@welljoneshate]

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]

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]

@@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 💌

[@Redditinsights76]

Where is the checklist Link I could not see it does or the newsletter email will come with the checklist

[@IanKlosowicz]

Hey! The checklist is within the welcome email when you sign up for the newsletter. Check the spam folder in case you don't see it. You will also receive a free ebook in there as well!

[@frederickjabagat6765]

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

[@IanKlosowicz]

Hey! I used a website called enhancv

[@Youtubeshorts_editor]

How much did you get paid on your first job. I want to know what to expect please

[@IanKlosowicz]

My first data job was a salary at $60k. I understood this was under the average of what I could make but it was higher than my hourly job and I knew once I got my foot in the door, my salary would keep increasing

[@byronjava3542]

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]

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]

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

[@ClaUDiishmoO]

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]

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

[@JamieJohnson-mr1lq]

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

[@IanKlosowicz]

Did you ever get this working?

[@davidmills2900]

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]

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

[@himaj7173]

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]

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.

[@madhuv1968]

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]

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

[@BusinessDuck69]

Yes, it's extremely hard to get junior jobs in this field (or any tech field right now). Beware of these clickbaity types of videos, as they are part of the problem, drawing people into the industry who think they can take an online course or two and then be on par with people who have a proper education and spend years perfecting these skills. Lame.

[@JamieJohnson-mr1lq]

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

[@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

[@joamitch]

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

[@IanKlosowicz]

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

[@joamitch]

@@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]

@@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

[@khushboomehta8611]

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]

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

[@ChristopherCordero-up7xq]

How long it takes you? thanks for the info!

[@IanKlosowicz]

To do what?

[@ChristopherCordero-up7xq]

@@IanKlosowicz to break into data analyst?

[@ShottyZGuy]

That applying method is patched its like 99% spam

[@remilekunfolohunso8785]

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

[@IanKlosowicz]

Add me on LinkedIn and I'll send one over

[@ashutoshtripathi-rx3hs]

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.🥦🥦🥦🥦🥦🥦

[@lye4931]

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

[@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

[@paulnyagah181]

can i like twice

[@IanKlosowicz]

I wish you could!

[@aR-dm3ns]

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]

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]

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]

Of course!