Interview Questions

Krutarth S. - "Hi, is this question part of the Powerday interview or the Mini-case interview?"See full answer

Dhruv M. - "During my internship at Inspira Analytics, our intern team had worked for two weeks on a client presentation for a new data dashboard. Unfortunately, during the final review, the manager pointed out several major flaws in our analysis and asked us to redo the entire structure. The feedback was blunt, and the team felt discouraged, questioning whether our efforts were even valued. As the informal team lead, I felt responsible for helping lift the team’s morale and refocus everyone so we could del"See full answer

Varun A. - "Quickbooks: understand the product and its users. QuickBooks is an accounting software package developed by Intuit that centralizes financial management for small and medium-sized businesses (SMBs). It is designed to replace manual spreadsheets and disconnected apps by consolidating income tracking, expense management, payroll, and tax compliance into a single system Who uses it and why? Small and medium businesses for consolidating income tracking, expense management, payroll, an"See full answer

Ankit J. - "The goal is to determine which shows get promoted to the home screen i.e the screen the user sees after launching Netflix. There are two ways to promote shows today; Editorially - the editorial team selects the categories and shows to be shown to the users Algorithmically - based on the historical views and contextual information such as location, time of the year, age, etc the recommendation algorithm determines a list of shows to show on the screen. The higher level goal for Netflix is o"See full answer

Alina G. - "SELECT upsellcampaignid, COUNT(DISTINCT trans.userid) AS eligibleusers FROM campaign JOIN "transaction" AS trans ON transactiondate BETWEEN datestart AND date_end JOIN user ON trans.userid = user.userid WHERE iseligibleforupsellcampaign = 1 GROUP BY upsellcampaignid `"See full answer

Anonymous Unicorn - "Count items between indices within compartments compartments are delineated by by: '|' items are identified by: '*' input_inventory = "*||||" inputstartidxs = [1, 4, 6] inputendidxs = [9, 5, 8] expected_output = [3, 0, 1] Explanation: "*||||" 0123456789... indices ++ + # within compartments ^ start_idx = 1 ^ end_idx = 9 -- - # within idxs but not within compartments "*||||" 0123456789... indices "See full answer

Farza S. - "It is the smallest level of significance at which the null hypothesis gets rejected"See full answer

Anna H. - "Clarifying questions: How to define “price” in this interview question? Price is defined as the market value of a crypto asset (bitcoin, Ethereum, tether, BNB etc.). Due to the characteristic of crypto assets which is time-sensitive, is this designed for a particular period of time? 1H, 1D, 1W, 1M, 1Y? No Do we know the target customer segment given geographic location or demographic? Not specific. Is it designed across devices? Mobile app. Assumptions: There are 03 cu"See full answer

Miguel C. - "Missing launch. Only design is covered."See full answer

Anubhav A. - "Started at 10.55 Clarifying questions: This is what I understand from a telemedicine platform -> A platform where users can get advice on medication over the telephone, is this correct? Does the retail company also sell medicines? Is the user aware that the telemedicine platform and the retail company are connected, and can either of the platforms use his data? Is the user engaging with the platform directly, or is there an agent to who he is speaking to via call/text? Does the"See full answer

Derrick M. - "SELECT o.order_amount FROM orders o JOIN departments d ON d.departmentid = o.departmentid WHERE d.department_name = 'Fashion' ORDER BY order_amount DESC LIMIT 1 OFFSET 1; `"See full answer