Trying out a new Header today to capture more quickly what I do and who I am. @canva is a great platform for a design newbie like me 😁

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.

You're asked to calculate the ROI for each Marketing Campaign and identify the top 25% of campaigns with the highest ROI. Can you do it?? This is the kind of queries you'll write in the real world - although the formulas and code won't always be so straight forward. See if you're able to get the right answer without any hints! Try it here: analystbuilder.com/questions…

In this weeks PostgreSQL lesson we are learning how to filter data! youtube.com/watch?v=qmQZ2jI3…

My son's soccer team went undefeated for the second year in a row! Each year I get a group of random 7 year olds and it's my job as coach to mold them and shape them into a unified team of star athletes. Well at this age, maybe not so much, but I do try to get them ready for the season. When I coach sports at any age I teach 2 things: Fundamentals and Hustle The harder thing to teach is hustle - which is what wins us most of our games. Fighting for every ball, not stopping until the whistle blows, running back when they get by you with the ball. When they do these things they outwork 99% of other teams.

I've gotten well over 100 Resumes and Portfolios sent to me in the past day and we are going to review them live! Livestream starts at 10am EST (about 1 hour)! youtube.com/live/Yei952XRCPs

Early in my career, I worked on double blind studies and we relied heavily on patient surveys - but patients don't always respond. So we would often sample data. Sampling is the practice of analyzing a subset of your data to draw conclusions about the whole. And it works surprisingly well when done right. Here's why sampling is useful: 1. Not everyone fills out a survey. Not every system logs every event. Sampling lets you work accurately with what you have instead of waiting on data that may never arrive. 2. A well-drawn sample accounts for gaps in your data so one missing group doesn't skew your entire analysis. 3. You don't need every data point to draw reliable conclusions. A properly selected sample can be just as accurate as the full dataset. Of course, there's a lot that goes into sampling correctly so you don't get incorrect results! I'm recording my full course on Statistics for Analyst Builder so statistics has been top of mind the past few weeks! I'll also be creating a Statistics Series on YouTube after the PostgreSQL series :)

This Friday at 10am EST - I'll be reviewing your Resume and Portfolios live! Send your resume and portfolio to AlexTheAnalystYT@gmail.com to be reviewed live! youtube.com/live/Yei952XRCPs

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.

In this weeks PostgreSQL lesson we are starting with the basics of Select and From. These are the building blocks of writing SQL and are used in almost every query you will write. youtu.be/YkIA8dS8LuI?si=AoPJ…

In 40 years, I don't want to be divorced, have estranged relationships with my kids, and wish I spent more time with my family. I've met a lot of people who regret prioritizing their careers over their families. I've met very few who regretted prioritizing their families over their careers.

"AI, what is it like working from home during the summer with kids?" I think this about sums it up. Working from home has some massive upsides! Most of those are taken away when your kids are home 24/7 😂

My wife and I attended what I would say is the strangest dance performance I've ever seen. We went on a whim and let me tell you... it was an adventure! Towards the middle we couldn't stop laughing so we had to leave. Find someone who you can laugh with and be best friends with and you'll never be poor in life. A good spouse is worth more than all the riches of this world.

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.

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. youtu.be/USOqNVz3gXQ

Kayaking with the family this Memorial Day! Feels good to get out on the water. Spending time with the ones you love is always a good ROI.

DAX is what separates Power BI users from Power BI developers. Most people can drag fields onto a canvas and call it a dashboard. But the moment someone asks for year-over-year growth, a running total, or a metric that respects filters the way the business actually thinks - you need DAX. And the first real test is knowing when to use a calculated column vs a measure. Get that wrong and your model bloats, your reports slow down, and your numbers stop making sense when someone clicks a slicer. Get it right and you stop being the person who builds reports and you become the person who builds models other people build reports on.

Listen, I know people are trying to grow their brands and get noticed - but  optimizing for engagement is super lame. Why don't you just be you - write interesting content and build things and share things you actually like. Stop trying to fit your content for the masses when maybe you need to be bring people into your fandom - who you are. The people worth having around will find you because of who you are, not because you cracked the algorithm.

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!

The new 2026 FREE Data Analyst Bootcamp is live! Here's what you'll learn: - Data Fundamentals - MySQL - @Microsoft Excel - @tableau - Microsoft Power BI - Python - Pandas - Building a Portfolio Website - Creating a Resume - Practicing for Technical Interviews - @awscloud - @Azure - Git and GitHub - R Programming - @databricks - How to use LinkedIn to Land a Job That's a lot! All packed into one long 28 hour and 41 minute video. Over the next year or so, I'll be creating new lessons on the following - @alteryx - @Snowflake - PostgreSQL - @duckdb - Statistics - and more! Sometime in 2027 I'll release an updated Bootcamp with these included! This Bootcamp was made with a lot of love and I hope you all learn a ton from it. The data community has given me so much so I'm glad to give back and pass it onto the next generation. Happy learning! youtube.com/watch?v=cnjhHZNJ…