Data Interrogation and
Analysis

line img
GowerJones Forensic are regularly engaged to undertake interrogation and analysis of large data sets.

Based on our clients’ objectives, GowerJones Forensic apply the most cost-effective methodology to the data including:

GowerJones Forensic has expertise in the practical application of the necessary computer tools and languages required for data interrogation and analysis including:

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 and R