This project demonstrates how I transformed messy e-commerce product data into a clean, organized, and ready-to-use Excel catalog. Using Excel tools, I standardized product names, categories, prices, and stock levels to ensure accuracy, consistency, and actionable insights for decision-making.
I structure data efficiently, helping businesses save time, reduce errors, and make smarter operational choices.
If you’re running an online store, managing CRM data, or handling large Excel files, I can help you turn raw information into reliable, organized data that works for you.
Skills: Data Entry | Excel | Data Cleaning | Data Organization | Data Validation
1
18
Now let’s talk #churn
I built this Tenant Retention Dashboard to help a real estate firm see what drives loyalty and where to act.
The goal was to find links between churn, satisfaction, and financial results.
Here’s the catch.
The data ended in September, but I reviewed it in November. So I assumed:
• Leases ending before today are #Churned.
• Leases ending after today are #Active.
It’s fine if the logic fits the business and you stay transparent.
Findings:
• Churn: 45%, mostly short-term and low-satisfaction tenants.
• Satisfaction: 3.02, neutral loyalty.
• Occupancy: 89%, strong demand, weak retention.
• Rent collection: low, poor follow-up.
The issue isn’t demand, it’s relationships. Tenants move in, not stay. Weak communication, slow maintenance, and low trust drive exits. Focus on keeping tenants, not chasing new ones
1
1
34
So, I asked the question every analyst should ask “why?”
Why are most offenders not being arrested?
I checked the breakdown.
Most incidents happened in urban and low-income areas.
Police activity there was highest only when responding, not investigating.
That was the problem. We react fast but follow up slow.
The more I cleaned and rearranged, the more the story unfolded
Theft was the most common crime.
Males dominated the data.
Most abusers were between 26 and 38 years old.
And drug types? Cocaine and marijuana led the pack
So, I redesigned the dashboard to show these relationships
Grouped by location, income, and drug type.
Insights:
Low-income areas, high incidents.
Urban centers, heavier response load.
Investigations, not enough
At that point, I realized this wasn’t a dashboard about drugs.
It was a story about system gaps.
1
46
I built an HR attrition dashboard on Excel. It tracks hires, retention, attrition rate, average tenure, demographics, roles, commute distance, and department.
Here are some key findings:
• Total attrition rate: 16.1%
• Average tenure: 7 years
• Most attrition cases: employees living 1–10 km from the office
• By age: employees aged 25–34 accounted for the largest share of attrition
Most people who left lived 1 to 10 km from the office. If you live close, why leave? I mean you’re saving time and spend less on transport. It should be an advantage.
Then I thought of other reasons. It could be that some people do not like working so close to home. They want privacy. They do not want colleagues showing up uninvited or being in their business. They prefer a clear line between home and work.😉
3
65
Your dashboard isn’t clear if people ask what every chart means.
Hi, I’m Munira 😊 I’m new here on Contra. I work with data and love turning messy numbers into stories people understand. I’ve learned that design and clarity matter as much as accuracy. My goal here is to share how I approach data work and learn from others doing the same.
If you work with data or design dashboards, I’d like to connect and see how you keep things simple.