Training Use Cases

Training Use Cases

Get day wise new addition of counts from the data with day wise closing balance of counts
Scenario: Data contains day wise cumulative (closing balance) corona cases for all the states. Requirement: Get day-wise new corona cases from the cum...
Mon, 12 Oct, 2020 at 8:47 PM
Merge actual data in financial year, with Plan data in calendar year, and create plan vs actual data as per financial year?
Scenario: Projection – Plan sales data is in Calendar year, monthly data. Actual sales data is in financial year, monthly data. Requirement: Merge ac...
Mon, 12 Oct, 2020 at 8:48 PM
Apply rounding logic to Time data – e.g. 1:39 PM should be 2 PM and 1:20 PM should be 1 PM.
Scenario: We have flight data that has Flight Time upto Minute level. We also have weather data that has hourly weather parameters. Requirement: We need ...
Mon, 12 Oct, 2020 at 8:48 PM
Merge monthly plan data with actual daily sales data and create plan vs actual data
Scenario: The actual sales data contains daily Sales person wise transaction data. The plan data has monthly target by sales person. Requirement: We ...
Mon, 12 Oct, 2020 at 8:49 PM
Find out the frequency of repetition of dimension value combinations – e.g. frequency of combination of bread and butter from sales transactions
Find out the frequency of repetition of dimension value combinations – e.g. frequency of combination of  bread and butter from sales transactions.          ...
Tue, 3 Nov, 2020 at 8:58 PM
How to find out MTD achievements from daily sales and monthly target scenarios on various dimensions
Scenario: The granularity of target data is monthly and sales data is daily. Requirement: Aggregate the daily sales and monthly target to find out the...
Fri, 27 Nov, 2020 at 4:58 PM