Python Programming Certification Training in Oxford

Case Study #1:

Domain: Banking

Problem Statement: FinBank is the latest entrant in the banking market of Thailand. For opening a bank account, verification was manual through the photocopy of the approved id card document till now. However, they have recently introduced a system where the customers’ fingerprint will be mapped with the newly introduced Unique Id for citizens of Thailand by the government of Thailand. FinBank should now verify customers against the fingerprint and Unique Id.

Case Study #2:

Domain: Marketing

Problem Statement: Bank of Portugal runs a marketing campaign to offer loans to clients. The loan is offered to only clients with professions. A list of successful campaigns (with client data) is given in the attached dataset. You must come up with a program which reads the file and builds a set of unique profession list and when the profession data of the client is fed, the system must be able to tell whether the client in question is eligible for the loan.

Case Study #3:

Domain: E-Commerce

Problem Statement: GoodsKart—largest e-commerce company in Indonesia with a revenue of $2B+ acquired another e-commerce company FairDeal. FairDeal has its own IT system to maintain records of a customer, sales, etc. For ease of maintenance and cost savings, GoodsKart is integrating customer databases of both the organizations; hence customer data of FairDeal has to be converted in GoodsKart Customer Format.

Case Study #4:

Domain: Education

Problem Statement: You are a data analyst with University of California,? USA University has data of Maths, Physics and Data Structure score of sophomore students. This data is stored in different files. University has hired a data science company to do an analysis of scores and find if there is any correlation of score with age, ethnicity, etc. Before the data is given to the company, you are required to do data wrangling.

Case Study #5:

Domain: Retail

Problem Statement: BigMart is one of the biggest retailers in Europe and has operations across multiple countries. You are a data analyst in the IT team of BigMart. Invoice and SKU wise Sales Data for the Year 2011 is shared with you. It would help if you prepared meaningful charts to showcase the various sales trends for 2011 to top management.

Python Project:

Domain: 911 Calls

Problem Statement:For this capstone project, we will be analyzing 911 call data from Kaggle. This data is from Montgomery County in the Pennsylvania State of USA. 911 is the most important social security feature in the USA. Citizens can call on 911 in case of any emergencies such as crime, medical, traffic, fire, etc. As a data analyst, you must analyze and visualize the data and answer the question in the section.