Power BI Practice

❓ 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

  1. Create a bar chart showing total sales by ProductCategory.

  2. Show a table with CustomerName, City, and their TotalSales.

  3. Use a slicer to filter data by Region and see how total profit changes.

  4. What is the average discount given per product category?

🔹 Level 2: Intermediate DAX & Modeling

  1. Create a new calculated column: NetSales = TotalSales - Discount.

  2. Create a measure for Total Profit Margin = SUM(Profit) / SUM(NetSales).

  3. Build a matrix to show monthly sales by Region and ProductCategory.

  4. Create a line chart showing sales trend over months.

  5. Add a filter to show data for customers with total purchases above $500.

🔹 Level 3: Advanced Analysis

  1. Create a calculated table that shows top 5 customers by TotalSales.

  2. Use DAX to calculate YoY (Year-over-Year) growth for sales.

  3. Create a tooltip page that shows detailed sales by customer when hovered on a region.

  4. Analyze which region has the highest average profit per order.

  5. Use bookmarks to switch between Sales Overview and Profit Analysis pages.


Comments

Post a Comment

Popular posts from this blog

TIME SERIES ANAYSIS DATASET

 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...
Read more