Explore insightful retail analysis of Sample Store with comprehensive data and visualizations. Gain valuable insights into sales trends, customer behavior, and more. Dive into the data-driven world of retail with our analysis.
Project Overview
This Visualization provides an overview of the project, which involves conducting a retail analysis of Sample Store. The analysis includes importing customer data with 7 queries and a data model table, incorporating key performance indicators (KPIs) and measures. Additionally, the Sample Superstore data XLSX file was synchronized to enhance the analysis. This slide sets the stage for the project and highlights its key components.
IT Spend Analysis in Power View
In the IT Spend Analysis project, I utilized Power View to create effective visualizations, adjusting my approach to overcome any limitations encountered with unsupported visuals in Power BI. By identifying and removing incompatible visual types, I ensured the continuity and accuracy of the analysis. The revised file, named "IT Spend Analysis Sample.pbix," highlights my proficiency in adapting visualization tools to meet analytical requirements. This project showcases my capability to navigate and resolve data visualization challenges dynamically.
Sample Superstore Monthly Sales Analysis
This Visualization showcases the monthly sales analysis of Sample Superstore, featuring various visualizations aimed at providing comprehensive insights. The visuals include a District Manager list displaying sales variance by fiscal month, comparisons between last year's sales and current year's sales by fiscal month, and the total sales variance percentage by category for the current year. Through these visualizations, key trends and performance metrics are highlighted, offering valuable insights into the store's sales dynamics over time.
New Stores Analysis
This Visualization presents an analysis of new stores, beginning with a map visualizing store locations by city and chain. Following this, the analysis includes a depiction of open store count by open month and chain, providing insights into the distribution and growth of new stores over time. Additionally, a line graph illustrates this year's sales by fiscal month, offering a temporal perspective on sales performance. Lastly, a list of store names further contextualizes the analysis, providing a comprehensive overview of new store dynamics.
KPI Analysis and Sales Composition
Both slide visualization provides a comprehensive analysis of key performance indicators (KPIs) and sales composition for Fashions Direct and Lindseys Chain. The first visualization compares total units sold this year and last year by fiscal month, offering insights into unit sales trends over time. The second visualization presents a pie chart illustrating the sales composition for each chain, distinguishing between regular sales units and markdown sales units. Together, these visualizations offer a holistic view of performance dynamics and sales distribution for both chains.
![KPI Analysis](https://private-user-images.githubusercontent.com/121683356/314167175-d58ae928-f695-4700-84b6-bfd1ee0bcdf7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM5NjYyNzEsIm5iZiI6MTcyMzk2NTk3MSwicGF0aCI6Ii8xMjE2ODMzNTYvMzE0MTY3MTc1LWQ1OGFlOTI4LWY2OTUtNDcwMC04NGI2LWJmZDFlZTBiY2RmNy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxOFQwNzI2MTFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hNDI1Mzk3MDE1NDRiYzZlNzdjYzcxY2NkMjBjMTEwNzczZWVmZjMzM2Q2YjNlNjc5N2ZlZmUwMTk3MGEwMjg5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.p7FZb20EgUzs7uNNnzM9wObulfQ84n6_UxTXyXeZOQk)
This slide presents a comparative analysis of this year and last year's performance for Fashions Direct and Lindseys Chain. A column chart visually depicts the performance trends over time, enabling easy identification of variances and trends. Filter buttons facilitate focused exploration within specific chains, enhancing granularity.
![KPI Analysis](https://private-user-images.githubusercontent.com/121683356/314167270-ffe2bbeb-d549-404d-9430-150d93d2f3c6.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM5NjYyNzEsIm5iZiI6MTcyMzk2NTk3MSwicGF0aCI6Ii8xMjE2ODMzNTYvMzE0MTY3MjcwLWZmZTJiYmViLWQ1NDktNDA0ZC05NDMwLTE1MGQ5M2QyZjNjNi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxOFQwNzI2MTFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hYWJkNmEwNjRjMzViMzI3MGEwZGMwYjhjMWViMWY0NWMwYWI0MzNiYWViZGUyNTI1OGRmOTZlZmVkODM0M2U3JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.5xIKuYwM1ltUNcFAoOXUXKOsg6xduYe2ebHBveqNmxE)
Incorporating a multi-row card with an arrow button, this slide offers drill-through functionality for detailed insights. Users can Ctrl + click on specific data points to delve deeper into underlying factors influencing performance variations. Seamless transition between slides allows for a comprehensive analysis, combining high-level trends with detailed examination for informed decision-making.
Sales by Category Analysis
![KPI Analysis](https://private-user-images.githubusercontent.com/121683356/314176847-e1033fc9-4e66-4a49-97b6-ff8fcebbfa89.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjM5NjYyNzEsIm5iZiI6MTcyMzk2NTk3MSwicGF0aCI6Ii8xMjE2ODMzNTYvMzE0MTc2ODQ3LWUxMDMzZmM5LTRlNjYtNGE0OS05N2I2LWZmOGZjZWJiZmE4OS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgxOFQwNzI2MTFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1lZGQ2MTk4YWZiMWI0ODYwNWE1Y2RhMjBjYWQ4ZjUwNzU1ZDM5ZDYwOTA5MmE2YzFjNTIxNjBiMTNmMWE0OTk5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.VRtwTtId5tSxa3LasZbs--92mY3igFw1bs1uAXhI9Ys)
This slide presents an analysis of sales by category, featuring a stacked bar chart visualization. The chart provides insights into sales distribution across different categories, allowing for comparison and trend analysis. Two filter tabs are included for chain and buyer, enabling users to dynamically filter and explore sales data based on specific criteria. This visualization empowers users to gain a deeper understanding of sales patterns and make data-driven decisions.
To view the reports, download the .pbix file and open it using PowerBI Desktop.
The data used for analysis is sourced from an Sample Super Store data.
This project is licensed under the MIT License.