Modellera och impelmentra ett Business Intelligence system för analys av ekonomiska data

Abstract

The purpose with this report is to show how a Business Intelligence system can be modeled and implemented to support economic analysis. The starting point for the problem of the report is the studied company of the report, which needs to analyze its economical result based on consultant, department and company level. Analysis of the environment external to the Business Intelligence system shows that the studied company of the report does not govern its own data. Instead, the supplier of the ERP-system must supply these. The data exchange is also restricted to a number of XML-streams over the https-protocoll, since the supplier deliveries data in this format. The report shows that a stage database, production database and data warehouse were implemented in order to enable the economic analyses. Furthermore, the data loading process was implemented by means of an ETL tool and the mentioned XML-streams over https-protocoll.