Business Intelligence

We have been developing business intelligence (BI) solutions with data warehousing, reporting components and data integration since 2005. During this time we have developed reporting solutions for banks and insurance companies, for administration and of course for companies. Databases are MS SQL Server, Oracle and Snowflake. Reporting systems are MS Power BI or Altova Stylevision and R/Shiny. In the cloud we use MS Azure and MS Fabric.

Reporting

Reporting systems with

  • MS Power BI und MS Azure
  • R / Shiny
  • Altova StyleVision (Server)
  • SSRS (SQL Server Reporting Services)

Data Warehousing

Data Warehousing and database development with

  • MS SQL Server, T-SQL
  • MS Azure Synapse Analytics
  • MS Fabric
  • Oracle DB, PL/SQL

Data Integration

Data integration with

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

Data Science

Statistical analysis and development with

  • R and Python
  • MS Azure Data Analytics
  • Minitab
  • IBM SPSS Statistics

References

We have been developing data warehouse solutions and business intelligence since 2005.

Data warehouse for the analysis and forecast of tax data (income and expenditure) with MS SQL Server, SSAS and SSRS
Federal authority, Berlin

Reporting for structured financial products with Oracle, PL/SQL and XML
Bank, Zurich

Reporting solution for real estate sales and commissions with MS SQL Server, SSAS, SSIS and MS Power BI
Real estate company, Munich

Generation of individual confirmations and documents for customers. General customer correspondence with advertising messages or other information
Insurance company, Vienna