This Energy company got value from my solution by tracking and analysing its IoT devices; enabling them to track trends, customer behaviour and predictive maintenance of their assets.
Delivery
By conducting an exhaustive research on possible sources for this company I collected data from OLTP SQL Server databases, Azure services and cloud storage in Microsoft Office 365.
Next I build the pipelines necessary to frame all this data into a Kimball dimensional model using Databricks for processing and Power BI as the final layer to create a one unified model for self service.