Retail Sales & Profitability Analysis

Analyze retail sales and profitability to understand business performance and identify areas for improvement.

My Work

Worked with Orders, People, and Returns data.

Built a data model using table relationships.

Developed measures for Total Sales, Total Profit, Profit Margin, Running Total, and Year-over-Year Growth.

Created calculated columns for profitability categories and shipping delay analysis.

Business Questions

How are sales and profits performing?

Which products or segments contribute to profitability?

How does performance change over time?

Where might shipping delays need attention?

Tools: Power BI, DAX, Excel.