Tom Mitchell @TomMitchellData Twitter profile

Last Seen Profiles

@stwmaniax

@GalaxyChocolate

@PFridlingt61556

@CaseyBNWO1

@upekkhaBe

@RealC113

@nasim1557

@Itskatieeroses7

@YoussraSab52774

@ucupmadun

@DrDGrossman

@Raskolnik3rd

@ShaharAvigezer

@LaurusLabs

@fakerockchick

@Lucasm0ya

@taamaonfire

@JNobeez

@DaphneShelbi871

@rre9981

@yourgirl_ajex

@stw_pdg

@AlHamraGolfClub

@yayoiakira00

@emalhani

@BigBenilda

@aqba89

@stw_pdg

@BigBenilda

@maryrdes

@BigBenilda

@CA_SGBS78

@MXfenxiang

@HeartSong_9

@woodman4tb

@imattdragons

Tom Mitchell

@TomMitchellData

1 year

Wow Microsoft have free beginner courses in Data Science, Machine Learning and AI (all on Github). Thats: - 34 Weeks of Learning - 70 Lessons - 52 Quizzes All for free?! Thank you, Microsoft! Here are the links:

81

2K

9K

Tom Mitchell

@TomMitchellData

1 year

The standard Data Analyst roadmap is: Excel SQL Visualisation Tool Optional: Python/R That's not very helpful. Here's a detailed breakdown of what you need to learn for each:

75

1K

5K

Tom Mitchell

@TomMitchellData

4 months

My career history: 2015 - Supermarket 2016 - Call Centre 2017 - Finance Analyst 2018 - Data Analyst 2021 - Senior Data Analyst 2023 - Data & Analytics Manager Rome wasn't built in a day. Keep grinding 💪

45

483

4K

Tom Mitchell

@TomMitchellData

9 months

Learn Data Analysis For Free in 2024: 1. Excel 2. SQL 3. PowerBI Reports in PowerBI (Datacamp) 4. Tableau 5. Python 6. R Make

19

1K

3K

Tom Mitchell

@TomMitchellData

6 months

The difference between SQL, NoSQL, MySQL, and PostgreSQL explained in simple terms:

27

686

3K

Tom Mitchell

@TomMitchellData

1 year

RIP to old Data Analysis certificates. Employers want certifications earned through exams. Want to land a job quickly? Here are the certifications that will help you do just that:

56

1K

3K

Tom Mitchell

@TomMitchellData

28 days

When I'm hiring a data analyst, here's what SQL I'd expect candidates with 1-2 years of experience to know:

34

478

3K

Tom Mitchell

@TomMitchellData

1 year

How I would study Data Analytics if I had to start over: Excel : Youtube + Microsoft Training Videos SQL : Mode + SQLBolt PowerBI: Youtube + Udemy Courses Python : learnpython .org + Google Classes Portfolio building - Youtube + Github Repos (Github Pages to host)

36

846

3K

Tom Mitchell

@TomMitchellData

1 year

I got rejected for a Senior Data Analyst role because I didn't know how to A/B test. I wasn't going to let this stop me, so I taught myself. Don't get caught out like me. Here's my super-simple breakdown of how-to A/B test:

54

592

3K

Tom Mitchell

@TomMitchellData

24 days

Data cleaning is one of the most important skills for a data analyst. Not Excel. Not SQL. Not PowerBI Without clean data, any analysis done is unreliable. Here's my data cleaning 101:

17

449

3K

Tom Mitchell

@TomMitchellData

1 year

Don't aim for this: Excel - 100% SQL - 0% PowerBI/Tableau - 0% Python/R - 0% Aim for this: Excel - 25% SQL - 25% PowerBI/Tableau - 25% Python/R - 25% You don't need to know everything straight away.

46

462

2K

Tom Mitchell

@TomMitchellData

1 year

Anyone with an Internet connection can learn Data Analysis for free: Excel - Microsoft Training Videos SQL - Mode PowerBI - Udemy Course Python - Google Classes No more excuses.

22

789

2K

Tom Mitchell

@TomMitchellData

7 months

