Codebasics Resume Project Challenge

AtliQ Media is a private media company and they wanted to telecast a show on Lok Sabha elections 2024 in India. Unlike other channels they do not want to have a debate on who is going to win this election, they rather wanted to present insights from 2014 and 2019 elections without any bias and discuss less explored themes like voter turnout percentage in India.  Peter is a data analyst in the company, and he is handed over this task of generating meaningful insights from data. Since this is a sensitive topic, he seeked help from his manager Tony Sharma who provided the list of primary and secondary questions.

Task: 

Imagine yourself as Peter Pandey and perform the following tasks. 

1. Begin your analysis by referring to the ‘primary_and_secondary_questions.pdf’. You can use any tool of your choice (Python, SQL, PowerBI, Tableau, Excel, PowerPoint) to analyze and answer these questions. More instructions are provided in this document. 
2. You can use additional data based on your own research to support your recommendations and provide more insights. 
3. Be creative with your presentation, audio/video presentation will have more weightage. You will be presenting these insights to the chief editor Bruce Haryali – he appreciates good storytelling and concise presentation. 

Other resources Provided: 

• Dataset required to answer preliminary analysis questions. 
• Metadata 
• Supporting documents 

Note: 

• We recommend you create a video presentation of ideally 15 minutes or less to keep it engaging for business stakeholders and get more points for your work. Additionally, make a LinkedIn post that includes relevant links, your video presentation, and a reflection on your experience while working on this challenge. 
• You can check out this example presentation to gain some inspiration: Sample Presentation Link 
• Please see this detailed evaluation criteria which is provided in the document “evaluation criteria”. 
• After completing your LinkedIn post, please submit the link in the input box provided below. 

Credits: The dataset is taken from the Election Commission of India. Thanks to the ECI for providing datasets for public access which is a great learning asset - feel free to explore them here. (https://www.eci.gov.in/statistical-reports).  

Download Problem Files