No video

Data Analysis Project in Excel (3-Step Framework)

Make a Full Data Analysis Project in Excel!
👉 Take our Excel Course: www.careerprinciples.com/cour...
🆓 DOWNLOAD Free Excel file for this video: careerprinciples.myflodesk.co...
In this video tutorial, we'll go over a full data analysis project in Excel. This will cover the 3 essential parts which are data cleaning, data analysis, and data visualization.
To make this as realistic as possible, we'll be using a real dataset on billionaires, which you can download in the description below. The data cleaning part will include key features such as removing duplicates, creating backups, changing text formatting and much more. The data analysis will begin with descriptive statistics to find the average, min, max, and much more. Then, we'll use pivot tables to analyze our data further. Finally, in data visualization, we'll use slicers and dynamic charts to visualize our data interactively.
LEARN:
🔥Power BI for Business Analytics: www.careerprinciples.com/cour...
📈 The Complete Finance & Valuation Course: www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: www.careerprinciples.com/cour...
🚀 All our courses: www.careerprinciples.com/courses
SOCIALS:
📸 Instagram - careerprinc...
🤳 TikTok - / career_principles
🧑‍💻 LinkedIn - / careerprinciples
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00​ -​ Intro
0:28​ - Data Cleaning
6:07​ - Data Analysis Descriptive Statistics
7:44​ - Data Analysis Pivot Tables
11:04​ - Data Visualization

