Astara is a vehicle import company. In Colombia, it exclusively represents Dodge, Fiat, Hyundai, Jeep, Opel, Peugeot, RAM and Volvo.
Astara had the need to have a forecast of the number of vehicle registrations in each of its markets in order to accurately determine the number of vehicles for import.
They made the prediction of 2 of their markets in tools such as excel and based on the knowledge of the automotive industry, however the COVID-19 pandemic created greater uncertainty and a decrease in the assertiveness of the forecasts, they wanted to include machine learning in their solution and that it take into account the impact of the year 2020.
Their priority was to improve the accuracy of existing forecasts and have new scenarios for the rest of their markets, segments and brands, a total of 7 scenarios or use cases within Amazon Forecast, additionally they needed support in the analysis and creation of a new one. variable that would allow evaluating the impact of the COVID-19 pandemic (year 2020) on vehicle registration records, we discussed with the client the benefits of AWS, the ease of integration, the low cost and the benefits of having a scalable architecture , benefiting from economies of scale and interaction between AWS services.
Lambda functions were created in Python language to upload Excel files and SQL Server tables to AWS. For the data transformation and creation of datasets for Amazon Forecast input, a lambda function was created that stores the datasets in an S3 bucket. Jobs and Workflows were created in Glue to automate the implementation of each of the steps within Amazon Forecast to achieve the prediction of vehicle registration in Colombia in the coming months.
Within the Astara server, the results visualization board was made in PowerBI, taking the resulting tables in Amazon Athena as a source.
Reduce the analysis time of the behavior of markets and macroeconomic variables, from 2 weeks to approximately 12 hours.
Have the registration forecast for 5 types of markets, segment groups and brands.
Go from predicting 6 months to more than 50 months.
Automate the creation of data sets and monthly forecast, and visualization of results on the PowerBI dashboard.
Improve the forecast between 5 and 10% in the precision of the results returned.
Advisory
En Insbuilt trabajamos de la mano con usted, su equipo, sus procesos y sus objetivos.
Lo acompañamos en la implementación de soluciones innovadoras basadas en la nube, pensando en ella como el entorno digital donde sus ideas cosecharán los mejores resultados.
– Talleres de adopción de la nube para alta y media dirección (Cloud Adoption Framework – CAF)
– Estructura inicial cloud / Célula Cloud (Personas y perfiles)
– Planes de capacitación
– Procesos de transición a la nube
Migración a la nube
Nunca estará solo. Nuestro equipo profesional lo acompaña en cada paso que de para adoptar la nube. Tanto líderes como colaboradores de soporte tendrán siempre un proceso de participación en las implementaciones y de aprendizaje paralelo bajo modernos esquemas ágiles.
Assessment (Evaluación de workloads)
Readiness & Planning (Diseño del plan de migración)
Landing Zone (Control Tower)
Migraciones
SAP on AWS (Descubrimiento y Migraciones)
Data & Analytics
En esta nueva economía, el dato está en el corazón de todos los negocios. Las soluciones de la nube, le habilitan conocer mejor los mercados actuales a partir de la información de los usuarios, consumidores o beneficiarios de sus servicios o productos. Aproveche la información para el mejoramiento de su oferta comercial y de su negocio en general.
Discovery Workshops
Data Lakes iniciales
ETLs y Visualización
Machine Learning / Inteligencia Artificial (ML/AI)
El factor humano es la clave en la adopción y transformación digital. Nuestra gente, posee diversas capacidades para facilitar cualquier etapa de la adopción digital. Proveemos recursos a modalidad de tiempos y materiales para proyectos transformacionales en la nube. Típicamente alocamos recursos de:
People is key to Cloud adoption and digital transformation. Our experts have different skills to facilitate any stage of digital adoption. We provide resources in the form of time and materials for transformational projects in the cloud. We typically allocate resources from:
Advisory
At Insbuilt we work hand in hand with you, your team, your processes and your goals.
We accompany you in the implementation of innovative cloud-based solutions, thinking of it as the digital environment where your ideas will reap the best results.
– Cloud adoption workshops for senior and middle management (Cloud Adoption Framework – CAF)
– Initial cloud structure / Cloud Cell (People and profiles)
– Training plans
– Cloud transition processes
Cloud Migration
You will never be alone in this journey. Our professional team accompanies you in every step you take to adopt the cloud. Both leaders and support collaborators will always have a process of participation in implementations and parallel learning under modern agile schemes.
Assessment (Workload Evaluation)
Readiness & Planning
Landing Zone (Control Tower)
Migrations
SAP on AWS (Discovery and Migrations)
Data & Analytics
In this new economy, the data is at the heart of all businesses. Cloud solutions enable you to better understand current markets based on information from users, providers or consumers of your services or products. Take advantage of the information to improve your commercial offer and your business in general.
Discovery Workshops
Data Lakes
ETLs and Visualization (BI)
Machine Learning / Artificial Intelligence (ML / AI)
We know that the challenge of migrating to the cloud is complex. Operating and maintaining workloads requires additional staff that sometimes the organizations budget does not contemplate.
Sabemos que el desafío de migrar a la nube es complejo. Operar y mantener los workloads requiere personal adicional que a veces el presupuesto de las organizaciones no contemplan.