Alex Freberg

Alex Freberg

These are the best posts from Alex Freberg.

64 viral posts with 39,374 likes, 2,911 comments, and 1,231 shares.
21 image posts, 0 carousel posts, 3 video posts, 38 text posts.

👉 Go deeper on Alex Freberg's LinkedIn with the ContentIn Chrome extension 👈

Best Posts by Alex Freberg on LinkedIn

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 genuinely confused with so much going on.

Keeping things simple and straight forward for the people consuming the reports was always top priority.

You make enjoy creating the complicated, advanced dashboards, but if it doesn't help your end user it really isn't helpful.
Post image by Alex Freberg
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 will fill in a lot of gaps that my YouTube channel currently has in Analytics and I hope will help a lot of Analysts out there!

If you have any other suggestions on videos or series let me know!
Year 1:
Coworker: “Do you know Excel?“
Me: “Yeah, absolutely! How can I help?“
Coworker: “I have these 10 projects I need help with. Really appreciate your help!“

Year 5:
Coworker: “Do you know Excel?“
Me: “I've never heard of it. Is that some kind of CRM?“
Coworker: “Oh, I'll go ask Bob. Thanks anyway.“

Life Lesson: Never tell your friends or coworkers you know Excel.
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. A/B Testing
6. Data Modeling
7. Exploratory Data Analysis

This covers a large portion of what an Analyst will do! I've worked in roles where it's 80% data collection + 20% data cleaning. Or 50% dashboards and 50% EDA. Every role is different and each wears many hats!
Power BI is like my therapist. Easy to talk to. Insightful. Says my best friend is a bad influence on me.

Qlik is like my personal trainer. I don’t really want to use them, but I will if I’m desperate.

Alteryx is like my lawyer. Expensive. I don’t fully understand what they do. But does the complex work me so I don’t have to do it myself.

Google sheets is like my barber. Useless.
(Ignore my face) because I'm releasing a new 2026 FREE Data Analyst Bootcamp on YouTube next Week!!

I created the first ever Data Analyst Bootcamp about 3 years ago and millions of people have taken it. Since then, I've created a lot more content and I wanted to update it.

Here's what it already included:
1. MySQL
2. Excel
3. Tableau
4. Power BI
5. Python
6. Pandas
7. Building a Portfolio Website
8. Creating a Resume
9. Practicing for Technical Interviews
10. Azure
11. AWS
12. How to use LinkedIn to Land a Job

New Content Being Added:
13. R for Data Analysis Series
14. Git and GitHub Series
15. Data Fundamentals Series
16. Databricks for Beginners Series
17. ETL in Databricks Series

This will be the longest free Data Analyst Bootcamp in the world (clocking in at around 29 hours). It took 3 hours just to download it!

I'm super excited and hope it'll continue to be extremely helpful to everyone out there trying to learn data skills!
Post image by Alex Freberg
Some of the best advice I never took:

1. Alex, you probably shouldn’t make Data Analyst content with only 3 years experience. You should wait until you have 7-10 then you’ll really know your stuff.
2. Alex, you’re only 21. Don’t get married, you should establish your career first.
3. Alex, you should wait to start a business until you have more savings and more experience.
4. Alex, don’t buy a house yet. The market is too uncertain.
5. Alex, wait to have kids. Go and have fun with nothing tying you down.

All well-meaning advice from people close to me, but if I had listened I would be single working a dead end job.

Sometimes you have to be bold and go after things you want instead of settling for what everyone else thinks you should do.
Post image by Alex Freberg
What's the difference between a Business Analyst and a Data Analyst?

I've worked with both and even hired both. Here's my thoughts on the difference!
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...
I'm not one for conspiracy theories.....

but it looks LinkedIn doesn't want their employees to complain about their pizza party this year...
Post image by Alex Freberg
SQL, Excel, Power BI, and Cloud Computing are still the most in-demand skills for almost all data professionals.

Whether you're a BI Developer, Data Engineer, or Data Analyst - you'll most likely still be using at least 1 or all of these skills!

I've built entire Playlists on YouTube for each of these that you can learn for FREE:

