Business Analytics

MGMT 665: Business Analytics

• The purpose of this project is to apply business analytics techniques (descriptive, predictive, prescriptive) on data in spreadsheet, and demonstrate results that add business value.
• You can do the project as a group of 3-4 people, or you can do it individually.
• Select a Dataset (from your work), or from the internet (open dataset) that you would like to perform the analytics on it. When selecting the data, try to think about the business values that can be generated by applying analytics to this data. Remember, the business value-driven is the best orientation for applying analytics. If you find the business value, then you can confidently select this data.
• The dataset should be in stored in Excel file, and include at least 400 records (rows)
• You can use google dataset search (link below) to help you searching for dataset on the internet
https://datasetsearch.research.google.com/

Elements of the project report
Section 1: Introduction (1 page)
• The introduction section should cover the following points:
o What is the topic of the data (for example, Sale, Energy, World cities, etc.)
o What is the domain of the data (for example, Finance, HR, Marketing, etc.)
o What is the business value that you would like to generate.
o What kind of business decisions that will be supported
Section 2: Information management (0.5 page) (optional)
• If some parts of your dataset requires to do some transformation (for example, standardization of some data like currency, or date), explain what transformation that you did
Section 3: Descriptive analytics technique (2 – 4 pages)
• This section should cover the following points:
o What type of the descriptive analytics techniques that will help you to understand your data. You can include more than one technique if needed
o For each descriptive analytics technique:
 Explain the reason why this technique is used
 Present the result (graph or table) that is generated from this technique
 Briefly explain the results

Section 4: Predictive analytics technique (2 – 4 pages)
• If the predictive technique is required in your case to generate the business value, then this section should cover the following points:
o What type of the predictive analytics techniques that will help you to get insight from your data. You can include more than one technique if needed.
o For each predictive analytics technique (that are required for your case):
 Explain the reason why this technique is used
 Present the result (graph or table) that is generated from this technique
 Briefly explain the results

• If the predicative technique is not required in your case, identify some scenarios (1 to 2) where you can apply predictive technique in your data. For each of the identified scenario:
 Explain the scenario
 Present the result (graph or table) that is generated from this technique
 Briefly explain the results

Section 4: Prescriptive analytics technique (2 – 4 pages)
• If the prescriptive analytics technique is required for your case, then This section should cover the following points:
o What type of the prescriptive analytics techniques that can precisely support the business decision (that you identified in Section 1 – in the last point). Only one technique will be enough. Once selected a prescriptive technique:

 Explain the reason why this technique is used
 Present the results that is generated from this technique
 Briefly explain the results

• If the prescriptive technique is not required in your case, identify one scenario where you can apply prescriptive in your data (optional). If you can identify a scenario, then:
 Explain the scenario
 Present the results that is generated from this technique
 Briefly explain the results

Good luck