Visualization Dashboards for a
Leading Energy Enterprise

Data insights with PowerBI for faster incoming data anaylysis

Industry

Energy

Technologies

Microsoft Power BI, SQL Server 2012, SSIS

Region

Europe

A leading enterprise serving the energy generation and base material industries needed incoming data from governing bodies to be analyzed and insights obtained with the help of a dashboard which would be populated on MS Excel.

Goal

Huge data from different governing bodies which will grow not only in size, but also in structure over a period of months. There also exists many data type issues and typecasting issues spread across multiple data sets. There were also one-to many relationships which between the tables were causing duplicate records.

Method

Data Models / Views were created for the unique data sets and then we built up cubes which were then exposed in Power BI as tables. Star Schema was used for data modelling, cache mode helped to push the data to Power BI web and clustered, non-clustered and covering index is defined on base line basis.

Results

Data visualization solution focussed on bringing in means to view various data types cummulatively and concisely for faster inferences. PowerBI was the choosen tool to implement the solution for the energy enterprise.