Data Analysis (IT)
<p class="font_8">Task under Dept. of Information Technology, CHEARS</p>
<li><p class="font_8">Time limit for Video - Maximum 5 Minutes</p></li>
<li><p class="font_8">No. of maximum slides in presentations (if any): 15</p></li>
Dear Intern, You need to complete following task within the duration of 1 Month.
Follow instruction given below for data analysis task.
Prepare the PowerPoint presentation for your Analysis.(Optional)
Record the video of presentation with yourself explaining the outcomes.
Submit the video and presentation / Code file (Link will appear on your profile in last week of your internship)
Your video will be uploaded by our official account on the preferred social media of yours ( LinkedIn / Facebook / Instagram ). You will be tagged and the response of your connection and real world people on your presentation will be analyzed. This step is required to get the wide range feedback in real world. It is responsibility of the intern to divert the connection and advice them to put the feedback on your submission.
Evaluation grades - 40 points ( Way of presentation ) ; 40 points ( Quality of work ) ; 20 points ( Social Response ) . Grade will appear on your certificate.
Highest score holder will be declared as Intern of Month (In each domain IT / Public Health/ Public Relations).
Data Analysis: Dataset link
Get Data - Click Here
Analyze the data by any analytical tools / language / IDE ( like excel , SPSS , python etc. )
ID: Customer's unique identifier
Year_Birth: Customer's birth year
Education: Customer's education level
Marital_Status: Customer's marital status
Income: Customer's yearly household income
Kidhome: Number of children in customer's household
Teenhome: Number of teenagers in customer's household
Dt_Customer: Date of customer's enrollment with the company
Recency: Number of days since customer's last purchase
Complain: 1 if the customer complained in the last 2 years, 0 otherwise
MntWines: Amount spent on wine in last 2 years
MntFruits: Amount spent on fruits in last 2 years
MntMeatProducts: Amount spent on meat in last 2 years
MntFishProducts: Amount spent on fish in last 2 years
MntSweetProducts: Amount spent on sweets in last 2 years
MntGoldProds: Amount spent on gold in last 2 years
NumDealsPurchases: Number of purchases made with a discount
AcceptedCmp1: 1 if customer accepted the offer in the 1st campaign, 0 otherwise
AcceptedCmp2: 1 if customer accepted the offer in the 2nd campaign, 0 otherwise
AcceptedCmp3: 1 if customer accepted the offer in the 3rd campaign, 0 otherwise
AcceptedCmp4: 1 if customer accepted the offer in the 4th campaign, 0 otherwise
AcceptedCmp5: 1 if customer accepted the offer in the 5th campaign, 0 otherwise
Response: 1 if customer accepted the offer in the last campaign, 0 otherwise
NumWebPurchases: Number of purchases made through the company’s website
NumCatalogPurchases: Number of purchases made using a catalogue
NumStorePurchases: Number of purchases made directly in stores
NumWebVisitsMonth: Number of visits to company’s website in the last month
First slide should have following format :
Department of Information Technology