How to become a Data Analyst

 Here is everything I would learn if I were trying to break into an entry-level data analyst role today.

Just as a disclaimer, I don't think you necessarily need a college degree to be a data analyst, but a degree (in anything) certainly helps!

@datawithluis Replying to @Eljay This is everything I would learn if I were trying to become a data analyst without any experience. -Excel -SQL -Data Visualization -Tableau -Networking All the links are in my bio, let me know if you have any questions, and follow me for more data content #DataAnalytics #DataAnalyst #SQL #Tableau #alteryx #python #PowerBI #excel #careeradvice #breakintotech #jobtok #STEM ♬ original sound - Luis - Data Analyst

• Intermediate Excel (Lookups (V, X, H), Pivot Tables, String Functions, Statistical Functions)

  • W3 Schools Excel Tutorial

  • Youtube: FreeCodeCamp

  • TikTok: MissExcel

• Intermediate SQL (Data Types, Joins, Group By, Aggregate Functions, Window Functions, Data Preparation, Performance Optimization)

  • Udacity FREE SQL For Data Analysis + SoloLearn Introduction to SQL & Intermediate Courses

  • YouTube: Alex The Analyst SQL Videos

  • Hands-On: Data With Danny 8-Week SQL Challenge (GitHub Portfolio)

  • Practice Questions: DataLemur, HackerRank, LeetCode

• Data Visualization Theory (Try to get these books at your local library)

  • Storytelling with Data by Cole Knafflic

  • How Charts Lie by Alberto Cairo

• Data Visualization Tools (Tableau)

  • Youtube: Andy Kriebel, Tableau Tim, Alex The Analyst

  • Hands-On: MakeOverMonday & WorkoutWednesday

  • Make a Tableau Public Profile to showcase your work

• Networking

  • LinkedIn

  • Tableau User Groups

  • Alteryx User Groups

• Nice to Haves (They might help set you apart from the competition)

• Data Preparation Tools (Alteryx)

  • Alteryx Academy (Get Alteryx Core Certified)

• Python (Pandas)

  • Keith Gali on Youtube

• Statistics (Probability, Hypothesis Testing, Sampling, Correlation & Regression)

• Khan Academy

I know I just left you with a ton of links and resources, so you might feel a bit overwhelmed, but the best advice I can give you is to do one thing at a time. Do the Excel portion, then move on to SQL, and so on. I know I can't be the only one who starts a course, then sees a new shiny course and moves on to that one and never actually finishes any of them. So, avoid that, learn one thing at a time, and have fun!

Let me know if you have any questions, and follow me on TikTok and YouTube for more data content.