You shall be reading https://learn.microsoft.com/en-us/azure/iot-hub/iot-hub-devguide-endpoints
You shall also look at `Time Series Insights'
https://azure.microsoft.com/en-us/services/time-series-insights/
Here is my rough sketch. Time series requires token to be generated from Active Directory, but it's easy to setup.
As shown above,
IOTHub support multiple endpoints. so one end can go to time series insights and one go to any database like CosmoDB.
Note: Time series can store only 400 days of data, later it deletes it.
Regarding reports - Time series has extensive components for report and it's very fast. Also, u can access it using programming language like c#.
Important Note: Before designing any cloud architect, please work on "Sizing" factor of the data. Like, frequency of data and size. Based on that we can select the resources in azure cloud.
Please read thishttp://download.microsoft.com/download/A/4/D/A4DAD253-BC21-41D3-B9D9-87D2AE6F0719/Microsoft_Azure_IoT_Reference_Architecture.pdf
