Why did Angulas Aguinaga contact Bosonit?
On the recommendation of one of our historical clients, we were contacted from the department of Business Intelligence from Angulas Aguinaga. From this area we have been asked to support both the maintenance of the existing Data Warehouse and the expansion and development of its tool. Business Intelligence.
The aim was to improve reporting capacity, improve the performance of the reporting loads, and to improve the Angulas AguinagaThe new functional modules that were requested encompassed the areas of Purchasing, Sales-Costing and Production Consumption. The new functional modules that were requested covered the Purchasing, Sales-Cost and Production Consumption sectors, however, discussions are already underway to continue the collaboration with new projects and modules.
What tools have been used?
Within the Business Intelligence, the following have been encompassed ETL as well as modelling and subsequent visualisation. All this has been carried out using the Microsoft BI suite (SSIS, SSAS, Power Business Intelligence, Power Pivot).
Use of Business Intelligence in the project
- Evolution of the BDWThe BDW: allows you to add more execution capacity, especially for tasks executed with Microsoft technologies (SSIS, SSAS, tabular models), Excel and Power Business Intelligence and to continue with the functional evolution of your BDW.
- Excel Power Pivot visualisationThe DWH: allows the integration of external data from different suppliers into Aguinaga's internal DWH for its future exploitation through Excel.
- Riunione data integrationThe DWH: allows the integration of external data coming from Riunione. Specifically, four tables; two dimensions and two fact tables, will be integrated in the internal DWH of Aguinaga.?