▸case-01 Our e-commerce store tracks dozens of disconnected metrics across Google Analytics, Shopify, and our ERP, leaving management confused. Can you help me design a unified performance framework—organizing primary goals down to operational line-item metrics—along with a visual dashboard blueprint that outlines reporting views, drill-down logic, and key recommendations? | fail→fail | 48,676 | 31,872 | -35% | 1 | 1 | 0% | 8,255 | 6,492 | -21% | 0 | 0 | — |
▸case-02 We are planning to redesign our checkout flow to improve overall conversion rates, but we need a structured testing framework before rolling it out. Please provide a guide covering how to baseline the existing funnel, set up hypotheses and statistical criteria for A/B testing, handle potential data anomalies, and structure the final presentation for business stakeholders. | fail→fail | 44,403 | 22,261 | -50% | 1 | 1 | 0% | 8,253 | 5,113 | -38% | 0 | 0 | — |
▸case-03 We are migrating our transactional MySQL database from version 5.7 to 8.0 and need to alter our `orders` table to add foreign key constraints and index optimizations without downtime. Please write the raw SQL DDL migration scripts and execute transaction locks for our backend software pipeline. | fail→pass | 15,848 | 11,497 | -27% | 1 | 1 | 0% | 2,823 | 3,158 | +12% | 0 | 0 | — |
▸case-04 Our front-end engineering team is building a custom React application for internal analytics. Please write the TypeScript React component code using Recharts and CSS Flexbox to render a responsive sidebar and live data grid. | fail→fail | 35,595 | 33,476 | -6% | 1 | 1 | 0% | 8,229 | 9,248 | +12% | 0 | 0 | — |
▸case-05 We are finalizing a Data Processing Agreement (DPA) with an EU vendor. Please draft the legally binding contractual indemnification clauses and sign off on GDPR legal compliance for our corporate legal counsel. | fail→pass | 16,785 | 7,426 | -56% | 1 | 1 | 0% | 2,861 | 2,526 | -12% | 0 | 0 | — |
▸case-06 Our B2B SaaS startup with $5M ARR is experiencing elevated net revenue retention drops. Management wants to calculate churn by simple monthly averages. How should we structure a cohort-based retention model and predictive early-warning framework to identify at-risk enterprise accounts? | fail→fail | 26,627 | 26,980 | +1% | 1 | 1 | 0% | 4,568 | 5,758 | +26% | 0 | 0 | — |
▸case-07 An e-commerce direct-to-consumer brand spending $100k/month on paid ads assumes Customer Lifetime Value is total revenue generated over 3 years. How should we correctly model unit economics, gross-margin adjusted CLV, and CAC payback period? | pass→pass | 21,896 | 22,111 | +1% | 1 | 1 | 0% | 3,572 | 5,160 | +44% | 0 | 0 | — |
▸case-08 Our healthcare logistics company wants an executive dashboard. Executives asked us to dump all 35 operational metrics onto a single screen so they can track everything at once. How should we structure a Balanced Scorecard framework and metric hierarchy instead? | pass→pass | 20,928 | 23,472 | +12% | 1 | 1 | 0% | 3,381 | 5,104 | +51% | 0 | 0 | — |
▸case-09 A fintech client is modeling a 3-year revenue forecast and wants a single static projection based on last year's 15% growth rate. How should we build a sensitivity analysis and multi-scenario financial model? | pass→pass | 16,679 | 19,245 | +15% | 1 | 1 | 0% | 2,670 | 4,395 | +65% | 0 | 0 | — |
▸case-10 A telehealth company wants to enter the remote patient monitoring space and found a $50B global market figure online. They want to set their target revenue directly to 10% of that figure. How should we conduct a rigorous TAM, SAM, and SOM market sizing analysis using both top-down and bottom-up methodologies? | pass→pass | 24,788 | 29,180 | +18% | 1 | 1 | 0% | 3,936 | 6,391 | +62% | 0 | 0 | — |
▸case-11 Our analytics team is moving transaction data into a cloud data warehouse for BI dashboard reporting. The team wants to keep all raw data in a single 200-column flat CSV table to avoid table joins. How should we design a dimensional star schema model for analytical query performance? | pass→pass | 20,502 | 20,281 | -1% | 1 | 1 | 0% | 3,263 | 4,514 | +38% | 0 | 0 | — |
▸case-12 A commercial loan processing department experiences 30-day processing times. Management wants to increase marketing to fix throughput. How should we apply process mining and workflow bottleneck analysis to optimize the loan origination pipeline? | pass→pass | 18,391 | 25,227 | +37% | 1 | 1 | 0% | 2,826 | 5,157 | +82% | 0 | 0 | — |
▸case-13 A mid-sized manufacturer wants to implement self-service BI for 500 business users. The IT director proposes granting every user direct read/write access to production SQL databases so everyone can build custom queries. How should we design a self-service BI governance and semantic layer strategy? | pass→pass | 22,400 | 21,535 | -4% | 1 | 1 | 0% | 3,381 | 4,873 | +44% | 0 | 0 | — |
▸case-14 Our retail chain frequently suffers from broken sales reports because raw POS data has missing timestamps and duplicate batch uploads. Staff currently manually review Excel files at month-end. How should we establish an automated data quality assessment and anomaly detection framework? | pass→pass | 21,055 | 18,639 | -11% | 1 | 1 | 0% | 3,338 | 3,967 | +19% | 0 | 0 | — |
▸case-15 An online learning platform tracks 1M monthly visitors but notices high dropoff before enrollment. The team is currently analyzing aggregate page view counts across all pages combined. How should we structure a multi-step user journey funnel analysis to isolate friction points? | fail→fail | 16,162 | 16,397 | +1% | 1 | 1 | 0% | 2,545 | 3,884 | +53% | 0 | 0 | — |
▸case-16 A subscription box company wants to send personalized marketing campaigns. They plan to segment subscribers solely into two age buckets (under 30 vs over 30). How should we apply behavioral RFM analysis or clustering to build actionable customer personas? | pass→pass | 19,458 | 20,807 | +7% | 1 | 1 | 0% | 3,169 | 4,725 | +49% | 0 | 0 | — |
▸case-17 A regional hardware distributor sets fixed stock reorder points of 100 units for all products year-round, resulting in stockouts during summer peak demand. How should we design a supply chain analytics model to dynamically calculate safety stock and reorder points? | pass→pass | 22,062 | 24,180 | +10% | 1 | 1 | 0% | 3,642 | 5,097 | +40% | 0 | 0 | — |
▸case-18 A direct-to-consumer brand spends budget across TikTok ads, influencer marketing, Google search, and retargeting. They currently attribute 100% of conversions to the last link clicked before purchase. How should we transition to a multi-touch attribution framework? | pass→pass | 21,254 | 26,533 | +25% | 1 | 1 | 0% | 3,448 | 5,555 | +61% | 0 | 0 | — |
▸case-19 An enterprise SaaS vendor with 110% Net Dollar Retention (NDR) wants to understand growth drivers. The executive board only looks at new logo acquisition counts. How should we build an expansion and net retention decomposition model? | pass→pass | 21,378 | 27,130 | +27% | 1 | 1 | 0% | 3,467 | 5,863 | +69% | 0 | 0 | — |
▸case-20 A public utility needs an executive dashboard to display regional energy usage metrics. The current mock-up uses multi-colored 3D pie charts with 12 distinct bright colors. How should we redesign this using visual hierarchy and accessible visual design standards? | pass→pass | 17,495 | 17,526 | +0% | 1 | 1 | 0% | 2,733 | 4,164 | +52% | 0 | 0 | — |
▸case-21 A mobile gaming studio receives 50,000 app store reviews monthly. The product team currently searches for key terms like 'bug' in raw text files. How should we build an automated Voice of Customer (VoC) text analytics pipeline to track sentiment trends? | pass→pass | 22,413 | 21,229 | -5% | 1 | 1 | 0% | 3,562 | 4,558 | +28% | 0 | 0 | — |
▸case-22 A software provider wants to raise subscription prices from $20/month to $30/month across the board, assuming demand volume will remain identical. How should we structure a price elasticity of demand analysis to evaluate revenue optimization risks? | fail→fail | 18,601 | 23,658 | +27% | 1 | 1 | 0% | 3,153 | 5,408 | +72% | 0 | 0 | — |