Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________
Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4Alex The Analyst2021-05-04 | Take my Full MySQL Course Here: bit.ly/3tqOipr
Today we start our Data Analyst Portfolio Project Series. In our first project we will be using SQL to do some Data Exploration. We will then visualize the data in Tableau for our next project.
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________
*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*
0:00 Introduction 1:43 Getting Out Dataset 6:41 Importing Datasets into SQL 13:40 Data Exploration 1:13:35 Import Code into GitHubFree Data Analyst Bootcamp 2024Alex The Analyst2024-10-17 | Just added AWS and Azure to my Free Data Analyst Bootcamp on YouTube!
It now covers MySQL Beginner to Advanced, Excel, Tableau, Power Bi, Python, Pandas, AWS, and Azure.
It also covers how to build a portfolio website for free, resume building with templates, and 10+ projects to add to your portfolio!Learn Python in Under 3 Hours | Variables, For Loops, Web Scraping + Full ProjectAlex The Analyst2024-10-15 | 💻Take my Full Python Course Here: analystbuilder.com/courses/python-programming-for-beginners
*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!
0:00 Intro 0:48 Installing our Environment 9:37 Variables 22:36 Data Types 44:12 Comparison Operators 51:03 If Else Statements 57:17 For Loops 1:06:18 While Loops 1:11:36 Functions 1:23:47 Converting Data Types 1:30:03 Mini Project - BMI Calculator 1:43:46 Web Scraping - Beautiful Soup and Requests 1:50:05 Web Scraping - HTML 1:55:05 Web Scraping - Find and Find_all 2:06:38 Web Scraping - Full Project
*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*Learn SQL Beginner to Advanced in Under 4 HoursAlex The Analyst2024-10-08 | 💻Take my Full MySQL Course Here: analystbuilder.com/courses/mysql-for-data-analytics
*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!
0:00 Intro 0:52 Installing MySQL and Setting up Database 11:19 Select Statement 21:47 Where Clause 33:54 Group By 44:18 Having vs Where 47:41 Limit and Aliasing 51:10 Joins 1:08:04 Unions 1:15:10 String Functions 1:26:39 Case Statements 1:35:16 Subqueries 1:45:58 Window Functions 1:58:55 CTEs 2:09:07 Temp Tables 2:16:34 Stored Procedures 2:28:51 Triggers and Events 2:42:46 Data Cleaning Project 3:32:14 Exploratory Data Analysis Project
*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*AWS Quicksight | AWS EssentialsAlex The Analyst2024-10-01 | In this AWS lesson we are going to be taking a look at AWS Quicksight!
*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!
*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*AWS Glue DataBrew and Glue | AWS EssentialsAlex The Analyst2024-09-24 | In this AWS lesson we are going to be taking a look at AWS Glue and Glue DataBrew!
*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!
*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*Amazon Athena in AWS | AWS FundamentalsAlex The Analyst2024-09-17 | In this AWS lesson we are going to be taking a look at Amazon Athena!
*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!
*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*Alex Freberg and Ben Rogojan Livestream | Everything Data Analytics and Data EngineeringAlex The Analyst2024-09-11 | Come listen to Ben and I talk about all things Data!
We will discuss Work-Life Balance, Career Progression, Engineering vs Analytics, and probably some more things.
*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!
*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*Landing a Data Job Course on Analyst BuilderAlex The Analyst2024-09-03 | Landing a Data Job Course: analystbuilder.com/courses/landing-a-data-job CODE: DATAJOB *This code is active until 9/8 - if you get it before then you'll have access forever*
*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!
*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*S3 Storage in AWS | AWS EssentialsAlex The Analyst2024-08-27 | In this AWS lesson we are going to be taking a look at Amazon S3
*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!
*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*AWS Setup and UI Walkthough | AWSAlex The Analyst2024-08-20 | In this AWS lesson we are going to be setting up and taking a look at the UI in AWS!
*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!
*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*Getting Started in Azure Synapse Analytics | Azure FundamentalsAlex The Analyst2024-08-13 | In this lesson we will be looking at Azure Synapse Analytics in Azure!
*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!
*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*August Q/A Livestream! Come Ask Me Anything!Alex The Analyst2024-08-09 | August's Livestream!
Come ask me anything about Data Analytics, the job market, economy, and anything else!
💻Get 25% Off Any Purchase on AnalystBuilder.com: 📱Code: AUGUSTAB
____________________________________________
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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*Getting Started in Azure Data Factory | Azure FundamentalsAlex The Analyst2024-08-06 | In this lesson we will be looking at Azure Data Factory in Azure!
*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!
*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*How to use Azure SQL Databases | Azure FundamentalsAlex The Analyst2024-07-30 | In this lesson we will be looking at Storage Accounts in Azure!
*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!
*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*Complete Data Analyst Roadmap on Analyst Builder | Become a Data Analyst Faster!Alex The Analyst2024-07-25 | The Data Analyst Roadmap on AnalystBuilder.com is one of the best resources to get up to speed and job ready.
*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!
*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*Blob Storage and Storage Accounts in Azure | Azure FundamentalsAlex The Analyst2024-07-23 | In this lesson we will be looking at Blob Storage and Storage Accounts in Azure!
*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!
*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*Azure Account Setup + $200 Free Credits | Azure FundamentalsAlex The Analyst2024-07-16 | In this lesson we will be setting up and walking through the UI of Azure!
*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!
*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*Building a Fully Interactive Web App using Shiny for PythonAlex The Analyst2024-07-09 | In this video we are building a Full Shiny App using real housing data!
**This video is sponsored by Posit PBC. Posit is a public benefit corp that creates open-source software for data science, scientific research, and technical communication. They are the team behind Shiny, the RStudio IDE, the tidyverse, Quarto and much more.
Posit also sells a suite of professional products that help data science teams do their work. Learn more at posit.co/products/** ____________________________________________
*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!
*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*Shiny for Python Components and Layouts | Customizing You Web AppAlex The Analyst2024-07-02 | In this video we look at how we can customize our Shiny app using components and layouts!
**This video is sponsored by Posit PBC. Posit is a public benefit corp that creates open-source software for data science, scientific research, and technical communication. They are the team behind Shiny, the RStudio IDE, the tidyverse, Quarto and much more.
Posit also sells a suite of professional products that help data science teams do their work. Learn more at posit.co/products/**
*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!
*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*Shiny for Python Setup and Install | Deploying First Shiny AppAlex The Analyst2024-06-25 | In this video we are going to install Shiny and setup our environment!
**This video is sponsored by Posit PBC. Posit is a public benefit corp that creates open-source software for data science, scientific research, and technical communication. They are the team behind Shiny, the RStudio IDE, the tidyverse, Quarto and much more.
Posit also sells a suite of professional products that help data science teams do their work. Learn more at posit.co/products/**
*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!
*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*Is the Economy on the Brink of a Recession? | Lets Look at the Data!Alex The Analyst2024-06-18 | 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.
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.
*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!
*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*Top 5 Most Common Excel Functions in ExcelAlex The Analyst2024-06-11 | In this video we look at the Most Common Functions in Excel!
*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!
0:00 Intro 0:23 Aggregate Functions 2:41 Year Month Day 5:10 Formatting 6:58 Logical 10:07 LookUp 15:56 Outro
*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*5 Awesome Excel Functions Youve Probably Never Heard OfAlex The Analyst2024-06-04 | Excel has so many functions it's hard to keep track! Here are some great ones you've probably never heard of!
*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!
0:00 Intro 0:31 PMT 2:56 FORMULATEXT 4:16 LET 9:42 HYPERLINK 10:56 EOMONTH 13:21 Outro
*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*How to Create Custom Functions in Excel | Lambda FunctionsAlex The Analyst2024-05-28 | Today we take a look at creating your own custom functions in Excel!
*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!
0:00 Intro 0:48 Lambda Function Syntax 2:15 Lambda Example 8:30 Real Use Case 15:45 Outro
*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*Top 5 Most Popular Functions In Microsoft ExcelAlex The Analyst2024-05-21 | Today we take a look at 5 of the most popular functions people use in Excel!
*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!
0:00 Intro 0:42 DateDif 3:11 TextSplit 6:37 If 9:47 Substitute 12:26 XLookUp 15:47 Outro
*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*Infrastructure of Analyst Builder | Entire Tech Stack | Part 3Alex The Analyst2024-05-14 | In this video we break down the Infrastructure that we used to build Analyst Builder!
*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!
*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*2 Hour Data Analyst Interview Masterclass | Interview Better Than The CompetitionAlex The Analyst2024-05-07 | Interviewing for Data Analyst positions can be tough!
As a previous Hiring Manager, and before that on a hiring team, I know the ins and outs of the hiring process, what they'll ask, and how you should answer. Join this Masterclass as we dive deep into the interview process!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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*Challenges of Creating Analyst Builder | Challenges of a Startup | Part 2Alex The Analyst2024-05-07 | In this video we talk about the challenges of a startup!
*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!
*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*How We Started Analyst Builder | How We Created It | Part 1Alex The Analyst2024-04-30 | 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!
*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!
*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*MySQL Exploratory Data Analysis | Full ProjectAlex The Analyst2024-04-23 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to be building an Exploratory Data Analysis project in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*750k Subscriber Livestream! | Giveaways | Songs | Q/AAlex The Analyst2024-04-18 | Thank you guys so much for 750k subscribers!! I'm extremely grateful for the opportunity to grow this community to such a large size. I've loved every minute of it and I don't plan on slowing down!
We will be doing giveaways for free courses and a Lifetime access to Analyst Builder! Stick around for a chance to win :)
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________
*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*Data Cleaning in MySQL | Full ProjectAlex The Analyst2024-04-16 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to be building a data cleaning project in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*How to get Promoted as a Data Analyst | Alex The Analyst Show Episode 26Alex The Analyst2024-04-09 | 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!
*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!
*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*Triggers and Events in MySQL | Advanced MySQL SeriesAlex The Analyst2024-04-02 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Triggers and Events in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*How to give up on the job search fastAlex The Analyst2024-03-27 | 💻Analyst Builder - analystbuilder.com
*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!
*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*Stored Procedures in MySQL | Advanced MySQL SeriesAlex The Analyst2024-03-26 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Stored Procedures in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*Temp Tables in MySQL | Advanced MySQL SeriesAlex The Analyst2024-03-19 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Temp Tables in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*CTEs in MySQL | Advanced MySQL SeriesAlex The Analyst2024-03-12 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at CTEs in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*7 Mistakes to Avoid During Your Data Analyst Job SearchAlex The Analyst2024-03-05 | When I was a Hiring Managers I saw a lot of people making these mistakes in interviews!
In this video I'm going to walk through them so you can prepare and not make the same mistakes!
*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!
0:00 Intro 0:41 Recruiters 2:00 Using Generic Resumes 3:10 Only Having Resume 4:50 Not Doing Research 6:10 Only Focusing on Hard Skills 7:15 Not Networking 8:27 No Online Presence 9:40 Outro
*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*#DataAnalyst #AnalystBuilder #SQLAlex The Analyst2024-03-01 | Link: AnalystBuilder.comQ/A Livestream | February Livestream | Ask Me Anything!Alex The Analyst2024-02-29 | This is February's Livestream where you can come and ask me anything!
Try out my Data Analyst Learning Platform AnalystBuilder.com ____________________________________________
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________
*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*Window Functions in MySQL | Intermediate MySQLAlex The Analyst2024-02-27 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Window Functions in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*Twitter making me tear up over here 🥹Alex The Analyst2024-02-23 | ...Subqueries in MySQL | Intermediate MySQLAlex The Analyst2024-02-20 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Subqueries in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*Case Statements in MySQL | Intermediate MySQLAlex The Analyst2024-02-13 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Case Statements in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*We did our bestAlex The Analyst2024-02-08 | ...Microsoft Copilot Full Review | AI in Word, PowerPoint, Excel and More!Alex The Analyst2024-02-06 | Microsoft Copilot is Microsoft's massive initiative at putting AI into the hands of every day users. Hundreds of millions of people use their products every day so this is a big leap forward for everyday AI. In this video we will look at how Copilot works and what it can/can't do.
*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!
0:00 Intro 1:35 How to Get Microsoft Copilot 2:12 What is Copilot in? 2:53 Copilot in Microsoft Word Demo 4:41 Copilot in OneNote Demo 5:23 Copilot in PowerPoint Demo 6:51 Copilot in Excel Overview 7:32 Testing Copilot in Excel 19:28 Positives and Negatives of Microsoft Copilot 23:58 Outro 📱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*Top 5 Emerging Trends in 2024 | CareerFoundry WebinarAlex The Analyst2024-01-30 | Today we’ll explore 5 emerging trends in data in 2024! A big thanks to CareerFoundry for inviting me to take part in this webinar. If you’re looking to kickstart a career in data analytics, check out the links below for an exclusive discount to their full program and more.
Take 20% off CareerFoundry’s Full Data Analytics Program: bit.ly/3HamZDm
Not sure if a career in data analytics is for you? Check out CareerFoundry’s free short course – to get an intro to data, try exercises, and learn about the field of data analytics: bit.ly/3TLDwoQ
Have questions about CareerFoundry’s program? Book a call with a program advisor to learn more: bit.ly/3tDtuvA
Dive into more data trends for 2024 in this article: bit.ly/41JZieM
____________________________________________
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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*String Functions in MySQL | Intermediate MySQL SeriesAlex The Analyst2024-01-30 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at String Functions in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!
*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*Unions in MySQL | Intermediate MySQLAlex The Analyst2024-01-23 | Full MySQL Course: analystbuilder.com/courses/mysql-for-data-analytics
In this lesson we are going to take a look at Unions in MySQL!
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 order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________
*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!