
Farwa Arooj
DATA ANALYST
Competenze

Consulta i miei servizi

Portfolio
Esperienza lavorativa
internship
Primeor Solutions • Lavoratore autonomo
Oct 2026 - Nov 2026 • 1 mo
E-Commerce Data Analytics & Power BI Dashboard This project focuses on analyzing e-commerce sales data to identify business trends, evaluate performance, and generate meaningful insights. I used Python (Pandas and NumPy and matplotlib) for data cleaning and preprocessing, including handling missing values, removing duplicates, standardizing data, and preparing the dataset for analysis. I also performed sales analysis to identify total sales, total profit, average discount, top-selling products, loss-making products, and regional sales performance. Using Microsoft Power BI, I developed a three-page interactive dashboard: - Executive Overview: Total Sales, Total Profit, Total Orders, and Average Discount. - Sales Analysis: Sales by Region, Market, Monthly Sales Trends, and Category Performance. - Product & Customer Insights: Top Products, Top Customers, Profit by Sub-Category, and Segment Analysis. The dashboard includes interactive slicers for Year, Region, Market, Category, and Segment, allowing users to explore business performance dynamically. Tools & Technologies: Python, Pandas, NumPy, Microsoft Power BI, DAX, Excel, and Data Visualization. Project Goal: Transform raw e-commerce data into clean, meaningful, and interactive business insights to support data-driven decision-making.