This project presents a comprehensive analysis of 2023 sales data, demonstrating key skills in data analytics, business intelligence (BI) reporting, and interactive visualization using Python.
- Analyze monthly sales performance and trends.
- Identify best-selling products across countries.
- Enable dynamic, interactive exploration of sales insights.
- Deliver actionable insights for data-driven decisions.
-
Data Import & Inspection
- Loaded CSV datasets using
pandasand reviewed structure via.head()and.info().
- Loaded CSV datasets using
-
Data Cleaning & Transformation
- Converted
Datecolumns to datetime format usingpd.to_datetime()for time-based operations.
- Converted
-
Aggregation & Grouping
- Aggregated monthly sales using
.groupby()and.sum()on relevant fields. - Grouped by
CountryandProduct IDto evaluate market-specific product performance.
- Aggregated monthly sales using
-
Feature Engineering
- Mapped numeric month values to full month names for clarity in visualizations.
-
Sorting & Ranking
- Identified Top 5 Products per Country using grouped sorting and filtering operations.
-
Visualization Libraries Used
Matplotlib,Seaborn,Plotly Express,Plotly Graph Objects
-
Interactive Time-Series Plots
- Visualized monthly trends in sales, tax, and quantity ordered using interactive line charts.
-
Stacked Bar Charts
- Compared product performance across countries with stacked bar visualizations.
-
Dropdown-Based Dynamic Filtering
- Enabled region-specific insights via dropdown menus using Plotly.
-
Automated Per-Country Charts
- Created dynamic bar charts per country to visualize top products.
-
Customization for Clarity
- Applied layout adjustments (titles, axis labels, legends, plot sizing) for presentation-readiness.
| Insight Area | Description |
|---|---|
| π Seasonal Trends | Revealed peaks in sales activity mid-year, indicating seasonality patterns. |
| π Regional Preferences | Certain products performed significantly better in specific countries. |
| π Top Products | Identified top-selling items per country to aid in targeted strategies. |
| π Interactive Dashboards | Dynamic filters enabled granular analysis by stakeholders. |
| π Data Storytelling | Logical structure from overview to detailed insights ensured clarity. |
Explore the full notebook, source code, and interactive visualizations: