From the course: Business Analytics: Sales Data
Unlock this course with a free trial
Join today to access over 24,900 courses taught by industry experts.
Build a dashboard for a sales team
From the course: Business Analytics: Sales Data
Build a dashboard for a sales team
- [Instructor] Have you ever struggled to show your KPIs in a sales meeting because of jumping back and forth between different spreadsheets? Let's fix that. In this lesson, you'll see how to build a simple, effective sales dashboard that tracks your most important KPIs, using external data sources and interactive visuals. Before you build anything, define the purpose of your sales dashboard, and determine the most important KPIs. If you're building a sales revenue dashboard for your monthly meeting with the CEO, consider KPIs like total monthly revenue, total deals closed, and top, or losing products. Let's now build a dashboard using Google Looker Studio, which connects easily with external data sources, such as Google Sheets, Google Analytics four, Google Ads, and CRMs. Log into your Google Looker Studio account. Now, you can either choose a blank report to start from scratch, or click on template gallery to choose a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.