Forensic Accounting & Business Valuations 

A boutique firm exclusively providing independent forensic accounting and valuation services.

Data Interrogation & Analysis

GowerJones Forensic is often engaged to undertake the interrogation and analysis of large data sets.
Based on our clients’ objectives, we apply the most cost-effective methodology to the data set, which may include:

  • Cleaning of data
  • Sample of 100% testing
  • Stratification of data by criteria
  • Visualisation of data
  • Modelling of alternative scenarios
GowerJones Forensic’s expertise in the practical application of the necessary computer tools and
languages required for data interrogation and analysis include:

Tools / Languages Advantages
Excel
  • Highly flexible
  • Widely used
  • Graphing capabilities
Visual Basic for Applications
  • Programming enables undertaking of complex tasks
  • Calculations can be applied across large data sets

Databases and
Structured Query Language
  • Very large data capacity depending on database type
  • Structured Query Language enables dissections by
    criteria and joining of data sets

Power Query

  • Extensive functionality for cleaning of data
  • Ability to customise and repeat using M language

Power Pivot

 
  • Summarising and filtering of data
  • Ability to customise the analysis using DAX
    language

Power BI

 
  • Visualisation of data
  • Integration with other tools and enables use
    of similar tools to those in Power Query
    and Power Pivot
  • Very large data capacity

R

  • Advanced graphing and statistical capabilities

C++

  • Provides alternative functionality for writing
    programs compared to Visual Basic for Applications