EXCEL SOLUTIONS
Majority of calculations are still calculated on dedicated Excel spreadsheets, which continues to be a preffered tool used by engineers across all sectors of industry.
This is where we can help you by developing or reviewing existing spreadsheets and implement automated solutions, that will save you time and minimise human error. This is acomplished by using full arsenal what Excel has got to offer.
Regular excel and advanced funtions are used first when developing calculations. When this is not possible or isn't practical, then user defined functions can be considered.
User defined functions are developed in Visual Basic for excel. Unlike regular functions, user need to create functions from scratch, inputs are identified, solution is tested and outputs are returned. Drawback of user defined functions is they cannot be used to modify the workbook.
When user defined functions cannot be used, regular Excel subroutines can be developed to produce a solution. Subroutines are allowed to change spreadsheets. Code execution in Visual basic can be executed hunder time faster than on spreadsheets, especially if arrays are used. So implemented macro solutions can be optimised to run faster.
Data extractors extract and copy the data from other excel workbooks, text files, JSON, SQL databases or HTML pages. This is known as ETL in computing and refers to Extract, transform and load. Data extractors are employed when large amount of data needs to be extracted from other sources and consolidated in a single excel file. For example of data extractors refer to our calculations page.
SQL DATABASE SOLUTIONS
SQL server is popular database solution for storage, reporting and data analysis purposes. It can store and handle large amounts of data, and responds quickly to queries.
We can offer services involving database creation and migration. Perform advanced querying and data analysis, writing efficient functions and procedures, or review your database solutions and suggest improvements.
Creating SQL databases, suitable data type, tables and specifying relationships. Definition of primary and foreign keys.
Creation of advanced queries in SQL using vast arsenal of SQL functionality, like select, unions, joins and where statements.
SQL function are useful for data transformation and mathematical operations carried out database values.
Stored procedures are used to execute multiple queries at the same time. Stored procedures may involve many series of SQL queries and functions combined to be executed at the same time.
POWER BI SERVICES FOR THE OIL & GAS INDUSTRY
Power BI is software developed by Microsoft that is used to create business intelligence reports that automate the entire process from pulling data from source databases all the way to final visualisations on the charts.
Get professional reports that suit your needs. We offer services covering the complete reporting process, from building the data model and transforming source data to calculations and final visualisations.
Analysing the data and create data model that best suits your needs.
Transform data using Power Query to get the data fit into your data model.
Perform data calculations and measures using Power BI DAX language.
Creating visually compelling visualisations and adding measures to additionally automate final views.