Problem: Inventory data was stored in multiple file formats, making reporting inefficient and time-consuming.
Solution: Built an automated Python system to process CSV and JSON files and generate structured reports.
Impact: Reduced manual work and improved reporting efficiency through automation.
Tools: Python | Pandas | OOP
Problem: Raw survey data lacked structure and was difficult to interpret for business insights.
Problem: Raw survey data lacked structure and was difficult to interpret for business insights.
Solution: Built an interactive Power BI dashboard using Power Query for cleaning and transformation.
Impact: Delivered clear insights into salaries, trends, tools, and industry behavior.
Tools: Power BI | Power Query
Problem: Airbnb data was complex and lacked clear pricing and location insights.
Solution: Developed an interactive Tableau dashboard to analyze pricing trends and location performance.
Impact: Enabled clear visualization of market behavior and pricing patterns.
Tools: Tableau | Excel
Problem: Poor data quality due to missing values, duplicates, and inconsistent formatting.
Solution: Used SQL to clean, standardize, and structure raw datasets for reliable analysis.
Impact: Enabled accurate reporting and improved data reliability for business decision-making.
Tools: SQL | MySQL