This project applies RFM analysis on a retail transaction dataset with a million entries to segment customers into categories like loyal, potential, and churned, helping businesses target and retain valuable customers through data-driven strategies.
I performed Exploratory Data Analysis (EDA) on a sales dataset using R language to uncover patterns, detect anomalies, and highlight key business insights using summary statistics and visualizations.
I used Power BI to create 15 interactive business intelligence reports by connecting data from multiple sources, building advanced DAX measures, and visualizing insights through charts like Column, Line, Pie, Combo, Scatter, Treemap, Funnel, Gauges, and KPIs.
I worked on the business metrics that measure how much a business can plan to earn from the average customer over the course of the relationship and it also tells that how valuable your customer is to your business.
I conducted a survey at Punjab University Hostels to identify key issues in student living. This project involved designing research questions, collecting real data, applying hypothesis testing, and presenting insights to faculty to improve hostel facilities and student satisfaction.
I hosted a webinar on analyzing Pakistan’s Balance of Trade using Power BI, focusing on transforming State Bank data into actionable insights. The session covered advanced data modeling, DAX, and report building to empower attendees with real-world BI skills.