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

📊 Build an interactive Excel dashboard to explore and analyze coffee shop sales in this beginner-level Guided Project! ☕️
Follow along by creating a free Maven account and accessing our Guided Projects: mavenanalytics.io/guided-proj...
OR
Download the dataset from our free Data Playground: mavenanalytics.io/data-playgr...
⏱️Timestamps⏱️
00:00 - Intro
00:52 - Project Brief
01:59 - Downloading the data set
02:45 - Objective 1
11:30 - Objective 2
17:56 - Objective 3
34:13 - Outro
💡 With Guided Projects, your goal is to solve a pre-defined series of tasks and objectives, designed to simulate the exact types of problems that data professionals encounter on the job.
Projects range from basic to advanced, feature tools like Excel, MySQL, Power BI, Tableau and Python, and cover topics spanning HR, transportation, hospitality, retail, government, and more.
For more details, visit mavenanalytics.io/guided-proj...
Ready to take your learning to the next level?
🗣️ Follow us on LinkedIn for daily data analysis tips and career guidance: / maven-analytics
💡 Interested in data courses? Join over 1,000,000 students who have taken our Maven Analytics courses in Excel, SQL, PowerBI, Tableau, Python and more: www.mavenanalytics.io/online-...

[@piymhz6775]

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

[@humemahkhalid891]

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

[@CharlesDeBarros]

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]

Glad to hear it Charles, thanks for the note!

[@user-lw1nv8fr4k]

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.

[@Chris-at-Maven]

Thank you very much!

[@moxie1189]

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]

Great suggestion, it's actually in the works!

[@MrVenterW]

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

[@Chris-at-Maven]

Thank you! ☕

[@jadehandy]

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!

[@Chris-at-Maven]

Glad you found it helpful!

[@fathimashanavas6511]

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

[@MavenAnalytics]

Glad it was helpful!

[@lavanyachinthapatla9468]

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

[@alivevideos]

Thank you so much

[@TheLearningMe]

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

[@Chris-at-Maven]

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

[@roderickmose4691]

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]

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]

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

[@heli1281]

I hope you create a video for power bi dashboard

[@MavenAnalytics]

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

[@jaysrej]

is it power bi dashboard?

[@CaribouDataScience]

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

[@ronnie2138]

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

[@ezekieldaniel6774]

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

[@MavenAnalytics]

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

[@menghao4576]

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

[@MavenAnalytics]

At the moment, there are four free guided projects.