An Analysis of the Parch and Posey Dataset, Using SQL And Power BI 

Project Description

Parch and Posey is a company that deals with the sale of three distinct paper types to its clients. The Parch and Posey dataset contains 5 tables with varying numbers of columns, all linked via primary keys and foreign keys. Each table contains important information on customers, their orders and their characteristics, their purchase regions, assigned sales representatives, and the route from which they were integrated into the company.

The tables include accounts, orders, region, sales_reps and web_events.

At the end of my training with HerTechTrail Foundation as a data analyst, this was the project I completed. I  accessed the company’s database(using SQL), analyzed the dataset, and generated 10 sales questions. I connected SQL to Power BI and visualized my findings, which will aid in data-driven decision-making for the Parch and Posey Company

Important insights were visualized using a business intelligence tool - Power BI for presentation to stakeholders.

Insights and Recommendations

• Standard Paper shines as our top-performing product, contributing an average total order of 52.73% of our total orders. To maximize our success, I recommend increasing our marketing efforts for Standard Paper.

• Direct customer outreach is a highly effective strategy. Maintaining this approach will help us bring new customers to Parch and Posey and also encourage business-to-customer relationship

• Among the regions, the Northwest region proves to be the highest revenue generator, while the Midwest region lags behind. To boost sales in the Midwest region, we should intensify our marketing efforts there.