|
This project was divided into two stages:
1) ETL Web Interface
Through this ETL interface, companies who are subscribed to SEDRONAR and work with substances controlled them, can upload, via Internet, quarterly reports detailing transactions made in the correspondent quarter of year.
2) Business Intelligence
Through an ETL process, the data the companies uploaded was used to create and update a central base of information. From this and the implementation of the MicroStrategy platform, it is feasible to mine the information in order to analyze it in comparative and historical terms, enabling better and more precise decision-making. |
