Portfolio project Microsoft Fabric Lakehouse Built with AI

AI-powered sales analytics

Sales for — – — reached —, — on the same months a year earlier. — earns the most profit.

Designed and built byHarpalSinh Jhala

Fabric LakehouseSource data in OneLake
SQL analytics endpointT-SQL with Entra ID sign-in
Python pipelineAutomated export and shaping
AI-assisted engineeringAnalysis, design and code with Claude Code agents
Interactive dashboardD3.js, responsive, light and dark

01Headline numbers

— – —, compared with the same months of the year before

Sales—

—

Profit—

—

Profit margin—

—

Units sold—

—

Discounts given—

—

02Key insights

Picked out automatically from the data

Best month for sales

—

—, the strongest month in the data

Highest-margin pairing

—

Margin for —, the best country and product combination

Cost of heavy discounting

—

Margin is — with high discounts against — with none

Weakest segment

—

Margin in —, the lowest of any segment

03Trends and mix

Use the toggles to switch what each chart shows

Monthly trend

Every month in the data. The dashed line is the monthly average.

Show

Breakdown

All months, most profitable first.

View by

SalesProfit

04Deep dive

Where profit comes from, and how the latest months compare

Country × product

Every pairing across all months. Stronger color means higher.

Color by

Same months, year over year

Each month the two years share, side by side.

Show

05The data

dbo.sample_data, exactly as exported

All rows

The full table as exported. Click a header to sort.