Portfolio Details

Advanced Spreadsheet Analysis

For this project, I developed an advanced spreadsheet analysis using Google Sheets to analyze sales data from various product categories and customer transactions. The main goal was to create a comprehensive report based on multiple CSV files, including Orders, OrderDetails, Products, Categories, Customers, and more. To start, I set up a "Temp" sheet to process and calculate essential details such as unit prices, quantities, discounts, and total sales for each order. I then used the INDEX and MATCH functions to link product categories and customer names to the order data. The analysis also involved creating calculated columns for sales amounts, categories, and ranking products based on total sales, which was achieved using functions like SUMIFS, RANK, and conditional formatting.

To further enhance the report, I incorporated additional filters, including a date range for order dates and a dropdown menu for customer names, ensuring that the data could be tailored to specific time periods and customers. The final report sheet included metrics such as total units sold, total sales per category, and sales rankings, along with a pie chart visualizing the data. By structuring the spreadsheet to allow for seamless updates with new data, I ensured that the analysis could be reused for future reports without needing to manually adjust formulas. This project demonstrated the power of Google Sheets for advanced data manipulation and reporting, providing actionable insights into sales performance across different categories and customer demographics.