Training Use Cases
Training Use Cases
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
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
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
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. ...
Tue, 3 Nov, 2020 at 8:58 PM
How to derive the MTD achievement based on monthly target and daily sales data on various dimensions
Scenario: The granularity of target data is monthly and sales data is daily. Requirement: Derive the MTD achievement based on monthly target and daily...
Thu, 21 Jan, 2021 at 1:14 PM
Scenario: The data contains Address column that has Name, City, Email, Contact Number, etc. separated with special characters. Requirement: Split the co...
Thu, 21 Jan, 2021 at 1:13 PM
Requirement: Handling multiple JOINs through Step by Step wizard to create dataset. e.g. Join LedgerMaster with InventoryDetail, Accounts, GoDown and its ...
Wed, 3 Feb, 2021 at 3:23 PM
Scenario: The dataset has yearly opening balance and their monthly transactions for different items. Requirement: Need to derive monthly closing bal...
Wed, 9 Jun, 2021 at 2:52 PM
Scenario: Shows daily customer transactions from various cities. The data also contains multiple purchase transactions of the same customer from different...
Wed, 9 Jun, 2021 at 2:51 PM