Hello, I am
a |
Transforming complex datasets into actionable business insights
Scroll
PROJECTS
data-analysis
UK Retail Sales Performance Analysis
SQL-driven retail analytics
- Examined 50,000+ retail transactions using advanced SQL techniques, identifying top 20% products generating 65% of revenue
- Enhanced dataset accuracy from 87% to 99.5% through data cleansing using CTEs and window functions
- Optimized 8 complex queries through indexing strategies, decreasing execution time by 87% (45s to 6s)
- Uncovered seasonal purchasing patterns that informed inventory planning, reducing stock-outs by 22%
SQLQuery OptimizationData AnalysisCTEsWindow Functions
data-analysis
UK Housing Market Analysis (ONS Dataset)
Time-series analysis of UK house prices
- Processed 18 years of UK House Price Index (2M+ records) from ONS
- Built time-series SQL queries identified top growth months and largest price drops to highlight extreme market movements
- Performed volatility assessment using standard deviation to detect unstable market periods
- Compared pre and post-COVID housing market behaviour
SQLTime-Series AnalysisONS Government Data
visualization
Employment Trends Dashboard (ONS Dataset)
Interactive Tableau dashboards for UK employment
- Standardized 10 years of UK employment statistics covering 8 industry sectors from ONS official database
- Created 5 interactive Tableau dashboards identifying 18-month recovery period post-2020 crisis
- Examined regional disparities, revealing 12% variance between highest and lowest performing regions
TableauExcelStatistical AnalysisONS Government Data
visualization
UK Immigration & Migration Analysis (ONS Dataset)
Migration trends analysis with Power BI
- Analysed UK immigration, emigration, and net migration trends using ONS official multi-year datasets
- Performed demographic and reason-based segmentation (nationality, age group, time period)
- Created pivot-table analysis and dashboards to identify key migration drivers and patterns
Power BIExcelStatistical AnalysisONS Government Data
EXPERIENCE
Jan 2023 – Jun 2025
Associate Data Analyst
AfinitiFull-time
Lahore, PK • On-site
- •Performed exploratory data analysis on datasets exceeding 200,000 records using Python and SQL, uncovering cost-saving opportunities worth $150K annually
- •Engineered and maintained 5 automated ETL pipelines with data engineering team, reducing manual processing time by 40% and ensuring 99.9% data accuracy
- •Contributed in 10+ interactive Power BI and Tableau dashboards tracking operational KPIs, enabling real-time monitoring for C-suite executives
- •Delivered monthly analytical insights to 15+ stakeholders with strategic recommendations that improved resource allocation efficiency by 25%
- •Applied regression modeling and statistical analysis to forecast project timelines with 92% accuracy, optimizing workforce planning
SQLPythonPandasNumPyPower BITableauExcelStatistical Modeling
Nov 2020 – Dec 2022
Catalogue Analyst
Graana.comFull-time
Faisalabad, PK • On-site
- •Examined 200,000+ property listings using Python and SQL, uncovering market trends that informed pricing strategy across 3 regional markets
- •Established data quality protocols across 5 databases, enhancing cross-platform consistency by 35%
- •Produced weekly sales performance reports analyzing 30+ KPIs
PythonSQLTableauExcelData Quality Management
Apr 2019 – Aug 2020
Freelance Web Developer
FiverrFreelance
US, Remote • Remote
- •Designed and launched 12+ responsive websites for e-commerce and business clients, achieving 95% client satisfaction rate
WordPressWixShopifyWooCommerce
May 2019 – Sep 2019
Software Development Intern
Al-Khawarizmi Institute of Computer ScienceInternship
Lahore, PK • On-site
- •Developed frontend components for home automation application using React Native, improving UI responsiveness by 20%
- •Collaborated with 12-member development team to implement 15+ features, delivering project on schedule
React NativeJavaScriptHTML5CSS3
K
Komal Afzal
Google Certified Data Analyst
location_onBirmingham, United Kingdom
About Me
Results-driven Data Analyst with 3+ years of experience transforming complex datasets into actionable business insights. Expertise in SQL, Python, Power BI, and Tableau with proven track record of improving operational efficiency by 30% through automated reporting solutions.
Skilled in ETL pipeline development, statistical modeling, dashboard creation, and executive-level data storytelling. Delivered strategic recommendations that enhanced decision-making across cross-functional teams.
0+
Years Experience
0%
Efficiency Improvement
0+
Dashboards Built
0$K
Annual Savings Identified
SKILLS
💻Programming Languages
🗃️SQL
🐍Python
🐼Pandas
🔢NumPy
📉Matplotlib
📊Seaborn
📊Business Intelligence & Visualization
📊Power BI
📈Tableau
📋Excel
📝Google Sheets
🔣DAX
⚡Power Query
⚙️Data Engineering & ETL
🔄ETL Development
🔗Data Pipeline Automation
🏭Data Warehousing
🗂️Data Modeling
🗄️Database Design
📐Statistical Methods
🔬Hypothesis Testing
📈Regression Analysis
🧪A/B Testing
🔮Predictive Analytics
⏱️Time-Series Analysis
🛠️Tools & Collaboration
🔀Git & GitHub
📋JIRA
📖Confluence
💻VS Code
📓Jupyter Notebook
☁️Azure Data Studio
EDUCATION
code
Bachelor of Software Engineering
University of Agriculture Faisalabad
Aug 2016 – Sep 2020
BSE
Bachelor of Software Engineering degree with comprehensive training in software development, computer science fundamentals, and engineering principles.
schooldegree
location_onFaisalabad, Pakistan
code
Google Professional Data Analyst Certificate
Google Career Certificates
2025
Google
Professional certification in data analytics covering data cleaning, analysis, visualization, and storytelling with data.
schoolcertification
location_onOnline
code
Complete Data Analyst Bootcamp Certificate
Udemy
2025
Bootcamp
Comprehensive data analyst bootcamp covering SQL, Python, Tableau, Power BI, and statistical analysis.
schoolcertification
location_onOnline