Icore Sales ReportThis project was completed as part of my Virtual Assistant training program to demonstrate my data entry and data management skills. Using the iCore Electronics Sales Report dataset, I practiced organizing customer information, structuring purchase records, and ensuring data accuracy for better readability and analysis. I also created basic data visualizations to highlight sales trends and customer activity.

This sample project showcases my ability to work with spreadsheets, manage structured data, and present information clearly using tools such as Google Sheets and Microsoft Excel. It is included in my portfolio as evidence of my competency in data entry, data organization, and foundational data visualization.

Customer Data Overview

The report contains detailed customer information including Customer ID, First Name, Last Name, Phone Number, Address, Date of Birth, Payment Method, and Delivery Notes. Example entries include:

“Emily Johnson – Prefers express delivery – Credit Card” “Liam Carter – Student discount eligible – Credit Card”

Purchase History Summary Each customer has corresponding purchase records with Order Number, Date of Purchase, Item Purchased, Quantity, Price, Total, Payment Method, and Delivery Notes. Examples include:

“ORD‑3001 – iPhone 15 Pro – 1 unit – AUD 1899 – Express delivery” “ORD‑3006 – MacBook Pro M3 – AUD 2999 – Extended warranty”

The dataset shows consistent purchasing patterns, with popular items such as iPhones, MacBooks, iPads, and Apple accessories. Delivery notes highlight customer preferences like express delivery, gift wrapping, corporate purchases, and VIP discounts.