Jyoti Dewangan

I’ve been focusing on building strong foundations in data analysis by working on real-world datasets and end-to-end projects.

My work typically involves:

Cleaning and transforming raw data (Python / Excel / Power Query)

Writing SQL queries to extract meaningful insights

Building...

Built an Excel dashboard to analyze personal finance data including income, expenses, savings, and EMI trends. The dashboard provides a high-level financial overview along with month-on-month and category-level insights using pivot tables and charts.

Warehouse Operations Data Analysis using SQL

This project focuses on analyzing warehouse operational data using SQL to derive business performance metrics.

The analysis includes revenue tracking, profit margin evaluation, stock balance monitoring, and delivery performance...

Developed a Power BI report to analyze average monthly expenses across customer segments. The analysis highlights month-wise spending trends and supports data-driven financial insights.