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: https://mavenanalytics.io/guided-proj... OR Download the dataset from our free Data Playground: https://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 https://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: https://www.mavenanalytics.io/online-...

Data Analyst Portfolio Project: Toy Store KPI Report in Power BI (with Solutions)
▶︎

Data Analyst Portfolio Project: Toy Store KPI Report in Power BI (with Solutions)

The ONLY EXCEL PORTFOLIO PROJECT YOU NEED
▶︎

The ONLY EXCEL PORTFOLIO PROJECT YOU NEED

30 Day Excel Challenge | Full Course (14+ hours) | #excel #dataanalysis #dataanalytics
▶︎

30 Day Excel Challenge | Full Course (14+ hours) | #excel #dataanalysis #dataanalytics

Power BI FULL COURSE for Beginners | Learn Dashboards & Reports Fast!
▶︎

Power BI FULL COURSE for Beginners | Learn Dashboards & Reports Fast!

Power BI Columns vs Measures | Real World Demo
▶︎

Power BI Columns vs Measures | Real World Demo

Which Tool Handles 40,000 Hotel Bookings Best? | Excel vs Power Query vs SQL vs Python
▶︎

Which Tool Handles 40,000 Hotel Bookings Best? | Excel vs Power Query vs SQL vs Python

Calculating Monthly Changes in Aggregate Data | Excel vs SQL vs Power BI vs Python
▶︎

Calculating Monthly Changes in Aggregate Data | Excel vs SQL vs Power BI vs Python

Data Analysis Project in Excel (Beginner to Intermediate)
▶︎

Data Analysis Project in Excel (Beginner to Intermediate)

Should You Become a Data Analyst in 2026? Honest Answer
▶︎

Should You Become a Data Analyst in 2026? Honest Answer

Data Drill Showdown #5: Movie Metrics | Excel vs. Power BI vs. SQL vs. Python
▶︎

Data Drill Showdown #5: Movie Metrics | Excel vs. Power BI vs. SQL vs. Python

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
▶︎

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Excel to Power BI Portfolio Project | Full End-to-End Data Project | #excel #sql #powerbi #python
▶︎

Excel to Power BI Portfolio Project | Full End-to-End Data Project | #excel #sql #powerbi #python

Learn Power BI - Full Data Analyst Course for 2026
▶︎

Learn Power BI - Full Data Analyst Course for 2026

Full Project in Excel | Excel Tutorials for Beginners
▶︎

Full Project in Excel | Excel Tutorials for Beginners

Excel Data Analysis Full Course Tutorial (7+ Hours)
▶︎

Excel Data Analysis Full Course Tutorial (7+ Hours)

Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard
▶︎

Interactive Insights: Excel Dashboard Techniques. How to create Excel Dashboard

Data Analyst Portfolio Project: Restaurant Order Analysis in SQL (with Solutions)
▶︎

Data Analyst Portfolio Project: Restaurant Order Analysis in SQL (with Solutions)

The Only Power BI Portfolio Project You Need
▶︎

The Only Power BI Portfolio Project You Need

Complete Data Analytics Project in Excel | Data Cleaning to Dashboard
▶︎

Complete Data Analytics Project in Excel | Data Cleaning to Dashboard

Excel vs SQL vs Power Query vs Python: Who Wins the NYC Data Cleaning Race?
▶︎

Excel vs SQL vs Power Query vs Python: Who Wins the NYC Data Cleaning Race?