Projects
- Monday Coffee Market Analysis (SQL): Engineered a Data-Driven Expansion Strategy for an online coffee retailer by analyzing sales performance and market potential across major Indian cities using Advanced SQL (CTEs, Window Functions, PostgreSQL). Identified the top 3 cities (Pune, Delhi, Jaipur) for store openings by balancing Highest Total Revenue and Estimated Market Size against the custom Avg. Rent per Customer metric, ensuring maximum profitability. Calculated and tracked performance metrics, including Monthly Sales Growth (using LAG()) and Top 3 Selling Products per city (DENSE RANK()); currently building a 2-page Power BI dashborad for visualization
• Data Analysis and Visualization: Data Science Job Salary Dashboard (Excel) • Engineered a dynamic, multi-criteria salary dashboard, built on structured data tables and renamed cells, to analyze 2023 job trends across title, country, and schedule. • Implemented advanced array formulas (e.g., MEDIAN(IF(...)), XLOOKUP), along with logic functions (FILTER(), COUNTIF(), ISNUMBER(), SEARCH(), UNIQUE()), to perform complex conditional lookups and accurately calculate the sorted median salary. • Visualized key compensation insights using geographic map charts and sortable bar charts; developed a dedicated Salary Calculator feature. • Enhanced us ability and data integrity by applying Data Validation lists for key criteria (Title, Country, Type), hiding background worksheets for compactness, and locking the final sheet to prevent formula misuse.
- Data Jobs Dashboard (Foundational): Developed a two-page Power BI dashboard to analyze data job market trends, sourcing data from a single Excel file. Performed data transformation using Power Query and created core metrics with DAX. Designed a multi-page user flow with drill-through functionality to provide both a high-level overview and a detailed, job-specific analysis. KeySkills: Data Cleaning (Power Query), Foundational DAX, Multi-Page Reporting, Drill-Through Navigation. 1
- Data Jobs Dashboard 2.0 (Advanced): Iterated on a previous project by creating a streamlined dashboard with enhanced metrics. Inte grated and modeled data from five different Excel files, utilizing Star Schema principles to create efficient relationships. Used advanced DAX to develop new, complex insights like ”Skills Per Job” and ”Skill Popularity,” demonstrating a strong ability to handle multi-source data and create so phisticated solutions. Key Skills: Data Integration, Data Modeling (Star Schema), Advanced DAX, UX/UI Optimization.
- Exploratory Data Analysis (EDA) of New York Airbnb Data:-(Python) Conducted com prehensive Exploratory Data Analysis (EDA) on a dataset of over 20,000+ New York Airbnb listings using Python (Pandas, Matplotlib, Seaborn) and Jupyter Notebook. Performed end-to-end data cleaning and preprocessing, including handling missing values and out lier detection, ensuring data integrity for analysis. Utilized advanced visualization (histograms, box plots, heatmaps) to uncover key trends, identifying that Manhattan had the highest average prices and most expensive room types. Finalizing documentation and GitHub upload of the Jupyter Notebooks for project sharing; data is prepared for subsequent visualization and presentation of actionable host/guest insights.