top of page

Data Analysis (IT)

<p class="font_8">Task under Dept. of Information Technology, CHEARS</p>
<ul class="font_8">
<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.

  1. Follow instruction given below for data analysis task.

  2. Prepare the PowerPoint presentation for your Analysis.(Optional)

  3. Record the video of presentation with yourself explaining the outcomes.

  4. Submit the video and presentation / Code file (Link will appear on your profile in last week of your internship)

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

  6. Evaluation grades - 40 points ( Way of presentation ) ; 40 points ( Quality of work ) ; 20 points ( Social Response ) . Grade will appear on your certificate.

  7. Highest score holder will be declared as Intern of Month (In each domain IT / Public Health/ Public Relations).


Data Analysis: Dataset link

  1. Get Data - Click Here

  2. 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 :


<Your Name>

CHEARS Internship

Department of Information Technology

<Month> <Year>

bottom of page