This repository provides an analysis of Parch and Posey Firm, revealing key insights in relation to customers, orders, sales regions, sales representatives and web events.
This analysis provides insights on:
- Customers - Customer base and customer segmentation based on profitability.
- Orders - Order volume patterns, most popular orders, average order value, order sales trends and profitability trends.
- Regions - Income distribution by region and customer distribution by region.
- Sales Representatives - Revenue distribution of sales representatives, number of sales representatives, and top performing representatives.
- Web Performance - Order distribution, top channels and frequency of web events.
'Parch and Posey Schema File': Dataset used for the analysis
'Keddy P & P Queries': SQL document containing analytical questions and corresponding queries
'Keddy P&P Performance Dashboard': PowerBI Dashboard containing a visual summary of trends
'Parch & Posey Analysis Report': Report summarizing findings of the analysis
- Download the repository
- Install required applications
- Run the queries
For feedback or collaborations, contact kedei.eyong@yahoo.com