Case Study Scenario
Your hypothetical employer, Park University, continues to be very pleased with your feedback and documentation on initial modeling efforts to support the new and coming payroll database. In fact, the University is very excited and pleased and is looking forward to the implementation of the database designed and proposed.
Going further into ideas and the implementation of this payroll database, Park University beyond payroll employee report stubs and other various payroll tracking reports wants other types of potential queries to support output of reports supporting statistical analysis or payroll analytics by offering suggestions based on the questions below:
Knowing that Microsoft Access or your recommended SQL-driven database will be used for the payroll database, and that use of queries and calculations could support statistical analysis, what would be the purpose of having queries to support reports for payroll analytics? Defend responses in scholarly detail!!
Based on the purpose and desired outcomes of payroll analytics, what types of queries and output would you envision in this case are needed and could this output also support business intelligence needs of university leadership to make decisions associated with cost controls? Defend responses in scholarly detail!!
Would analytical, cloud and non-relational database alternatives need to be used to further support these payroll analytic needs? Defend responses in scholarly detail!!
Would a secondary application like Microsoft Excel need to be used to further support these payroll analytic needs? Defend responses in scholarly detail!!
Finally, should there be some type of documented plan of action in place if in case the implemented payroll analytics queries and reports determine negative outcomes like fraud, waste, and abuse and what types of decisions would be made in this case? Defend responses in scholarly detail!!
Include any other important conclusions or content you see fit to support this assignment.
Leave a Reply