Title Technical Test Materials - Astra Data Intelligence Internship Program 2024B.pdf ✅

CONFIDENTIAL Technical Test Materials Data Intelligence Internship Program
CONFIDENTIAL Instructions There are 3 section of test; general test, programming test, and capstone project idea. Candidates must submit their answers maximum 24 hours after fill registration form. Please read instruction carefully for each section. General Test Candidates will be given several essay questions then asked to create slides to answer those questions. Programming Test Candidates will be given several programming questions in Python then submit their code. Capstone Project Idea Candidates asked to ideate capstone project case related to data-field. Submission Form: bit.ly/ADIIP24B_Submission
CONFIDENTIAL General Test Instructions Submit your answers as slides in PDF format called full_name-general.pdf with maximum 4 slides without title slide (make sure its exactly same with full name you submit at registration form) Questions Astra, known as one of the largest diversified conglomerates in Indonesia, have multiple vertical and businesses. As part of the data team that manage analytics collaboration within 230 companies under Astra Group, you need to support a certain car selling business unit by enabling their analytical capabilities to increase the revenue of the company. One line question from management is "We need to increase our revenue; however, we are having difficulties to monitor and track our business metrics performance. How can you support us with our current needs?" 1. Please write down the steps that you will do to answer the question from management. 2. What factors could possibly increase the revenue of this car selling company? 3. Explain: 1. Any possible approach 2. Possible solution architecture 3. Reason to choose those approaches 4. Any data needs and their reasons 4. Assume the project has run smoothly and delivered successfully, management now asks: How can you ensure that the analytics output generates good revenue and has a significant impact on the business?
CONFIDENTIAL Programming Test Instructions 1. Access and make a copy of this notebook: https://colab.research.google.com/drive/1YpAYYx73ZHIJL9kpO437wLduLIaCSB-q?usp=sharing 2. Answer the questions without using any library and do not change any function, parameter, and class name 3. There are several test cases to validate your answer 4. Submit your answer in .py format with file name full_name-python.py (make sure its exactly same with full name you submit at registration form) Questions 1. Create a function where you can pass a list of phone numbers, then return a list of cleaned phone numbers. Valid phone number should start with 62 and must be 11-digits number excluding 62. If after cleansing, there is still an invalid phone number, change it to “Invalid Number”. 2. The marketing team wants to know the effects of two different sales promotion programs: discount and lucky draw prize. For each program, 10 customers were selected. The observed average spending for the first program was $100, while the average spending for the second program was $96. The pooled standard deviation found to be $1.65. Create a function where you can input the number of customers, average spending for the first program, average spending for the second program, pooled standard deviation, and alpha (with a default parameter of 5%) and return the t-statistics. 3. Create a class called Data where you can initialize without any input. It has data attributes to return input data and size attributes to return size of data. Also, it has methods called read_data(data) to read input data, find_total() to return sum of input data, and find_average()to return average of input data.