Doubts regarding Project 2 (Instagram User Analytics)
Hi, I have the following doubts regarding project 2 (Instagram User Analysis) 1. Do I have to get the answers by only writing SQL queries or I can use mix of sql and pandas function in python? 2. In the question: Declaring Contest Winner: The team started a contest and the user who gets the most likes on a single photo will win the contest now they wish to declare the winner. Your Task: Identify the winner of the contest and provide their details to the team Q: Do I have to find the user whose photo has the most like? Also what details are expected from us about the user? 3. In the question: Launch AD Campaign: The team wants to know, which day would be the best day to launch ADs. Your Task: What day of the week do most users register on? Provide insights on when to schedule an ad campaign. Q: What kind of insights on when to schedule an ad campaign is expected from us? 4. In the question: User Engagement: Are users still as active and post on Instagram or they are making fewer posts Your Task: Provide how many times does average user posts on Instagram. Also, provide the total number of photos on Instagram/total number of users Q: Your Task: Provide how many times does average user posts on Instagram. Here do I need to include the users who haven't posted anything as well for find the average users number of posts? 5. Are we expected to provide any graphs as well as mentioned in the example section of Insights?
