上QQ阅读APP看书，第一时间看更新
Project ingestion questions
Several topics and specific questions are so common that a standard "project ingestion" form or document can be created to support design and planning meetings. These topics and questions include the following:
Data Sources: Is all the data required in system X? What other sources are required or currently used?
Security: Will the data model contain PCII or sensitive data? Does any data need to be secured from certain users?
Version Control: Are there existing reports or models with the same measures?
Complexity: Can the source data be used directly or are transformations required?
Analytics: Are any custom or advanced analytics required (for example, exception measures, statistical analyses)?
Data Refresh: Is there a need for real-time access? If not, how frequently does the data need to be refreshed?
Model Scale: How much historical data is required? How many rows per week/month/year are in the largest fact table?
Distribution: Approximately how many users will need to access the reports and dashboards this model will support?
Security: Will the data model contain PCII or sensitive data? Does any data need to be secured from certain users?
Version Control: Are there existing reports or models with the same measures?
Complexity: Can the source data be used directly or are transformations required?
Analytics: Are any custom or advanced analytics required (for example, exception measures, statistical analyses)?
Data Refresh: Is there a need for real-time access? If not, how frequently does the data need to be refreshed?
Model Scale: How much historical data is required? How many rows per week/month/year are in the largest fact table?
Distribution: Approximately how many users will need to access the reports and dashboards this model will support?