AFIA ZAKI

"Transforming Raw Data into Strategic Insights: Where Numbers Tell the Story." Adept at Excel, SQL, Statistics, Python, PowerBI and Tableau.

NORTH WIND DATA ANALYSIS

Northwind Database models a fictional company called 'Northwind Traders', including its customers, products, orders, sales and employees. I've performed category, orders, and customer analysis using metrics like category revenue by top products, chun rate, retention rate, customer life time value, Month inventory stock, and order lead time etc.
Tools: SQL

TABLEAU: NORTHWIND DATA ANALYSIS
TOOLS : TABLEAU

ABSENTEEISM ANALYSIS

Conduct statistical analysis on Employee Absenteeism data to identify patterns and trends.
• Utilize descriptive statistics to summarize key metrics, including average absenteeism hour per length of service, age distribution, and length of service.
• Performed inferential statistics to test hypotheses and assess the significance of factors influencing absenteeism.
• Employed factor analysis to uncover latent factors influencing absenteeism, contributing to a deeper understanding of workforce dynamics.
• Performed correlation testing to analysis the relation between city and unemployment rate, age and length of service.
Tools : Python