Analytical consulting services

The world of corporate analysis is dominated by Microsoft Excel, and Corality’s Analytical Consulting team assist clients with their most challenging tasks in Excel, VBA, Access and other databases. Our business consulting experience combined with our exceptionally skilled Excel and VBA consultants assist our clients with services including:

• Business process modelling
• Excel automation and reporting
• Data analysis and forecasting

Business process modelling in Excel and VBA

Using our expertise in Microsoft Excel and VBA we assist our clients in the development of models and systems to map existing business processes. Our solutions are easy to use, give confidence to users and add robustness to your processes. Areas of expertise include:

• Audit and documentation of business processes
• Enterprise spreadsheet redesign to increase process efficiencies, robustness and quality
• Internal communication routines for recruitment, reporting, order management and scheduling
• Data collection, mapping and analysis
• Secure solution for data sharing in Excel between departments, clients or other stakeholders

Excel automation and reporting

Using Excel for financial reporting is extremely powerful but can also be risky and frustrating if the platform and solutions are not robust and scalable. Corality can assist with Excel automation and reporting solutions including:

• Integration of Excel with accounting and reporting systems
• Weekly/monthly/quarterly reporting suites
• Import interfaces to/from third party information providers in Excel
• VBA routines for filtering, mining, sorting, communication and cleaning of data
• Workshops with operational teams to increase quality and efficiency of Excel reporting

Data analysis and forecasting

Using our experience in mathematics, accounting, actuarial studies, physics, engineering, and programming we assist clients with data analysis for forecasting models in Excel. In addition to our financial modelling services, we also provide expertise in:

• Development of databases and related interfaces for analysis
• Excel pivot table development and analysis
• Development of monte carlo / stochastic simulation frameworks
• Trend analysis and development of forecasting methodologies
• Correlation analysis to reveal key critical business drivers
• Smoothing and normalisation of data to reduce noise in historical data and forecasts
• Numerical data mining for patterns and hidden information

Consulting Credentials