Here’s a simple 4 column dataset Bacterin Donor# Recovery Agency Date Donor Received DONOR STATUS B050001 1 09-06-2005 00:00 ACCEPT B050002 3 09-06-2005 00:00 ACCEPT B050003 1 09-06-2005 00:00 ACCEPT B050004 1 09-06-2005 00:00 ACCEPT B050005 1 09-06-2005 00:00 ACCEPT B050006 1 09-06-2005 00:00 ACCEPT B050007 1 09-06-2005 00:00 ACCEPT B050008 4 09-06-2005 00:00 ACCEPT […]
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 →
{ 3 Comments }
Here is a simple two column dataset which shows EmpID in column A and DateWorked in column B. My objective is to filter the table to show those employees who worked ONLY on August 17 and August 18. I’d like to exclude employees who: Did not work on both these days; and Worked on both […]
Read More →
Here’s a simple four column table showing date wise amount spent per project Date Project ID Project Name Total Amount 10-01-2015 P250 Project A 100 15-03-2015 P250 Project A 250 01-08-2015 P250 Project A 175 01-12-2015 P250 Project A 90 16-01-2016 P250 Project A 75 28-02-2016 P250 Project A 105 23-02-2016 P300 Project B 175 […]
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 →
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 →
{ 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 →
In this workbook, I have Sales data of an E-Commerce Company for 3 months. The typical columns in the base data are: 1. Order Date/Time 2. City to which orders were shipped 3. Order Number 4. Payment Type i.e. Cash on delivery, Net Banking, EMI’s 5. Order Status i.e. Delivered or cancelled 6. SKU’s which the […]
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 →
Affinity analysis encompasses a broad set of Analytic techniques aimed at uncovering the associations and connections between specific objects: these might be visitors to a website (customers or audience), products in a store or content items on a media site. Of these, “market basket analysis” is perhaps the most common example. In a market basket analysis, one analyses combinations of […]
Read More →
Show months with no data which fall within a certain date range of a Pivot Table
{ 4 Comments }