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:
1. Of all those passengers who originated their journey (City of Origin) from Chandigarh, how many terminated their journey (City of destination) in New Delhi via different modes of transport; and
2. Of all those passengers who terminated their journey (City of destination) in Jammu, how many arrived in Amritsar (City of Origin) via different modes of transport; and
3. Of all those passengers who travelled by Bus, how many travelled from City A (City of Origin) to City X,Y,Z (City of destination)
While one can analyse/slice and dice this data using Pivot Tables, one cannot visualize this data very clearly (even after creating a Pivot chart). I have attempted to visualize this data using a software called PowerBI desktop (a free for download and use Business Intelligence software from Microsoft which rolls all of Excel’s BI tools into 1 – PowerPivot, Power Query, Power Map and Power View).
You may download the source Excel workbook and the Power BI desktop workbook from this link.
You may also watch a short video here:
Visualising data flows using Custom Visuals
{ 0 Comments }