Alex The Analyst

When you're working a 9-5 you're trading your time and expertise for money.

So you need to learn to be a great salesman in interviews!

Here's how to do that:
1. Know your product (You)
Understand your strengths, skills, and experience. Be ready to explain how you bring value, not just what you’ve done or the tools you use.

2. Make the Product Look Good
You don't have to be Brad Pitt or Angelina Jolie (I know I don't have the hair for it). But dress nice, shave, do your hair, wear cologne/perfume, and smile!

3. Lead with results
“I increased efficiency by 30%,” sounds way better than “I worked on process improvements.”

4. Tell a compelling story
Structure your answers like mini-stories. Talk about how you solved problems and helped the company you work/worked for.

5. Handle objections with confidence
If you’re missing a skill or experience, show your willingness and ability to learn fast - companies love problem-solvers.

If you can do all of this and present yourself well you'll do better than 95% of other candidates!

2 days ago | [YT] | 536

Alex The Analyst

The 4 Real Levels of SQL...

Level 1: The "Beginner"

```
SELECT customer_id, name, email
FROM customers
WHERE country = 'USA';
```

Level 2: The "Just Completed a Course"

```
SELECT r.region_name, COUNT(DISTINCT o.order_id) AS order_count
FROM orders o
JOIN regions r ON o.region_id = r.region_id
WHERE o.order_date >= '2024-01-01'
GROUP BY r.region_name
ORDER BY order_count DESC;
```

Level 3: The "Landed Your First Job"

```
SELECT customer_id,
order_id,
order_total,
order_date,
RANK() OVER (PARTITION BY customer_id ORDER BY order_total DESC) AS rank_by_spend,
CASE
WHEN order_total > 500 THEN 'High Value'
WHEN order_total BETWEEN 200 AND 500 THEN 'Medium Value'
ELSE 'Low Value'
END AS order_tier
FROM orders
WHERE order_status = 'Completed'
AND order_date BETWEEN '2024-01-01' AND '2024-12-31';
```

Level 4: The "Used to for Years"

```
CREATE TEMP TABLE high_value_customers AS
SELECT
customer_id
FROM orders
WHERE order_total IS NOT NULL
GROUP BY customer_id
HAVING SUM(order_total) > 20000
AND COUNT(DISTINCT order_id) >= 5;

WITH recent_orders AS (
SELECT *
FROM orders
WHERE order_date >= CURRENT_DATE - INTERVAL '90 days'
AND order_total > 0
AND order_status IN ('Completed', 'Shipped')
),
clean_customers AS (
SELECT
customer_id,
INITCAP(name) AS name_cleaned,
LOWER(TRIM(email)) AS email_cleaned,
COALESCE(loyalty_status, 'Standard') AS loyalty_status
FROM customers
WHERE email IS NOT NULL
),
enriched_orders AS (
SELECT
ro.order_id,
ro.customer_id,
ro.order_date,
ro.order_total,
ro.product_id,
cc.name_cleaned,
cc.email_cleaned,
cc.loyalty_status
FROM recent_orders ro
JOIN clean_customers cc ON ro.customer_id = cc.customer_id
),
orders_with_products AS (
SELECT eo.*, p.product_name, p.category
FROM enriched_orders eo
LEFT JOIN products p ON eo.product_id = p.product_id
)
SELECT *
FROM orders_with_products
WHERE customer_id IN (SELECT customer_id FROM high_value_customers)
ORDER BY order_total DESC, order_date DESC;
```

1 week ago | [YT] | 1,124

Alex The Analyst

I just passed 1 Million Subscribers here on YouTube so I thought I would introduce myself to the many new people who have followed me over the past year.

My name is Alex Freberg and I'm the host of the YouTube channel Alex The Analyst. I teach people how to become a Data Analyst and create tutorials on just about everything including SQL, Python, Excel, Tableau, and Power BI to name a few.

That's probably what I'm known best for as I just crossed 1 Million Subscribers last month!

I was a Data Analyst for several years before becoming an Analytics Manager. During that time I had done some Consulting on the side and it was growing and I quit my full time job in December of 2022 to start Alex Analytics LLC. I work with Tech Companies and Startups (primarily in Silicon Valley), but have worked with companies all around the world.

I also started Analyst Builder which is my Ed-Tech platform to teach Data Analytics where you can take full in-depth courses and practice SQL and Python for Technical Interviews. We just crossed 100k users this year and love seeing so many people get jobs from it!

