Business Analytics

Instructions

Week 4 Project: Sales Analytics with Power BI Desktop (CO3 & CO6)

Background:

TechGiant Inc. is a leading electronics retailer with stores across multiple regions. As a Business Analyst at TechGiant, you've been tasked with analyzing sales data to derive insights that could shape the company's future sales strategy.

Objective:

Use Power BI Desktop and the datasets provided to create an interactive dashboard that visualizes TechGiant's sales performance across different regions and products. Identify trends, outliers, and potential areas of improvement.

Datasets:

1. Sales Data (sales_data_powerpivot.csv): Contains monthly sales data for different products across various regions. 2. Region Data (region_data_powerpivot.csv): Contains region ID and corresponding region names.

Tasks:

1. Data Import & Relationship Building:
   • Import both datasets into Power BI Desktop.
   • Establish a relationship between the sales data and region data using the RegionID field.
2. Data Transformation & Cleansing:
   • Ensure there are no missing values or duplicates.
   • Standardize data formats if necessary.
3. Data Visualization:
   • Create a line chart that showcases monthly sales trends for each region over the years.
   • Develop a bar chart that displays total sales for each product across all regions.
   • Design a pie chart that illustrates the sales distribution across various regions.
   • Implement slicers or filters to allow for interactive exploration of data by year, region, or product.
4. Advanced Analysis (Optional):
   • Use DAX to calculate Year over Year growth for each region.
   • Identify the top 3 salespeople based on total sales.
   • Highlight months where sales dipped below the average.
5. Insight Generation & Recommendations:
   • Based on your dashboard, derive key insights about TechGiant's sales performance.
   • Provide recommendations on potential strategies or areas of focus for improving sales.

Submission:

• Share the Power BI report file containing your dashboard.
• Provide a brief report (1-2 pages) summarizing your insights and recommendations.

Evaluation Criteria:

1. Data Handling & Cleansing: Effective use of Power BI's data transformation tools.
2. Visualization Quality: Clarity, aesthetics, and appropriateness of visualizations.
3. Interactivity: Implementation of filters, slicers, and drill-down features.
4. Insight Depth: Quality of insights derived and their potential business impact.
5. Recommendations: Feasibility and relevance of proposed strategies or areas of focus.

This case study challenges you to apply the skills acquired in Week 4 in a real-world context. Beyond technical proficiency, focus on deriving actionable insights that could have tangible business implications. Good luck, and happy analyzing!