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 five column dataset – ID, Age, Gender, Time and Class. For chosen ID’s, the objective is to: 1. Assign a Rank (in ascending order of time i.e. lowest time will be rank 1 and so on) to each ID 2. Determine the overall place of each ID – Count of unique time entries […]
Read More →
{ 0 Comments }
Assume a three column dataset which has Year, Company ID and Cash flows. For each Company, there are cash flows for multiple years. So for Company ID A001, there are 7 rows, one each for 2010 to 2004 and cash flows appearing in a third column. Let’s assume the number of rows are 750,000. The task is to compute […]
Read More →
{ 0 Comments }
Assume a three column dataset showing Audit ID, Date of receipt of audit mandate and Date of audit completion. There are other columns as well but they are not important for our Analysis. One may want to compute the following month wise: 1. Which (Audit ID) are the audits pending at the end of every […]
Read More →
{ 0 Comments }
Assume two databases: 1. One showing employee headcount (one row per employee) which has all employee details such as Name, ID, Date of Joining, Supervisor name, Department etc. (Range A1:R781 of Source worksheet) 2. The other showing data for employees who resigned. (Range U1:Z36 of Source worksheet) The task is to compute the attrition rate for selected Group and […]
Read More →
Assume a simple three column dataset showing hours worked by different machine on different dates. So column A is Date, column B is Machine Name and column C is hours worked. There are duplicates appearing in column A and B . Blanks in column C depict machine idle time. The task is to create a simple […]
Read More →
{ 30 Comments }
Visualise Sales Data of a Non-Alcoholic Beverage Company with basic columnar information such as Date of Sale, Time of Sale, Brand, Stock Keeping Unit (SKU), State, City, Quantity sold, Unit Price and Salesman Code. In this sales dataset, each line item represents one visit for one SKU. If nothing is sold in a certain visit, then the SKU […]
Read More →
{ 0 Comments }
Visualise an MS Excel file with two worksheets: Employee headcount – a multi column dataset with information such as Employee code, Date of Joining, Age, Division, Department and Location. Each row represents data for one employee. The number of rows on this worksheet is approximately 700. Training Data – a multi column dataset with information […]
Read More →
Visualise a Pivot Table with a few Fields dragged in the Report filter, Row labels and Value Area section. In the Column labels are two fields, Month and then Year – so in the column labels, for every month, there is data for three years 2005, 2006 and 2007. For some months, there is data […]
Read More →
{ 10 Comments }
Assume quantity sold date by date and City in a three column database. The objective is to determine year wise, month wise and City wise running total of quantity sold in a Pivot Table. The issue which will arise with generating this result in a Pivot Table will be that the Show Values As > Running […]
Read More →
Identify buy and sell break points
{ 0 Comments }