Global-SuperStore-Sales-Report
Situation
Global Super Store is an online super store that has worldwide operations. This store takes orders and delivers products across the globe and deals with all the major product categories like furniture, office supplies and technology, and so on.
The objective is to analyze the sales of the products based on provided historical data. As this analysis will help to plan the inventory and business processes accordingly and also to know the product’s and customer’s behavior.
Output
The final report should contain the following two pages:
1. Sales Summary
2. Q&A Analysis
Tasks:
1. Load data from the provided data sources (excel workbooks).
2. Perform the required data transformations in the Power Query Editor window.
3. Create the relationships between the loaded tables.
4. Create the required measures for key performance indicators like Sales, Profit, and Ratio.
5. Use the visuals as per the provided design to plot dimensions like Category, Year, Region, Market, Sub-category, Manager, and so on. Add key slicers to slice and dice data in the visuals.
6. Train the Q&A data model for the below synonyms:
Revenue: Sales
Income: Profit
Income Percentage: Profit Ratio
7. Managers should have restricted data access as per their market allocation by the organization. (Implement RLS)
8. Publish a report in the Power BI Service and share it with other users of the same market role.
💡 Key Dashboards & Insights:
1️⃣ Sales Summary – Tracks of key performance metrics, profit and sales trends and revenue insights for strategic decision-making.
2️⃣ Q&A Analysis – Designed to help users interactively explore business metrics and combines visual storytelling with natural language querying, making it easier for non-technical users to gain insights.
🧠 Built entirely using Microsoft Power BI, this dashboard focuses on data storytelling, intuitive design and practical insights which ensure that stakeholders can grasp key takeaways at a glance.
Screenshots of the Sales Report Dashboard:
Connect with me
