There are 100 machines in a factory. Every machine has different test frequency. In a given month, not every machine is tested but we still have the last known rating (from some previous month) of that machine. We have to show the latest rating of each machine for each month in a stacked column chart. […]
Read More →
This post is an extension to the one I posted here – Segment towns according to volume contribution and market share. Here’s a simple dataset of Shampoo sales in the state of Rajasthan, India. For a chosen segment, one may want to segment the 4 towns based on the following conditions: Based on the two screenshots […]
Read More →
{ 0 Comments }
Consider a 4 column table – Respondent ID, Device ID, App Name and Category. So this dataset shows which apps are installed on which device ID by which user and which category do the apps fall into. It is a small dataset with only 4 columns and 2,000 rows. The question on this dataset is […]
Read More →
Here’s a simple two column dataset Comment Identifier Intervals A 3pm-6pm A 9pm-12pm S 3pm-6pm S 3pm-6pm S 9pm-12pm A 9pm-12pm S 9pm-12pm D 3pm-6pm A 9pm-12pm A 9pm-12pm A 9pm-12pm A 3pm-6pm A 3pm-6pm For identifiers listed in column A, there are time intervals in column B. Note that for a certain identifier, a […]
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 →
{ 2 Comments }
Assume a dataset with a Key Performance Indicator (KPI) [appearing in one column] data for years ranging from 1985 to 2010 for 114 countries. This dataset has 170,000 rows of data and one row below the last row for every country, there is a total of the KPI column. So, if there are 25 rows […]
Read More →
Determine latest condition of each equipment and show a month wise count
{ 1 Comments }