Data mart expansion and Power BI migration for Government Energy Distributor

Our customer had a data mart that was only focused on the needs of the finance department, therefore they wanted to expand the data mart to serve other areas of the business. As a trusted partner, they selected DSP to carry out this work. The challenge involved consolidating all data sources into a single data mart, migrating Power BI data sources, and creating diverse dashboards covering various subject areas.

DSP executed a comprehensive solution to accommodate the customer's requirements, designing and developing several Power BI dashboards for subject areas ranging from voltage consumption to asset management. We gathered company-wide reporting requirements and prepared design documents for the expansion of the data mart. We also designed and developed Power BI dashboards and reports based on the requirements of stakeholders.

Our approach entailed:

• Requirement Gathering: We engaged in a thorough process involving document analysis and client consultations to source essential data and meet their reporting needs.
  
  
• Data Modelling: Upon identifying relevant data, we crafted the data model in a star schema format to support the dashboard.
  
  
• Dashboard and Report Design: Aligned with stakeholder requirements, we designed and developed Power BI dashboards and reports, ensuring precision in their content and functionality.
  
  
• Dashboard Implementation: To enhance data insight, we defined key performance indicators (KPIs) and inspected measures and columns for inclusion in Power BI tables. We built reports/dashboards, which spanned various subjects, including voltage consumption, IT audit, authorisation reports, business planning, and asset management (this is a critical report and continues to be managed).

Throughout the process we conducted "show and tell" events, where we presented the reports to the client, facilitating a feedback loop. This collaborative approach allowed for adjustments, tweaks, and the incorporation of additional features to meet the client's evolving requirements.