Data Analyst Portfolio Project: Build a Google Sheets Dashboard (with Solutions)

Looking for a great project to practice your Google Sheets skills and add to your portfolio? Check out our CRM Sales Dashboard Guided Project! In this FREE intermediate-level guided project, you’ll follow along with Enrique and use Sheets to build an interactive dashboard for Sales Managers to track their team's quarterly performance. Here’s your brief: You work as a Sales Manager for Maven Tech, a company that specializes in selling computer hardware to large businesses. They’ve just started using a new CRM system to track their sales opportunities but have no visibility of the data outside of the platform. To combat this, you’ve set out to build an interactive dashboard that enables sales managers like yourself to track their team's quarterly performance. Along the way, you’ll… 1️⃣ Prepare the data for analysis 2️⃣ Explore the data with pivot tables 3️⃣ Build a dynamic dashboard Sound interesting? Follow along by creating a free Maven account and accessing our Guided Projects: https://mavenanalytics.io/guided-projects OR Download the dataset from our free Data Playground: https://mavenanalytics.io/data-playground?order=date_added%2Cdesc&search=CRM%20Sales%20Opportunities ⏱️Timestamps⏱️ 00:00 - Intro 00:54 - Project Brief 01:34 - Downloading the data set 02:19 - Objective 1: Prepare the Data for Analysis 13:40 - Objective 2: Explore the Data with Pivot Tables 21:12 - Objective 3: Build a Dynamic Dashboard 33:11 - Outro/Resources 💡 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-projects Ready to take your learning to the next level? 🗣️ Follow us on LinkedIn for daily data analysis tips and career guidance: https://www.linkedin.com/company/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-analysis-courses