Excel is a requirement for 99.9% of Data Analyst roles. Don't waste time trying to learn everything it has to offer. Prioritise these 5 things and leave the rest for later:

15

422

2K

Tom Mitchell

@TomMitchellData

7 months

The standard data analyst roadmap is: Excel SQL Visualisation Tool Optional: Python/R That's not very helpful. Here's a detailed breakdown of what you need to learn for each:

25

496

2K

Tom Mitchell

@TomMitchellData

7 months

I've been a: Data Analyst. Senior Data Analyst. Data & Analytics Manager. Here are the three most important lessons I've learned at each level:

14

378

2K

Tom Mitchell

@TomMitchellData

1 year

I got my first data job because I knew SQL better than the other candidates. There are 134 days left in 2023. That means 134 opportunities to learn. Here's my roadmap to master SQL by the end of the year🧵:

26

442

2K

Tom Mitchell

@TomMitchellData

1 year

Data cleaning is one of the most important skills for a Data Analyst. Not Excel. Not SQL. Not PowerBI Without clean data, any analysis done is unreliable. Here's my Data Cleaning 101:

29

447

2K

Tom Mitchell

@TomMitchellData

3 months

Don't aim for this: Excel - 100% SQL - 0% PowerBI/Tableau - 0% Python/R - 0% Aim for this: Excel - 25% SQL - 25% PowerBI/Tableau - 25% Python/R - 25% You don't need to know everything straight away.

16

329

2K

Tom Mitchell

@TomMitchellData

1 year

25 terms every Data Analyst should know:

28

543

2K

Tom Mitchell

@TomMitchellData

1 year

Data Visualisation Tool Comparison:

4

356

2K

Tom Mitchell

@TomMitchellData

7 months

Data cleaning is one of the most important skills for a data analyst. Not Excel. Not SQL. Not PowerBI Without clean data, any analysis done is unreliable. Here's my data cleaning 101:

13

309

2K

Tom Mitchell

@TomMitchellData

1 year

Excel, SQL, Python & R play a huge part in data careers. Don't spend $100's to learn them. Here are 12 websites that will teach you for free: 🧵

19

519

2K

Tom Mitchell

@TomMitchellData

1 year

I've worked in data for more than 6 years. It took me over 4 years to get my first job. If I had to start again, I'd do things differently. Here's how I would become a Data Analyst in 2023:

36

483

1K

Tom Mitchell

@TomMitchellData

7 months

I got rejected for a Senior Data Analyst role because I didn't know how to A/B test. I wasn't going to let this stop me, so I taught myself. Don't get caught out like me. Here's my super-simple breakdown of how-to A/B test:

20

275

1K

Tom Mitchell

@TomMitchellData

1 year

SQL is the undisputed champion of the data world. To be successful in data, SQL skills are a non-negotiable. Want to become an SQL champion? Here's a roadmap that will get you there:

30

345

1K

Tom Mitchell

@TomMitchellData

10 months

My career history: 2015 - Supermarket 2016 - Call Centre 2017 - Finance Analyst 2018 - Data Analyst 2021 - Senior Data Analyst 2023 - Data & Analytics Manager Rome wasn't built in a day. Keep grinding 💪

31

167

1K

Tom Mitchell

@TomMitchellData

1 year

How to become a Data Analyst without a tech background:

34

345

1K

Tom Mitchell

@TomMitchellData

3 months

Learn data analysis for free in 2024: 1. Excel 2. SQL 3. PowerBI Reports in PowerBI (Datacamp) 4. Tableau 5. Python 6. R

14

482

1K

Tom Mitchell

@TomMitchellData

1 year

Thinking like a Data Analyst didn’t come easily for me. I'd spend hours staring at datasets, unsure what questions to ask. I knew I had to change if I wanted to have a successful career in data. Luckily, I found a way through. Here's what I did in 4 steps:

31

305

1K

Tom Mitchell

@TomMitchellData

6 months

RIP to old Data Analysis certificates. Employers want certifications earned through exams. Want to land a job quickly? Here are the certifications that will help you do just that:

11

334

1K

