While carrying out analytical and research activities, BGI Consulting exploits the opportunities provided by IT. Depending on the nature of analytical task, BGI Consulting analysts develop applied IT solutions aimed at optimizing data analysis, ensuring its efficiency and reliability. Moreover, unique IT solutions are always developed and adapted for client’s needs while applying such sophisticated research and evaluation methods as modelling, cost and benefit analysis, counterfactual analysis and multi-criteria analysis.
Visual Basic for Applications (VBA) solutions
BGI Consulting broadly applies Visual Basic for Applications (VBA) solutions that allow to automate the tasks being performed, save time and provide optimal solution for the client. VBA solutions being applied encompass different areas - from developing automated spreadsheets and economic models to facilitating daily tasks, such as transferring the client’s comments from the report prepared in MS Word format to the separate table (protocol) of notes, summing up expenditure lines according to the background colours of the cells, etc.
Modelling and statistical solutions using R package
BGI Consulting broadly applies open code statistical package R. The latter is employed for performing counterfactual impact evaluation (e.g. propensity score matching or double difference regression), as well as for developing economic model - in order to prepare the database required for applying economic model and calibrate the parameters of the model. R source code is often linked to VBA source code, allowing to enable and execute R source code using control panel in the MS Excel environment.
Big data and solutions for databases
Analysis of databases plays an important role in the activities of BGI Consulting. Such analysis encompasses selection of necessary entries from the databases with thousands or tens of thousands of cells. For example, after selecting a few hundreds of respondents, using MS Excel formulas each respondent is linked to the database storing thousands of persons, allowing to automatically find the necessary characteristics of each respondent in the database. Another example - after selecting subjects for the control group of the counterfactual analysis, each individual is linked to the database storing data of all population, allowing to automatically find data regarding each selected subject (e.g. turnover, profit, the number of employees, the amount of the assistance provided for all the projects implemented by the subject, etc.) in the database.