1. SQL: https://lnkd.in/e-wkYT9f
2. Excel: https://lnkd.in/eKF4i2ud
3. Power BI: https://lnkd.in/gEzpDCuF
4. AWS: https://lnkd.in/eP--T7m8
5. Azure: https://lnkd.in/eA8ytqWV

I've also built entire courses that go 50% more in-depth and have Real-World Projects:

1. MySQL for Data Analytics: https://lnkd.in/gA9TmDpu
2. Advanced MySQL for Data Analysis: https://lnkd.in/gJ_sSggZ
3. Excel for Data Analytics: https://lnkd.in/efm4_DKu
4. Advanced Excel for Automation: https://lnkd.in/egbMPbYg
5. Power BI Desktop for Business Intelligence: https://lnkd.in/dJhHRv3Z
6. Cloud Computing Essentials with Azure and AWS: https://lnkd.in/eiZmDw6V

These skills build the foundation of what Data Professionals work on in the real world. Working in Databases, Visualizing Data, Transforming Data, and Collaboration.
Post image by Alex Freberg
Count your days Apple....
Post image by Alex Freberg
I don't know who needs to hear this, but that recruiter ain't calling you back.

Move on. Find a better recruiter.
6 years..... 6 longs years creating videos on all things Data Analytics...

And it's been and amazing 6 years!!

I started making videos in January of 2020 because I didn't think there were enough free resources for people trying to break into data - so I wanted to change that.

I started making videos on SQL, Excel, and Tableau. The basics. And then I just kept going!

I loved getting feedback that people were learning from my videos and it was actually helping them get jobs and upskill into better paying jobs.

All I've ever asked in return was that you like and subscribe and over 1.25 Million people have!!

So thank you for supporting me after all these years. I have no plans on stopping or slowing down - I'm having just as much fun making videos today as I was 6 years ago.

Thank you all! I'll see you at year 7!
Post image by Alex Freberg
Working from home has increased my quality of life substantially. I’ve been able to spend so much more time with my kids and my wife and honestly that makes me work harder when I do sit down to work!

What would you say is the biggest upside to working remote?
I've consulted with 20+ companies in the past 2 years. Every single one still writes SQL, Python, and other programming languages by hand. They use Power BI and Excel just like you and me.

They have issues with duplicates, data migrations, making use of their data.

They use AI, but it doesn't do everything for them.

People get lost in the buzzword of AI and assume all problems are solved and Data Analysts, Data Scientists, and Data Engineers are no longer relevant.

The real world is a great example of that not being the case.

This is why I still stress knowing the basics!
I have over 400+ videos on Data Analytics - that's too many for one person to watch.
 
Here are the top 5 that I would watch:
1. How to Become a Data Analyst - https://lnkd.in/gA6f9XHJ
2. Complete FREE Data Analyst Bootcamp -  https://lnkd.in/eDiihce2
3. Learn Power BI in Under 3 Hours - https://lnkd.in/e92EpFyB
4. Top 5 Reasons NOT to Become a Data Analyst - https://lnkd.in/ep7aJPZr
5. Learn SQL in 4 Hours - https://lnkd.in/e97a4vxG
 
Some of these videos are ones I made over 5 years ago, but they still hold true today.
You are going to make mistakes in your life and your career.

You will 100% regret things and wish you had done things different. But you can't change it! So stop living in the past and start preparing for your future.

Learn from those mistakes and don't let them control you. Create a plan and move forward.

You only get one life - don't waste it dwelling on your mistakes. It can consume your everyday or you can move on and live a fulfilled life.
In 24 hours 28k people started the 2026 Data Analyst Bootcamp!

3 million people started the first one I launched 3 years ago, but only around 10k people finished. That’s a 99.7% dropout rate.

So if you complete it and put in the work you’re proving you have a lot of determination and perseverance that most people don’t.

Use this time to upskill, learn, and advance your career!
Post image by Alex Freberg
Want to be successful in 2026? Be Consistent!

Consistent in applying to jobs. Consistent in learning new skills. Consistent in staying healthy.

Consistency is what most people lack! Don't give up on something just because it doesn't work exactly how you thought it would after a month. You know what you're doing is good, but you need to stick with it!

