Business intelligence for your company

The question of data integration raises the question of the usefulness of an ETL. The question is often asked in our discussions with the SMEs and SMIs we work with: « Why should I buy an ETL? One of the main benefits is the durability of the BI system! The ETL is there to store, secure and historicalize the data in your information system. In the event of an ERP change, for example, your dashboards will continue to function with the new tools and to consult the history. On the other hand, if you’ve been querying your databases directly for reporting purposes, you’ll have to redo all your queries and dashboards. The second major advantage of ETL is its ability to mix data sources. Its transformation power is widely recognized, particularly for flat files. Microsoft BI offers several ETLs: Power BI, SSIS and Azure Data Factory.