Internet of things data is noisy and contains gaps and false readings.

the Internet of things data is noisy and contains gaps and false readings. Please describe how would you filter process transform and enrich this data and would it be possible to store this data in standard tables with rows and columns?