Description

1. Sales Dashboard in Power BI Designed an interactive Power BI dashboard to analyze monthly sales performance. Cleaned raw data, created KPIs, applied DAX formulas, and built visuals to track revenue, top-performing products, and customer trends. --- 2. Excel Data Cleaning & Reporting Project Cleaned and organized a large Excel dataset by removing duplicates, handling missing values, and formatting the data for analysis. Created pivot tables, charts, and a summary report for better decision-making. --- 3. Customer Segmentation Analysis Used Python and Excel to group customers based on purchase behavior. Identified key segments, calculated KPIs, and provided insights to improve marketing strategy and customer retention. --- 4. SQL Data Extraction & Trend Analysis Wrote SQL queries to extract and analyze data from multiple tables. Found trends, performed calculations, and prepared summary insights for business reporting. --- 5. Power BI KPI Performance Dashboard Developed a modern dashboard showing KPIs like total sales, average sales, product-wise performance, and region-wise comparison. Ensured the visuals were simple, clean, and easy to understand.