subject: How should an EDW data model be designed for scalability? [print this page]
A good edw data model should align to business processes and be flexible enough to accommodate future reporting requirements. Before deciding on dimensional, normalized, or hybrid schemas, determine important entities, relationships, measures, and dimensions. Clear business metrics and consistent naming can help avoid anything but clarity between departments. It's also important that the model takes into account the historical data, data quality, security, and query patterns. Don't make the design too complicated. When an organisation requires assistance to map the business requirements into an enterprise data model that can readily be developed, a consulting firm like Datalance can prove valuable.
welcome to Insurances.net (https://www.insurances.net)
