It’s a group assignment, in which we have to apply- the BI implementation plan by considering the BI requirements, architectural framework, data modelling, and BI design in real world hospital.The...

It’s a group assignment, in which we have to apply- the BI implementation plan by considering the BI requirements, architectural framework, data modelling, and BI design in real world hospital.The part is - Dimensional modelling that should include fact tables, star schema, snow flake schema, dimension hierarchy, slowly changing dimensions and other possible things (diagram should include hospital, department, staff, patient, diagnosis, procedure etc.) - Diagram presented considers all aspects of the requirement - Detailed explanation of what the diagram is showing Other requirements to be consider- • Financial challenges and hospital productivity • Maintaining patient safety • Regulatory standards and emerging energy mandates • Hospital security • Patient satisfaction