Welcome to my Data Analyst Portfolio – a collection of projects showcasing my journey into data analytics. This repository highlights my skills in Excel, SQL, Python, and Power BI through real-world inspired datasets.
| Project Name | Description | Tools | Key Skills | Link |
|---|---|---|---|---|
| Superstore Sales Analysis: Discount Strategy Recommendation | Full Excel data pipeline analyzing rising sales but declining profit margins to recommend a revised discount strategy, leveraging high customer loyalty. | Excel, Power Query | Data Cleaning, Feature Engineering, KPI Dashboarding | View Project |
| Cyber Crimes in India 2024 (Mock Data Analysis) | Full Bronze–Silver–Gold data pipeline workflow on simulated cybercrime data, culminating in an interactive Excel dashboard built on a Star Schema model. | Excel, Power Query, Power Pivot | Data Modeling, EDA, Dashboarding | View Project |
ExcelPower BISQLPythonDashboardingEDAData CleaningFeature Engineering
Each project demonstrates hands-on practice in cleaning, analyzing, and visualizing data, showcasing the ability to transform raw datasets into actionable insights.
- Excel – Data cleaning, Pivot tables, dashboards, Power Query, Power Pivots
- SQL – Querying and Database Management
- Python – Data cleaning, Analysis, Visualization
- Power BI – Interactive dashboards and Reports