For
this project, think of a situation in business/organization or in your personal
life where you can apply the analysis and tools we learned throughout the
semester to improve or automate decision-making. You can use
functions, pivot table, macros, as well as things beyond what you leaned in the
class.

The
goal is that application of these tools can help the business/organization to
run more efficiently or effectively. There are two general directions you can
take to achieve this goal:

·     
extract insights from data to help firm improve their operations
or make better decisions,

·     
automate certain operations so that it is easier for users/decision-makers
to search and access information or insights.

You
can pick one of them or do a hybrid of both.

Submission

Your
final submission should include an Excel file with your data and
analysis and a recorded presentation with slides that explain: 1. The
scenario 2. How your analysis/automation help with the business/organization. 

I
am grading your project mainly based on two aspects.

·     
The technical aspect: whether the tools you use is appropriate
for the analysis and the sophistication level of the tools

·     
The business aspect: whether you are solving a meaningful
problem (to aswer the “so what” question)