Post #2772

60. How do you compute month-on-month or week-on-week growth? 61. How do you write a query to calculate retention / churn? 62. How do you calculate LTV (lifetime value) conceptually? 63. How do you write a funnel analysis query (e.g., sign-up → activation → purchase)? 64. How do you handle time-based aggregations (daily, weekly, monthly)? 65. How do you compare cohorts (e.g., users by month of acquisition)? 66. How do you calculate lead-time, cycle-time, or other business-process metrics? 67. How do you implement A/B test-style analysis in SQL? 68. How do you approximate segmentation (RFM-style) in SQL? 69. How do you document and version your SQL queries? 🧠 Behavioral Business-Sense Questions 70. Walk me through a real-world analysis you did end-to-end. 71. Tell me about a time you presented insights to a non-technical audience. 72. Tell me about a time your analysis changed a decision or strategy. 73. Tell me about a time you found a data quality issue and how you fixed it. 74. How do you translate a vague business question into a concrete analysis? 75. How do you handle conflicting priorities from stakeholders? 76. How do you collaborate with product, marketing, and engineering teams? 77. How do you validate your analysis before sharing it? 78. How do you explain statistical or technical concepts in simple language? 79. How do you stay updated with data-analysis trends and tools? 📊 Real-World Case-Study / Scenario-Style Questions 80. Design an analysis to track product usage or feature adoption. 81. Design an analysis to evaluate marketing campaign performance. 82. Design a churn / retention dashboard for a SaaS product. 83. Design a sales-performance report for a regional team. 84. Design a customer-segmentation analysis (e.g., high-value vs low-value). 85. How would you analyze a sudden drop in website traffic or orders? 86. How would you analyze a pricing change or discount test? 87. How would you analyze customer support ticket volume and trends? 88. How would you design a simple A/B test and its success metrics? 89. How would you explain results and next steps to a manager? 🧠 Tooling, Processes Best Practices 90. What tools do you use most often as a data analyst? 91. How do you version your code and SQL (e.g., Git, folder structure)? 92. How do you document queries, dashboards, and assumptions? 93. How do you handle data privacy and PII in your analyses? 94. How do you manage permissions and access to dashboards? 95. How do you automate repetitive reports (scheduled exports, SQL jobs, etc.)? 96. How do you handle ad-hoc vs recurring analyses? 97. How do you get feedback on your dashboards and improve them? 98. What are your top 5 productivity shortcuts / habits as a data analyst? 99. What skills do you want to improve most in the next 6–12 months? 🚀Double Tap ♥️ For Detailed Answers