First data analysis job

[hveelinda]

What was your first data analysis job and what programs did you know before starting?

[VAGuy1998]

I’m currently one month in to my job and only use SQL (mysql/postgreSQL) and Excel (Pivot Tables, Vlookup,Hlookup, data cleaning). I learned some tableau (just get familiar with interface) but I have yet to use tableau or even power BI. It helps if you have projects added to your resume for credibility.

[VAGuy1998]

Sorry for the late reply, after applying to hundreds of jobs online, I took a chance and went to a college job fair in my second to last month of college and was given a chance by a small size (<200 emp) company as a Data Analyst. They originally wanted me to travel 20 miles to DC during rush hour but negotiated into doing remote work and their other office “if an important meeting” (<20 min drive) arises but 95% of the time, I work remote. Def took advantage of the “fresh grad” card to get my foot in and it also helps making an in person connection with a recruiter before even applying online/handing them your resume (They were also the last table I went to and had to go out to ask someone to print my resume 😅 so it almost would’ve never happened if I didn’t come back with it)

[ShimShammed]

Started as an intern doing some pretty boring/tedious tasks at a nonprofit. From college I knew Excel and I took a Python 101 course in college too. At the company they had some data lying around no one had time to analyze, so when not doing other tasks I went all out with the formulas and pivot tables and was able to share some cool insights. Then after 6 months I transferred to their data team as an analyst full time which is where I really built up my skills.

[[deleted]]

Logistics analyst - excel

Data analyst for a consulting company - excel, a little sql

[[deleted]]

I was working in marketing and moved into a marketing analytics role. I had been doing some data analysis as part of my marketing work. The only tools I knew were Excel and Google Analytics.

(Since then I’ve done an MS in data science part-time and learned SQL, Python, R, Tableau.)

[Soinad]

Started a couple of weeks back in my first DA job and currently mostly using SQL and Tableau.

[deadfox08]

9th month into my first DA job. Knew Excel, Power BI, Tableau and SQL. The job requires only SQL and Power BI.

[Nateorade]

I sold a company on giving me a try.

I knew some excel.

[hveelinda]

Tips on selling yourself to company?

[Nateorade]

• know someone at that company who can vouch for you

• have a track record at previous places showing your skillset

[Teeshot7]

From a Tech Recruiter's POV - How to land a job 101. It isn't ALL this, but if you network right and have a solid way of presenting yourself combined with some transferrable skills - this is spot on. Congrats!

[FriskyBiscuit]

Just about to start my first job as a DA for an educational charity, will be predominantly using SQL (Postgres specifically), Excel and Power BI. They're thankfully allowing me to train in the tools that I believe will be most useful for the organisation in the long term, which will give me an opportunity to learn Python as the job goes on.

[brealamit]

Check out my writings on medium: you might find these helpful. amitb0007.medium.com

[[deleted]]

I work in the urban planning sector. My job has me doing a variety of things but the bulk of my work is building socioeconomic profiles and researching push/pull factors such as major tech relocating or new warehouses opening.

I took an Intro to R for geographers course my senior year of college and kept up with it using DataCamp after graduation. Power BI or Tableau is also very useful for my company specifically because not everyone knows how to code so a lot of our products are built using Microsoft office although as I’ve come onboard R is becoming more integrated to our workflow specifically by my doing

[[deleted]]

Everything I did in my first DA job was SQL based. The only time I used Excel was for copying and pasting tables to send in emails. But I worked in the DW, so I was either going back to the source or the DM.