Excel and VBA optimizations and BI (Business intelligence) implementation

Objective: Increase the productivity of teams working on operational processes, optimize and organize the collection and reporting of key business indicators, enabling the use of statistical analysis techniques to strengthen decision-making in the business in which you operate.

Most commonly used techniques:

• - Automations in your reporting process (Excel)
      • Macros
      • VBA
      • Solver (Operations Research)

 

• - Implementation of Business Intelligence (BI)
      • Prescriptive Analysis
      • Preventive Analysis
      • Predictive Analysis

 
Most Used Software (SETA's work in conjunction with partner companies of the SETA DIGITAL TRANSFORMATION ECOSYSTEM:

• • Power BI
  • Tableau
  • Qlik
  • MicroStrategy

 
 
 
Work plan (SETA's work together with partner companies of the SETA DIGITAL TRANSFORMATION ECOSYSTEM):

• • Current process mapping for generating reports, indicators and data collection (including measuring the time of employees involved in the process)
  • Survey of assumptions and desires for business measurement and analysis
  • Design of future collection process in sync with the tools available in the company (and offer of possibilities from SETA or its partners)
  • Development of mathematical and statistical models
  • Homologations and tests
  • Presentations and support for audits / Post-implementation follow-ups
  • Post-implementation support

 
Where we perform:
Nitroquímica (Áustria), Guide Investimentos e RB CAPITAL