Nayra Blal
Data Analyst | Turning data into clear, actionable insights
New to Contra
Nayra is building their profile!
Customer Churn Analysis – Excel
Analyzed 20,000 customer records to identify key patterns associated with customer churn and provide actionable retention insights.
Cleaned and validated the dataset with no duplicates or missing values.
Calculated key KPIs including total customers, churned customers, churn rate, and average monthly charges.
Analyzed churn by contract, payment method, and internet service.
Identified month-to-month contracts as the strongest churn indicator, with a 43.18% churn rate.
Provided data-driven recommendations to support customer retention.
Tools: Microsoft Excel, PivotTables, Data Analysis, Data Visualization
0
5
Sales & Profit Analysis Dashboard
Interactive Power BI dashboard designed to analyze sales and profitability performance and provide clear business insights.
Analyzed sales and profit performance across categories and sub-categories.
Created KPIs for Total Sales, Total Profit, Order Count, and Profit Margin.
Built interactive visualizations with slicers and filters for better data exploration.
Implemented time intelligence analysis, including Sales YoY and Profit YoY.
Created a structured data model using a Calendar table and relationships.
Used DAX measures to calculate KPIs and business metrics.
Added tooltips and interactive elements to improve dashboard usability.
Tools: Power BI, DAX, Excel
0
8