Refer to this simple Sales dataset The objective is to create a simple matrix with months in the row labels, years in the column labels and sales figures in the value area section. The twist in the question is that for years prior to the current year (2018 in this dataset), sales should only appear […]
Read More →
{ 0 Comments }
This table contains a list of all the inspections created and completed within different time periods. The objective is to create two Tables from this single table – one showing the Accounts created within the chosen time period and another showing the those that were closed within the same time period. Here are screenshots of […]
Read More →
This post is in continuation of an earlier post where I applied Excel’s Business Intelligence tools (PowerPivot, Power Query and PowerView) to analyse the Sales data of an E-Commerce Company. So, just for starters, in that post, I have basically sliced and diced the Sales dataset of an E-Commerce Company from multiple perspectives/facets to know the […]
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 →
Show sales only for corresponding months in prior years
{ 2 Comments }