Practice First: Excel Sales Performance Metrics Dashboard Dataset
The main purpose of this blog is to give you the dataset to practice building the Excel Sales Performance Metrics Dashboard. Use this practice Spreadsheet Template to follow the steps below and tailor visuals and KPIs to your sales operation.
How this fits your Dashboard Templates workflow
This structure works across professional Dashboard Templates: adapt it into a Google sheets dashboard or a Power BI Dashboard, and present highlights as a PowerPoint Dashboard using your existing Power Point templates.
Unique Features
- Video Tutorial (Click here)
- Analysis for more than 45 types of data
- Wide Screen – Full HD; preview images included
- Free Font & Icons; Easy Customize
- All objects and database are fully editable
- Exclude Logo
Dashboard Contents & Analysis
- Total Earnings and total Paid Calls
- Top 5 Consultant Sales Revenue
- Total Earnings by Month with Highest/Lowest/Average highlights
- Count and percentage of Total Paid and Unpaid Calls
- Monthly Slicer
- Enrolled Courses and the Average
- Sales per Area Codes
- Training Models Fees by Sales Team
- Total Enrolled Courses by Training Levels
- Top 5 Training Levels
- Average Paid calls duration by month (Min/Max)
- Advertising Spend broken down by channels
- Average Calls by Month
- Total Sales by Sales Team with Top Team highlight
- Consultants by Total Sales with Top Consultant highlight
- Revenue broken down by Training Models
- Advertisement campaigns by total sales
- Training Models Fees by Sales Team and by Consultant
- Slicer for Sales Team
- Modern and clean database data tables
Package Includes
- Excel – XLSX format (411 KB)
- Three sheet tabs: Database, Pivot tables, Dashboard
- Instruction File; Help & Contents File
- Light Theme
Share:
Financial Statistics Dashboard Systems | Tutorial 1
Financial Statistics Dashboards System | Dynamic Excel Map Chart | Tutorial 2
3 comments
Only Database sheet is there others are absent
Hi, I downloaded the dataset but there is only the database sheet and no Pivot table or dashboard. Could you please help me?
good