Database and data model design are arguably the most important steps in the creation of a data warehouse and business intelligence application. Performance, scalability, ease of use, intuitiveness, administration, and maintenance can all be adversely affected by a less than optimal database and data model design. Lunexa consultants have years of experience designing data models from scratch to meet the functional and non-functional requirements of applications. In other cases, our consultants are brought in to work with data architects and DBAs, to provide advisory services related to the impact of data model design on the business intelligence or ETL layers of the solution.

Lunexa consultants are unique in their experience with designing both transactional and analytical environments. This is becoming more and more important as the lines between different systems are becoming blurred. Business users want to derive more insight directly from transactional systems, while analytical systems or data warehouses are being used for more operational reporting. In this environment, our Consultants' experience with both transactional and analytical systems, and all different types of schema design – third normal, star, snowflake, hybrid etc. – are invaluable.

Most importantly, Lunexa consultants understand that database and data model designs cannot be created in a vacuum. Designers must work hand-in-hand with the business community, the developers, and the administrators to ensure that all perspectives are taken into account when designing the database.