Ali Ahmad

Motivated Data Analytics graduate eager to kickstart a career as a Junior Data Analyst. Skilled at turning raw, complex data into clear visual charts and actionable reports to help teams make informed decisions. Possesses solid hands-on training in SQL database queries, Python scripting, and Power BI dashboard creation. Highly adaptable and ready to apply structured project experience to deliver immediate value in an entry-level role.

E-COMMERCE SALES PERFORMANCE DASHBOARD (CAPSTONE PROJECT)

• Cleaned and pre-processed a raw dataset of 10,000+ sales transactions using Excel and Python to handle missing values and duplicates.
• Extracted actionable business metrics using SQL queries, focusing on top-performing product categories and regional sales trends.
• Designed an interactive Power BI dashboard with dynamic filters, allowing users to track monthly revenue and profit margins instantly.

CUSTOMER CHURN & RETENTION ANALYSIS

• Analyzed customer demographic and behavior datasets to identify key factors contributing to user subscription cancellations.
• Applied descriptive statistics to segment customers by tenure, monthly charges, and contract types.
• Developed clear visual charts in Tableau to present retention trends and recommended data-backed strategies to improve customer loyalty.

B.SC in Double Mathematics & Statistics – Govt. Islamia Graduate College, Kasur (2023-09 – 2025-06)

F.SC in F.Sc Pre Eng. – Govt. Islamia Graduate College, Kasur (2020-09 – 2022-06)

METRIC in Metric Science – Pakistan Model High School, Kasur (2018-09 – 2020-06)