Here is a dataset showing Project wise forecast of open opportunities. Topic is the Project Name Est. Close Date is the date by when the opportunity would be closed i.e. the project would be won from that Client Duration is the time (in months) for which the project would run Amount is the total amount […]
Read More →
Imagine a Sales dataset with the following columns – ID, Country, Start date, End date and Tier. Here’s a snapshot of the table: ID Country Start date End date Tier 33948 ES 25-Sep-17 28-Sep-17 3 19820 US 08-Oct-17 17-Oct-17 4 9118 US 27-Oct-17 03-Nov-17 2 1563 ES 02-Sep-17 07-Sep-17 2 11087 US 18-Oct-17 27-Oct-17 1 […]
Read More →
Assume a single row of data with numbers and blanks appearing at random intervals. The objective is to sum the largest 5 of last 10 numbers in that row. Solving this problem entails multiple steps: Identify the last 10 numbers in that row i.e. starting from the right hand side, identify the last 10 numbers […]
Read More →
{ 4 Comments }
Assume a simple two column dataset with dates in column A and numbers in column B. The dates in column A are from January 1, 2013 to December 31, 2016 and numbers in column B are for the period January 1, 2013 to December 31, 2015 (there are no numbers for January 1, 2016 to […]
Read More →
{ 0 Comments }
Assume a 4 column dataset (a small sample) as follows: City of Origin City of destination Mode of Transport Passengers travelled New Delhi Pune Air 123 New Delhi Mumbai Air 213 New Delhi Kolkata Air 125 Chandigarh Jammu Bus 785 Chandigarh Amritsar Train 567 Given this dataset, one may want answers to the following questions: […]
Read More →
Assume the following data layout Name Budget April Actual April Budget May Actual May Budget June Actual June a 2 1 1 4 3 b 4 4 2 1 c 2 3 3 3 d 2 1 e 5 6 4 8 6 As one can observe here, there are two sub columns for each […]
Read More →
{ 8 Comments }
The objective is to assist a Store Manager with computing potential sales across different products and colours. To start with let’s assume two datasets: 1. Customer-Colour dataset – a two column table which lists down the colour preference of each customer; and 2. Colour-Product-Price dataset – a three column table which lists down the multiple […]
Read More →
{ 0 Comments }
Assume a two column dataset with Date in the first column and Price in the second one. The purpose is to identify times to buy and sell – buying would be just after the lowest low is confirmed and sell before or just after the highest high is in place. Confirmation is achieved through crossover of […]
Read More →
{ 0 Comments }
Assume a simple four column dataset with the following columns – User, Month, Leads and Sales. The dataset shows the user and month wise leads generated and revenue earned. One may want to analyse this data in a Pivot Table with the User field appearing in the Row labels section, Months field appearing in the […]
Read More →
{ 11 Comments }
Assume a simple two column data range as follows: Product Amount A 1 S 2 D 3 E 4 Product A F 5 G 6 R 7 Product B q 8 w 9 s 10 d 11 c 12 v 13 b 14 Product C In the table above, one may want to compute the Product […]
Read More →
Distribute projected revenue annually
{ 9 Comments }