Skip to content

SharvananB0510/SAPL_Sales_Funnel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 

Repository files navigation

SAPL_Sales_Funnel

As part of the bluetick.ai workstation experience, I had the opportunity to work on this project.

Problem Statement

Strent AH Pvt Limited (SAPL) has recently launched student hostels across India, providing flexible room rentals to university students and exam aspirants through their app and website. However, despite a surge in website visits and app usage during the admission season, the actual conversion rate of students joining SAPL was low (approximately 13%). To understand the reasons behind this drop, SAPL plans to analyze the stages of student acquisition in detail.

Solution

I created a Sales Funnel Analysis for SAPL to understand the different stages of the funnel and identify the significant factors contributing most to the lower lead conversion ratio.

Table Schema

image

Steps Followed in this Project

  1. Gathered and transformed the data in Excel.
  2. Conducted a basic exploratory data analysis to understand the data's characteristics.
  3. Connected the Excel dataset to Power BI.
  4. Created measures as needed and used them to create visuals in Power BI.

Final Result

SAPL cover

Overview :

image The subsequent process flow provides a comprehensive overview of the sales process that operates throughout the entire SAPL sales funnel.

Interactive dashboard

2023-10-28-02-21-43.mp4

About

Sales Funnel - Live Interactive Dashboard

Topics

Resources

Stars

Watchers

Forks