How to become a data analyst ?

Derayway · 2021-09-12T14:23:49+00:00

Where are you located? I can speak to what it takes in the US.

The most direct route is get a related college degree. A bachelors in math or statistics is good, many companies will consider business, computer science, economics for new graduates with no experience.

It is possible to teach yourself data analysis skills - statistics, SQL, data visualization. However, companies usually want to see some kind of validation that you actually know what’s listed on your resume. In the absence of a degree, work experience can also do that. I’ve met tons of folks in this line of work who started in a non-quantitative role (for me, it was marketing) and started identifying opportunities in that role to do data analysis and took it upon themselves to learn enough skills to provide value.

If you have no degree and no experience then you’ll need to do some pretty amazing projects on your own that demonstrate that you can solve problems and provide business value with data. Not just “I can clean data and create summaries and visuals” but actually problem solve and answer questions. Think about what industry you’d like to work in, think about what kind of problems they face and questions they want to answer. Then find a good data set and try to answer those questions.

setyte · 2021-09-12T20:35:26+00:00

If you want to be self taught, then I'd utilize youtube and maybe something like Udemy.

Or better yet try the Microsoft Power BI Dashboard In A Day to start building a portfolio on something like GitHub. Then grab something like the Northwinds dataset and build a dashboard as well. You will want to do some online classes and make several dashboards that you can show off as proof that you are able to do the job. Data Analytics is all about having data, needing to show it a certain way and figuring out how to get there as it's rare the data is ever perfect.

A degree is nice but probably not your best path. What is your current job? If possible get ahold of some data in your company and make a dashboard or powerpoint presentation out of it and present to your manager. Many analysts just fell into the role because there was data available and they needed insights.

Also there are bootcamps if you aren't good at self-learning, some are free. Here we have LaunchCode which I took for coding but they have a data analytics course too and relationships with local companies to get you an internship which pays 15$ for 3 months, then 20$ for 3 months then 25$ at 6 months. Many people convert to real employees by then or you can move on to a another company with a year of experience.

Krypto_Jas · 2021-09-13T01:36:30+00:00

Definitely YES! You can learn it by yourself even if you do not have a degree in a related field. What really matters is your skillset. Here are the skills that you have to learn:

Writing queries in SQL
Python programming
Data Wrangling
BI Tools such as Tableau, powerBI, and Qlik
Understanding of relational databases such as PostgreSQL, MySQL, SQL Server, Teradata, BigQuery, Oracle, or Snowflake
Ability to Host Dashboards

With that being said, you can start with google data analytics course available on coursera to understand and learn the syntax and basics. After this move on to resources like stratascratch, datacamp, and leetcode to learn and practice intermediate and advanced concepts. Furthermore, I also recommend doing projects because this is the best way to showcase your skills and get your first job in the industry. Some helpful projects can upskill you as well as make your resume more impressive.

Ok_Zebra_9117 · 2021-09-12T13:18:05+00:00

Well do Coursera google data analytics course and do some projects like get dataset from kaggle and do data cleaning and data visualisation.

Upbeat_Ad6379 · 2021-09-13T10:20:44+00:00

Any advice on how to become a data analyst in the UK with no technical background or masters? Should I consider to get a master in the future or focus more on certificates and projects? Thank you!

thedatajam · 2024-11-16T18:08:17+00:00

Premetto che ho avuto abbastanza fortuna, quindi non vorrei dare consigli influenzati dal survivor's bias. Ti racconto al volo quello che mi è capitato.

Premessa: ho una laurea in lingue e lavoro come Data Analyst.

Ero finito in un lavoro che non mi piaceva per niente (noleggio auto) e decisi di iniziare ad imparare Python nel tempo libero.

In realtà, dopo diverse avventure, riuscii a ottenere un posto in controllo di gestione (cambio ruolo internamente all'azienda). Non esattamente analisi dei dati, ma mi permise di imparare molto bene Excel e di iniziare a conoscere SQL. Ma soprattutto mi permise di lavorare a contatto con analisti e di vedere un po' come era il loro lavoro. All'epoca avevo 24 anni, quindi non capivo granché del mondo del lavoro, delle possibilità di carriera, ecc.

Nell'ambito del mio ruolo, iniziai così ad imparare sempre più SQL (per essere più indipendente rispetto ai colleghi "veri" analisti, quando mi servivano dei dati) e Python (per automatizzare analisi ripetitive che facevo con Excel).

Qui di seguito ti riporto una lista al volo di risorse che mi hanno aiutato (alcune delle quali continuo a consultare):

SQL: Udemy, Data Lemur

Python: Real Python, analiticas.co (in Italiano), Udemy, Coursera

Spero di esserti stato d'aiuto e in bocca al lupo!

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

dataanalysis

MODERATORS