Mind the gap: Using advanced analytics to find and fill the holes in real world data