Business Intelligence

Since 2005 I have been developing BI and DWH solutions – primarily with Microsoft and Oracle databases.

  • Relational modeling and data vault
  • Integration of XML and JSON
  • Database development with Microsoft SQL Server (T-SQL), Oracle DB (Oracle SQL and PL/SQL)
  • Development of data integration
  • Reporting and visualization of data

Services

Business intelligence with DWH development can be implemented with and without the cloud. The focus is on relational data structures that are filled with SSIS or ADF. Reporting is usually done with MS Power BI.

Modelling

  • 3NF
  • Star Schema
  • Data Vault
  • XML Schema
  • JSON Schema

Development

  • Microsoft: T-SQL, DAX, M
  • Oracle SQL and PL/SQL
  • R and Python
  • Apache Spark
  • XML, XSLT

Reporting

  • SQL Server Analysis Services (SSAS) and Tabular Model
  • Azure Analysis Services
  • MS Power BI
  • Altova StyleVision (Server), XSLT, XSL-FO
  • R/Shiny, Python

Integration

  • MS Azure Data Factory
  • MS SQL Server Integration Services (SSIS)
  • Altova MapForce (Server)
  • Development with T-SQL, PL/SQL, XSLT, Python

References

Over the last 15 years, I have (co-)implemented BI / DWH systems for various industries and at very different locations.

“

Public Administration

  • Data warehouse for the analysis and forecast of tax revenues and tax expenditures at a government agency (Berlin)
  • Data warehouse for the analysis and forecast of labor market data at a government agency (Vienna)

“

Banks / Insurance Companies

  • Integration of banking systems in a DWH for regulatory reports of a regional bank (Kiel)
  • Reporting for structured financial products (Zurich)
  • Data warehouse for a health insurance company (Stuttgart)
  • Reporting system for a health insurance company (Vienna)

“

Industry

  • Conducting and analyzing employee surveys with comprehensive reporting for a human resources consulting firm (Munich)
  • Competition monitoring system for evaluating the technological lead of a telecommunications company (Berlin)
  • Data warehouse for web shop data (Hamburg)
  • System for reporting in market research for a beverage retail company (Berlin)