FUTURE_DS_01

Business Sales Dashboard – E-commerce Data

This repository contains Task 1 of the Data Science & Analytics Internship at Future Interns.

Task Objective

Analyse e-commerce sales data to identify:

• Best-selling products
• Sales trends over time
• High-revenue categories and regions

Tools Used

• Power BI
• Microsoft Excel

Folder Structure

• dataset – Raw dataset files
• powerbi – Power BI (.pbix) file
• screenshots – Dashboard images

---

Key Insights

• Sales show clear seasonal trends, with peak performance during certain months.
• Technology and Office Supplies contribute significantly to overall revenue.
• A small set of products drives a large portion of total sales.
• Certain regions consistently outperform others in terms of sales.
• Profitability does not always increase proportionally with sales, highlighting the impact of discounts.

Business Recommendations

• Focus marketing and inventory planning around peak sales months.
• Promote top-performing products while reviewing low-performing ones.
• Optimise discount strategies to protect profit margins.
• Invest more resources in high-performing regions.

Intern: Naresh Tallapaka