❓ Power BI Practice Data https://docs.google.com/spreadsheets/d/1qQ90Fru5QbNK8QjgPSVOSIlLcHFa2hXO/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true Scenario: Retail Sales Performance Analysis Business Context: You are a Business Analyst at a retail chain called TrendZone . The company operates across multiple cities and sells four product categories: Electronics, Apparel, Home Decor, and Sports Equipment. Management wants to understand sales performance, profitability, and customer purchasing behavior. ❓ Power BI Practice Questions 🔹 Level 1: Basic Reporting Create a bar chart showing total sales by ProductCategory . Show a table with CustomerName, City, and their TotalSales . Use a slicer to filter data by Region and see how total profit changes. What is the average discount given per product category ? 🔹 Level 2: Intermediate DAX & Modeling Create a new calculated column: NetSales = TotalSales - Discount . Create a measure for ...
https://docs.google.com/spreadsheets/d/1Ans3hkk0RuC9tMLq8X83bFYA_6Zux8K6/edit?usp=sharing&ouid=105173447805752617719&rtpof=true&sd=true basic practice data above.. ------------------------------------------------------------------------------ ☕ Scenario: Coffee Shop Monthly Sales (Excel Practice) Context: You are analyzing monthly sales data for a chain of 5 coffee shops (Central, North, South, East, West) from January 2022 to December 2024 . 📊 Practice Tasks (for Excel) Line Chart: Plot monthly sales trend for each branch. Moving Average: Calculate 3-month and 6-month moving averages. Growth Rate: Compute month-over-month and year-over-year growth. Seasonality Check: Identify months with consistently higher or lower sales. Branch Comparison: Create a line chart comparing all 5 branches. Forecasting (Basic): Use Excel’s trendline feature to project next 6 months. Practice Dataset https://docs.google.com/spreadsheets/d/1JKiaBWRzur3E_ySpfdMOZ...
Comments
Post a Comment