Projects
Sales Dashboard for a Furniture Analyst in the United States
1
Data Preparation:
- Cleaned and organized raw sales data to ensure accuracy and completeness.
- Segmented the data by state, city, customer category, and segment to enable detailed analysis.
2
Data Analysis:
- Used pivot tables to perform in-depth analysis of the segmented data.
- Identified key trends and patterns in sales performance across different segments and regions.
3
Dashboard Creation:
- Designed an interactive dashboard in Microsoft Excel to visualize the analyzed data.
- Incorporated charts such as pie charts, bar charts, and column charts to represent sales by segment, state, and customer category.
- Added interactive filters to allow users to explore data by state, city, customer category, and segment for better decision-making.
