Overview

The Inventory Analysis for Acropolis Retail Ltd. starts with loading and preparing raw data, ensuring no duplicates exist to avoid double-counting stock items. The Orders table requires manipulation to correct column data. Initial calculations focus on the Cost of Goods Sold (COGS) using disclosed costs for each item in the Stock table. Next, revenue and profit are calculated using sales data, with a focus on comparing performances between 2020 and 2021. Inventory turnover is analyzed to determine product sales frequency in 2021. The ABC analysis classifies items based on revenue importance, with preliminary results visualized for insights. A COGS-to-revenue ratio guides smart purchasing decisions, identifying high-profit items. The study examines inventory turnover and revenue at the category level and analyzes order data by countries to understand geographic influences. Comprehensive dashboards are built to present findings to management, focusing on product-level and category-level data. The final presentation integrates both dashboards into a compelling data story for Acropolis Retail’s management team.

Inventory Analysis

Dashboard