Your partner in business intelligence and data warehousing projects

Easy-to-use BI Applications

…dashboards, interactive reports,  cubes, mining models.

Use our experience in design of BI applications:
your business users will like them!

Measures, dimensions, hierarchies, calculations
– all them impact usability, navigation & speed!

Help your business customer to specify
how BI application fits to operative or analytical processes!

Take benefits from platform specific features:
Microsoft Analysis Services, XLCubed, Business Objects, Cognos, Oracle BI

Scalable Data Transformation Jobs

Use our skills in design of scalable data transformation tasks

Logical & physical data model, partitioning, processing architecture, parallel execution, job scheduling – all these have impact on performance and scalability!

Take benefits from platform specific features: Oracle database, Oracle Exadata, Teradata, Netezza, Microsoft SQL Server, Microsoft Parallel DW

Achieve efficient collaboration between transformation definition tool (ODI,Informatica,AbInitio,…) and transformation engine / database server

Application Performance Tuning

Make your tuning projects efficient and effective!

Use our tuning methods and skills in database technologies

Avoid try-and-fails in root cause analysis

… especially if rollout of changes is difficult

Our consultants have many years practical experience with various server technologies:

Oracle features for data warehousing (20+ years)

Microsoft Analysis Services (15+ years)

Microsoft SQL Server, Teradata (4-5 years)

BI Consult provides high-quality consulting and development services in business intelligence and data integration projects.

Our latest projects:

Profit and Loss Analysis

solution delivery for

Large international retail bank – Austria

Expertise delivered by BI Consult

  • BI solution design (cube model)
  • BI software architecture
  • Implementation + testing + rollout

Main challenges

  • short data latency (intra-day loading)
  • manual corrections and comments
  • temporary incompleteness of data

Technologies

  • Cubes in Microsoft Analysis Services (MOLAP+ROLAP)
  • On top of Oracle Database Server
  • Accessed by Excel /  Reporting Services / Power BI

Technical Project Review

of new enterprise-wide data warehouse

International finance institute – Austria

Expertise delivered by BI Consult

  • review and coaching best practice on
  • system architecture
  • data model of DWH core
  • datamart structures
  • project/development methodology

Application Performance Tuning

of data transformation jobs in new enterprise-wide data warehouse

Large international retail bank – Austria

Expertise delivered by BI Consult

  • root cause analysis for performance issues
  • shortening of jobs execution times
  • increased HW utilisation
  • improved communication between DBAs and developers

Main challenges

  • simultaneous tenant processing
  • auto-generated ODI scenarios
  • complex SQL statements (determined by ODI mappings)
  • large variance in volatility of master data
  • Oracle database on IBM POwer8 hypervisor

Technologies

  • Oracle Database Server
  • Oracle Data Integrator (ODI)
  • IBM Power8
  • Automic Workflow Automation (AWA)

New Business & Sales Channels Analysis

BI solution delivery for

Group Controlling Department at

Large international retail bank – Austria

Expertise delivered by BI Consult

  • BI solution design (cube model)
  • BI software architecture
  • Implementation, rollout

Main challenges

  • complex BI model
  • complex calculations
  • large data volumes

Technologies

  • Cubes in Microsoft Analysis Services
  • On top of Oracle Database Server
  • Accessed by XLCubed
  • EMC AppSync

Liquidity Risk Analysis

BI solution delivery for

Large international retail bank – Austria

Expertise delivered by BI Consult

  • BI solution design (cube model)
  • BI software architecture
  • Implementation + testing + rollout

Main challenges

  • large data volumes (1+ TB)
  • short data latency (intra-day loading)

Technologies

  • Cubes in Microsoft Analysis Services
  • On top of Oracle Database Server
  • Accessed by Excel

Corporate Performance Management

prototype & solution delivery for

Mobile Telco Provider – Switzerland

Expertise delivered

  • consolidation of business requirements
  • design of BI concept
  • technical architecture design

Main challenges

  • large data volumes (traffic data)
  • high variety of life-cycle-events
  • non-additive measures
  • high expectations on query performance for business users

Technologies

  • Microsoft Analysis Services
  • Teradata Database
  • Microstrategy

Delivery Supervision of data warehouse project

for member of board of directors in technology migration project

National Association of Statutory Health Insurance Physicians  – Germany

Expertise delivered

  • supervision of project’s progress
  • validation of technical decisions
  • validation of implementation deliverables

Main challenges

  • extremely large data sets to process and query
  • scalability & throughput of data processing jobs
  • fixed-price delivery contract of main supplier

Technologies

  • HP NeoView (Nonstop SQL) database

Who is BI Consult?

BI Consult is built up by small team of IT professionals.

We believe that experienced, communicative and reliable people are the key factors to make projects successful.

BI Consult was founded in 2007. Our consultants deliver high-quality expertise to Austrian, Swiss and German customers.

Go to Our team

BI Consult stands for high value added

Technology competence

Deep understanding of technologies
being used in BI and DWH solutions

18+ years practical experience
in at least one database server technology
each consultant

Ability to deliver

Seniority in social skills
shaped in high variety of projects / missions

High commitment
small team of consultants
open and direct culture

Bridge between business and IT

Seniority in communication skills
shaped in 15+ years consulting, training, coaching

Ability to simplify properly
focused on given purpose
using deep-dive understanding
in both business intelligence and IT technology

Small, independent, vendor-neutral

We define our success by trustful long-term relationship with project stakeholders and project delivery team.

BI Consult proves that even a small company can get high market acceptance.

Being small and independent allows us to deliver qualities which large IT providers are not always able to deliver:

  • Vendor-neutral view
  • Focus on project-centric efficiency (instead of vendor’s internal utilization)
  • Strong personal commitment
Check References