Customer Churn Analysis
Description: Analyzed Data about +6 k customers to gain insights about churn rate for a telecom company such as causes of churn and customer age groups and provided recommendations to help improve customer retention.
Technologies: Excel, Tableau
Financial Complaints Analysis
Description: Analyzed +75 k financial complaints over a period of 10 years by measuring different KPIs such as response time, dispute rate, complaints in progress, complaints solved at no cost and categorizing complaints by issue, state, product,
media and status.
Technologies: Tableau
Call Centers Analysis
Description: Analyzed +32 k calls across 4 call centers in the US by measuring KPIs such as Customer Satisfaction Score (CSAT), Service Level Agreement (SLA) and segmenting the calls by state, city, channel, response time and sentiment.
Technologies: Tableau
Superstore Sales Performance Dashboard
Description: Built a fully interactive executive summary dashboard for tracking the sales and profitability of +10 k orders, and categorizing these metrics by product category, subcategory, segment, manufacturers, customers, region...etc.
Technologies: Tableau
US Bank Failures 1934 – 2023
Description: Following the recent events of bank failures in the US, I performed an analysis on +4 k banks to gain insights about how likely bank failures occur and how Silicon Valley Bank and Signature Bank compare to other failures in the US.
Technologies: Excel, Tableau
Covid-Exploratory-Analysis
Description:Performed and exploratory analysis on covid-19 vaccinations and death cases in SQL using CTEs, window functions, temporary tables and other SQL functions.
Technologies:T-SQL, SSMS
Housing sales data cleaning
Description: Performed data cleaning on housing sales dataset using various SQL functions.
Technologies: T-SQL, SSMS
Upstaffer since May, 2023
