Calculations using R and Excel.
OPIM 390 Introduction to Business Analytics
Term Project – Spring 2018
Opimbank, Inc. is a commercial bank in Turkey that offers many banking products and services, such as time-deposit accounts, various credit cards, personal loans, mortgages, etc. Recently, the bank is interested in analyzing its customers’ spending patterns based on its credit card transaction database. Based on this database, the bank not only knows when, where and how much a customer spends, but it also knows certain demographics of the customer, which may contribute to understanding the customer’s spending pattern and preferences. The bank wants to analyze this dataset and use the results of this analysis in estimating the likelihood of customers’ spending money where and how, which can then be used to predict customers’ responses to campaigns and promotions.
As an analyst employed at Opimbank, your main job is to analyze the database, which consists of customer information and the matching transaction records, and come up with descriptive statistics as well as predictive results. Because you have taken an introductory course on Business Analytics, you have knowledge of tools and techniques that you can use for this purpose. You have already acquired a dataset from the bank’s datamart and you are now ready to use your analytics skills.
Generally speaking, there are two main tasks you would like to perform on the available dataset. First, you would like to understand the nature of this dataset by creating a variety of descriptive statistics and visualizations. You would like to find answers to questions such as:
You are given a detailed dataset that includes the following layers, which will help you seek answers to the questions above:
The two tables of business data are provided to you in a single Excel file, which contains the worksheets listed below.
customers: all customers in the analysis and their demographic attributes.
transactions: details of every purchase transaction made by the customers in the customers table, including the merchant XY coordinates.
Note that the data is rather extensive in number of records; should you choose, you have the liberty to sample the data and use appropriate subsets, without sacrificing the quality of analysis. If you do this, you must explain your sampling method in your project report as well.
Format, Submission and Grading
Prepare your responses and a final report as if you are presenting it to the senior management of Opimbank, Inc.
. Submit your report and all accompanying documents via SUCourse. No extensions will be allowed due to tight course grading deadlines. Every team member is also required to individually complete and submit the Peer Evaluation Form, which is attached to this project document on web .
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more