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

Подписаться 35 тыс.

Просмотров 15 тыс.

50% 1

📊 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-...

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@piymhz6775 5 дней назад

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 2 месяца назад

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

@CharlesDeBarros 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 4 месяца назад

Glad to hear it Charles, thanks for the note!

@user-lw1nv8fr4k 4 месяца назад

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 4 месяца назад

Thank you very much!

@moxie1189 7 месяцев назад

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 7 месяцев назад

Great suggestion, it's actually in the works!

@MrVenterW 7 месяцев назад

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

@Chris-at-Maven 4 месяца назад

Thank you! ☕

@jadehandy 7 месяцев назад

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 4 месяца назад

Glad you found it helpful!

@fathimashanavas6511 5 месяцев назад

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

@MavenAnalytics 5 месяцев назад

Glad it was helpful!

@lavanyachinthapatla9468 25 дней назад

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 6 месяцев назад

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

@Chris-at-Maven 4 месяца назад

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

@roderickmose4691 7 месяцев назад

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 7 месяцев назад

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 7 месяцев назад

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

@heli1281 7 месяцев назад

I hope you create a video for power bi dashboard

@MavenAnalytics 7 месяцев назад

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