WYSE-BUYER MEGA STORES
I carried out this project for Wyse-Buyer Mega Stores by creating an advanced data visualization using Microsoft Excel. The process began with data extraction, where I managed databases by querying relevant information from product, sales and customer tables using SQL. This foundational step allowed me to access and organize the necessary data for analysis.
Following the extraction, I employed Power Query in Excel to clean and manipulate the dataset. This involved removing inconsistencies, filling in missing values and ensuring that the data was in a usable format for analysis.
Once the data was properly cleaned, I utilized various charts and graphs to create an interactive dashboard with slicers and timeline to drill down. This dashboard generated critical insights, which include:
The top five products by profit
Profit segments
The top ten states by profit
The top five customers by profit
Regional sales performance
Profit trends between 2014 to 2017, and
Key Performance Indicators (KPI's) for total sales, profit, discount and customer count
The actionable insights derived from this dashboard have empowered Wyse-Buyer as follows:
Made informed decisions on business strategies
Streamline operations, and
Ultimately increase profitability
Dashboard Snapshot
Check out the live project on my portfolio here: https://lnkd.in/dc_pN9fN
By presenting complex data in a visually compelling manner, I facilitated a better understanding of key metrics and trends, enabling the organization to adapt its strategies effectively in a competitive market.