I don't just analyze data. I transform it into intuitive and clear interfaces for users

Required to identify key factors influencing student academic performance based on ~1000 exam results from a Kaggle dataset.

Cleaned the data in Excel, standardized columns, and created new metrics (Average Score, Performance Level). Developed a fully interactive dashboard using Pivot Tables and Slicers to analyze impact factors.

Identified a strong positive correlation between test prep courses and scores, as well as the impact of socio-economic factors. Insights were used to propose academic efficiency improvements.

Aimed to understand price trends, room types, and neighborhood distribution in the New York City Airbnb market to predict listing prices.

Cleaned the dataset (NaN values, outliers) and performed feature engineering. Conducted EDA using Matplotlib and Seaborn. Built a Linear Regression model with Scikit-learn to forecast prices.

Identified primary price determinants (location, room type). The model enabled price forecasting and provided investment recommendations for the business.

Goal was to analyze global UFO sightings from 1906 to 2014 and identify trends by time, location, and shape.

Cleaned the dataset and performed complex feature engineering (extracting year, month, season, and time of day). Used text mining on witness comments to identify light effects and prepared data for unified visualization.

Identified the distribution of UFO incidents by season and time of day. Documented the chronological growth trend and geographical clusters through interactive visualizations.

Needed to analyze hospital patient admissions, weekday revenue, and billing performance to provide management with a tool for monitoring workload.

Used Pivot Tables and complex formulas in Excel to analyze patient demographics, billing by insurance type, and admission types. Created an interactive dashboard with dynamic KPI cards, Slicers, and Timelines.

Identified busiest weekdays and a high proportion of Emergency admissions. Revenue analysis by insurance provider provided crucial data for hospital resource allocation.

A jewelry retail store needed an advanced BI solution to automate tracking of sales, purchase costs, and operational expenses to calculate real-time profitability and gold inventory balance.

Developed an interactive Power BI dashboard using Power Query for ETL processes and DAX for complex measures (profit margin, inventory turnover). Integrated data from Google Sheets/Excel and visualized financial trends, expense breakdowns, and vendor performance.

Automated the tracking of Key Financials (Revenue, Gross Profit, Net Margin) and improved inventory control by tracking gold stock levels across all categories (Rings, Earrings, etc.). Provided actionable insights into vendor efficiency and seasonal sales peaks.