Optimizations in Excel and VBA and BI (Business Intelligence) implantation

Objective: Increase the productivity of the teams that work with operational processes, optimize and arrange the collection and report of the main business indicators, enabling the utilization of statistical analysis techniques to strengthen the decision making in the business you work in.

Most Employed Techniques:

•  Report generation process automation (Excel)
      • Macros
      • VBA
      • Solver (Operational Search)

 

•  Business Intelligence (BI) Implantation
      • Prescriptive Analytics
      • Preventive Analytics
      • Predictive Analytics

 
Most Employed Programs (SETA working with companies that are partners of ECOSSISTEMA SETA DE TRANSFORMAÇÃO DIGITAL):

• • Power BI
  • Tableau
  • Qlik
  • MicroStrategy

 
 
 
Work plan (SETA working with companies that are partners of ECOSSISTEMA SETA DE TRANSFORMAÇÃO DIGITAL):

• • Current report generation Process Mapping, Data collection indicators (including time measurement of the employees involved in the process)
  • Premise survey, measurement preferences, and Business analysis
  • Future collection process design according to the tools available in the company (and possibility offer from SETA or its partners)
  • Mathematical and statistical model development
  • Homologation and tests
  • Presentations and support in audits / Post-implantation monitoring
  • Post-implantation support

 
Where does it take place:
Nitroquímica (Austria), Guide Investimentos, and RB CAPITAL