Design Live streaming of Sensor Data using Azure Database

Hey we are working in Bio-gas factory where we are trying to trace the Data readings of every Bio-Gas plant produce heat by using Wireless Temperature sensor,
and I am able to store the readings in Azure database for around 15 sensors individually through Raspberry pi.

But please suggest the best way to design the dashboard for sensors individually as well as using average data for all sensor (daily, hourly and monthly),

Also I need trace the live streaming data and check previous data of sensor according to days or months in form of Bar Graph presentation.

Your suggestions will be very helpful