If you're developing a new application using relational database, SMH Systems can provide a full programme of data analysis, data modelling and database design. These now-classic methodologies are must-do best practice for all major database-related initiatives.
Even if your business applications and databases are well established, the disciplines are still relevant. One of the stock approaches to get more business value out of data acquired by the business applications is to develop a "reporting database" or "data warehouse", specifically established and designed for aggregation, reporting and analysis. For this approach we can:
If new queries and access strategies are to be used on existing application databases in order to mine the data, two factors that can cause real problems are denormalisation, and null values. These can often lead to unexpected or misleading results. By combining the classic techniques for Data Analysis/Modelling and Database Design with our Data Content and Quality Review service, SMH Systems can help you to: