Who asked: Marcus Bell, who runs the East sales team.
Why: every Monday Marcus rebuilds the same numbers in a spreadsheet from exports: open pipeline by stage, weighted pipeline by rep, and revenue won this quarter. The numbers never quite match the CRM.
The data: the deals in the Sales Pipeline, their amounts, stages, owners and close dates.
Done looks like: three saved reports on a dashboard the team can open, a version filtered to Marcus for his one-to-one, and his weighted pipeline read off it.
A dashboard is a page of reports that answers one person's recurring questions. Marcus Bell runs the East team's Monday meeting and asks the same three things every week: where is the open pipeline, what is it worth weighted by owner, and what have we won this quarter. In this project you build those reports, the dashboard, and a version filtered to one rep.