ShopSphere E commerce project

Data Analyst responsible for the end-to-end analysis of a 25,000-record e-commerce dataset. I cleaned and validated the data in Excel, identified and resolved duplicate records, inconsistent values, and missing shipping information, then used SQL to analyze customer, order, product, sales, and shipping data. I applied JOINs, aggregations, CASE statements, CTEs, subqueries, and window functions to answer business questions and identify trends. I then developed an interactive Power BI dashboard with KPIs, visualizations, and filters to communicate key findings and translate the analysis into actionable business insights.

SALES OF BIKES ANALYSIS

Data Analyst responsible for analyzing customer demographic, financial, and behavioral data to identify factors associated with bike purchases. I cleaned, organized, and analyzed customer-level data using Excel, created pivot-table-based analysis to compare purchasing behavior across income, age, gender, education, occupation, region, and commute distance, and developed visual summaries to communicate key patterns and customer segments. The analysis was focused on understanding which customer characteristics were associated with bike purchases and generating insights that could support customer targeting and marketing decisions.

Sales Analytics

Data Analyst responsible for developing a business-focused SQL analytics portfolio using SQL Server. I analyzed customer, regional, and product performance to answer business questions around revenue, profitability, customer behavior, sales contribution, and product performance. I developed SQL queries using aggregations, CTEs, window functions, ranking functions, and data validation techniques to transform raw business data into meaningful insights. I interpreted the results to identify high-value customers, regional performance patterns, profitable and underperforming products, and opportunities for improved business decision-making.