Shahzaib Y

Data Analyst

Freelancing Career • Self-employed

Jun 2024 - Present • 2 yrs 3 mos

With over two years of dedicated freelancing experience as a Data Analyst, I have helped e-commerce businesses transform raw, messy data into actionable insights that drive revenue growth and operational efficiency. My expertise spans the complete data analytics lifecycle, from data collection and cleaning to advanced analysis and interactive visualization. Data Cleaning & Preparation: I specialize in handling imperfect, real-world datasets using Python's Pandas library. I apply advanced statistical techniques including mean, median, mode analysis, quartile distribution, and Interquartile Range (IQR) to systematically identify and treat missing values, duplicate records, and outliers. This rigorous approach ensures that every analysis is built on a foundation of clean, reliable data—enabling confident business decisions. Data Analysis & SQL Expertise: Using SQL Server, I write complex, optimized queries to extract meaningful insights from large transactional databases. I routinely develop solutions for critical business questions including: Top-performing products by revenue and quantity Monthly sales trends and seasonality patterns Average Order Value (AOV) analysis High-value customer identification and segmentation Repeat purchase behavior and order frequency analysis Revenue growth rate calculations Product portfolio analysis (high volume/low margin items) Dashboard Development & Storytelling: I create comprehensive, interactive dashboards in Power BI that tell compelling stories with data. Using DAX for custom measures and calculated columns, I build relational data models that support dynamic filtering and drill-down capabilities. My dashboards provide 360-degree views of business performance.