Visualise a 5 column dataset as show below. This is a very small sample of the actual dataset. It shows the date on which supplies were received for each item from Vendors and whether those supplies had errors in them. Finally those identified errors have been bucketed into relevant categories. The Item ID# is a […]
Read More →
Here is a simple 3 column dataset showing Categories, Date and Value Catagorie Date Value Fish 08-12-2015 6 Crab 05-12-2015 7 Crab 04-12-2015 6 Bird 27-11-2015 4 Snow 25-11-2015 10 Cat 21-11-2015 7 Dog 12-11-2015 5 Dog 28-10-2015 5 Fish 12-10-2015 3 Bird 11-10-2015 9 Dog 22-09-2015 9 Crab 17-08-2015 8 Cat 11-08-2015 1 Fish […]
Read More →
{ 9 Comments }
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 fixed monthly amount due to an Organisation for services rendered to various customers. While an invoice is raised every month by this Organisation, not all pay up the dues on time. For unpaid dues, the Organisation charges its client interest ranging from 3% to 9% per annum. The objective is to determine cumulative […]
Read More →
Here is a dashboard created with a Pivot Table, a Pivot chart and slicers (Click to enlarge image). In the Pivot Table, the % have been computed using “% of row total”. The Pivot chart shows two columns per month – one for complete and the other for incomplete. The objective is to show only the […]
Read More →
{ 0 Comments }
Assume a dataset with two columns which lists down the student names in column A and courses opted for in column B. Since one student can opt for multiple courses and the same course can be taken up by multiple students, there can be repetitions in both columns. The objective is to create a matrix […]
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 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 →
{ 6 Comments }
With Power Business Intelligence (BI) tools of Excel 2013, one can metamorphose raw data and/or results of complex calculations into stunning and interactive visualizations. Power View (one of the four components of Power BI) allows one to create a PPT like flow in Excel thus allowing one to weave a story. To be able to interact with/create visualizations, […]
Read More →
A tournament has 18 participating teams with 25 players in each team. Each team has to play five rounds of the Tournament and not all players play all rounds. Scores earned by each player in each round are shown in individual cells. If a player does not play a round, that cell is left empty. The task […]
Read More →
Perform an aggregation on Top x items after satisfying certain conditions
{ 0 Comments }