A comprehensive analysis and visualization project based on a financial dataset spanning multiple countries, product segments, and time periods. This project showcases data wrangling, business insights, and interactive visualizations using tools like Power BI.
π Dataset
The dataset, Financial Sample.xlsx
, contains over 700 records and includes the following key fields:
- Segment
- Country
- Product & Discount Band
- Units Sold, Sale Price, Gross Sales, Discounts, Profit
- Date, Month, Year
To analyze sales, discounts, and profitability across product types and market segments, and present actionable insights through dynamic dashboards.
- Power BI β for data visualization and dashboard creation
- Microsoft Excel β for initial data inspection and formatting
- Identification of high-profit product segments by country
- Seasonal trends in sales and profitability
- Discount impact on overall revenue
- Interactive Power BI Dashboard
- Summary of insights with visual storytelling
- Documentation of data cleaning and processing steps