Analyse data with me | Using pivot tables

Поделиться
HTML-код
  • Опубликовано: 18 сен 2024

Комментарии • 71

  • @theajaoalimat
    @theajaoalimat 2 года назад +3

    It is the way you simplify your videos for me.
    Thank you so much🙌

  • @zaitunpeace
    @zaitunpeace 2 года назад +3

    Thank you!
    I just got to know about the Google Data Analytics Certification through your channel last week.
    I’m now on Module 3 and having a blast!
    You have a new subscriber and I owe you one!

    • @walegbads
      @walegbads  2 года назад +1

      Fantastic! Welcome aboard!

  • @Holu54
    @Holu54 2 года назад +2

    Thanks Wale, that was brief and impactful.

    • @walegbads
      @walegbads  2 года назад

      Great!

    • @yemuraimlambo8719
      @yemuraimlambo8719 2 года назад

      @@walegbads Hey can you comment on LinkedIn certificates that's what I'm starting with then I'mma do a business analyst one

  • @adebayoabiola2428
    @adebayoabiola2428 Год назад +1

    Thanks so much.
    This video was very helpful. Can you please do more of something of this nature. Like exercise to improve ones idea on analysis.

    • @brand1974
      @brand1974 Год назад +1

      I second this comment. Would really like to see videos like this as well.

  • @Fehintiti_
    @Fehintiti_ 2 года назад +1

    Thanks Wale..Would appreciate a Portfolio Project 😀

  • @yasithdissanayake4556
    @yasithdissanayake4556 2 года назад

    Damn, so clear. Thanks for the great stuff!

  • @Etin_Gabriel
    @Etin_Gabriel 2 года назад +2

    Nice one......I have waited for long tho

  • @sandilekhumalo5693
    @sandilekhumalo5693 2 года назад +1

    Great video!!! Pivot table under another pivot table can be a problem if data is going to be analyse over a long period.
    As the top table grows, it will end up overlapping to the one below it.
    Maybe it’s better to have one pivot table on each sheet? 🤔

    • @walegbads
      @walegbads  2 года назад

      Absolutely. Good point!

  • @iwalewa_ery
    @iwalewa_ery 2 года назад

    This was very insightfull but short, can you please make longer versions . please Adewale.

  • @brendamg7298
    @brendamg7298 2 года назад

    Thank you so much

    • @walegbads
      @walegbads  2 года назад +2

      You're most welcome

  • @thereelaccountant9246
    @thereelaccountant9246 2 года назад

    absolutely incredible bro

  • @mariamadekanye
    @mariamadekanye 2 года назад

    Finally 💃💃. Been waiting for this video

  • @taiwo_odu
    @taiwo_odu 2 года назад

    Loved this!

  • @suganya9838
    @suganya9838 2 года назад

    Amazing video 👊🏾👊🏾👊🏾👊🏾👊🏾

  • @kamogelokhumalo4792
    @kamogelokhumalo4792 2 года назад

    Hi Wale. I've been following your videos form last year and they are quite informative I must say. I just completed my Google analytics certificate, thanks to you. My question is where to from here. Thank you in advance.
    Kamo in South Africa

    • @williamfesters7199
      @williamfesters7199 2 года назад

      Hi through which platform did you do your certification I am also from SA

  • @awhypappy
    @awhypappy 2 года назад

    Nice video but you didn't show the full master piece you used in merging the two datasets

  • @agyekumkenneth3466
    @agyekumkenneth3466 4 месяца назад

    Where do you get the questions

  • @zamasomimsomi450
    @zamasomimsomi450 2 года назад

    Concise.

  • @Knynn
    @Knynn 2 года назад

    Thanks wale

  • @hazeezatadebayo8319
    @hazeezatadebayo8319 2 года назад

    Can anyone please explain how he joined the 2020 data with the 2016 one??

  • @abiodunonadeji7549
    @abiodunonadeji7549 2 года назад

    Thanks a lot.

  • @mizpahgideon3768
    @mizpahgideon3768 2 года назад

    Hi Wale, do you have a video on Data Analyst Salaries and work life preferably in Nigeria?
    If you don't, could you make one please 🥺

  • @peterolawoye5715
    @peterolawoye5715 2 года назад

    Thank you

  • @lilianezeli5521
    @lilianezeli5521 2 года назад

    Please in 3:27 I tried doing that YEAR(G1) - Year(G3) and its returning a value error in my excel. I'm using Microsoft excel 365. how did yours work?

  • @agbooladavid5353
    @agbooladavid5353 2 года назад

    Good afternoon Mr Wale
    Please how can I have access to your data analysis training??

  • @thearowele
    @thearowele 2 года назад +1

    Hello Wale,
    The Athlete CSV file of the 2021 Olympics in Tokyo dataset has only Three (3) columns in the link shared.
    The one you worked with had about fourteen columns.
    Can you help look into this?

    • @walegbads
      @walegbads  2 года назад +1

      Sure. check again now.

    • @thearowele
      @thearowele 2 года назад

      I can now access the dataset.
      Thanks Wale.

    • @bamigboladapo7076
      @bamigboladapo7076 2 года назад

      @@walegbads Hello Wale
      I have the same issue. I can only see3 columns on the athletes worksheet.
      How can I access the others?

  • @johncloutier3887
    @johncloutier3887 2 года назад

    Hey buddy, I know data analytics course is self pace but how along did you spend to clear the program? 🤔

    • @walegbads
      @walegbads  2 года назад +1

      i already knew most of the stuff...took me less than 3 weeks

  • @luisosegbowa394
    @luisosegbowa394 2 года назад +1

    My Tokyo 2021 data only has Name, Country And Discipline.

    • @walegbads
      @walegbads  2 года назад

      Nah...you should have more than that. Did you download using the link in the description?

    • @luisosegbowa394
      @luisosegbowa394 2 года назад

      @@walegbads Yes and i have downloaded more than 3 times but it's all the same.

    • @luisosegbowa394
      @luisosegbowa394 2 года назад

      @@walegbads But it's fine though. I did everything you did with the other data and I am good for it. Thank you so much.

    • @michelles.5198
      @michelles.5198 2 года назад

      @@walegbads Same thing happened to me and I followed your steps.

  • @Infobydavid
    @Infobydavid 2 года назад

    Great Content sir . Does the datasets on kaggle come along with Tasks for Analysis? Or we just have to create a task(problem) , then analyze the data to Solve the created Task(problem)??

    • @walegbads
      @walegbads  2 года назад

      absolutely....for this dataset i didnt find a task assigned to it on Kaggle. so you will have to create your task

  • @hatimouahbi6250
    @hatimouahbi6250 2 года назад

    Thank You Boss

  • @uchechukwumazi6512
    @uchechukwumazi6512 2 года назад

    Please a question. Started learning by myself. Will like to know what type of sql will I be needing for data analytics as a beginner(i want to know what kind of sql I will be needing for data analytics)

    • @walegbads
      @walegbads  2 года назад

      what do you mean by what kind of sql?

    • @uchechukwumazi6512
      @uchechukwumazi6512 2 года назад

      @@walegbads someone starting on the Dataanalytics journey. What should be covered in sql

    • @walegbads
      @walegbads  2 года назад +1

      @@uchechukwumazi6512 mastery of select, from, where statements. Having, Group by, order by, joins as well as other aggregate functions

  • @heartbeattv7687
    @heartbeattv7687 2 года назад

    How much does it cost to get the certificate on Coursera?

  • @Chrisley56
    @Chrisley56 Год назад

    Hello wale. Can you make this video but for a beginner. You’re too fast. For example, didn’t know how you split the screen. Cleaning your data, you didn’t check for duplicate does it not matter in this case....? Also, how’d you append both dataset? Like I said, data analysis for a beginner.

  • @adebowale9919
    @adebowale9919 2 года назад

    Thanks for this video
    How did you arrive at 92% ?

    • @walegbads
      @walegbads  2 года назад +1

      simply divide the 2021 women/men participants

  • @malenaprinzing2010
    @malenaprinzing2010 2 года назад

    Could you update the captions please? :)

  • @adeyemiadeyemi6668
    @adeyemiadeyemi6668 2 года назад

    Do you have a twitter account bro?

  • @oyingiwahouse_of_majestic254
    @oyingiwahouse_of_majestic254 2 года назад

    Thanks wale