Implementing a Robust Analytics System with 100+ Control Scenarios for a Defence & Security Acquisition Authority
Tableau Free Trial Alteryx Free Trial Aurex Free Trial

Implementing a Robust Analytics System with 100+ Control Scenarios for a Defence & Security Acquisition Authority

The client was able to analyse 33 control scenarios on a quarterly basis. To date, they have incorporated 100+ control scenarios across departments daily.
Industry Industry

Industry

Defence

Region Region

Region

Middle East

AI AI

Technology

Oracle, Alteryx, Power BI

Client Client

Client

The client is one of the top Defence-security acquisitions authorities in Middle East which helps in facilitating ecosystem growth and human capability development through global and local partnerships, and empowering technology & innovation through the defense and security R&D ecosystem.

Requirement Requirement

Requirement

The client required a robust analytics system to implement control scenarios across Finance, Procurement, Human Resources and IT.

Challenges Challenges

Challenges

  1. Dependency on the IT team for the data extraction
  2. Repeated manual efforts for the audit reports
  3. Issues of accuracy with manual efforts
  4. Limited access to true source data for daily refresh
  5. Manual follow-up process for identified inconsistencies
  6. Limited number of control scenarios
  7. No Visual Analytics tools for the end users
Process Process

Process

Control scenarios are implemented on the Oracle ERP. Identified inconsistencies are visualized in Power BI for the business users:

  1. Real time data is extracted from Oracle database.

  2. Automated data cleansing and data wrangling is incorporated with the help of Alteryx.
  3. The cleansed and enhanced data is stored in the SQL layer for data warehouse.
  4. Power BI fetches data from SQL data base for Visual Analytics.
  5. Power BI refreshes this data on a daily basis and the client can track inconsistencies on a daily basis and the stakeholders concerned will be notified on the identified inconsistencies for further action.

Result Result

Result

  • Interactive dashboards that allow self-service analytics for the user
  • Streamlined data that can be analysed with ease
  • Automated data extraction from different sources
  • Daily refreshed Power BI reports for real time follow-up of inconsistencies
Key Key

Key Takeaway

The client was able to analyse 33 control scenarios on a quarterly basis. To date, they have incorporated 100+ control scenarios across departments daily.

Client Client Requirement Requirement Challenges Challenges Process Process Result Result Key Takeaway Key Takeaway