One week, I accidentally didn't post on YouTube after about 4 years of posting every week on Tuesday morning. I had people reach out to me asking if everything was okay. If you're consistent people will notice!

Be so consistent this year that people notice.
Having a good foundation in Statistics is really important when working with just about any data!

I'm recording my new course for Analyst Builder which will cover:
1. Foundations of Statistics
2. Describing Data (Spread, Outliers, Mean, Median)
3. Probability
4. Sampling Data
5. Relationships (Correlation, Pearson vs Spearman, Linear Regression)

In the relationships chapter we actually learn how Linear Regressions are calculated and build our own from scratch!

These are all things I wish I knew when I first started!

This will be available next month once I finish recording and get it all edited :D

I'll also be releasing a short Statistics series on YouTube that will launch after the PostgreSQL series!
Post image by Alex Freberg
A funny thing I’ve found is that the higher paying the job the more freedom they give you.

Low paying jobs pay you less for a few reasons:
1. They don't have the money to pay you a reasonable wage
2. The role is easily replaceable
3. They are stingy and want to maximize value

So they'll track every minute, police breaks, watch attendance like a hawk, and measure productivity daily.

Higher paying jobs can sometimes do this, but more often it's the opposite.

You'll get more freedom because:
1. They're trusting you to be the expert.
2. They're paying for you judgment and not labor
3. They care more about the outcomes rather than staying busy

I've worked and consulted for every kind of company - big, small, startup, Fortune 500, big tech - almost always, the ones that pay more are more relaxed because they're trusting me to do what they paid me to do.
My Data Career Book Officially Launches Today!

Check it out: https://lnkd.in/eDhimKCD

In this book we go Beyond the Interview and talk in depth about how to Build your Data Career from Day 1.

We talk about how to:
- build a strong 30/60/90 day plan
- avoid the common mistakes that derail new analysts
- communicate with managers, stakeholders, and executives
- position yourself for promotions, raises, and long-term career growth
and a lot more.

I share a lot of personal stories and experiences I've had along the way and I hope that this book really helps you in your Data Career!
Post image by Alex Freberg
Needing some feedback on a new Profile Picture.

Which one fits me the best? I haven't had hair in quite some time so not sure what's in with the Kids these days.

Want something trendy that also says "I know data".
Post image by Alex Freberg
My wife and I were both offered jobs on the same day, but we could only take one.
 
She was offered a Senior Position in Oklahoma for Counseling for 100k. I was offered an Entry Level Data Analyst Job in Dallas for 63k.

She had just gotten let go from her job so were only on my 47k per year salary which wasn't enough to provide for our family.

It was a very tough decision. Neither of us wanted to move to Oklahoma, but there was more money there.

After a few days we agreed to let me take a stab at this "Data" thing and see if I could make it in that industry since we saw a lot of future potential in it.

Fast forward 8 years and I would say it was the best decision we could have made. Taking a leap of faith doesn't always work out, but if you don't ever try and you always play it safe it's almost impossible to make it big.

Sometimes you just have to believe in yourself and go for it if you see the long term potential.
It's all fun and games until John from Accounting racks up a $20k bill in one month.
Post image by Alex Freberg
After a lot of feedback, here is the new updated for 2026 on my YouTube channel:

1. Soft Skills in Data - 3 Videos (currently releasing)
2. PostgreSQL series - 10+ Videos
3. Databricks IDP - working with Unstructured Data - 5 videos
4. dbt for Data Analysts - 3-4 Videos
5. Alteryx for Beginners - 3-4 videos
6. Data Pipelines for Dummies - 5-6 Videos
7. Statistics for Data - 3 Videos
8. Show us the Data Series (Digging into real world data) - 5 Videos
9. Duckdb for Data Analysts (3 Videos)
10. Building and Maintaining APIs- 5 Videos

I release 1 video per week so this should be almost all the videos I make for the whole year!

It's a lot! I hope these really help a lot of people out there and if you have any other ideas or suggestions please let me know! I'm always adding to my list!
I've made 436 videos on YouTube.

