Alex The Analyst
Alex The Analyst
  • Видео 308
  • Просмотров 35 516 428
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 ...
Просмотров: 4 361

Видео

Top 5 Most Common Excel Functions in Excel
Просмотров 4,1 тыс.19 часов назад
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,1 тыс.14 дней назад
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,7 тыс.21 день назад
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 тыс.28 дней назад
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,6 тыс.Месяц назад
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: ruclips.net/video/4UltKCnnnTA/видео.html GitHub Code: github.com/AlexTheAnalyst/MySQL-RUclips-Series/blob/main/Portfolio Project - EDA.sql SUBSCRIBE! Do you want to become a Data A...
Data Cleaning in MySQL | Full Project
Просмотров 71 тыс.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-RUclips-Series/blob/main/layoffs.csv GitHub Code: github.com/AlexTheAnalyst/MySQL-RUclips-Series/blob/main/Portfolio Project - Data Cleaning.sql SUBSCRIBE! Do you want to become a Data Analyst? T...
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-RUclips-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 o...
Stored Procedures in MySQL | Advanced MySQL Series
Просмотров 20 тыс.2 месяца назад
Stored Procedures in MySQL | Advanced MySQL Series
Temp Tables in MySQL | Advanced MySQL Series
Просмотров 16 тыс.3 месяца назад
Temp Tables in MySQL | Advanced MySQL Series
CTEs in MySQL | Advanced MySQL Series
Просмотров 27 тыс.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
Просмотров 32 тыс.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
Просмотров 25 тыс.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
Просмотров 26 тыс.4 месяца назад
String Functions in MySQL | Intermediate MySQL Series
Unions in MySQL | Intermediate MySQL
Просмотров 25 тыс.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
Просмотров 263 тыс.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
Просмотров 30 тыс.6 месяцев назад
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

Комментарии

  • @rhythmdas2689
    @rhythmdas2689 8 минут назад

    Hey there! I am trying to transfer the data to sql but it is showing that 564 records are showing instead of 2361. Can someone please help

  • @christinefreberg
    @christinefreberg 31 минуту назад

    “I want to go to Bali! I want to go to France”! Hehe 😂

  • @sneddonnw3562
    @sneddonnw3562 39 минут назад

    Hi Alex Thank you for the video. I'd like to ask, how do we set up the lice server to view changes as we go for the first time?

  • @muhammadalikhan5733
    @muhammadalikhan5733 43 минуты назад

    I would honestly love to get a deeper dive into this, the data speaks volumes of the current state of the economy!

  • @MyVibes369
    @MyVibes369 Час назад

    Thank you for this video. Please dive deeper into this. That would be awesome!

  • @SierraPeak
    @SierraPeak Час назад

    Green beans 😅

  • @Chrisbit1
    @Chrisbit1 Час назад

    I want to specialize in Human Resources, I feel like HR needs to use tech and data more often

  • @tigistberhe8499
    @tigistberhe8499 3 часа назад

    Hello Alex I couldn't download my SQL anyone help me please

  • @lovewatchingyoutube2467
    @lovewatchingyoutube2467 3 часа назад

    Will the US government come for you? If not then please make more videos like this 😉

  • @wanderlvst6801
    @wanderlvst6801 3 часа назад

    please make more

  • @lydiamorah3351
    @lydiamorah3351 4 часа назад

    I have questions when Alex was using the ROW_NUMBER() function over the other columns why didn't he use the last three columns??? Can you opt to include them?

  • @cynthiaryu5628
    @cynthiaryu5628 5 часов назад

    Finally, find insights and take necessary actions is the essence of data analyst!

  • @RonWeber2011
    @RonWeber2011 5 часов назад

    Please dig in deeper!! Amazing content!!

  • @sam02109
    @sam02109 6 часов назад

    Thank you so much Alex I prepared Upsc for 3 years and then moving towards data science, it will help to connect broad picture

  • @MadeForD
    @MadeForD 7 часов назад

    1:48 can someone help? :((( this doesnt autofill for me. the SERVER NAME is blank for me and i dont know what to type or what the actual address? is for that whatever that is. i know this vid is 4 years old and im using a different version (currently using the SQL 2022 ver) but i hope some good hearted person here in the comments can help :(((((((((((((((( if not Alex himself

  • @GA_Guy10000
    @GA_Guy10000 7 часов назад

    The emperor wears no clothes, and the can has been kicked to the end of the road - contrary to the constant propaganda of the ruling "elites" and their mainstream media lapdogs. I'd love to see an analysis on the actual REAL inflation rate for average folks...shadow stats usually says it's around 17%.

  • @user-do3nn2kl6h
    @user-do3nn2kl6h 7 часов назад

    As a huge fan of parks and rec i enjoy learning from these video : )

  • @euniceduah4793
    @euniceduah4793 8 часов назад

    I wanted to make this analysis for my dissertation, I couldn’t find appropriate data to use 😅. Well done Alex. Will be looking forward to something on exchange rates too if you don’t mind 😊

  • @jasxteo
    @jasxteo 10 часов назад

    @Alex The Analyst how do you insert multiple row data in one go?

  • @richflowfunflow
    @richflowfunflow 11 часов назад

    the sumx function, first part you said "Apocolypse sales" but that table is actually "Apocalypse store", I do not understand... could you explain Alex?

  • @devonrd
    @devonrd 12 часов назад

    Really appreciate your effort in informing people and helping them prepare!

  • @mlumawig2911
    @mlumawig2911 14 часов назад

    Hi, Alex, or anyone, I need your help. Why is it that when I created a view and refreshed it, the view created was not there? What did I miss? The msg says, "There is already an object named 'PercentPopulationVaccinated' in the database. But there's nothing on the Views.

  • @afrozaakter5996
    @afrozaakter5996 15 часов назад

    Hello Alex, Hope you are doing amazing. I am doing your bootcamp and following all the steps. But I got stuck in this video because of PowerBI app. When I wanted to connect the workbook in the powerBI, it shows me this error message 'THERE ARE PENDING CHANGES IN YOUR QUERIES THAT HAVEN’T BEEN APPLIED ' I waited hours and hours but it doesn't load the data. What can I do? Please help me with this?

  • @samuelsackey2433
    @samuelsackey2433 15 часов назад

    I love this video. Dive in more. And teach us how to get and analyse this data

  • @ontheram
    @ontheram 16 часов назад

    Got to do whatchu got to do 😭😭😭

  • @ontheram
    @ontheram 17 часов назад

    I'll share this resourceful information on my IG and all my pages for people to find you here.... this is a well organized tutorial I never get to watch and put in practices as real class, now i have book and a pen 😂😂Thank you Alex you're amazing.

  • @jkmcdani
    @jkmcdani 19 часов назад

    Please make a longer video, Alex. Excellent, fact-based, forecast. Mahalo.

  • @shiwaniification
    @shiwaniification 19 часов назад

    I like your analysis. Love to watch detailed videos on the housing market and coming recession.

  • @electropad
    @electropad 20 часов назад

    I recently landed a job as a senior digital analyst and it was due to my storytelling abilities and communication skills not my technical ability. I think this proves that without you writing SQL and simply showing your ability to review data, just how important this skill is and how good you are at it.

    • @devonrd
      @devonrd 12 часов назад

      How did you apply? How did you showcase your storytelling abilities?

    • @electropad
      @electropad 8 часов назад

      @@devonrd I've been a digital analyst for over 10 years so I was able to call upon many examples from previous years to explain scenarios I have been in where data storytelling and insights lead to big changes in business or helped inform important decisions.

  • @RLWade2
    @RLWade2 22 часа назад

    Teach us how to search for and analyze the data.