Question 1
You are to analyze a dataset Customer.xlsx to answer the following questions. The provided
dataset contains details of information on customers of a commercial bank. Details of all data
fields are in the tab of Description.
(a) Identify one (1) business problem that can be addressed by analyzing the data. Your description should provide a clear understanding of what data fields are relevant and how
the data fields can be used to address the business problem. Create an influence chart
pertinent to the problem. (Up to 200 words for part (a))
(15 marks)
(b) Create a summary of the dataset in tabular format. It should identify the data type of each
data field, the key attributes and summary measures and data issues if applicable. (Up to
200 words for part (b))
(15 marks)
(c) Employ visualization techniques and create one (1) dashboard that includes at least three
professional graphical charts that provide helpful information about the dataset. Produce
the charts and the dashboard using Power BI. Provide a screenshot of each produced chart
and the dashboard. Use up to 250 words to explain how the chart and dashboard are
produced and how the dashboard generates and communicates the insights.
(35 marks)
(d) Develop a proposal of a business analytics solution to address the problem identified in
part a). It should contain the discussion of the appropriateness of at least one (1) business
analytics technique to use (e.g., types of spreadsheet analysis, clustering, association
analysis, predictive or prescriptive) and explain how various steps of the business
analytics process (except for the stages of business understanding, searching for
information, define a problem) are applied in this business analytics initiative. (Use up
to 250 words for your answer)
(20 marks)
Question 2
You are to analyze a spreadsheet model in Capacity.xlsx which is used by Company A to plan
the proper capacity level for a new product. The company aims to maximize the expected net
present value generated from the new product over the next 15 years. The discount rate is
assumed as 10% per year. The unit cost of building capacity (400,000 units) to produce the
new product is $10 per year. The unit maintenance cost is $1 per year. Assuming all
construction costs are paid at year 0, the first profits come in at the end of the first year. In year
1, we know demand will be for 160,000 units of the product. The annual percentage growth of
demand for the product is 15%. During year 1, each unit of the product sells for $8. The price
of the product will grow at 5% per year. Unit variable cost is known to be 40% of sales price.
The depreciation rate is 10% and the tax rate is 30%.
(a) Your task in this question is to analyze the spreadsheet model built for you and identify
all the bugs. (Note: a “bug” here refers to an error that causes the spreadsheet to return
ANL203 Copyright © 2022 Singapore University of Social Sciences (SUSS) Page 5 of 5
ECA – January Semester 2022
the wrong value of the output, not a poor choice of layout or format or other poor
practices. A bug can involve an error in the data or an error in a formula.) You may
assume that the accounting in the model is conceptually correct. Present your findings in
tabular format.
Bug Cell Location Fix
… … …
(15 marks
Do you need help with this assignment or any other? We got you! Place your order and leave the rest to our experts.