Capstone Project on Power BI

A leading department store in the e-commerce marketplaces in Portugal. Serving as a seamless link, it connects small businesses from various regions in Portugal to channels, streamlining the process with a single point of contact.Through the ShopNest Store, these merchants can showcase and sell their products, with the added convenience of direct shipment to customers facilitated by ShopNest logistics partners. The provided data represents authentic commercial information that has undergone the process of anonymization. This capstone has 9 datasets and the descriptions are below :

Design a comprehensive Power BI dashboard to address key business analytics for a retail dataset. The following analytical questions should be answered through your dashboard:

Identify the rating distribution in the Shop_Nest dataset, showcasing ratings categorized as Excellent, Very Good,Good,Bad, and Very Bad, along with corresponding orders. What are the top 10 and bottom 18 most popular product categories in the ShopNest dataset? Please list them based on the number of orders. List the total number of active sellers by yearly and monthly. Which payment methods are most commonly used by ShopNest customers. Identify the product category. wise profit margin using the formula Hint: (Payment value -price + Freight_value)/payment_value*100 (Rounded to two decimal points). Determine the monthly payments made by customers using credit cards. Identify sellers categorized by city,excluding cities starting with the letters S and B. Create a dynamic visual that compares the number of delayed orders to the number of orders received earlier for each month.Utilize the drill through the crossreport feature to provide a detailed analysis of late and on-time deliveries. Instruction to submit the capstone

PowerBI Dashboard (PBIX File): Provide the Power BI dashboard in a PBIX file format. Create a Power BI dashboard in a single sheet that includes all the charts for the given 8 questions. The file should contain all necessary visualizations, slicers, and data connections for the analysis.

Dashboard Report (DOC File): Create a detailed report document in DOC format that explains the dashboard comprehensively. Include screenshots or images of the dashboard visuals in the document for a clear representation. For each question/task outlined in the Power BI Capstone Project, include a section with the following details:

Question Statement: State the question/task. Visualization: Include an image of the corresponding visualization(s) in the dashboard. Explanation: Provide a clear and concise explanation of the visual,highlighting key insights and findings. Ensure the document is organized, with each section corresponding to a specific question or aspect of the dashboard