Alex The Analyst
Alex The Analyst
  • 308
  • 35 402 181
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*
Переглядів: 3

Відео

Top 5 Most Common Excel Functions in Excel
Переглядів 3,3 тис.12 годин тому
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
Переглядів 3,9 тис.День тому
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
Переглядів 33 тис.Місяць тому
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
Переглядів 69 тис.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
Переглядів 26 тис.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!
Переглядів 62 тис.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
Переглядів 55 тис.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
Переглядів 20 тис.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
Переглядів 260 тис.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

КОМЕНТАРІ

  • @HomeAlbadawi
    @HomeAlbadawi 2 години тому

    I love your videos and to support you I'm gonna watch other courses with watching adds on

  • @toluayet3929
    @toluayet3929 6 годин тому

    Thank you so much Alex🙏.

  • @mohamedsedgi7640
    @mohamedsedgi7640 7 годин тому

    Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'Parks_and_Recreation'. Msg 102, Level 15, State 1, Line 63 Incorrect syntax near 'AUTO_INCREMENT'. whats wrong

  • @MrNess2911
    @MrNess2911 9 годин тому

    This video was very helpful bro 😊

  • @rohithreddy3811
    @rohithreddy3811 10 годин тому

    While installing I am getting only 4 options server only, Client only, Full, Custom. I can’t see any developer Default. Can anyone please help me. Thanks

  • @galaxyshaz
    @galaxyshaz 10 годин тому

    You have to have co poilot Pro to do all this you need to make this clear. Mine is just co poilot advance

  • @amabbychannel9053
    @amabbychannel9053 12 годин тому

    How can someone be able to gwt you email?

  • @erudite9721
    @erudite9721 14 годин тому

    Do data analysts need to be onsite or can they work remote? And what are the options for someone from outside of the US looking to apply for a position?

  • @richardduydang8248
    @richardduydang8248 19 годин тому

    Love you contents. And I like meat & potatoes, too! :D

  • @vishnushendge3190
    @vishnushendge3190 19 годин тому

    Thanks

  • @richardduydang8248
    @richardduydang8248 23 години тому

    So much useful insights and great advices! I really appreciated you taking the time to share with us, Alex!

  • @adwaamohamed2674
    @adwaamohamed2674 День тому

    thank you so much, this last query was challenging, but you are such a good teacher, thank you again

  • @pitaszekfistaszek
    @pitaszekfistaszek День тому

    I love the tutorial so far but the line: print(data_frame.loc['Uzbekistan']) does not work neither in jupyter, nor in VSO.

    • @pitaszekfistaszek
      @pitaszekfistaszek День тому

      Alright. I had to change index_col attribute to 'Country'.

  • @minanabil1035
    @minanabil1035 День тому

    thanks alot for this great video.

  • @aryandodani7994
    @aryandodani7994 День тому

    Alex what is the difference between VIEW function and this WITH CTE example stuff

  • @sfd672
    @sfd672 День тому

    I hate excel.

  • @cheryyc1751
    @cheryyc1751 День тому

    Are these projects done in a playlist?

  • @typicalstoic2089
    @typicalstoic2089 День тому

    its giving error code 2013, lost connection when im trying to update t1 amd t2 by setting t1.industry = t2.industry

  • @robertlee8519
    @robertlee8519 День тому

    Yeah so we've been in a recession for a long time now for the vast majority of people. Retired boomers that have had stocks and homes the past 40 years are probably doing somewhat better

  • @typicalstoic2089
    @typicalstoic2089 День тому

    is it normal that sometimes the results of data appeares different from the video when I'm writing a query even though I'm doing exactly the same thing?

  • @yanpaucon1043
    @yanpaucon1043 День тому

    Help Please ! 44:16 UserWarning: The figure layout has changed to tight self._figure.tight_layout(*args, **kwargs) Thank you..

  • @MikeM-uy6qp
    @MikeM-uy6qp День тому

    "If HR, fire immediately" LOL

  • @whothefcares2687
    @whothefcares2687 День тому

    I think the best thing about these courses for anyone already in a data analysis role is just learning what everything is called. In job postings and interviews hiring managers like using short hand and buzzwords. Knowing the skills isn't enough, though it should be, you have to be able to convey through buzzwords and acronyms what you can do so hiring managers will pick you. Also, don't underestimate yourselves and your skills. I just had to teach a business analyst with 25 years of experience how to do a vlookup 🤦🏼‍♂️

  • @yuko2732
    @yuko2732 День тому

    It is taking a long time for me to log in :(

  • @DevDax-qx1bz
    @DevDax-qx1bz День тому

    What are the alternative to Maven for showcasing the analytics portfolio? Please share the links to such alternatives or name them.

  • @harshagrawal2001
    @harshagrawal2001 День тому

    Can you make a video on how to install on macbook. I am not getting the same options as in the video for my macbook?

  • @hisokaamorou4211
    @hisokaamorou4211 День тому

    superb!

  • @nguyenthikieuoanh8966
    @nguyenthikieuoanh8966 День тому

    thanks for your effort making this amazing video. It helps me alot. I've been struggling on Data cleaning and your video is helpful

  • @petermachiengchangaduel1501
    @petermachiengchangaduel1501 День тому

    Wonderful🎉

  • @gayatrideshmukh5625
    @gayatrideshmukh5625 День тому

    Best explanation. Crisp, short and to the point. Thanks Alex!

  • @SRB_Creation21
    @SRB_Creation21 День тому

    I am having problems running my files at the very last stage. It shows "failed with the following error, culture is not supported parameter name: culture 3072 (0x0c00) is an invalid culture identifier." Could anyone please help me with difficulties?

  • @pavithrap769
    @pavithrap769 День тому

    I'm getting fail to fetch data. could please anyone tell me what to do?

  • @hawkid8479
    @hawkid8479 2 дні тому

    The video quality on the tutorials aren't that clear but I still appreciate it.

  • @hawkid8479
    @hawkid8479 2 дні тому

    I really appreciate your effort in making this lectures available for free. And I promise to devote my time to learning this skills.

  • @oluponadeborah9463
    @oluponadeborah9463 2 дні тому

    i am having issue setup the MySQL it downloaded and the installing was ok but setting it is difficult giving me error

  • @kevindeschepper8140
    @kevindeschepper8140 2 дні тому

    another way to select the columns (think of a big data sets where indicing with numbers would be challeging) columns_to_include_2 = df.select_dtypes(include=['number']).filter(like='population').columns

    • @kevindeschepper8140
      @kevindeschepper8140 2 дні тому

      columns_to_include_2 = df.select_dtypes(include=['number']).filter(like='Population').columns.difference(["World Population Percentage"]):P

  • @kevindeschepper8140
    @kevindeschepper8140 2 дні тому

    To exclude rank from being display in the numerice data: columns_to_include = df.select_dtypes(include=['number']).columns.difference(['Rank'])

  • @user-pc8jj6dl2v
    @user-pc8jj6dl2v 2 дні тому

    Thanks for the Starting

  • @rosaliahmuhoho7469
    @rosaliahmuhoho7469 2 дні тому

    Thank You Alex. Great teacher

  • @da_facilitator
    @da_facilitator 2 дні тому

    i'm still a beginner, but i must confess this is really great

  • @sushmithar9343
    @sushmithar9343 2 дні тому

    hi did anyone have an idea about the certification like for Powerbi we have PL_300 certification likewise I want to know for Sql, Excel, and python.

  • @cinthiaramos7325
    @cinthiaramos7325 2 дні тому

    Thanks a lot!

  • @Mr.Arshad-oc1fd
    @Mr.Arshad-oc1fd 2 дні тому

    Thanks for this great work ❤

  • @AkatukundaSamantha
    @AkatukundaSamantha 2 дні тому

    Mr Alex how do I insert my name into the certificate

  • @Nature_lover_Bnda
    @Nature_lover_Bnda 2 дні тому

    need more series like this

  • @witchelreme3262
    @witchelreme3262 2 дні тому

    Where is the data set to practice with ?

  • @evelic
    @evelic 2 дні тому

    I guess ill add it to list of things to learn ...

  • @Mr.Arshad-oc1fd
    @Mr.Arshad-oc1fd 2 дні тому

    Sir I donwnload Parks and Recreation in SQL (not mysql) but when I put the quarry like Parks and Recreation.employee_demographics but shows wrong or invalid code please

  • @truthgaming2296
    @truthgaming2296 2 дні тому

    thanks alex, its help me a lot :)

  • @andresdelatorreramirez4197
    @andresdelatorreramirez4197 2 дні тому

    what about the recommended experience requested by the course? Is the google data analysis course enough?