Data insights and visualization dashboards delivered through Power BI for a leading energy enterprise

CRM_1

Client Challenge

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 which was causing duplicate records.

Solution

Nalashaa initially started with identifying the reference links, analyzing the data to factor the unique combinations to avoid duplicate entries.  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.

Overview

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. Nalashaa built up the required dashboards and visualizations using Power BI for data modelling.

Technology Stack

  • Microsoft Power BI
  • SQL Server 2012
  • SSIS