Jyoti Dewangan
Data Analyst | SQL ,Tableau ,Power BI | Dashboard & Insight
New to Contra
Jyoti is ready for their next project!
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 measurement.
Key Outcomes:
Identified revenue contribution by warehouse and category
Calculated product and category-level profitability
Evaluated inventory balance using inbound vs outbound movement
Measured delayed order percentage for operational performance tracking
Tools: MySQL, SQL Analytics
0
11
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.
6
5
128
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.
0
32
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.
0
38
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.
0
33
SQL Product Analytics (MySQL)
0
41
Global Freelancer Analysis Dashboard (Detailed)
0
41
Global Freelancer Analysis Dashboard (Tableau)
0
35