A client has requested some of this information be simplified and represented in a way they could interpret and utilize the data for use.
Resource Table
with the above resource, we should find solutions the following question
- What is Our Highest selling item?
- what item or branch is predicted to bring more profit in 2023
- what time of the year did we make more Sales?
- Who is our Best sales representative?
Our Predictive Analysis Report and Solution
From the Analysis, we find out that the highest-selling item in the past two years is Binder with a total sale of $19627.88
Now that we know the Item that sold more in the past two years, we need to find the region where this sale was made in order to predict the next year's sales profitable region and item.
By using the total sale against each region we are able to know this information.
The table above will help us to visualize the solution
below
The CENTRAL Regional branch makes more profit; from the Bar chart we can tell this .
The client Also asked that we provide what period of the year they made more sales
after carrying out our analysis to find the total sum of items sold in each quarter of the year we represent it in the table below
The most profits where made in the fourth Quarter of the year.
Top comments (0)