This is a Data Analyst Internship task to design a basic interactive sales dashboard using Power BI.
The dashboard visualizes sales performance by product category, region, and month, helping business users quickly see key trends and make data-driven decisions.
- Dataset used:
Superstore_Sales.csv(or a custom generated dataset with columns: Order Date, Region, Category, Sales, Profit)
- Imported the dataset into Power BI.
- Converted Order Date to Month-Year format for trend analysis.
- Created 3 visuals:
- 📈 Line Chart: Sales over Months
- 📊 Bar Chart: Sales by Region
- 🍩 Donut Chart: Sales by Category
- Added a slicer to filter data by Region or Category.
- Used colors to highlight top-performing regions and categories.
- Summarized findings in short insights.
- Overall sales show a gradual decline from Dec 2023 to Sept 2025.
- The West region recorded the highest total sales among all regions.
- Sales are balanced across categories: Office Supplies, Furniture, and Technology each contribute roughly one-third.
- The slicer enables easy drill-down by region or category for deeper analysis.
Superstore_Sales.csv– The dataset used.Dashboard_Screenshot.png– Export of the final dashboard.Insights.txt– Key insights summary.README.md– This file.
- How to import, clean, and transform data in Power BI.
- How to create clear visuals for trends, regional breakdown, and category contributions.
- How to use slicers for interactivity and better user experience.
- How to extract and communicate actionable insights.
- Clone this repository.
- Open Power BI Desktop.
- Load
Superstore_Sales.csv. - Recreate visuals or view the exported dashboard image.
This GitHub repository link was submitted as per the internship task submission guidelines.
🔗 Built for the Data Analyst Internship — Task 2