Case Study 1:
Domain: Telecom
Statement: LifeTel Telecom is the latest entrant in the
highly competitive Telecom market of Singapore. It issues SIM to the
verified users. Till now verification was manual through the photocopy of
the approved id card document. However, the government has recently introduced
Social ID called Reference ID which is mapped to fingerprint of the user.
LifeTel should now verify user against the
fingerprint and Reference ID
Case Study 2:
Domain: Marketing
Statement: Bank of Portugal runs a marketing campaign to
offer loans to clients. Loan is offered to only clients with particular
professions.
List of successful campaigns (with client
data) is given in attached dataset.
You have to come up with a program which reads
the file and builds a set of unique profession list and given, input profession
of client – system tells whether the client is eligible to be approached for
marketing campaign.
Case Study 3:
Domain: E-Commerce
Statement: GoodsKart—largest e-commerce company in
Indonesia with revenue of $2B+ acquired another ecommerce company
FairDeal. FairDeal has its own IT system to maintain records of 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
Statement: You are a data analyst with University of
California, USA
University has data of Math, Physics and Data
Structure score of sophomore students. This data is stored in different
files.
University has hired a data science company to
do 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 have to do data
wrangling.
Case Study 5:
Domain: Retail
Statement: BigMart is one of the biggest retailer in
Europe and has operations across multiple countries.
You are a data analyst in IT team of BigMart.
Invoice and SKU wise Sales Data for Year 2011 is shared with you. You need to
be prepared meaningful charts to show case the various sales trends for 2011 to
top management.
Case Study 6:
Domain: Human Resource
Statement: SFO Public Department - referred to as SFO has
captured all the salary data of its employees from year 2011-2014. Now we
are in year 2015 and the organization is facing some financial crisis. As a
first step HR wants to rationalize employee cost to save payroll budget.
You have to do data manipulation and analysis
on the salary data to answer specific questions for cost savings.
Case Study 7:
Domain: Government
Statement: You are a data analyst in SanFrancisco(SFO)
City IT Department. SFO Police has shared crime data for year 2016.
Data contains various incidents which have happened throughout the year, along
with the geolocation of the crime.
You need to prepare effective webmaps to
analyze and present the data. SFO Commissioner of Police will reassign
the forces based on the density of various crime.