Besides all of that I'm really a family man first. I have a wife and 3 beautiful kids. We moved out to Charleston, SC a few years ago and spend a lot of time at the beach, pool, sporting events, and kids school events. I love every minute of being a husband and dad - it brings me more joy than anything else in my life.

In my free time I like playing guitar, woodworking (pic 2 is a birdhouse I am building), volunteering at my church, pickleball with my wife (pic 1), playing with my kids, and doing puzzles.

That's just about me in a nutshell - thanks for reading and nice to meet you! :D

Skip the Carousel

1 2

2 weeks ago (edited) | [YT] | 2,239

Alex The Analyst

I've had several people reach out in the past few days to ask how I was so certain we would see markets go down this year.

I made a video June of last year (https://youtube.com/watch?v=wJiJXD7MVoY) covering the basics of why I thought we were going to see a recession in the next 8-16 months if you're interested.

For several months last year I went into a deep dive of past economic crashes to find trends over the past 50 years. During that time I was quite confident in what was going to happen and I moved my personal investments and money around based on what I thought would happen.

I don't think I did anything groundbreaking, but I trusted the data. One of the things that I found that was very interesting was how stock crashes and recessions correlated with incoming Republican Presidents. Should look that up and take a look because it was quite fascinating.

I didn't cover a lot of the more deep analysis that I did because I didn't think most people would understand or be able to follow along, but there is so much information out there.

I may make a more advanced video or several videos on the economy in the future.

All that being said, markets could take a turn and go up and I could be completely wrong - time will tell - but do your own research and plan accordingly!

3 weeks ago (edited) | [YT] | 361

Alex The Analyst

We made it! 1 Million Subscribers on YouTube and the Gold Play Button!!

Thank you to everyone who have supported my over these past 5 years and helped me get here. It's been a wild ride and I have no plans on slowing down.

I recorded an unboxing video, but I need to edit it and I'll release it next week :D

p.s. excuse the mess - this is what my office actually looks like below the camera line

1 month ago (edited) | [YT] | 3,363

Alex The Analyst

Introducing our new Foundations of Data Pipelines Course on Analyst Builder!

In this course you'll get hands-on experience using Apache Airflow and AWS Glue to create Data Pipelines! This course is taught by @SeattleDataGuy (Benjamin Rogojan), a Big Tech Data Engineer and YouTuber "Seattle Data Guy".

If you have a Subscription or a Lifetime Membership to Analyst Builder you'll have immediate access to this new course!

If you don't, you can get this course 30% OFF using Code "PIPELINE" at checkout (code expires on 3/24).

Link to Course: analystbuilder.com/courses/foundations-of-data-pip…

Skip the Carousel

1 2

1 month ago | [YT] | 321

Alex The Analyst

It took 5 years and 350 videos, but we hit 1 Million Subscribers!

I started this channel to make content on Data Analytics because I truly just enjoyed teaching and helping others learn.

I never thought it would get this big - I was shocked when it hit 100k!

I'm extremely grateful for the support I've received over the years and so happy my content has been so helpful.

I have no plans on stopping and I have a lot of content to come!

1 month ago (edited) | [YT] | 2,397

Alex The Analyst

Today we will hit 1 Million Subscribers on my YouTube channel!!

I'll be doing a Livestream to celebrate and will be giving away 10 Lifetime Memberships to Analyst Builder (as voted on by the community).

Who else knows what's going to happen, but I'd love for you to join and celebrate!

You guys have truly changed my life and I feel incredibly blessed to be celebrating this with all of you!

Link: youtube.com/live/r5512UY3MTc?feature=share

Skip the Carousel

1 2

1 month ago (edited) | [YT] | 697

Alex The Analyst

It's hard to stay motivated when you don't know if it'll work out or not - but not doing anything is guaranteed to keep you where you are.

Most people are capable of so much more than they are doing or they think they can do!

A lot of it is believing in yourself and believing the work you're putting in will pay off in the end.

1 month ago | [YT] | 1,474

Alex The Analyst

I'm excited to announce my latest course - Microsoft Power BI Desktop for Business Intelligence - on AnalystBuilder.com!

This course dives into Power BI to get you job ready and covers things like Data Modeling, DAX, Power Query, and Data Cleaning.

You can get this course 25% OFF using Code "POWERBI" at checkout (code expires on 3/4)

Everyone who is a Lifetime Member or who has a Full Platform Subscription will have access to this as of today!

Link: www.analystbuilder.com/courses/microsoft-power-bi-…

1 month ago (edited) | [YT] | 404