Project Decription:
Analyzed a dataset of pizza orders from a fictional pizza chain using Excel and Power BI.
Created interactive dashboards and reports to explore and communicate insights about the pizza business.
Identified the busiest days and times, the most and least popular pizzas, and the average order value for each customer segment.
Project Description:
Conducted data analysis on a dataset of cryptocurrency data using Excel and Power BI.
Built interactive dashboards and reports to explore and communicate insights about the cryptocurrency market trends and performance.
Revealed the market capitalization, market volume, coin’s high and low values, and price fluctuations of various cryptocurrencies.
Project Description:
Created a dashboard in Excel to analyze bike sales data from different customer segments and regions.
Generated key insights on customer age, marital status, education level and region.
Used Pivot Tables, Charts and Slicers to display the data in an interactive and user-friendly way.
Applied Data Validation and Conditional Formatting to ensure data quality and accuracy.
Project Description:
Performed data analysis on a dataset of global sales data from a fictional superstore using Excel and Power BI.
Developed interactive dashboards and reports to examine and communicate insights about the sales performance across regions, segments, markets, and products.
Discovered the best selling regions, the sales by segment and market, the top profitable and loss products, and the top 10 customers.
Project Description:
Performed data analysis on a dataset of data professional survey data using Excel and Power BI.
Designed interactive dashboards and reports to explore and communicate insights about the data professionals’ demographics, skills, salaries, and satisfaction.
Uncovered the total respondents, average age of respondents, average salary by job title, and happiness with salary of data professionals.
Project Description:
Conducted data analysis on a dataset of business sales data using Excel and Power BI.
Developed interactive dashboards and reports to explore and communicate insights about the sales performance across
countries, salespersons, and products.
Provided actionable insights and recommendations to improve sales performance and customer satisfaction based on data.