Пікірлер: 80

  • @KenjiExplains
    @KenjiExplains4 ай бұрын

    🔥Learn more in our Excel Course here: www.careerprinciples.com/courses/excel-for-business-finance

  • @williamchurch711

    @williamchurch711

    3 ай бұрын

    I really want to attend this course are there any promo codes out there?

  • @kemtemartchirouesylvestre

    @kemtemartchirouesylvestre

    14 күн бұрын

    grea

  • @LivingGuy484
    @LivingGuy4844 ай бұрын

    The Casual dragging of a sheet to create a new one was such a Flex to me It's not something I might ever need, but just knowing you can do that is cool

  • @PareshGujarati
    @PareshGujarati3 ай бұрын

    Wow. Learned many things in a single short video... Thanks

  • @DanielNotates
    @DanielNotates4 ай бұрын

    Thanks, grouping pivot function super helpful

  • @edilvaplanas8531
    @edilvaplanas85313 ай бұрын

    Super helpful ❤❤ Thank you so much Kenji Explains 😊

  • @SUPAPEL
    @SUPAPEL4 ай бұрын

    Amazing intro !! Thank you

  • @doyimega
    @doyimega4 ай бұрын

    thank you so much kenji vey clean calm and amazing explanation

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    You're very welcome!

  • @camlex6310
    @camlex63103 ай бұрын

    Really helpful!!

  • @quiloplays698
    @quiloplays6984 ай бұрын

    Short and simple but very informative. Thank you very much!

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Glad it was helpful!

  • @thebytelife

    @thebytelife

    3 ай бұрын

    Are you looking to learn som ebasic pythong skills for data analytics? Check out my newest KZread video here! kzread.info/dash/bejne/hZmXw6qpm9Paaag.html

  • @sorin-gabrielailenei1558
    @sorin-gabrielailenei15584 ай бұрын

    Super, ultra, mega cool!

  • @Singhsushma98
    @Singhsushma984 ай бұрын

    Thanks It Is really helpful. Thank You

  • @anditopan514
    @anditopan5142 ай бұрын

    wow that full information insight, Thnks kenji

  • @alivevideos
    @alivevideos3 ай бұрын

    Thank you so much ❤❤❤

  • @mayuronce
    @mayuronce4 ай бұрын

    Great job

  • @pluto_dp
    @pluto_dp4 ай бұрын

    Very valuable video

  • @BillahaMdMasum
    @BillahaMdMasum4 ай бұрын

    a good one.

  • @willzinner8813
    @willzinner88134 ай бұрын

    short but great thank you

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Glad you liked it!

  • @RalfHeid
    @RalfHeid4 ай бұрын

    Great Tipx, thank you very much

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Glad it was helpful!

  • @MK_Secrets
    @MK_Secrets3 ай бұрын

    AWESOME

  • @manhtuannguyen7512
    @manhtuannguyen75124 ай бұрын

    Thank you very much. It is greatful

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    I'm glad you like it!

  • @tulspalkaur7621
    @tulspalkaur76212 ай бұрын

    @KenjiExplains Thanks you are amazing dude...

  • @Alphapowermind
    @Alphapowermind4 ай бұрын

    Super❤

  • @nasralfy6104
    @nasralfy61043 ай бұрын

    اكثر من رائع

  • @AbdullahAbrar-sc1pw
    @AbdullahAbrar-sc1pw4 ай бұрын

    Great one brother! Would love to learn some SQL basic to advance type tutorials/projects from a real world point of view and then how to visualize it and gaining insights. Subscribed for the amazing content!

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Thank you! Made a 1st video on that last week: kzread.info/dash/bejne/qaGdpsZ7d5DfgJc.html

  • @AbdullahAbrar-sc1pw

    @AbdullahAbrar-sc1pw

    4 ай бұрын

    @@KenjiExplains Haha must've missed it! Thank you. Will be looking out for more!

  • @AbdullahAbrar-sc1pw

    @AbdullahAbrar-sc1pw

    4 ай бұрын

    @@KenjiExplains and another thing i, along with many other would love to know is basic case studies and knowledge of business/finance needed to become a great data analyst! Hoping to see that as well!

  • @arnoldmacatangay3742
    @arnoldmacatangay37423 ай бұрын

    I suggest to use power query when cleaning data

  • @rupalthakur1046
    @rupalthakur10463 ай бұрын

    How to get the data analysis ribbon in MS excel 2021 plus version

  • @CaribouDataScience
    @CaribouDataScience4 ай бұрын

    Whenever I try and using the ceiling function an error? For instance, I enter 68.10 into a cell and when I try an do =CEILING(E17) I get a red box and an error? Any ideas.

  • @Nazaref
    @Nazaref4 ай бұрын

    gracias senor

  • @gadgetgemsonline
    @gadgetgemsonline4 күн бұрын

    You could have add country also it the slice filter

  • @ahmedshahzad9402
    @ahmedshahzad94024 ай бұрын

    Please make a video on advance ecommerce analysis like AOV, CLV, CRR etc.

  • @thebytelife

    @thebytelife

    3 ай бұрын

    Are you looking to learn some basic python skills for data analytics? Check out my newest KZread video here! kzread.info/dash/bejne/hZmXw6qpm9Paaag.html

  • @ItsLrenzo
    @ItsLrenzoАй бұрын

    I'm not sure if it's me, but your =DATE function might be a little different or the order of the cell within the function, it looks like the months are incredibly high numbers.

  • @owolabiademola2440
    @owolabiademola24404 ай бұрын

    HELLO, I DUD SAME THING WITH SAME DATASET BUT MY SUM VALUES ARE DIFFERENT IN THE PIVOT TABLE.

  • @desilvakts2071
    @desilvakts20713 ай бұрын

    when I use the data analysis with the highlighted fields it does not give the headings from the first row, any reason why this is happening ? I have selected the headings in first row option too.

  • @MDCRITICA
    @MDCRITICA4 ай бұрын

    Hi Kenji! Good material mate. Just asking, is it possible to make it harder? Also, I would like to know your vision of the AI in excel and Data Analysis. I think it makes lots of things you are doing here in 1 sec.

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Thank you! As for AI in Excel, I find that the scriptwriting process is quite tedious. Sometimes it does what you want, other times it doesn't so I think that part needs quite a bit of work. Especially when you want it to do very precise things

  • @user-sx5yl3ux4u
    @user-sx5yl3ux4u4 ай бұрын

    Please make out a complete video on project using sql for beginner to showcase their work on platform. Linkedin.

  • @essietakpan6000
    @essietakpan60005 күн бұрын

    please, why is the screen blurred at the anlysis phase. i couldn't see anything. can anyone help.

  • @michealoladeji5316
    @michealoladeji5316Ай бұрын

    Can you please share the datasheet

  • @NPRD1
    @NPRD13 ай бұрын

    How to save these dashboards if we want to send them to someone as pdf or a sheet?

  • @user-fk8yk3rx1h
    @user-fk8yk3rx1h15 күн бұрын

    بعيدا عن انو المدينة كانها ف المتركس.. مدينة خيالية غير خقيقية انت كيف ما خايف انو يعتقلوك و انت منزل الفيديوهات دي و انت لسه هناك؟؟ بالجد مشكور انك اتكلمت بوضوح عن الموضوع دا❤ اللهم انصر اخواننا الايغور و ف كل بقاع الأرض و اجعل لنا من سهام النصر سهما😢❤

  • @kashifbhatti7287
    @kashifbhatti72874 ай бұрын

    Hey Kenji. Please make a tutorial on SQL Part 2 (data analysis series).

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    next week hopefully :)

  • @kashifbhatti7287

    @kashifbhatti7287

    4 ай бұрын

    @@KenjiExplains thank you. :)

  • @amirhussain5745
    @amirhussain57454 ай бұрын

    How to subtract multiple cells from one cell in excel?

  • @UtkarshKumar-mp2ls
    @UtkarshKumar-mp2ls4 ай бұрын

    Always here

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    Thank you!! Means a lot :)

  • @prashantabhowmik7670
    @prashantabhowmik76703 ай бұрын

    Why don't I have the Data Analysis tab in my excel? How can I do the analysis manually since I don't have this tab?

  • @andreamedrano782

    @andreamedrano782

    2 ай бұрын

    I do not have the Data Analysis tab. How can I add it? I could not find it.

  • @ChillWithUche

    @ChillWithUche

    Ай бұрын

    Same here,i dont no how to add the ribbon

  • @jonathanojesebholo5792

    @jonathanojesebholo5792

    12 күн бұрын

    Go to excel options and then click on add-on

  • @utkarshsinha3277
    @utkarshsinha32774 ай бұрын

    kindly create a playlist for SQL

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    New video next week hopefully :)

  • @essietakpan6000
    @essietakpan60005 күн бұрын

    when i drag the date, current date and birth date disappears

  • @exceltips.andtricks
    @exceltips.andtricks3 ай бұрын

  • @preetshah3793
    @preetshah37934 ай бұрын

    Make more videos on sql

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    coming next week :)

  • @erdooabanyi5166
    @erdooabanyi5166Ай бұрын

    How can I get the dataset for this project

  • @essietakpan6000

    @essietakpan6000

    5 күн бұрын

    it's in the description

  • @unique_properties184
    @unique_properties1844 ай бұрын

    I can't see the dataset

  • @KenjiExplains

    @KenjiExplains

    4 ай бұрын

    its in the video description :)

  • @essietakpan6000
    @essietakpan60005 күн бұрын

    i still can't drag the age.

  • @kemtemartchirouesylvestre
    @kemtemartchirouesylvestre12 күн бұрын

    please link of this file

  • @KenjiExplains

    @KenjiExplains

    12 күн бұрын

    in the video description

  • @UXDesigner-b5r

    @UXDesigner-b5r

    8 күн бұрын

    @@KenjiExplains When I click on the link, I get a 502 Bad Gateway page. Can you ensure your site/link is up-to-date or provide a new link from google drive? I would love to follow along with your tutorial in real-time. Thank so much.

  • @khanyanqundwana7526
    @khanyanqundwana75264 ай бұрын

    Don't do process capability etc

  • @Anubis1010-tx1ev
    @Anubis1010-tx1ev3 ай бұрын

    What is the point of doing this kind of simple analysis that can be done by even toddlers 😂

  • @shamisomaisiri9117

    @shamisomaisiri9117

    10 сағат бұрын

    It is done for freshers like me that could not afford varsity and have certificates and need practise. Toddlers dont remain Toddlers but grow and we are not born knowing everything, we start from somewhere and we are not the same.

  • @akramali6574
    @akramali65743 ай бұрын