Data Analyst Portfolio Project: Build an Excel Dashboard (with Solutions)

Поділитися
Вставка
  • Опубліковано 2 жов 2024

КОМЕНТАРІ • 37

  • @momohtimothy6898
    @momohtimothy6898 Місяць тому +2

    You are just too good sir. On another video this could have been hours.

  • @MrVenterW
    @MrVenterW 10 місяців тому +4

    Thank you Chris, nice, short and to the point like a good cup of coffee

  • @moxie1189
    @moxie1189 10 місяців тому +5

    I think making the completed excel workbooks, power bi pbix files, tableau twbx files and eventually Jupyter notebooks available for these guided projects, as they evolve and incorporate more of the instructors and their expertise, would be incredibly useful.

    • @MavenAnalytics
      @MavenAnalytics  10 місяців тому +1

      Great suggestion, it's actually in the works!

  • @piymhz6775
    @piymhz6775 3 місяці тому +3

    Most useful video I've seen so far from my point of view. I'm a beginner and it is really killing my drive and motivation to follow along hours of theoretical videos without knowing were this is going and how the knowledge will be applied. Here I can follow along and see the actual skills in action and learn by doing myself. Great stuff. I would add some teaser visuals at the beginning to see what we will achieve, not just explainations and text. Quick question. Why add headers and not a table ? Cheers from France. A

  • @heli1281
    @heli1281 10 місяців тому +2

    I hope you create a video for power bi dashboard

    • @MavenAnalytics
      @MavenAnalytics  10 місяців тому +2

      We've created one! The Toy Store KPI Report PowerBI Dashboard can be found on our website and is free to access: www.mavenanalytics.io/guided-projects#projects-list

  • @ahassan7270
    @ahassan7270 Місяць тому +1

    Thank you so much for this amazing video! It was really insightful and well-made. I learned a lot and truly appreciate the effort you put into creating this content. Keep up the great work!👏👏

  • @CharlesDeBarros
    @CharlesDeBarros 10 місяців тому +7

    Keep up with the excellent material. 👏👏👏
    As a recent career changer, from web development to data analytics, these kinds of study materials are priceless.
    Thank you.

    • @Chris-at-Maven
      @Chris-at-Maven 7 місяців тому +1

      Glad to hear it Charles, thanks for the note!

  • @ericachioma1615
    @ericachioma1615 2 місяці тому

    Interesting.What happened to total sales and total sales volume .you only worked on transaction id

  • @roderickmose4691
    @roderickmose4691 10 місяців тому +3

    Hi Chris, excellent starter tutorial. If I'm only interested in Excel projects at this stage, do you have Excel/PQ only projects that range from basic to advanced?

    • @MavenAnalytics
      @MavenAnalytics  10 місяців тому +2

      We have a few Excel projects live now (Coffee Shop, HR Survey Analysis, Traffic Safety) and one that combines Excel + SQL (Motor Vehicle Thefts). The HR project is intermediate and involves some good visualization techniques, but we haven't built a Power Query project quite yet. That said, we're producing new projects monthly and will certainly plan to include PQ!

    • @roderickmose4691
      @roderickmose4691 10 місяців тому

      Thanks guys. I'll be sure to check out your website projects.

  • @ธัชภรณ์สัทธาพงศ์

    I am a big fan of you and would like show big appreciation towards your excel works.You make everything so easy to follow along for such a beginner with little experience.Always keep up the good work.

  • @fazlkhn
    @fazlkhn 2 місяці тому +1

    Very helpful, thanks !

  • @humemahkhalid891
    @humemahkhalid891 5 місяців тому +1

    Chris you are the best teacher ever. Anything you teach becomes so easy to understand and follow. May Allah bless you.

  • @saheedmorenikeji4020
    @saheedmorenikeji4020 2 місяці тому

    Excellent Guided tutorial from you guys, Keep up the good job❤.
    It was observed that in the dataset we have 6:00 am and 6:00pm but it was incorporated into 6:00 on the Pivot table, How do we go about it pls.
    Thank you.
    ❤❤❤

  • @TheLearningMe
    @TheLearningMe 10 місяців тому +1

    Hi Chris. I hope that you make a video or a course that focuses on data cleaning. Thanks!

    • @Chris-at-Maven
      @Chris-at-Maven 7 місяців тому

      We'll definitely add some guided projects with a heavy focus on data prep and cleaning - stay tuned!

  • @jadehandy
    @jadehandy 10 місяців тому +1

    This is great! Great because the project is very straightforward and beginner oriented. Great because the dataset is useful for going beyond the guided project, like analyzing for cross sell opportunities, etc. Thanks!

  • @menghao4576
    @menghao4576 10 місяців тому +1

    Hello,may I ask how many projects do free users have access to?

    • @MavenAnalytics
      @MavenAnalytics  10 місяців тому +1

      At the moment, there are four free guided projects.

  • @lavanyachinthapatla9468
    @lavanyachinthapatla9468 4 місяці тому

    Thank you so much sir 😊😊😊 it am learning a lot as a housewifr want to become a dataanalyst lots of love from india

  • @fathimashanavas6511
    @fathimashanavas6511 9 місяців тому +1

    Hi Chris! I got to learn so much through this guided project. Thank you!

  • @CaribouDataScience
    @CaribouDataScience 10 місяців тому

    How can I add leading zeros to day and. Month?

    • @ronnie2138
      @ronnie2138 10 місяців тому +2

      ="0"&DAY(serial_number) for the day or you can use ="0"&MONTH(serial_number) for the month

  • @ezekieldaniel6774
    @ezekieldaniel6774 4 місяці тому

    Thank you for the class but i cant download the csv file to this project

    • @MavenAnalytics
      @MavenAnalytics  4 місяці тому +1

      You can find all guided project data sets on our data playground: mavenanalytics.io/data-playground?search=coffee%20shop%20sales

  • @alivevideos
    @alivevideos 4 місяці тому

    Thank you so much

  • @jaysrej
    @jaysrej 3 місяці тому

    is it power bi dashboard?