Tom Mitchell

@TomMitchellData

9 months

It took me 2 years to go from Data Analyst to Senior Data Analyst. I could've done it faster with what I know now. Here's what I'd do differently if I was starting again as a Data Analyst:

17

278

1K

Tom Mitchell

@TomMitchellData

10 months

Anyone with an Internet connection can learn Data Analysis for free: Excel - Microsoft Training Videos SQL - Mode PowerBI - Udemy Course Python - Google Classes No more excuses.

14

506

1K

Tom Mitchell

@TomMitchellData

9 months

Don't aim for this: Excel - 100% SQL - 0% PowerBI/Tableau - 0% Python/R - 0% Aim for this: Excel - 25% SQL - 25% PowerBI/Tableau - 25% Python/R - 25% You don't need to know everything straight away.

22

306

1K

Tom Mitchell

@TomMitchellData

1 year

Data Interviews 101 In the past 6 years, I've interviewed countless people for data-related roles. Want to know a secret? I use the same 5 questions every time:

19

364

1K

Tom Mitchell

@TomMitchellData

1 year

How to write a killer data analyst resume with no experience:

21

311

1K

Tom Mitchell

@TomMitchellData

1 year

It took me 4 years of studying to get my first data analyst job. As a beginner with no experience, the journey to employment can seem daunting. I want you to do it quicker than me. I've condensed everything you need to do into 6 steps: 🧵

34

295

1K

Tom Mitchell

@TomMitchellData

1 year

I've been a: Data Analyst. Senior Data Analyst. Data & Analytics Manager. Here are the three most important lessons I've learned at each level:

13

304

1K

Tom Mitchell

@TomMitchellData

1 year

How to Analyse Data with Python 101:

19

272

1K

Tom Mitchell

@TomMitchellData

8 months

Nobody showed me how to create a data analysis portfolio. I was lucky to land my first job. To become a data analyst in 2024, it's non-negotiable. Here's how you can do it in 5 steps:

24

317

1K

Tom Mitchell

@TomMitchellData

1 year

Excel is a requirement for 99.9% of Data Analyst roles. Don't waste time trying to learn everything it has to offer. Prioritise these 5 things and leave the rest for later:

17

354

1K

Tom Mitchell

@TomMitchellData

1 year

I have a PDF with 3 Data Analyst resume templates which helped my mentees land $60-70k jobs I usually charge for them But, I'm loving interacting with you guys So i'm giving it away for free All you have to do is comment 👍 and i'll dm the download link (must be following) ⬇️

2K

222

1K

Tom Mitchell

@TomMitchellData

1 year

Data Analyst vs Data Scientist What's the difference? You need to know this if you want to work in data: 🧵 (Disclaimer - this is based on my experience)

20

327

1K

Tom Mitchell

@TomMitchellData

9 months

Want to land a Data Analyst job in 2024? Here's what you need: - Excel - SQL - PowerBI or Tableau - Python or R and master: - Communicating data - Problem solving - Data transformation & cleaning - Data visualisation theory Make 2024 your best year yet. I'm rooting for you.

16

293

1K

Tom Mitchell

@TomMitchellData

1 year

A 4-year Data Science degree from Harvard costs $330,000+ Want to learn about Data Science but don't want to spend that much? Here are 6 Data Science courses from Harvard that cost $0:

16

335

1K

Tom Mitchell

@TomMitchellData

11 months

Data Analysis is not: - Writing SQL code - Building PowerBI Dashboards - Creating Pivot Tables in Excel - Using Python to wrangle data It's: - Listening for problems - Selecting the right tool to solve the problem - Overcoming challenges - Helping drive action and following up

19

305

1K

Tom Mitchell

@TomMitchellData

9 months

Learning SQL changed my life, and it will change yours too. Do yourself a favour and make 2024 the year you master it. To help, here's my 2024 SQL roadmap:🧵

18

255

1K

Tom Mitchell

@TomMitchellData

11 months

A breakdown of: - Data Analysts - Data Scientists - Data Engineers - Business Analysts And the skills needed for each role 🧵:

15

335

1K

