Hi, I’m seeking an individual to create a visual design for a course focused on Business Data Management and Intelligence. The ideal candidate should possess expertise in Excel. In order to win this big, you must message me, letting me know that you have read the instructions.
Assignment Details:
Check the progress of the project
Instructions
Project Progress Report (100%)
Check the progress of the project.
Grading
[30%] Your Briefs with updates
List your briefs about the supply chains data that you have chosen and summarize your findings. you might revisit your ideas and update these here. It’s often need more than one diagram to show/support your brief.
[30%] Visual Design :
What your visual design to support/not support your briefs
6% Layout/organization (Clear headings? Easy to follow?)
6% Use of text (Succinct or verbose?)
6% Use of graphics (Are they relevant? Do they help you better understand the briefs?)
6% Legibility (Is the text and figures too small?)
6% Does the visual graphs is the best fit to illustrate the briefs? Any other options to do it better? why?
[25%] Visual Analysis
Analyze your findings based on visual design
15% What are the results?
10% Explain with storyboard on your findings.
[10%] Data Transformation
Please show how the Dataset you have extracted and transformed into the visualization tools.
[5%] Progress evaluation
Here’s the Brief
The supply chain study aims to understand and identify methods for quarterly monitoring of product progress, distinguishing which products are generating profits and which are trending towards not being profitable.
Information on what I have already completed:
This is some information from the previous assignment that you may need for reference:
I used MY SQL to get this information.
Top Trending Product:
SELECT
`Product type`,
AVG(`Number of products sold`) AS `Average Number of Products Sold`,
AVG(`Revenue generated`) AS `Average Revenue Generated`,
AVG(`Price`) AS `Average Price`
FROM
supply_chain_data
GROUP BY
`Product type`;
This type of query allowed us to sort through the data and process the information into a very unique table, which tells us that these products are our top trending products.
Product Type
Avg Number of Products Sold
Avg Revenue Generated
Average Price
haircare
400.3235
5131.040900176471
46.01427887361765
skincare
518.2750
6040.704053325001
47.25932887995002
cosmetics
452.1923
6212.356384653847
57.36105759961537
‘haircare’,’400.3235′,’5131.040900176471′,’46.01427887361765′
‘skincare’,’518.2750′,’6040.704053325001′,’47.25932887995002′
‘Cosmetics’,’452.1923′,’6212.356384653847′,’57.36105759961537′
Trending Downward Products:
SELECT
`Product type`,
SKU,
SUM(`Number of products sold`) AS total_units_sold,
SUM(`Revenue generated`) AS total_revenue
FROM
supply_chain_data
GROUP BY
`Product type`, SKU
ORDER BY
total_revenue ASC
LIMIT 10;
This type of query allowed us to sort through the data and process the information into a very unique table, which tells us that these products are trending downward these are our least profitable products.
Product Type
SKU
total_units_sold
total _revenue
cosmetics
SKU59
484
1061.618523
skincare
SKU86
223
1229.591029
haircare
SKU78
946
1292.458418
haircare
SKU57
227
1605.8669
skincare
SKU69
511
1752.381087
skincare
SKU42
155
1839.609426
skincare
SKU75
106
1889.07359
skincare
SKU39
176
1912.465663
cosmetics
SKU91
916
1935.206794
skincare
SKU58
896
2021.14981
Average Selling Prices:
SELECT
`Product type`,
AVG(Price) AS average_price
FROM
supply_chain_data
GROUP BY
`Product type`;
This type of query allowed us to sort through the data and process the information into a unique table, which tells us that these products are our Downword Trending Products.
Product Type
Average_Price
haircare
46.01427887361765
skincare
47.25932887995002
cosmetics
57.36105759961537
