Reference no: EM133052027

Your brother Bob has his own building company, Constructed Homes, which specialises in new builds as well as renovations to existing houses. Bob's role as Project Manager is to oversee the timing of supplies to multiple building projects simultaneously, whilst ensuring trade workers are available, to keep construction running as per contractual timelines with his customers. His company will lose money on each job that is significantly overdue. Bob is finding managing the builds particularly difficult brought about by a combination of shortages of building supplies due to global shipping issues, and renovations becoming extremely popular due to people watching home renovation shows during the COVID-19 lockdowns. You would like to use your skills as a BI expert to help your brother. In particular you want to give Bob insight into what the predicted levels of building demand and building materials supply will be in 2022, so he can sign building contracts for the number of jobs he will be able to successfully deliver on time. Given Bob is the Project Manager all insights will need to be at the tactical level of decision-making.

A1. What is the Priority?

A2. Name two ways Business Analytics can help Bob achieve this priority.

A3. Write one intermediate descriptive question and one overall predictive question a dashboard supporting this priority should be able to answer.

A4. List two potential issues with making the data Reliable in this case study.

A5. List one external data item you could use for this case study and indicate whether this item would be structured or unstructured.

A6. List two possible metrics that could be included in a dashboard for this
case study.

A7. Write one performance indicator that would tell Bob whether the priority is being addressed halfway through the next 6-month period.