Reference no: EM133571142

Assignment

Part I: Group Project Report

To show proficiency and understanding of data analytics techniques, student teams will evaluate data using the AMPS model, perform analysis, develop meaningful dashboards, and create a formal presentation demonstrating the process and results to the class.

Each group will be responsible to look for its own case for in-depth analysis. Your team will take on a role, such as the data analyst/auditor/business analyst, hired to provide recommendations to an intended audience, such as the management team of a business/organization, on an accounting, finance, or other business-related issue.

Your report should follow the following framework.

A. Background Overview:

Summarize key facts about the business/organization. Describe key factors that affect the organization's performance as a profit-maximizing entity. If relevant, describe important current events affecting the organization that might give rise to the issue. State the role of your team, your client or audience, and the goal you want to achieve through the project, or the big picture problem you are trying to address. Discuss why addressing this issue is important to your organization. Your group can use the same background but should use your own words to avoid plagiarism.

B. Ask the Question:

Your group should provide the problem statement (main question) to address the issue of your choice. The other sub-questions should be helping you to address the main question. These questions can be "What happened?" "Why it is happening?" "What will happen in the future" "Given what will happen in the future, what should we do now to optimize the performance?"

C. Master the Data:

1. Explain where and how you retrieve the data. You can use public data sources or proprietary data sources.1 Otherwise, submit your original database. Consider data sources discussed in Chapter 2. You only need to describe the data you will use in your analysis.

2. Explain how you have prepared the data

a. Clean it as needed to prepare for analysis
b. Make sure data is loaded completely
c. Make sure data doesn't have missing information

3. Discuss any data quality issues in your dataset

4. Must have calculated fields

5. Transform at least one non-numeric data into numeric data

6. Create at least one additional attribute

D. Perform the Analysis:

1. All 4 types of analytics (descriptive, diagnostic, predictive, and prescriptive).

2. Explain the rationales for each analytics. For example, the reasons for selecting variables as independent variables in the regression.

3. Discuss any unexpected results and the reason for the unexpected results.

4. Discuss the main limitations of your analyses

E. Share the Story:

1. There should be at least 2 graphs/dashboards using Power BI, Tableau or Excel.

2. Concisely describe the recommended course of action and how your analyses provide the main support for your recommendation.

Part II: Group Project Presentation:

Each group will have 18 minutes to present the case and 5 minutes for the Q&A section. The PPT should not be more than 15 slides. Individual presentation skills (such as not reading from notes, eye contacts with the audience, and how well you respond to questions raised by your audience or instructor) will also be assessed.

We will use role play format to do the presentation. Another team will be selected on the day of presentation to be the intended audience, who needs to ask at least 3 meaningful questions during the Q&A section. Students are expected to think from the perspective of the intended audience and ask questions to the presenters. The qualified question(s) will count toward your class participation points for the group.