Posts

Inferences from a Timeline plot

Image
The timeline for each bid is standardized. The application time for each participant is shown in the blue circles. The large blue ball represents the bid application time of that participant who has been awarded the bid. The bids awarded for those participants who has applied for the bid at the ending time or starting time are suspicious. Such bids must be invetigated. The bid item is searched in Amazon.com and highly matched cases are scrapped. Such items prices are compared with the price of the item for which the bid is offered in GeM. The items that are available in amazon for lesser amount are shown in orange.

Funnel coversion rate analysis

Image

Sankey chart to determine the cashflow

Image
  This chart was created using the treasury data to determine the cash flow of major schemes. The Sankey chart is created as a user-friendly dynamic dashboard, where the user can select each of the three layers to understand the flow of cash between various units. This was created back in 2017 referring to various blogs. But now the tableau allows us to create such diagrams easily using the show me more 2.0 extensions  feature added to the tableau in 2021. NB:- This dashboard cannot be published due to the data privacy of the organization.

A use case of Ternary plot

Image
The scheme states that the houses provided will be under the joint ownership of the husband and wife, except in the of the case of an unmarried, widow or divorced individual. As the ternary plot clearly shows that the jointly owned units are the least.

Health in India (NSSO 71st Round)

Image