Analysis
Sales Performance Analysis for a 40-Person SaaS Scale-Up
Overview
What this challenge is about.
You will receive a dataset containing 500+ sales opportunities with fields like deal value, stage, source, close date, and account size. Your challenge is to design a data mart for sales analysis, implement ETL to clean and load the data, and create a set of reports (using any BI tool) that answer: Which customer segments have the highest conversion? Which channels yield the largest deals? What is the average sales cycle length? Success means delivering a dashboard with at least 5 key performance indicators (KPIs) and a written analysis recommending where to focus sales efforts. Constraints: use provided synthetic data; no external data sources.
The Brief
What you'll do, and what you'll demonstrate.
Build a BI reporting system that enables the sales team to identify the most promising customer segments and channels for enterprise sales.
Earning criteria — what you'll demonstrate
- Design a data mart tailored to sales analytics
- Implement ETL processes for data cleaning and integration
- Apply OLAP techniques to analyze sales funnel and segmentation
- Create effective reports and dashboards for business users
- Translate data insights into strategic recommendations
Program Fit
Where this fits in your program.
Sharpens the same skills your degree expects you to demonstrate.
Skills
Skills you'll demonstrate.
Each one shows up on your verified credential.
Careers
Roles this prepares you for.
Real titles. Real skill bridges. Pick the one closest to your trajectory.
Career mappings coming soon.