I had the opportunity to complete a project with Adventure Works Dataset. This analysis revolves around Adventure Works. Adventure Works is a manufacturer and supplier of bicycles, parts and accessories. My goal is to journey through this comprehensive dataset and create visuals representation of the data to access performance over the year (2005–2008). I am primarily interested in analyzing our profit, specifically I would like to concentrate on the analysis of products, customer locations(countries). By exploring this data with Microsoft Excel, I aim to identify trends and patterns that will empower the company to enhance its operations and better serve its customers, refine product offerings, and ultimately increase sales.
| Aspect | Details | jnfjkb |
|---|---|---|
| Business Goal | Reveal where revenue, profit, and order volume are growing or shrinking so managers can target high-value segments, fix unprofitable pockets, and forecast demand. | c nk xcn xn |
| Time Frame | FY 2021 – FY 2025 (note: no orders yet in 2025) | |
| Grain | One record per product line on an order (“wide” Super-Store style) | |
| Key Dimensions | Date ➡ Year/Month/Day, Ship Mode, Customer Segment, Region > State > City, Category > Sub-category | |
| Key Facts | Sales, Quantity, Discount, Profit |
nsfjkczn n k n cpmzocziozc nz cizcn mnzjzc cn