Calculating Pending Completion Months for an Ongoing Project

Merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year

Apply rounding logic to Time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.

Find out the frequency of repetition of dimension value combinations – e.g. frequency of combination of bread and butter from sales transactions

Apply rounding logic to Time data

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