Analytics for Decision-Making

  1. 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.

Quality Guaranteed

Any Deadline

No Plagiarism