SAPL_Sales_Funnel

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

• Link to the Site
• Link to the Interactive Dashboard

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

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

Overview :

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