Alex Freberg
@Alex_TheAnalyst
Followers
76K
Following
6K
Media
391
Statuses
2K
Alex The Analyst Official Twitter Account | YT Alex The Analyst | IG @Alex_The_Analyst | YouTube’s #1 Data Analyst Channel (don’t fact check that)
Joined March 2022
I should set up a playlist called "Data Analyst Bootcamp" on my YouTube channel that will walk you through all of the basics in SQL, Excel, Tableau, Power BI, Python, and more. All accompanied by projects and a way to create a portfolio website for free.
269
776
4K
New Python Series will start right after the Power BI Series finishes in a few weeks! This is the first 6 videos of about 30 videos that will cover all of the basics as well as Pandas, Web Scraping, Matplotlib, and more! Super excited to finally do some Python tutorials! :D
59
662
4K
Here are some of the best FREE resources for learning SQL. A Thread ->.
83
1K
4K
The people have spoken and I have heard you. A sneak peak of next weeks video/playlist release!
170
791
4K
Top 10 Data Analyst Courses for Coursera (Updated 2022 Thread). 1. Tableau Data Visualization -
54
999
3K
Coursera just announced 2 brand new Google certifications!. 1. Google Advanced Data Analytics Professional Certificate The Advanced Certification is 90% Python! I think they heard our feedback.
55
498
2K
FREE Data Analyst Bootcamp (With Certificate!). Link:
45
579
2K
Here are some of my favorite FREE resources for learning Excel!. A Thread ->.
30
589
2K
PSA: Udemy is having their Black Friday Sale so if you were waiting for a sign to buy that course here it is!. (Sale Ends November 25th). Here are some of my favorite courses I've taken on Udemy:.
25
385
1K
I see a lot of Data Analysts try to learn ML right out the gate. They think it'll help get them hired since it shows they know the advanced stuff. Hiring managers don't really care about that - they're hiring you for a specific reason. I recommend learning the basics first.
34
256
1K
Here are some of my favorite FREE resources for learning Power BI!. A Thread ->.
51
465
1K
Story time!. The year was 2017 and my wife was the breadwinner of the family when she was laid off. I was making 47k at the time and we couldn't afford our apartment anymore and didn't have much in savings. She was applying to jobs everywhere and I also was applying to jobs all
83
214
1K
I’m feeling the love right now 😄.
he explained data analysis like no one else could. Retweet if you love him.
49
192
1K
Today we kick off our Python Tutorial Series!!. This series will have 15 videos going over everything you need to get started in Python!.
31
375
1K
Top 10 Data Analyst Courses for Udemy (Updated 2022 Thread). 1. Python for Data Science and Machine Learning -
19
456
1K
Here are some of my favorite FREE resources for learning Python!. A Thread ->.
21
374
1K
Since the beginning of this year, I've had over 400 people message me telling saying my YouTube channel helped them land a job as a Data Analyst!. That's almost 60 people per month! 2 per day!.
13
198
1K
When I'm using Python I probably know about 30-40% by memory, the rest I look up when I use it. I think being good at coding is much more about knowing concepts and the basic principles rather than memorizing everything.
34
258
1K
(Data Science vs Data Analytics). I found this interesting thread on the r/datascience subreddit last night talking about data science and data analytics. I think OP (original poster) has some good points. What do you think?
22
273
1K
Here are some of my favorite FREE resources out there right now to help you become a Data Analyst! I'll be making follow up posts on specific skills you can learn with these resources. Thread ->.
31
399
1K
Learn SQL from Beginner to Advanced in under 4 Hours!. I've taken my entire MySQL series and put it into one video so you have everything in one place!. SQL is one of the best skills for people in the data world to learn and this is one of the best free resources to learn MySQL.
20
262
1K
"Makes everyone a Data Analyst". Multiple times a week I get messaged by people saying they're giving up on becoming a Data Analyst or Data Scientist because they see things like this everywhere they look. They feel like they missed their chance and AI is going to automate their.
🚨 BREAKING: Code Interpreter is FINALLY rolling out to all ChatGPT Plus users. It's the most powerful feature OpenAI has released since GPT-4. It makes everyone a data analyst. Here are 15 mind-blowing use cases of Code Interpreter:
54
338
967
I am now 29 years old. I changed my career from Recreational Therapy to Data Analysis at 21. I got married and had 3 kids when I was 22. I started my YouTube channel when I was 24. I quit my full time job to start my own business at 27. I got made the best cake in the world
222
78
1K
Tomorrow we are going to be starting our Azure series!. In this series we will cover Storage Accounts, SQL Databases, Azure Data Studio, Azure Data Factory, and Azure Synapse Analytics. These are incredibly useful and popular tools within Azure that I think everyone should know
16
195
1K
I just added my Pandas series into the Data Analyst Bootcamp!. Pandas is a fantastic, open-source library in Python used for Data Analysis. It's been one of my favorite libraries for the past few years. I've added this series right after the Python series - so once you learn
27
200
1K
I didn’t even know 900k people were interested in Data Analytics!!. I started this channel 4 1/2 years ago to help people understand how to get into Data Analytics because I had a really tough time getting in myself. It means the world to me that I can help so many people and
32
82
1K
People are reaching out asking why I've created a "Data Analyst Bootcamp" when I'm against most bootcamps. Here's why I don't like bootcamps:. 1. As a whole I don't like most bootcamps because they charge extraordinarily high rates (10-15k USD) for fairly basic things.
40
216
1K
How do you "clean" data?. When I first got into the data world this was an extremely confusing concept for me to understand, but incredibly important to the data process. A thread ->
25
244
1K
Just added AWS and Azure to my Free Data Analyst Bootcamp on YouTube! . It now covers MySQL Beginner to Advanced, Excel, Tableau, Power Bi, Python, Pandas, AWS, and Azure. It also covers how to build a portfolio website for free, resume building with templates, and 10+ projects
29
178
1K
Added the Web Scraping Series to my Free Data Analyst Bootcamp on YouTube!. It now has 70 videos dedicated to helping you become a data analyst and over 1.3 million views!
23
223
942
SQL is like my wife. My first real love and I want to spend more time with her than I usually get to. Excel is like my Uncle. He’s family so I have to talk to him, but I’d rather be hanging out with my wife. Python is like my dad. Old and wise and can do a bit of everything.
31
201
927
This week I'm releasing my entire Data Analyst Bootcamp in one video!!. This is almost 24 hours of amazing content covering SQL, Python, Excel, Tableau, Power BI, Azure, AWS and more!. It also covers creating a Portfolio Website, Interviewing techniques, Creating a Resume, and.
29
149
954
Learn Tableau in under 2 Hours!. In this video we dive into Tableau and learn how to create Visualizations, Dashboards, and Reports!.
6
207
950
I just finished the last tutorial in my Beginner, Intermediate, and Advanced SQL Series on YouTube!. If you want to learn SQL for free this is a great place to start and will take you from the very basics of Select, From, and Where all the way up to Stored Procedures, Temp.
34
281
933
Here are my upcoming series on YouTube:. 1. Data Fundamentals (5-7 videos).2. Git and Github (3-4 videos).3. Everything you need to know about Healthcare Analytics (4 videos).4. Full R series Beginner to Advanced (12-15 videos).5. Statistics in Data Analysis (3-4 Videos). This.
40
147
925
It is with a sad heart to announce I will no longer be continuing my YouTube channel. I’ve grown my channel beyond what I could have ever imagined and offered free educational content to millions around the world. I have signed an exclusive deal to create Analytics content for a.
283
73
891
Here are some of my favorite FREE resources for learning Tableau! . A Thread ->.
29
300
876
When I met my wife I was making $10 per hour and renting a room in a house outside of Dallas, TX. I was making 32k when I knew I wanted to marry her (and luckily she felt the same way!). We went ring shopping and all the rings were way out of my budget, but there was one she
52
108
888
Today we finish our Power BI Tutorial Series with the Final Project!. In this project we use real data from a survey we took about 2 months ago and we build a full dashboard from scratch!.
21
212
812
Learn Power BI in under 3 Hours!. In this weeks lesson we take a crash course of Power BI to get you up and running! We dive into Conditional Formatting, DAX, Drilling Down into Data, and we even build a full project!.
4
187
843
I've never had anything go viral on YouTube, but today I had my first video to ever reach 1 Million views!. I have over 200 videos on Data Analytics and out of all of them this video was the first. Took almost 2 years for it to get there, but it got there!
37
72
800
Data is never going away. So learning skills focused on data will last a lifetime.
29
195
821
Taking some big leaps in the next few months! Thank you all so much for everything - it’s truly been life changing! More updates on this in the next video 👍
57
48
815
Low key, Data Analysis is sexier than Data Science.
46
136
709
The data community on Twitter is far wilder than LinkedIn and Instagram… I had no idea.
51
99
699
The best data analyst doesn’t always get the job. The one with the best marketing skills usually does.
13
93
654
I went from a Junior Data Analyst to an Analytics Manager in 5 years. Here are some of my best tips to get promoted quickly:. 1. Take on important projects and work. If you only work on small projects your impact will always be small. Large projects are often vertical and will
13
140
640
This is my office in all its glory. It’s not much, but from this room I reach about 2 million people per month on my YouTube channel, LinkedIn, X, and Instagram. Nothing super fancy, but it gets the job done!
46
40
647
Learn Excel for Analytics in Under 3 Hours!. In this weeks video we are diving deep into Excel to look at Pivot Tables, Conditional Formatting, Data Cleaning, and more!.
3
152
644
It has been said that SQL is the meat and potatoes, the main course, for data analysts. If that's true, Excel would be the appetizer to get you started. Tableau would be a nice wine to pair with the meat.
16
129
615
Most people only focus on the Base Salary when considering a job offer. Here are 7 other things you should consider when looking at a job offer:. A Thread ->.
12
177
608
You get into Data Analytics thinking you're going to build dashboards and find insights into data. And then you get your first Data Analyst job and you start working with real data. You find out it's a lot more than dashboards. You're aggregating data from multiple data sources,.
18
138
607
"Data is the new oil". The importance of data analytics is continuing to grow. As we move further into a digital era, the value of understanding the basics of data analytics will continue to rise, and here's why:. Data-Driven Decision Making.Businesses and organizations are.
13
167
596
Did you know I have a completely FREE Data Analyst Bootcamp??. It'll teach you everything you need to know to get started in Data Analytics! You'll learn SQL, Excel, Tableau, Power BI, Python, Pandas, and more!. You'll also learn about Data Cleaning, Exploratory Data Analysis,
22
167
607
60% of my career has been built on effective Googling. 40% on Stackoverflow.
16
108
592
Unethical Life Hacks in the Workplace (Part 2):. Does you employer check your activity on Skype? Teams? Slack?. Use this Python Script to automatically move your mouse every few minutes to keep you active. They'll never know…
9
103
574
200k usd?? “Average”??. Where?.
Data Analyst is one of the highest paying fields in IT and also one of the fastest growing!. The average Data Analyst salary is $200,000 a year. If you want a career in Data Analytics, I will share with you all today 12 FREE courses that will help you. Indicate your interest.
60
135
592
I got started in Analytics while working at a non-profit living paycheck to paycheck. I'd study SQL, Python, and Excel at night when I got home from work. The investment really wasn't the money I spent on courses. It was the time and focus putting in the hours learning and.
19
90
577
My prediction is that we will see a large rise in Freelancing/Consulting in Data in the next 5 years. There are tens of thousands of companies right now that don't have any dedicated data team. They may not have the infrastructure or the budget to establish one in-house.
25
125
572
I landed my first 2 data analyst jobs working with recruiters!. I highly recommend using them during your job search!
14
87
555
What certifications should you get after completing my Free Data Analyst Bootcamp?
8
120
552
Kaggle is a fantastic free resource to learn from! . They have free courses on Python, Pandas, SQL, Data Cleaning, Data Visualization, and more!. Definitely worth checking out!.
7
143
545
After you become a Data Analyst you should also learn about the roles of the team you're working with to better understand the entire process of the data. 📊Learn from Data Scientists. Data scientists focus on cleaning data, extracting insights, and building predictive models.
9
161
537
The genius who didn't buy Bitcoin in 2015.
52
27
556
I love Data Engineering!. As a Data Analyst for the past 7 years I find myself loving the work of Data Engineering more and more. I think there is actually a lot of crossover and overlap to Data Analysts as well. If you can learn how to create simple pipelines from source.
24
84
521
Once you're done with the "Data Analyst Bootcamp", you can go to my GitHub and download the Certification for free. Then you can put "Data Analyst Bootcamp" on your resume in your Experience Section.
37
21
508
Do you need to learn SQL or can you just use Python for everything? 🐍
14
83
506
This week we are starting our AWS Series!. In this series we will cover S3, Amazon Athena, Glue, Glue DataBrew, and Quicksight!. In this weeks video we will be setting up our AWS account and walkthrough the UI. Link to AWS Setup:
4
127
522
After looking at the analytics for my Data Analyst Bootcamp, so far about 2,500 people have started the bootcamp… PER DAY. It launched almost exactly 1 month ago and almost 75k have people started the Data Analyst Bootcamp since it started!. That's insane!!.
22
40
494
A lot of people are looking for jobs right now and I want to help!. I made a full course on Creating a Resume, Building a Portfolio Website, Working with Recruiters, How to Interview, and more!. If you use Code "DATAJOB" at checkout you can get it for Free!. Hopefully it will
28
107
520
I learned Python about 7 years ago and I'll admit it was extremely difficult for me. I didn't have any background in coding or computer science so I really didn't understand how to do anything. Here's what I found out about learning a programming language from scratch:. 1.
11
91
500
Ever seen a dashboard like this?. I've been a Data Analyst for almost 7 years. I don't think I ever made or created a dashboard that looked like this. Almost all Dashboards I created had between 1-3 charts/graphs each. Anything above that and people would get overwhelmed and
33
77
484
I'll be doing a video soon on using ChatGPT for Data Analysis! . I gave ChatGPT a dataset and asked it to break out a column that had a city, street, and state in it into 3 separate columns. The output is almost exactly how I've done it in real life! . Super neat!
9
66
483
Someone said they finished my Data Analyst Bootcamp on YouTube, but were complaining they hadn't landed any interviews yet. I asked if they had applied to jobs and they said no 😂 😂. Not everyone is cut out for the employed life. .
27
50
478
I went from being a Mid-Level Data Analyst to an Analytics Manager at a Fortune 500 Company making over 125k. I was fairly shocked they gave me an interview and I was even more shocked that they offered me the job!. During the final interview the hiring manager, my soon to be.
13
64
489
5 Years ago I posted my very first video on YouTube!. It was titled "Top 3 Data Analyst Skills in 2020". I recorded it on my iPhone 6s and I wore my nicest button up I owned at the time because I wanted to look professional. Since then a lot has changed!. I invested in some
27
34
492
If I died tomorrow almost none of you would notice. Videos would stop getting posted, X posts would stop being made, and people would move onto new content. If I died tomorrow my kids wouldn't see me at their soccer games, sitting around the table for dinner, or out in the.
28
94
474
Next week we'll be opening up the waitlist for everyone who wants to join the Beta launch of Analyst Builder!. Analyst Builder is your all-in-one platform to become a Data Analyst. It has Full Courses (taught by myself), Crash Courses for interviews, and a Questions section to
41
83
468
Here is a very realistic breakdown of where you'll spend your time as a Data Analyst:. 📥Data Collection and Access (15%): This involves understanding the client's data needs, identifying the necessary data sources, and getting access to this data. This often involves arguing.
13
189
460
I'm honored to have my Free Data Analyst Bootcamp featured on @freeCodeCamp !!. I've been using freeCodeCamp since I started programming over 6 years ago and they've been an amazing resource for millions of people around the world!. So happy to contribute to the Open Source.
13
91
461
I filmed my first YouTube video 3 years ago on my Iphone 6s!. We had two kids at the time and we didn't have extra money for a nice camera and microphone, but I went for it anyways. If you don't start with what you have you'll never start at all. Start small and build from.
18
100
446
I took one week of work completely! No meetings, no social media, nothing. Am I a hero? Yes. To my family at least. I don't plan on letting my work and career ever get in the way of spending time with my family. What good is it to give my family everything, but not be there to
22
20
458
4. The "Certification" at the end doesn't hold any weight for getting a job, but it helps share the hard work you put in. In all honesty, I called it a "bootcamp" to be ironic, but it really can help you get a job if you put in the work.
10
78
447
WOW!! Today we hit 250k subscribers and 10M views on the same day!. I didn't even know there were 250k people who would be interested in this type of content, but I'm glad there are :). The data world is huge!. #YouTube #dataanalytics
25
28
436
🎉We hit 500k Subscribers on YouTube!!🎉. I can't believe the immense support I've received from you all the past 3 years. It's hard to imagine half a million people out there wanting to watch my videos and be a part of this community!. You guys have meant the absolute world to
42
20
435
Most people think Analysts just build dashboards, but let's look at some other things Analysts do:. 1. Data Collection (one of my previous jobs was 80% data collection).2. Data Cleaning.3. Data Quality.4. Testing Code and Debugging (QA Analysts spend a lot of time doing this).5.
6
130
445
I honestly think 40 hours per week is too much. For employees and for students. I honestly can’t focus for 8 hours a day. I can usually do maybe 5 hours of solid work.
11
61
427
Cleaning and Transforming data is one of the most time consuming parts of using data in the real world. In this week's MySQL tutorial we dive into the basics of Data Cleaning with real tech layoff data.
8
116
439
I don’t talk about this enough, but I wouldn’t be where I am today if it wasn’t for my wife. She pushed me past my comfort zone and always believed in me. She saw the potential in me even when I was making no money. I really owe a lot of who I am today because of her!. It’s
21
69
425
Here were the Data Analyst Tools I used in my career:. Year 1: SQL and Excel. Year 2: SQL, Excel, and Tableau. Years 3-4: SQL, Excel, Tableau, Python, and Azure. Years 5-7: Any tool that's best for the task. Years 5-7 were pretty transformational because I really started to.
14
84
423
After about 2 years working as a Data Analyst I realized almost everyone is winging it! No one knows everything and people do a lot of research to figure things out - they don't just know it. This completely baffled me because I thought you needed to really know almost.
19
104
431
SQL Interviews are everywhere!. Interviewers do this to ensure you are experienced enough in the skill to use it in the position they're hiring for. They don't want to have to teach you everything from scratch - even if you're a beginner (you should still know the basics well).
17
82
424
Sometimes you have to be a bit shameless to get your first job in data. Messaging people, sending your resume to people, calling recruiters, posting on LinkedIn about needing a job - no one will remember that in 10 years, they will just see your success. It really is a grind.
6
99
422
This week we are starting our MySQL Series! It will go through the basics, intermediate, and advanced concepts in MySQL!. This will be replacing the MSSQL series in my Data Analyst Bootcamp so Mac users can more easily take the bootcamp. Here is a link to the full current.
7
86
415
Did you know I've basically open sourced my entire YouTube channel?. That means anyone around the world can use my content free of charge on or off YouTube. As of today there are over 10 non-profits using my videos in their curriculum who help individuals break into tech!. I've
30
38
405