How to derive the MTD achievement based on monthly target and daily sales data on various dimensions

Derive monthly closing balance of various items from yearly opening balance and their monthly transactions data

How to derive the recently purchased city of each customer from daily customer transactions from various cities

Use case for a Jewellery agent’s order count calculation where orders and customers can be divided amongst multiple transactions for the same order

How to Derive Daily and Monthly Opening and Closing Covid Cases

Deriving week start date and week end date of a given date

Derive Week of year considering the week starts from Saturday

Create Custom column values from the dataset

Minimizing Number of Steps using Custom SQL in SSDP

Tracking Daily User Login Hours Through VPN Logs