Power BI reports development for India largest power and energy company

Context

- The client was using Microsoft
  analytics infrastructure for data
  consolidation and for reports and
  dashboards.
- Earlier manual excels were being
  used.
- The existing process of data
  compilation and KPI’s was lengthy
  and intervened many factors like
  skill-sets and decision making.
- Advaiya offered services for
  development of new reports and
  enhancing existing reports based on
  inputs from business and IT team
  from client.

Challenge(s)

- The client was earlier using excel
  based reporting which increased
  susceptibility to errors.
- Inefficiencies in data
  management, and potential
  delays in decision-making
  processes across the
  organization
- The human error to generate
  inaccurate information across
  the organization, thereby
  impacting decision-making at
  multiple levels.

Solution

- Standard excel templates were
  created for easy ingestion of
  data.
- A standard staging environment
  was developed using SSIS to
  automate data integration and
  data movement from excel to
  SQL database.
- Automation of report KPIs and
  dashboard solution for all
  businesses.
- Interactive Summary Landing
  Page and Business Level
  detailed reports for the
  management.

“ Your dealer management application has transformed day to day operations, ensuring seamless collaboration, efficient order placement & tracking. ”

– CIO

Engagement coverage and highlights

- Enhancements of the Flash Power BI Reports
  developed for Adani Digitization
- Creation and enhancement of new reports
- Modifying Energy Dashboard Report with new Outage
  Status and Major event Template
- Standardization of Excel templates
- Locking up excel column headers in excel based
  templates.

- Performing data validation on excel cells.
- Creating new Power Automate Flow or Modifying
  existing Power Automate flow.
- Creating approval in Power Automate
- Creating New SSIS Packages or Modifying the Existing
  SSIS Packages
- Creating New SSAS Model or Modifying Existing SSAS
  Model
- Modification in Console application.

- Creation or modification of Database, Tables, Stored
  Procedures, and scheduling Job activities.
- Update of user manual/SOP/documents with new logics
- Organization of Share point folders and providing
  requisite user access.
- This also includes technical support provided: Help in
  the smooth operations, refreshes and access of tabular
  models

Timeline

25+

KPIs tracked through reports

5-10 minutes

Time reduced for approval and rejection

10+

Different Power plants covered

<2 hrs. per week

Report monitoring and support time

3

Number of Businesses covered

>75%

Reduced manual work

Featured technologies