Here are some of the lessons I've learned along the way:
1. Consistency is more important than perfection
2. Some videos will flop and others will be huge. Don't worry if a few don't get views.
3. Almost no one will care if you get no views, but lots of people will notice when it starts to grow. It doesn't hurt to try.
4. You don't have to be an expert to make a video. Know 90% and start recording - you learn more when you try to teach it.
5. You will have people not like you, even though they've never met you. They don't know the real you so just move on.
6. Don't rewatch old videos if you get embarrassed easily
7. Try to really help people and if you only help 1 you were successful
8. People want the best equipment to get started. I still don't have the best equipment. Use what you have now.
Post image by Alex Freberg
Invisible work is the reason people won't be replaced by AI.
 
Most people aren't just doing their job description - they're doing hundreds of other small things that keep the business running that you can't program a system to do.

They’re constantly filling the gaps between what the process says should happen and what reality actually requires.

That kind of work rarely shows up in a dashboard. It’s hard to measure the crisis someone prevented, the customer they calmed down, the misunderstanding they caught early, or the meeting they made useful because they knew who needed to hear what beforehand.

I know a lot of people won't agree and think everything can be programmed and will lead to mass unemployment, but I just don't think that's the case.

The value of people is not only the visible output, but also the invisible output that keeps a business running.
If I were applying for a job today here is what I would do:

1. I would look up 10-15 companies that I'm trying to target for a job.
2. I would look up job postings for roles I'm qualified for and create 2-3 custom resumes to use to apply.
3. I would apply to all open positions at those companies and then reach out to recruiters and hiring managers who work at those companies/for those specific jobs.
4. Create a Spreadsheet of all these roles and track responses.
5. Follow up. If I don't hear back in a week.
6. Rinse and Repeat.

I would also be focusing on local jobs that are in-person as there will be a lot less competition. If I was out of work I would be willing to relocate for a role.

The job market is tough! But it wasn't ever super easy. It took my about 6 months or applying to 1k+ jobs back in 2017 to land my first real Data Analyst Job.

There are still great companies hiring if you look in the right spots and apply strategically.
3 Years ago I was offered a job at PwC as a Senior Data Analyst Consultant.
 
The offer was around 140k and I was making 100k at the time. I had just started doing Consulting on the side and was starting to get some clients and make some money from that.

PwC is a big Consulting company and I know that would have looked good on my resume and would help my credibility with other companies and future work.

I was researching PwC and all the reviews said it was a lot of hours, a lot of travel, and not a good work culture. My work-life balance was great at that time - I was spending lots of time with my family, taking trips here and there and I wasn't willing to sacrifice that.

So I turned it down and haven't regretted it for a second!

Since then, I continued to scale up my own Consulting business and have worked with large tech companies and a lot of startups in Silicon Valley. And not once have I looked back and wish I'd taken it.

I get to pick and choose who I work with and I don't have to travel all the time and be away from my family.

As I get older and my kids grow I value that time with them a lot more than I do the extra money that would have come with that job.
Posting on Social Media can change your life completely, but most people give up if they don't get 100 likes on a post in a month.

I started posting on Social Media in January of 2020. I didn't just post about anything that came to my head, I had a plan. I wanted to post about Data Analytics and share things I was learning as I grew as an Analyst.

I was finding groups on LinkedIn, Facebook, Reddit, and other platforms where they were already interested in things I was going to post about.

I started with SQL, Excel, and Tableau (things I was actively using in my job) and as I learned more I posted more about different things like Azure, Python, and Databricks as I started using them.

I got very few "likes", "favorites", etc. because people didn't know who I was. I had no track record of knowledge in this area. After a few months though, people started noticing I was posting a lot on topics they were interested in and what I had to say was useful.

You can't build a following or grow a personal brand in one day. Maybe some do out there, but that's like winning the lottery.

So here's what you do step by step:
1. Figure out what you want to post about
2. Find groups that value that type of content
3. Post consistently in those groups as well as just in general on your main accounts
4. Keep sharing as you learn more
5. Don't stop

