I returned to Parch & Posey for the last time
A visual representation of the analysis of the paper company
ABOUT PARCH & POSEY
Parch & Posey, a fictional company created by Udacity as part of its SQL training, is a paper company that sells three kinds of paper to fortune 100 companies with the help of 50 sales reps spread across four regions in the United States.
PROBLEM STATEMENT
As part of understanding how the company had fared over the years, the stakeholders asked for an analysis of their data which was done. However, they needed something more quick and precise as opposed to a bunch of numbers and texts. Insert: visuals.
DATA
The Parch & Posey database schema contained 5 tables:
1). accounts.
2). orders.
3). web_events.
4). sales_reps.
5). region.
The Entity Relationship Diagram (ERD) can be seen below:
DATA VISUALISATION
I used tableau for the visualisation of the data. The visuals included information on the companies, regions and sales reps.
VISUALISATIONS BY COMPANY
The dashboard contains information on companies with the most orders, companies who bought the most paper and the companies with the biggest revenue. There are two categories for the units bought and revenue made. A set of visuals contains the type of paper bought and the other set contains how the companies bought paper over time.
EOG Resources, for example, bought gloss paper the most which, of course, resulted in majority of the revenue coming from gloss paper. I also noticed they bought the most paper in 2015 but of the top 5 in 2016, the company ranked last. It also ranked 1st for revenue in 2015 but 4th in 2016.
The dashboard is an interactive one and can be found here.
VISUALISATIONS BY REGION
I colour coded the regions for this dashboard and the legend can be found at the top left corner. Found on this dashboard, information about the number of companies and sales reps in each region, the top 3companies based on units bought and revenue in each region, how those companies did overtime and the web events in each region.
An observation was made in the units bought and revenue charts. While some companies cracked the top 3 for units bought, those companies did not crack top 3 for revenue. The reason for this is the type of paper bought which have varying unit prices which I mentioned in the first article.
As at the time the data was published, no company in the Midwest had made a purchase.
The dashboard is an interactive one and can be found here.
VISUALISATIONS BY SALES REPS
Found on this dashboard: the number of companies each sales rep handled, the units sold and revenue made by the sales reps.
Georgiana Chisholm joined the company in 2014. She had no sales in 2013 or 2017 as at the time the data was published, cracked top 5 for units sold and revenue and also sold the most units and made the most revenue in 2016.
The dashboard is an interactive one and can be found here.
CONCLUSION
The importance of visualisation cannot be overemphasised. Asides, making findings easier to understand to readers, it helps with the analysis process itself as patterns and trends are noticed that would be more difficult to spot with just tables, texts and numbers.
Article one can be found here and article two, here.
Thank you for sticking with me to the end! Till next time.