Alex The Analyst
Alex The Analyst
  • 308
  • 35 465 720
Is the Economy on the Brink of a Recession? | Let's Look at the Data!
The Economy isn't looking good and there's a lot of data to back it up. In this video we dive into what's influencing the economy and what the trends show for the next several years.
FFER: fred.stlouisfed.org/series/FEDFUNDS
Freddie Mac Mortgage Rates: www.freddiemac.com/pmms
Credit Card Debt: www.lendingtree.com/credit-cards/study/credit-card-debt-statistics/
Layoffs: layoffs.fyi/
Full vs Part Time: www.advisorperspectives.com/dshort/updates/2024/06/07/a-closer-look-at-full-time-and-part-time-employment#:~:text=The%20focus%20is%20on%20total,time%20workers%20increased%20by%20286%2C000.
Groceries: www.thestreet.com/economy/why-are-groceries-so-expensive
Note: This is just my opinion (although we are looking at data) and I may be completely wrong. Look into these things and make an informed decision for yourself and for your future.
____________________________________________
RESOURCES:
💻Analyst Builder - www.analystbuilder.com/
📖Take my Full MySQL Course Here: bit.ly/3tqOipr
📖Take my Full Python Course Here: bit.ly/48O581R
📖Practice Technical Interview Questions: bit.ly/46pDqqL
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Science - bit.ly/3Z4A5K6
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
ua-cam.com/channels/7cs8q-gJRlGwj4A8OmCmXg.htmljoin
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱Instagram: @Alex_The_Analyst
____________________________________________
*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*
Переглядів: 11

Відео

Top 5 Most Common Excel Functions in Excel
Переглядів 3,8 тис.14 годин тому
In this video we look at the Most Common Functions in Excel! Dataset: github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Most Common Excel Functions.xlsx 💻 Take My Full Excel Course Here: www.analystbuilder.com/courses/excel-for-data-analytics RESOURCES: 💻Analyst Builder - www.analystbuilder.com/ 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖P...
5 Awesome Excel Functions You've Probably Never Heard Of
Переглядів 4 тис.День тому
Excel has so many functions it's hard to keep track! Here are some great ones you've probably never heard of! Excel Link: github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Uncommon Excel Functions.xlsx 💻 Take My Full Excel Course Here: www.analystbuilder.com/courses/excel-for-data-analytics RESOURCES: 💻Analyst Builder - www.analystbuilder.com/ 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖T...
How to Create Custom Functions in Excel | Lambda Functions
Переглядів 4,6 тис.14 днів тому
Today we take a look at creating your own custom functions in Excel! Dataset: github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Lambda Functions.xlsx 💻 Take My Full Excel Course Here: www.analystbuilder.com/courses/excel-for-data-analytics RESOURCES: 💻Analyst Builder - www.analystbuilder.com/ 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖Prac...
Top 5 Most Popular Functions In Microsoft Excel
Переглядів 13 тис.21 день тому
Today we take a look at 5 of the most popular functions people use in Excel! Dataset: github.com/AlexTheAnalyst/Excel-Tutorial/blob/main/Popular Excel Functions.xlsx 💻 Take My Full Excel Course Here: www.analystbuilder.com/courses/excel-for-data-analytics RESOURCES: 💻Analyst Builder - www.analystbuilder.com/ 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.l...
Infrastructure of Analyst Builder | Entire Tech Stack | Part 3
Переглядів 3,5 тис.Місяць тому
In this video we break down the Infrastructure that we used to build Analyst Builder! 💻Analyst Builder - www.analystbuilder.com/ RESOURCES: 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖Practice Technical Interview Questions: bit.ly/46pDqqL Coursera Courses: Google Data Analyst Certification: coursera.pxf.io/5bBd62 Data Analysis with Python - ...
Challenges of Creating Analyst Builder | Challenges of a Startup | Part 2
Переглядів 2,1 тис.Місяць тому
In this video we talk about the challenges of a startup! 💻Analyst Builder - www.analystbuilder.com/ RESOURCES: 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖Practice Technical Interview Questions: bit.ly/46pDqqL Coursera Courses: Google Data Analyst Certification: coursera.pxf.io/5bBd62 Data Analysis with Python - coursera.pxf.io/BXY3Wy IBM Da...
How We Started Analyst Builder | How We Created It | Part 1
Переглядів 6 тис.Місяць тому
In this video we talk about how we started Analyst Builder! Analyst Builder is a platform to learn Data Analytics. Practice for Technical Interviews and take courses while you earn Badges and Certificates! 💻Analyst Builder - www.analystbuilder.com/ WaveZync: wavezync.com/ RESOURCES: 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖Practice Techni...
MySQL Exploratory Data Analysis | Full Project
Переглядів 34 тис.Місяць тому
Full MySQL Course: www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to be building an Exploratory Data Analysis project in MySQL! Started Project by cleaning the data in this video: ua-cam.com/video/4UltKCnnnTA/v-deo.html GitHub Code: github.com/AlexTheAnalyst/MySQL-UA-cam-Series/blob/main/Portfolio Project - EDA.sql SUBSCRIBE! Do you want to become a Data Ana...
Data Cleaning in MySQL | Full Project
Переглядів 70 тис.2 місяці тому
Full MySQL Course: www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to be building a data cleaning project in MySQL! Download Dataset: github.com/AlexTheAnalyst/MySQL-UA-cam-Series/blob/main/layoffs.csv GitHub Code: github.com/AlexTheAnalyst/MySQL-UA-cam-Series/blob/main/Portfolio Project - Data Cleaning.sql SUBSCRIBE! Do you want to become a Data Analyst? Tha...
How to get Promoted as a Data Analyst | Alex The Analyst Show Episode 26
Переглядів 8 тис.2 місяці тому
I was promoted fairly quickly over my career and I want to let you in on how I was able to do that. In this video I walk through the things I did to get promoted and how I think you should go about it as well! RESOURCES: 💻Analyst Builder - www.analystbuilder.com/ 📖Take my Full MySQL Course Here: bit.ly/3tqOipr 📖Take my Full Python Course Here: bit.ly/48O581R 📖Practice Technical Interview Questi...
Triggers and Events in MySQL | Advanced MySQL Series
Переглядів 19 тис.2 місяці тому
Full MySQL Course: www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to take a look at Triggers and Events in MySQL! GitHub Code: github.com/AlexTheAnalyst/MySQL-UA-cam-Series/blob/main/Advanced - Triggers and Events.sql SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in or...
Stored Procedures in MySQL | Advanced MySQL Series
Переглядів 19 тис.2 місяці тому
Stored Procedures in MySQL | Advanced MySQL Series
Temp Tables in MySQL | Advanced MySQL Series
Переглядів 16 тис.2 місяці тому
Temp Tables in MySQL | Advanced MySQL Series
CTEs in MySQL | Advanced MySQL Series
Переглядів 26 тис.3 місяці тому
CTEs in MySQL | Advanced MySQL Series
7 Mistakes to Avoid During Your Data Analyst Job Search
Переглядів 18 тис.3 місяці тому
7 Mistakes to Avoid During Your Data Analyst Job Search
Window Functions in MySQL | Intermediate MySQL
Переглядів 31 тис.3 місяці тому
Window Functions in MySQL | Intermediate MySQL
Subqueries in MySQL | Intermediate MySQL
Переглядів 27 тис.3 місяці тому
Subqueries in MySQL | Intermediate MySQL
Case Statements in MySQL | Intermediate MySQL
Переглядів 24 тис.4 місяці тому
Case Statements in MySQL | Intermediate MySQL
Microsoft Copilot Full Review | AI in Word, PowerPoint, Excel and More!
Переглядів 63 тис.4 місяці тому
Microsoft Copilot Full Review | AI in Word, PowerPoint, Excel and More!
String Functions in MySQL | Intermediate MySQL Series
Переглядів 25 тис.4 місяці тому
String Functions in MySQL | Intermediate MySQL Series
Unions in MySQL | Intermediate MySQL
Переглядів 24 тис.4 місяці тому
Unions in MySQL | Intermediate MySQL
Joins in MySQL | Intermediate MySQL
Переглядів 56 тис.5 місяців тому
Joins in MySQL | Intermediate MySQL
Solving VERY HARD SQL Interview Questions on Analyst Builder
Переглядів 13 тис.5 місяців тому
Solving VERY HARD SQL Interview Questions on Analyst Builder
Solving HARD SQL Interview Questions on Analyst Builder
Переглядів 20 тис.5 місяців тому
Solving HARD SQL Interview Questions on Analyst Builder
Solving Medium SQL Interview Questions on Analyst Builder
Переглядів 21 тис.5 місяців тому
Solving Medium SQL Interview Questions on Analyst Builder
Solving Easy SQL Interview Questions on Analyst Builder
Переглядів 35 тис.5 місяців тому
Solving Easy SQL Interview Questions on Analyst Builder
How I Would Become a Data Analyst if I had to Start Over in 2024 | 6 Month Plan
Переглядів 261 тис.5 місяців тому
How I Would Become a Data Analyst if I had to Start Over in 2024 | 6 Month Plan
Limit + Aliasing in MySQL | MySQL Beginner Series
Переглядів 29 тис.5 місяців тому
Limit Aliasing in MySQL | MySQL Beginner Series
Analyst Builder Full Launch! | The Learning Platform Built for Data Analysts
Переглядів 22 тис.6 місяців тому
Analyst Builder Full Launch! | The Learning Platform Built for Data Analysts

