Retail Sales Analysis with Excel

I conducted a comprehensive retail sales analysis using Excel, uncovering key trends and customer purchasing patterns to optimize inventory management and boost revenue. By leveraging pivot tables, data visualization, and advanced formulas, I delivered actionable insights that drove strategic decision-making for improved business performance. 

Data Professional Survey Analysis with PowerBI

This dashboard presents insights from a survey of 630 data professionals, with an average age of 29.87. The key metrics analyzed include salary distribution, job roles, programming language preferences, work-life balance, salary satisfaction, and demographic distribution of survey takers.

• Job Titles & Salaries: It can be seen that Data Scientists earn the highest average salary, followed by Data Engineers and Data Architects. Other roles like Data Analysts and Database Developers have comparatively lower salaries.

• Programming Language Popularity: From the analysis and also as shown on the dashboard, Python is the most favored programming language among respondents, significantly ahead of R, C/C++, JavaScript, and Java.

• Happiness Ratings: Work-life balance satisfaction is rated at 5.74/10, whereas salary satisfaction is slightly lower at 4.27/10.

• Salary by Gender: A gender distribution chart suggests that male respondents dominate the dataset, and there may be a disparity in salaries based on gender.

• Geographical Distribution: Survey participants primarily come from India, the United States, Canada, and the United Kingdom, with a portion categorized as “Other.”

This analysis helps understand salary trends, job satisfaction, and demographic distribution within the data profession.