It's not an easy path, but it is a path that will take you where you want to go over time. You don't need 100k followers to have a personal brand. Finding 1000 people who value what you have to say is still a good personal brand!
The issue with the Economy, Companies, and Politics boils down to Greed.
 
A father of 3 used to be able to work at Sears 30 years ago and he could retire with a pension, paid off house, and savings.
 
Today, companies want to make record profits and give their employees as little as they can. Not because they need to, but because they want to maximize profits (no other reason).
 
The father of 3 at Sears wasn't lucky - he was working in a system that hadn't yet decided employees were a cost to minimize instead of an asset to invest in.
 
We need to go back.
What are your New Years Goals going into 2026?

Here are some of my personal goals:
1. Write a full book on Analytics (Not on how to become one, but a guide once you are) - probably finish 2027
2. Make new Series on Alteryx, Snowflake, DuckDB and others on YouTube
3. Make Analyst Builder even better for every Analyst out there
(AI Resume Reviewer, Mock Interviews, Integrated Full database)
4. Travel less for work this year and go on more small trips with the family (hiking, beach, etc.)
This week we are starting our PostgreSQL Series!

This series we will be going beyond just queries, but we will be starting with it to build the base. We will also be learning about connecting databases to apps, using APIs, and more.

PostgreSQL has become one of the most popular SQL Databases to work with due to the rise of AI.

PostgreSQL became the default for AI apps because pgvector lets you store embeddings right next to your structured data with no separate vector database needed.



https://lnkd.in/eJnP42Pq
I've helped millions of people around the world learn tech skills and land data jobs.

I get messages every day on what helped them land jobs and here's what I've been seeing:

#1 - Domain Knowledge (35%)
I get messages that say "I was a nurse..."/"I was a teacher..."/"I worked at a bank... and then I transitioned into a data role". They're using their domain knowledge to switch jobs - adding in technical skills they've learned.

#2 - SQL (25%)
"I work at a small company and they use SQL so I learned it from you and they gave me the chance". I'm surprised at how much I get this job. Local, small companies have been great places for people to upskill and transition into data roles.

#3 - Cloud Platforms (25%)
"My company switched to AWS (or Azure or Databricks)...". Companies are migrating to the cloud and they need people who know how to work in it. Being early to learn these tools gives you a massive edge.

#4 - Miscellaneous (15%)
"My best friend got me an interview"/"A recruiter on LinkedIn reached out to me." - lots of different stories.

From all of these messages it's apparent there is no 1 way to get a job.

The best thing to do is to upskill - learn technical skills, get a job in an industry and learn it, and work with recruiters.

I show how to do all of these things on my YouTube channel "Alex The Analyst" where you can learn all of these things completely free!

You can also learn on my platform AnalystBuilder.com where you can take my full courses and learn everything more in-depth with hands-on practice questions.
Everybody wants to use the data.

But no one really wants to get to know the data first.

What happened to first dates? Not even a walk next to the data lake?

Straight from Raw data to insights with no warm-up and you’re shocked when the insights feel a little… underwhelming.
My 13 year old said she heard that Tik Tok collects people’s data and it’s really valuable and now her friends think I’m cool because I work with data.

I don’t make the rules.
“At this moment, lying in bed, sick and remembering my whole life, I realize that all the recognition and wealth I have is meaningless in the face of imminent death. I have the money to hire the best at any task, but it is not possible to hire someone to carry my disease. Money can get you all kinds of material things, but there is one thing you can't buy: "LIFE".
- Steve Jobs

When I'm on my deathbed (if I make it that far). I want to know that my family came first. Money was always important to have to do things and pay bills, but that it wasn't my main motivation or thing I lived for.

Money will come and money will go, but if my family isn't there I know I'm in the wrong place.
Technical skills are 20% of the job... but you 100% have to have them to get most jobs in data.

Here are the other 80% of skills that actually matter once you get the job:
- Turning vague questions into clear problems you can actually solve
- Knowing when “good enough” is better than perfect
- Communicating insights in a way non-technical people understand
- Asking better questions than anyone else in the room
- Understanding the business behind the data
- Managing stakeholders (and their expectations)
- Prioritizing what actually matters vs. what’s just noise
- Being reliable and hitting deadlines consistently
- Documenting your work so others can use it
- Not overcomplicating things just to look smart