Tom Mitchell

@TomMitchellData

1 year

When starting out, a lot of people struggle with SQL Joins. The truth is, once you've grasped it, you won't forget it. Here's my super simple breakdown of common SQL joins:

32

292

1K

Tom Mitchell

@TomMitchellData

23 days

If you want to learn Python for Data Analysis: Don't try and learn everything it on offer. Instead, focus on: Pandas (cleaning, transforming, and analysing) NumPy (for math) Matplotlib (for data visualisation) That'll get you up and running.

7

198

1K

Tom Mitchell

@TomMitchellData

7 months

I combined 3114 CSV files with 4 lines of Python code: Here's how:

19

121

1K

Tom Mitchell

@TomMitchellData

1 year

As a Data Analyst its crucial to know the difference between a Dashboard and Report Here's my super simple breakdown:

8

269

1K

Tom Mitchell

@TomMitchellData

8 months

Data Analysts are in high demand, but the competition is tough. Here's a dead-simple guide to landing your first Data Analyst role:

21

238

1K

Tom Mitchell

@TomMitchellData

1 year

How to optimise your LinkedIn profile to land high paying data jobs:

14

311

996

Tom Mitchell

@TomMitchellData

2 months

Data analysis is not: - Excel - SQL - Python/R - PowerBI or Tableau Data analysis is your ability to spot patterns in data and transform raw data into actionable insights. The tools help you get there, they don't do the job for you.

6

231

1K

Tom Mitchell

@TomMitchellData

1 year

Most people think new Data Analysts need to use many tools. The truth is, you only need 3. Don't waste your time with tools you won't use on the job. Here are the only 3 you need to get started:

38

267

966

Tom Mitchell

@TomMitchellData

1 year

A Data Analyst who understands customer segmentation will never be short of work. Problem is, it's not covered often in courses. So, I've put everything I know about it into this thread. Grab a pen and some paper and get stuck in 🧵:

17

279

957

Tom Mitchell

@TomMitchellData

9 months

Data Analysis is not: Building Dashboards 25% SQL 25% Plotting data 25% Cleaning data 25% It's: Communication/Meetings 50% Understanding the data 20% Data cleaning & transformation 15% Analysing data 5% Validating/Tweaking 10%

15

264

949

Tom Mitchell

@TomMitchellData

1 year

Data Analyst vs Business Analyst What's the difference? You need to know this if you want to work in data: 🧵 (Disclaimer - this is based on my experience)

14

287

945

Tom Mitchell

@TomMitchellData

8 months

Over the last 2 years I have reviewed 100's of Data Analysis portfolios. 99% sucked. For the 1% that were outstanding, here's 5 things they had in common:

22

222

929

Tom Mitchell

@TomMitchellData

1 year

Pandas (Python) methods worth knowing for Data Analysis:

12

185

928

Tom Mitchell

@TomMitchellData

1 year

If you want to learn Python for Data Analysis: Don't try and learn everything it on offer. Instead, focus on: Pandas (cleaning, transforming, and analysing) NumPy (For Maths) Matplotlib (For Data Visualisation) That'll get you up and running.

17

219

925

Tom Mitchell

@TomMitchellData

1 year

Without Data Engineers, there would be no data science, analysis or BI That's why it's one of the highest-paying data roles with average salaries of ~$150k Knowing where to start can feel overwhelming Don't worry, here are 3 Data Engineering certifications that make it simple:

22

236

920

Tom Mitchell

@TomMitchellData

2 months

How I would study data analytics if I had to start over: Excel : Youtube + Microsoft Training Videos SQL : Mode + SQLBolt PowerBI: YouTube + Udemy Courses Python : learnpython .org + Google Classes

4

220

919

Tom Mitchell

@TomMitchellData

1 year

Matplotlib (Python) Cheatsheet for Data Visualisation:

2

168

907

Tom Mitchell

@TomMitchellData

1 year

3 websites to learn SQL for free:

17

252

899

Tom Mitchell

@TomMitchellData

1 year

I've been working in data for over 6 years. I've been writing SQL since day one. Here are the most common keywords I use:

