Тёмный
Alex The Analyst
Alex The Analyst
Alex The Analyst
Подписаться
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
Data Cleaning in MySQL | Full Project
51:11
Месяц назад
CTEs in MySQL | Advanced MySQL Series
10:31
2 месяца назад
Subqueries in MySQL | Intermediate MySQL
11:01
3 месяца назад
Unions in MySQL | Intermediate MySQL
7:22
4 месяца назад
Joins in MySQL | Intermediate MySQL
17:11
4 месяца назад
Комментарии
@marysoil3209
@marysoil3209 20 часов назад
I really like your way of explaining things and giving us the real-life example on how to properly use them. Thank you for putting so much effort making this kind of content. Hope you make more, I wanna learn a lot from you!
@dineroman21
@dineroman21 21 час назад
Wow!! I was the 1 thousandth like. Keep up the excellent work Alex.
@mrased10
@mrased10 21 час назад
You say at 4:55 that the age 50 is too low and lower it further to 40 😂
@bijankhadembashi1016
@bijankhadembashi1016 22 часа назад
Nice video, underwhelming program... So much potential though 😭
@SidraKhan-ns6tq
@SidraKhan-ns6tq День назад
@alextheanalyst How to download it for MacOS??
@isaacjoseph8725
@isaacjoseph8725 День назад
Damn you Ron Swanson!
@krazyhand1653
@krazyhand1653 День назад
in which part of the github is the park and recreation file? I can't find it.
@sahargandomkar
@sahargandomkar День назад
دم شما گرم🎉
@brettdoyon3200
@brettdoyon3200 День назад
When you changed the titles of the rows in the pivot tables to include the age range, particularly on the "Customer Age Brackets", is there anything wrong with manually changing the order of the data? When you insert the ages, it reorders the points on the line graph but if you manually reorder the rows the chart works as intended.
@gloomandglow
@gloomandglow День назад
What is going on with the audio? It sounds like you're constantly moving in front of the mic.
@maggietang1369
@maggietang1369 День назад
You have great Excel videos, which are really helpful. But for Tableau, give me that feeling you are not very confident, your clear explanation can make it up some, but I still hope you'll have same as Excel level Tableau courses in the future. Thanks!
@najeebaslami-ie3ll
@najeebaslami-ie3ll День назад
I gonna start this journey from Afghanistan, Wish me luck
@ashukla280
@ashukla280 День назад
Thank you so much Alex for making these informative videos and especially for portfolio projects. I have completed my first project with the help of your video it took me 5 hours to complete. Respect Man 🙌
@kaloyantoskov6818
@kaloyantoskov6818 День назад
The fucking GOAT
@zhackercameback2690
@zhackercameback2690 День назад
love you so much
@dragster100
@dragster100 День назад
Great video! I am a complete beginner to GitHub, and as a side question how do I upload my projects to GitHub? I mean what is the best practice to make the uploaded projects well organized on GitHub? Thanks!
@datascience244
@datascience244 День назад
Hi Alex, having trouble logging into analystbuiler. can you help?
@amirhaghnazar
@amirhaghnazar День назад
Why LIKE is not case-sensitive? I think something is going wrong 🤨
@freshflashcreation5724
@freshflashcreation5724 2 дня назад
how i can use excel on macbook air
@Insightss.....
@Insightss..... 2 дня назад
I'm in love with ur videos
@PM_Tx
@PM_Tx 2 дня назад
So easy to understand. Thank you Alex.
@9884827015
@9884827015 2 дня назад
Thank you so much for patiently explaining everything in detail.
@hardcorehunter7162
@hardcorehunter7162 2 дня назад
Option one lie and get the job but have a chance of being fired but gaining work experience and a salary out of it to avoid a job gap., your next job will never know because they can't asked why were you fired. Or the second option, hand them an honest under qualifying resume where they won't hire you, but it shows the world you have gumption and 40 years later you're a senator. Truth is if an employer believes they need 3+ years experience or a college degree to do this medial level job, then they deserve to be lied to.
@JJJoeJoe
@JJJoeJoe 2 дня назад
So without a Bachelor’s or Master’s degree then taking the Google course is a complete waste time?
@KnackiiTM
@KnackiiTM 2 дня назад
Very clear and concise video, tyvm!
@TheBestMrSam
@TheBestMrSam 2 дня назад
I just want to say a big thanks to you. This video is priceless
@imvimalkumar007
@imvimalkumar007 2 дня назад
Is it alright if I don't get it in the first go?
@CatherineBean
@CatherineBean 2 дня назад
For big files with a lot of tricky formulas, I sometimes keep a kind of change tracker on a separate sheet. I make a list of all the formulas in the workbook, use FORMULATEXT to show them as a string, and copy paste as values in a helper column next to it. Conditional formatting to show if the FORMULATEXT differs from the pasted-as-values version, and I can tell at a glance where I made edits (or someone else broke something).
@gustavonix
@gustavonix 2 дня назад
I can't follow this project if I use a big company like amazon or twitter, I tried with a website from a smaller company and it worked. I'm doing this project in June 2024.
@ash1983
@ash1983 2 дня назад
Thank you for this video and for all your tutorials. Question: what is the difference between using a temp table to store a part of a table and using a view to store the same logic and the same part of that table?
@Sana-hg8ow
@Sana-hg8ow 2 дня назад
wow database is actually so so convenient and useful! i really hope to learn this
@momohtimothy6898
@momohtimothy6898 2 дня назад
Couldn't understand a thing on this topic on Udemy, but you lay it down simple here. Glad there's a channel like this.
@kevindeschepper8140
@kevindeschepper8140 2 дня назад
df.xs('Australia', level='Country') met cross section kan je op land zoeken zonder continent te specifieren, geweldige serie, alles gevolgd tot nu toe. Je tempo is top, niet te snel niet te langszaam
@actuallylans718
@actuallylans718 2 дня назад
It says "In order to run a trace against SQL Server you must be a member of sysadmin fixed server role or have the ALTER TRACE permission". What do I do?
@sifisomahlangu-ft2sg
@sifisomahlangu-ft2sg 2 дня назад
How can I pay if I am from South Africa?
@NkemjikaNwanebu
@NkemjikaNwanebu 2 дня назад
nice
@NkemjikaNwanebu
@NkemjikaNwanebu 2 дня назад
amazing Alex, good job
@aslamshaikhisdi
@aslamshaikhisdi 2 дня назад
Hello, Could anyone please help me with uploading this data set to my SQL 8 bench? Table has been created but the data is not loading.
@NkemjikaNwanebu
@NkemjikaNwanebu 2 дня назад
good job
@nickcheruiyot9069
@nickcheruiyot9069 2 дня назад
Hey Alex your videos are very good and helpful, I can't find some function like XLOOKUP and TEXTSPLIT in my version of excel is this normal?
@ajaybhandari9596
@ajaybhandari9596 2 дня назад
Amazing tutorial. thanks for straightforwardly explaining this. I want to request you to please make a video on Mathematics used in Data analysis.
@rnpk9572
@rnpk9572 3 дня назад
this was amazing! thanks
@chowdhuryjoy
@chowdhuryjoy 3 дня назад
1st Day done
@Chris-kq7ir
@Chris-kq7ir 3 дня назад
People have been commenting for months about the developer default option. Can you please provide us with an update on what to do about that? Thanks.