Technology Stack
Business Intelligence architecture requires several types of software components. Scandic Fusion works with world leading technologies, which are used and trusted by many businesses.
Business Intelligence
BI component is responsible for various data visualization needs – interactive dashboards, data exploration, dynamic reporting (aka ad-hoc queries), control reporting, publishing. Scandic Fusion masters various BI tools.
- SAP Business Objects
- Oracle Business Intelligence
- Tableau
- PowerBI
- Qlik View/Sense
- SAS Visual Analytics
- Microstrategy
Data mining and predictive analytics
Data mining and predictive analytics software helps find patterns and systematic relationships among different aspects of business operations.
- R
- SAP Infinite Insight (KXEN)
- IBM SPSS Modeler
- Oracle Advanced Analytics (aka ODM)
- Python
Database
Database is responsible for storing BI data. Right pick of database technology has great impact on the SQL performance, i.e., user satisfaction of how quickly data is being retrieved from the database. Scandic Fusion works with variety of DB technologies.
- SybaseIQ
- Oracle db
- Vertica
- PostgreSQL
- Teradata
- SQL Server
- HANA
Extraction, transformation and load
Extraction, transformation and load of data help transfer data from source system and compose into BI data layer as dimensions and facts. Scandic Fusion works with a variety of tools, starting with great open source solutions and finishing with leading commercial software.
- Oracle Data Integrator
- SAP Data Services
- Pentaho Data Integration
- Informatica
- SSIS