Què és la Intel ligència de Negocis (BI / BW)?

Intel·ligència de Negocis is transforming the data that a business stores in it’s database, i el que és útil.

dades típic que es tranformed és dades transaccionals, com ara dades de vendes. Per a un negoci cada dada de vendes individual no és molt útil, però l'agregació d'aquestes dades (summerising les dades) can yield some powerful results for business decision makers. Per exemple, analitzar les dades de vendes individuals per al 1r trimestre de 2013 no seria molt útil, però si aquestes dades de vendes es summerised, it would show the total sales for the period and becomes even more powerful it can be compared to the 2nd Quarter of 2013. It turn for decision makers it can become a powerful tool to increase sales, crear previsions i desenvolupar noves estratègies de negoci.

Business Intelligence uses large amounts of data and can be cumbersome without the IT tools that are used to transform the data. The transactional data that BI uses can come from different sources such as transactional database such as Oracle Databases or MS SQL Servers. The data then undergoes an ETL process known as Extract. Transform and Load.
etl

Extract is the process of extracting the data from the source. Transform is changing the data into an appropiate format to store in the Data Warehouse. The Data Warehouse is the storage for the data used in BI, que està preparat per a la presentació d'informes de dades.

company-report

Les dades emmagatzemades després del procés de ETL, is stored in the Data Warehouse. This is the data that is analysed and presented in Reports, llest per als prenedors de decisions per interpretar.

The commonly used software are SAP BI i Microsoft BI.

Deixa un comentari