18

187

909

Tom Mitchell

@TomMitchellData

9 months

SQL is the bread and butter of Data Analysis. For any Data Analyst, it's non-negotiable. Use these case studies to test your skills with real-world problems:🧵

10

232

892

Tom Mitchell

@TomMitchellData

1 year

You have 6 seconds to make your data analyst resume stand out when you apply for a job. How do you do that? By showcasing your skills through projects. Here are 6 portfolio projects (with datasets) guaranteed to WOW employers. 👇

19

308

895

Tom Mitchell

@TomMitchellData

1 year

SQL Query Execution Order: FROM: Tables are joined. WHERE: The data is filtered. GROUP BY: The filtered data is grouped. HAVING:The grouped data is filtered. SELECT:The final data is returned. ORDER BY: The final data is sorted. LIMIT: Returned data is limited to row count.

9

225

890

Tom Mitchell

@TomMitchellData

9 months

How to write a killer data analyst resume with no experience:

16

187

876

Tom Mitchell

@TomMitchellData

1 year

What's more powerful than: Excel? SQL? Python? Having the ability to use them together. Excel can import data from SQL using Power Query. Create SQL tables from Excel files. Python can read/write Excel Files/CSVs. Python can access data in SQL tables. Go beyond the basics.

12

167

870

Tom Mitchell

@TomMitchellData

1 year

A list of Python resources I used as a Data Analyst:

5

232

868

Tom Mitchell

@TomMitchellData

1 year

25 Beginner SQL Interview questions (+ answers):

15

204

868

Tom Mitchell

@TomMitchellData

29 days

Here's the fastest way to use Python if you already know SQL:

8

133

891

Tom Mitchell

@TomMitchellData

1 year

My Data Analyst resume checklist: Download below 👇

12

167

865

Tom Mitchell

@TomMitchellData

6 months

A Data Analyst who understands customer segmentation will never be short of work. Problem is, it's not covered often in courses. So, I've put everything I know about it into this thread. Grab a pen and some paper and get stuck in 🧵:

13

238

874

Tom Mitchell

@TomMitchellData

8 months

Data analysis is not: - Excel - SQL - Python/R - PowerBI or Tableau Data analysis is your ability to spot patterns in data and transform raw data into actionable insights. The tools help you get there, they don't do the job for you.

11

216

853

Tom Mitchell

@TomMitchellData

8 months

As a Data Analyst its crucial to know the difference between a Dashboard and Report Here's my super simple breakdown:

4

201

851

Tom Mitchell

@TomMitchellData

1 year

How I went from Entry Level Analyst to Senior Data Analyst in 2 years:

13

132

850

Tom Mitchell

@TomMitchellData

1 year

Matplotlib (Python) Data Visualisation Tips Sheet:

2

127

854

Tom Mitchell

@TomMitchellData

1 year

If you want to learn Python for Data Analysis prioritise: - NumPy (maths) - Pandas (data wrangling) - Matplotlib (Data viz) - Seaborn (built on top of matplot lib, has higher level interface capabilities) - OS (Operating System Interaction for working with files and folders)

12

208

838

Tom Mitchell

@TomMitchellData

19 days

How much Excel, SQL and PowerBI did I actually use as a data analyst? (Honest take):

12

104

859

Tom Mitchell

@TomMitchellData

6 months

How to become a Data Analyst without a tech background:

11

210

841

Tom Mitchell

@TomMitchellData

8 months

Thinking like a Data Analyst didn’t come easily for me. I'd spend hours staring at datasets, unsure what questions to ask. I knew I had to change if I wanted to have a successful career in data. Luckily, I found a way through. Here's what I did in 4 steps:

11

191

825

Tom Mitchell

@TomMitchellData

1 year

Becoming a Data Analyst doesn't need to be more complicated than: 1. Excel/Stats 2. SQL 3. Tableau/ PowerBI ➡️Build dashboards 4. Python/R ➡️ Analyse + Visualise Data 5. Using the above, build Portfolio projects (From data cleaning → Tell the story → Recommendation & Actions)

6

172

812