КОМЕНТАРІ

  • @Kaura_Victor
    @Kaura_Victor 25 хвилин тому

    Though the project was quite tricky, I got over it. Thank you so much Alex.

  • @travelgirlbigworld4837
    @travelgirlbigworld4837 43 хвилини тому

    Hello all, for the part where he deleted the duplicates, I simply populated the new table with results filtered for "row_num = 1". My question - is my method more risky and opening me up to miss some mistakes or does it also work just fine all the time? Will be happy for a response.

  • @Sunmibayo_Orisakahunsi
    @Sunmibayo_Orisakahunsi Годину тому

    Hello Alex. I couldn't find the file you used for starting the SQL tutorials in your github repository. (parks_and_recreation.sql)

  • @JeremyOkocha
    @JeremyOkocha 3 години тому

    Hey Alex! Thanks for the guidance this definitely changes my approach. However, could you maybe also explain how to tell whether a recruiter is legit or not or what to watch for. Ex. A lot of recruiters have reached out through WhatsApp. I always feel suspicious lol

  • @IsraelFernandezvstheworld
    @IsraelFernandezvstheworld 8 годин тому

    Thank you for the list, I’m definitely checking it out today, I’m really interested in a data analysis job. Real quick courses number 8 and 11 are no longer available, any alternatives? Or could you make a new top 10 list? Thank you 🙏🏼

  • @94kmichelle
    @94kmichelle 12 годин тому

    Trying to do the where clause but when I run it it's saying employee_salary doesn't exist

  • @johnnieiminabo4428
    @johnnieiminabo4428 13 годин тому

    Hi Alex thank you so much for doing this and making it free for people like me. Can you please help me? I'm finding it difficult to install MySQL. Is there any other MySQL we can substitute for this one?