Trilha dos Pães - Goals and Sales

Creation of a sales data lake; the data is stored in the Varejo Fácil ERP system and extracted from an API. Pentaho DI was used for data extraction and validation, as well as the loop to read the API pagination, later automated to read the data day-to-day (d-1). A Postgres database was created with "raw" values; this database generated almost 30 million lines during the company's existence. Later, another database was created with a leaner data set and processed data for use in the Business Intelligence (BI) system. Finally, a BI system was created with target data and a visual interface for managers to understand which products were best-selling and which salespeople were achieving their targets.