Sales Pipeline from CRM Data

DunderMifflin — Sat, 22 Feb 2025 02:33:23 GMT

Overview of the Dataset

The dataset used for this analysis simulates a B2B sales pipeline from a fictitious company specializing in computer hardware.

Sales Pipeline Visualization Choices

Initially, I considered using a Sankey chart to represent the sales pipeline, as it is particularly effective in showing flow relationships, such as the movement of deals from one stage to another. However, due to limitations in the available dataset and the need for a more detailed breakdown of sales drivers, I opted for a decomposition tree instead.

The decomposition tree offers a powerful way to drill down into sales data, enabling users to dynamically explore key factors contributing to win rates and revenue performance. By allowing segmentation by Sales Agent, Customer Account, Product, Region, Office, and Sector, this visualization ensures that decision-makers can identify bottlenecks and high-performing segments with ease.

Enhancing Visuals with the New Filter Feature

One of the standout features used in this analysis was the new filter visual, which supports embedding images through URLs. This functionality is particularly valuable for enterprises with large sales teams, as it enhances memory retention and recognition. For example, including sales agents’ profile pictures or product images helps users quickly associate data points with real-world entities, making the dashboard more intuitive and engaging.

Using Parameters for Dynamic KPI Measurement

To provide deeper flexibility in sales performance analysis, I leveraged parameters to enable users to toggle between different key performance indicators (KPIs). With this setup, stakeholders can dynamically switch between metrics such as:

Win Rate by Sales Agent – Identifying top-performing individuals and areas for improvement.
Total Revenue by Product – Understanding which hardware products drive the most sales.
Sales Performance by Region or Office – Evaluating the effectiveness of different territories.
Sector-Based Analysis – Assessing sales trends across different industries.

By integrating parameters, I ensured that the dashboard could serve multiple analytical needs without requiring additional reports or manual filtering.

eyJrIjoiYWJmNDMyOTktY2FlNS00YTI1LWJlYTMtMTZhODI0MTRjOGUxIiwidCI6IjY4ZDQ1MzNjLWVhZTYtNDgzMy05OWNjLTdhOTcwNGFjODcwYiIsImMiOjZ9

Re: Sales Pipeline from CRM Data

AlexGMathieu — Mon, 11 Aug 2025 15:01:45 GMT

Great Job!
Where did you get the dataset from?

topic Re: Sales Pipeline from CRM Data in Data Stories Gallery

Sales Pipeline from CRM Data

Sales Pipeline Visualization Choices

To provide deeper flexibility in sales performance analysis, I leveraged parameters to enable users to toggle between different key performance indicators (KPIs). With this setup, stakeholders can dynamically switch between metrics such as:

Win Rate by Sales Agent – Identifying top-performing individuals and areas for improvement.

Total Revenue by Product – Understanding which hardware products drive the most sales.

Sales Performance by Region or Office – Evaluating the effectiveness of different territories.

Sector-Based Analysis – Assessing sales trends across different industries.

By integrating parameters, I ensured that the dashboard could serve multiple analytical needs without requiring additional reports or manual filtering.

Re: Sales Pipeline from CRM Data