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.
- The client was using Microsoft
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.
- The client was earlier using excel
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.
- Standard excel templates were
“ 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.
- Enhancements of the Flash Power BI Reports
- 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
- Creation or modification of Database, Tables, Stored
Timeline

Solution discovery & Envisioning
Four Weeks

Implementation
3 months

User adoption
Four Weeks

Maintenance & updates, support
Dedicated Support team
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