You still need the hard-skills (and they're important for getting a job), but in the real world they aren't 100% of what you need.
Took the morning off to have breakfast with my wife!

My work will still be there when I get back.
Post image by Alex Freberg
AI is becoming part of how we work, create content, communicate, and solve problems every day, but knowing how to use it well is a skill on its own. #sponsored

I recently took the Google AI Professional Certificate in its entirety and here's what I really liked:

1. The Hands-on Labs where you implement AI using Google Gemini
2. The Google Instructors had great, applicable stories and delivered the content well
3. The Quizzes which give real-world scenarios

Genuinely one of the better certificates to learn AI! Try it out for yourself: bit.ly/4teRGgn

 #GoogleCareerCertificates #GrowWithGoogle @Grow with Google
Here are the current things I'm working on in my different businesses this week:

1. Porting over Videos and Emails to new systems for Analyst Builder
2. Working on Google Contract for the AI Professional Certificate
3. Starting new Consulting Contract with a Tech Startup in Silicon Valley
4. Finalizing new Statistics for Data Professionals course for AB
5. Creating new Weekly Video for YouTube releasing tomorrow
6. Planning out next YouTube videos after PostgreSQL series

There's a few other small things, but these are the things I'm working on in one week.

Working for yourself full time is about 2x the amount of work that I had in a full-time job, but I enjoy it much more and get to do what I want to do so I'd say it's very much worth it.
Big Tech used to be the pinnacle of success as a Software Engineer, Data Analyst, Program Manager, or really anything else.

It came with prestige, high pay, and unparalleled benefits.

Those days are gone (for now).

For the past several years, Big Tech has been a gamble. Will you have a job next year? Will you position get cut our of nowhere? Nobody knows!

Because they're mainstream brands they know there is still a line of people waiting to fill any job they have and are willing to risk being fired the following year with no backup plan.

I'm not one for being discarded like my work meant nothing, but to each his own.
Post image by Alex Freberg
You are the sum of your daily actions.

If every day you get up and make good choices for your health, family, community, and career - you're going to see positive change.

If your everyday choices are poor you probably won't have the life you were expecting.

The daily habits that I try to do every day:
1. Breakfast with the family
2. Read Bible and workout (mostly push ups)
3. Focus on work and don't get distracted with other things
4. Spend time with Family in the afternoon
Saying "No" can get your farther in your career than saying "Yes".

Say No to:
- Jobs that don't pay you what you're worth
- Bad bosses
- Staying late because everyone else does
- Work that doesn’t use your strengths
- Every request that comes your way

Saying Yes to these things can set you back years in your career. Know yourself, your strengths, what you want and say Yes to those things and no to everything else.
I've been making videos on YouTube for over 6 years!

Next week I'm going to start making a 2nd weekly video for the first time ever.

I've always wanted to do a Weekly Recap in Tech and Data video, but I've just never had the time, but I want to make time as I really enjoy those types of videos myself and love keeping up with everything that's happening.

I'm going to test it out for a few months and see how it goes. I'll start releasing 2 videos - my normal one on Tuesday that will remain unchanged and one on Thursday which will be a weekly recap.

This is something fun I've been wanting to do so I'm finally doing it!

I hope it'll be something fun people look forward to each week!
I'm excited to announce that a handful of my courses from Analyst Builder will now also be on LinkedIn Learning!

We've had so many people over the years ask for this and today we are finally making it happen!

Here are the ones you can take today:
1. Tableau for Data Visualization
2. Excel for Data Analytics
3. Advanced Excel for Automation
4. Advanced MySQL for Data Analytics
5. Git and GitHub for Data Professionals
6. Soft Skills for Data Professionals

2 other courses will launch on LinkedIn Learning in the next 2 weeks:
1. MySQL for Data Analytics
2. Databricks for Data Workflows

You can find all of these courses on LinkedIn Learning here: https://lnkd.in/etmK9QwN

We won't have all the courses from Analyst Builder on LinkedIn Learning, but these are some fantastic courses to take and upgrade your skills!

Related Influencers