Reference no: EM133569142
Assignment: 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. A thorough individual report is required. The report should not be more than eight pages (excluding cover page, tables, graphs, appendix and references, if any), typed, double spaced, 10 to 12 pitch with one-inch margins.
Your report should follow the following framework.
I. 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.
II. 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?"
III. 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
IV. 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
V. 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.