LAG Report
Project related images. Click to view
?Project Description
?
?Design & Aesthetic: Built with a sophisticated gold-and-white theme featuring a central gold heart layout that houses all primary financial metrics alongside custom-styled year selection buttons (2016 through 2019).
?Data Model & Structure: Powered by cleaned inventory, sales, and returns datasets with standardized date types, relationships, and a dedicated Calculations table housing custom DAX measures.
?Key Financial Metrics (Formatted in Nigerian Naira ?):
?Gross Sales: Tracks total sales revenue across the selected periods.
?Cost of Sales: Captures total product costs.
?Net Sales: Dynamically calculated by subtracting returns and discounts from gross sales.
?Gross Margin: Measures profitability by subtracting the cost of sales from net sales.
?Returns & Discount: Quantifies product returns and total promotional discounts applied.
?Interactivity & Navigation: Includes interactive year slicers for temporal filtering and a designated "Go to Report" action button to guide users through a seamless analytical experience.



Leave your thought here