Projects
Professional Data Analytics Projects
Detailed project work from her Data Analyst role at Homz N Space, Bangalore.
Project 01 - Homz N Space
Sales Performance & Revenue Analytics
Developed a sales performance and revenue analytics solution to monitor business performance, evaluate sales productivity and analyse revenue trends across multiple real-estate regions. The project focuses on transforming sales data into meaningful business insights to support management decisions.
Business Objectives
- Monitor overall sales performance and revenue generation.
- Evaluate employee-wise and regional sales performance.
- Track bookings, cancellations and net booking figures.
- Identify trends in lead generation, site visits and booking conversions.
- Provide management with a consolidated view of business performance.
Key Responsibilities & Activities
- Collected, organised and maintained sales datasets containing employee details, project information, lead counts, site visits, bookings and revenue figures.
- Cleaned and validated datasets by identifying missing values, inconsistent formats and duplicate records.
- Analysed gross bookings, cancellations, net bookings and net revenue to understand actual business performance.
- Compared sales performance across different regions, including East, North, South and Hyderabad.
- Evaluated employee productivity by analysing individual leads, visits, bookings and revenue contributions.
- Created KPI summaries to monitor business performance and identify areas requiring improvement.
- Developed SQL queries to retrieve, filter, aggregate and analyse sales data.
- Used Power BI to build interactive dashboards with KPI cards, regional comparisons, employee performance and monthly sales trends.
- Used Excel for data preparation, validation, reporting and reconciliation.
Key Performance Indicators
Total LeadsTotal Site VisitsTotal BookingsGross BookingsCancellationsNet BookingsGross RevenueNet RevenueLead-to-Visit Conversion RateVisit-to-Booking Conversion RateEmployee-wise Revenue Contribution
Tools & Technologies
Microsoft Excel for data cleaning, validation, analysis and reporting. SQL for data extraction, joins, aggregations and business analysis. Power BI for data modeling, DAX measures and interactive dashboards.
Business Value
Provides management with a consolidated view of sales performance, helps identify high-performing regions and employees, highlights conversion trends and supports data-driven business decisions.
Project 02 - Homz N Space
Lead Management & Conversion Analytics
Developed a lead management and conversion analytics solution to monitor customer enquiries, lead allocation, sales follow-ups, site visits and booking conversions. The objective is to understand how effectively leads move through the sales pipeline and identify opportunities to improve conversion performance.
Business Objectives
- Monitor incoming customer enquiries and lead distribution.
- Analyse lead allocation across sales teams and regions.
- Track the movement of leads through different sales stages.
- Measure enquiry-to-visit and visit-to-booking conversion rates.
- Identify duplicate records and improve data accuracy.
- Evaluate sales team performance and lead conversion efficiency.
Key Responsibilities & Activities
- Maintained structured lead datasets containing customer enquiries, contact details, assigned employees, project information and lead statuses.
- Organised lead allocation data across different sales teams and geographical zones.
- Performed data cleaning and validation to identify duplicate contacts, missing information and inconsistent entries.
- Analysed lead movement from initial enquiry to site visit and final booking.
- Calculated lead-to-visit and visit-to-booking conversion percentages.
- Compared lead handling and conversion performance across sales employees and regions.
- Identified trends in lead distribution, follow-up progress and conversion outcomes.
- Developed SQL queries to retrieve lead records, join related datasets, identify duplicates and calculate conversion metrics.
- Created Power BI dashboards to visualise lead distribution, conversion funnels, regional performance and employee-wise results.
- Used Excel and Google Sheets to maintain tracking reports and validate business data.
Key Performance Indicators
Total Leads ReceivedLeads AllocatedPending LeadsSite Visits CompletedBookings GeneratedLead-to-Visit Conversion RateVisit-to-Booking Conversion RateOverall Lead Conversion RateEmployee-wise Lead PerformanceRegion-wise Conversion PerformanceDuplicate Lead Records
Tools & Technologies
Microsoft Excel for data organisation, cleaning and validation. SQL for data querying, joins, duplicate identification and conversion analysis. Power BI for data visualization, KPI reporting and conversion dashboards.
Business Value
Helps management understand lead distribution and sales pipeline efficiency, identify conversion gaps, improve data quality and evaluate sales team performance.
Project 03 - Homz N Space
Real Estate Website Content & Data Management
Supported website content management and property information updates for the company's real-estate website, ensuring that project details, pricing, unit availability and SEO information remained accurate and consistent.
Key Responsibilities & Activities
- Managed and updated real-estate project posts and website content using WordPress.
- Updated project descriptions, property details, pricing information and unit availability.
- Reviewed and maintained consistency of property information across website pages.
- Worked on SEO titles, meta descriptions and schema-related settings.
- Supported website content improvements and updates to enhance website information quality.
- Coordinated project information updates with internal teams.
Tools & Technologies
WordPress, Microsoft Excel and SEO content management tools.
Business Value
Improved the accuracy, consistency and presentation of property information on the company website and supported ongoing website content and SEO improvements.