The data was gotten fron F20 Analytics challege for june/July 2023. you can interact with the visual here and can also swict to a view on the full screen.
Here are some insights from the report:
Sales and total Profit are positively correlated with each other.
There was an average downward trend from January 2020 to December 2020 and an average increase in sales from January 2021 till December 2021.
At $20,882,630.00 Men's Street Footwear had the highest Sales and was 95.84% higher than Women's Athletic Footwear, which had the lowest Sales at $10,663,192.00.
Men's Street Footwear accounted for 23.21% of Sales.
Across all 6 Product, Sales ranged from $10,663,192.0 to $20,882,630.0 and Profit ranged from $3,897,578.50 to $8,280,226.10.
In-store had the highest Sales at $35,664,375.0, followed by Outlet at $29,558,553.0 and Online at $24,767,262.00.
This Analysis was on Data Fest January Challenge, view the solution here
Tool: T-SQL