Tom Mitchell

@TomMitchellData

4 months

The standard Data Analyst roadmap is: Excel SQL Visualisation Tool Optional: Python/R That's not very helpful. Here's a detailed breakdown of what you need to learn for each:

14

171

761

Tom Mitchell

@TomMitchellData

1 year

If you want to learn SQL for Data Analysis prioritise: - Data Types - SELECT Statements - Filtering/Sorting - JOINs - Aggregation Functions - Subqueries - Window Functions (Analytic Functions) If you want more help learning, here's my best SQL threads and free resources:

9

213

801

Tom Mitchell

@TomMitchellData

1 year

The tools I used as a Data Analyst: - SQL - Python - PowerBI - Cloud tech (Azure/AWS) The tool I use the most? Excel. Here's why I recommend you learn Excel in 2023:

13

150

803

Tom Mitchell

@TomMitchellData

1 year

When I first started as a Data Analyst I was dashboard crazy. But, I learnt quickly that not validating my work properly pre-deployment would seriously damage my reputation. Don't make the same mistake I did. Here's a 4-step framework I used to bulletproof my work:

7

153

803

Tom Mitchell

@TomMitchellData

1 year

8 Data Analysis terms you should know: Cleanse - fix or remove. Analyse - examine patterns. Visualise - create visuals. Transform - modify structure. Correlate - identify relationships. Predict - forecast trends. Interpret - explain results. Extract - retrieve information.

3

218

796

Tom Mitchell

@TomMitchellData

10 months

Data Analysis projects from YouTube won't get you a job. Following tutorials won't get hiring managers attention. Thinking outside the box will. Here's my 5-step process for creating unique projects that demand attention🧵:

9

234

786

Tom Mitchell

@TomMitchellData

11 months

It took me 2+ years to become a successful Data Analyst. I really struggled at first. I learned so much by asking the right questions. If I was starting my data career again, here are 5 questions I'd ask everyone I met:

11

185

769

Tom Mitchell

@TomMitchellData

1 year

I went from entry-level analyst to manager of 20 in 4 years. I climbed the ladder by knowing exactly what I needed to do at every level. It's not always clear what you need to do to move up. Here's my breakdown of each role from Analyst to Manager: (Based on my experience)

18

172

773

Tom Mitchell

@TomMitchellData

7 months

If you want to learn Python for Data Analysis: Don't try and learn everything it on offer. Instead, focus on: Pandas (cleaning, transforming, and analysing) NumPy (for math) Matplotlib (for data visualisation) That'll get you up and running.

11

163

731

Tom Mitchell

@TomMitchellData

1 year

Learn Data Analytics whilst working full time: Find 60 minutes per day to learn the absolute basics (Excel, SQL, PowerBI/Tableau) on Youtube. Do this for 2-3 weeks. Write down project ideas as you learn. Start building projects. Don't wait to "feel ready" just go.

30

185

756

Tom Mitchell

@TomMitchellData

1 year

GitHub offers the best free Data Science education on the internet. But there are more than 372 million repositories to choose from. How do you find the best ones? Bookmark these 5 repositories and start learning fast:

9

191

754

Tom Mitchell

@TomMitchellData

5 months

Anyone with an Internet connection can learn Data Analysis for free: Excel - Microsoft Training Videos SQL - Mode PowerBI - Udemy Course Python - Google Classes No more excuses.

Google's Python Class | Python Education | Google for Developers

Assorted educational materials provided by Google.

developers.google.com

5

248

767

Tom Mitchell

@TomMitchellData

11 months

I moved from writing SQL code for a company with 4 million customers to one with 26 million. The first day I wrote some basic SQL and my query crashed. I found out the hard way working with data of this size needs serious consideration. Here's what had to change and why:

11

166

752

Tom Mitchell

@TomMitchellData

1 year

Data Science and Python are a match made in heaven. But there are over 137,000 Python libraries to choose from. Here are 8 you will use the most as a Data Scientist:

7

153

750

Tom Mitchell

@TomMitchellData

1 year

6 analysis techniques I used the most as a Data Analyst:

15

207

747