The Mediterranean Camera Company’s CFO Ms. Toni Hewlett is expecting a report with no more than 2 pages with a horizontal navigation menu. This is an
(EDA) Exploratory Data Analysis and product specifications have been masked.
1. Page 1 should be an Executive overview of the Company Sales performance YTD report.
2. Page 2 should be dedicated to a Products Data Analysis and Time Intelligence report. Any trends/seasonality for any of the Products and or
Countries of sales. Does any product sell more
over weekends?
*Reports are limited to 2 pages and no other restrictions, or
techniques are imposed. Feel free to use all the techniques at your
disposal – tooltips, drill-throughs, page navigations, etc.
The dataset contains transaction records of camera products for the year 2021, the approach is to create an dynamic dashboard with KPI cards covering total sales, total profit & profit margin.
Page 1 of the report is executive summary of revenue from different countries, weekday/weekend sales, trending profit by month, price range & buyer type.
Page 2 is a deeper product level performance report with gauge meter set for Total Units sold vs Order Target, Actual Sales vs Target sales & Total Cost vs Target Cost.
Price adjustment slicer helps us to identify how product performance & profit can improve if the product price point % can be increased or decreased.
Comments