Asim Manna·Aug 2Ever Wondered How Much Time You Spend on WhatsApp?Ever wondered how much time you actually spend on WhatsApp ?
Asim Manna·Apr 11FRND Product Analyst Interview QuestionThis SQL Question was asked in my product analyst interview.
Asim Manna·Feb 1The Van-Tetris Dilemma: How I Optimized a Quick Commerce Dark Store Using ILPIt’s 11:00 PM on a Friday night at a Quick Commerce Dark Store in Indiranagar. The “Midnight Cravings” rush has just started. A shipment of…
Asim Manna·Jan 12Daily Active Users(DAU)Here is the details of user events. In this table user’s activities are stored.
Asim Manna·Jan 8Guesstimate : Estimate the number of UPI failed orders per day in SwiggyClarifications:
Asim Manna·Dec 27, 2025Comic StripsFor last few days I’m trying something new…. Comics. I am a huge comic lover. As a Bengali in childhood i used to read a lot of comics…
Asim Manna·Dec 25, 2025Guesstimate : Number of Orders Delivered per Day in BigBasketYou are working as a product analyst as Bigbasket. You have to guess number of orders delivered per day.
Asim Manna·Nov 9, 2025Guesstimate: Estimate Sales of Rameswaram Cafe in a WeekRecently i gave interview for business analyst role in the case study round i was asked one guesstimate question.A response icon1A response icon1
Asim Manna·Aug 11, 2025Product Analytics KPIsI’m currently working as a Product Analyst, where one of my key responsibilities is analyzing KPI trends. Among them one of the most…A response icon1A response icon1
Asim Manna·Apr 12, 2025Calculate Watch Time for New and Repeat UsersCurrently I am working on a project in my company. There we are analyzing watchtime KPI. Recently I encountered a question in my analysis.