Design Review

Poor performance, inability to derive important information, scalability limitations, and outright application failure are too often caused by non-optimal database designs implemented by Analysis Services novices.

We can evaluate your relational data mart and Analysis Services database to ensure that the designs make technical sense, and are suited to the business requirement.

We will convey best practices for design and implementation of: 

  • star/snowflake schemas
  • dimension design
  • cube design
  • aggregation design
  • MDX scripting