![Alex The Analyst](/img/default-banner.jpg)
- 308
- 35 402 181
Alex The Analyst
United States
Приєднався 7 січ 2020
My name is Alex Freberg and on this channel I will be going over everything you need to know to become a Data Analyst. If you are wanting to make a career change or learn the skills needed to become a Data Analyst, be sure to subscribe to stay up to date on all my latest content.
You can find me on LinkedIn at:
www.linkedin.com/in/alex-freberg/
AlexTheAnalyst.com
www.alextheanalyst.com/
Discord Channel:
discord.gg/rxZUjNvRzR
Twitter:
@Alex_TheAnalyst
Send Me Something:
431 Saint James Avenue Suite L #318, Goose Creek, SC, 29445
You can find me on LinkedIn at:
www.linkedin.com/in/alex-freberg/
AlexTheAnalyst.com
www.alextheanalyst.com/
Discord Channel:
discord.gg/rxZUjNvRzR
Twitter:
@Alex_TheAnalyst
Send Me Something:
431 Saint James Avenue Suite L #318, Goose Creek, SC, 29445
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*
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
I love your videos and to support you I'm gonna watch other courses with watching adds on
Thank you so much Alex🙏.
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
This video was very helpful bro 😊
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
You have to have co poilot Pro to do all this you need to make this clear. Mine is just co poilot advance
How can someone be able to gwt you email?
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?
Love you contents. And I like meat & potatoes, too! :D
Thanks
So much useful insights and great advices! I really appreciated you taking the time to share with us, Alex!
thank you so much, this last query was challenging, but you are such a good teacher, thank you again
I love the tutorial so far but the line: print(data_frame.loc['Uzbekistan']) does not work neither in jupyter, nor in VSO.
Alright. I had to change index_col attribute to 'Country'.
thanks alot for this great video.
Alex what is the difference between VIEW function and this WITH CTE example stuff
I hate excel.
Are these projects done in a playlist?
its giving error code 2013, lost connection when im trying to update t1 amd t2 by setting t1.industry = t2.industry
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
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?
Help Please ! 44:16 UserWarning: The figure layout has changed to tight self._figure.tight_layout(*args, **kwargs) Thank you..
"If HR, fire immediately" LOL
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 🤦🏼♂️
It is taking a long time for me to log in :(
What are the alternative to Maven for showcasing the analytics portfolio? Please share the links to such alternatives or name them.
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?
superb!
thanks for your effort making this amazing video. It helps me alot. I've been struggling on Data cleaning and your video is helpful
Wonderful🎉
Best explanation. Crisp, short and to the point. Thanks Alex!
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?
I'm getting fail to fetch data. could please anyone tell me what to do?
The video quality on the tutorials aren't that clear but I still appreciate it.
I really appreciate your effort in making this lectures available for free. And I promise to devote my time to learning this skills.
i am having issue setup the MySQL it downloaded and the installing was ok but setting it is difficult giving me error
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
columns_to_include_2 = df.select_dtypes(include=['number']).filter(like='Population').columns.difference(["World Population Percentage"]):P
To exclude rank from being display in the numerice data: columns_to_include = df.select_dtypes(include=['number']).columns.difference(['Rank'])
Thanks for the Starting
Thank You Alex. Great teacher
i'm still a beginner, but i must confess this is really great
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.
Thanks a lot!
Thanks for this great work ❤
Mr Alex how do I insert my name into the certificate
need more series like this
Where is the data set to practice with ?
I guess ill add it to list of things to learn ...
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
thanks alex, its help me a lot :)
what about the recommended experience requested by the course? Is the google data analysis course enough?