[Input given in prompt] under ‘My Role Analysis Request’

• Role to Analyze: Data analyst in a BI team
• Industry Context: Consumer brand in supplements market, 50M revenue
• Current Team Size: BI team of 4
• Key Challenges: Struggling to keep with data requests of the organization, frustrated with manual work, lack of time to work on strategic insights

Conway Capability Ladder Analysis: BI Data Analyst in Supplements DTC Brand

1. Activity Breakdown by Level

Level 1: Button Pushers ✅ (Full AI Automation Ready)

1. Daily dashboard refreshes - Running scheduled data pipeline updates in dbt/Power BI
2. Standard report distribution - Emailing weekly sales reports to department heads
3. Data quality checks - Running validation scripts on new data imports
4. Basic data cleaning - Removing duplicates, standardizing product names in supplements catalog
5. Routine query execution - Pulling "top 10 products by revenue" for marketing team
6. Metric calculations - Computing standard KPIs (AOV, CAC, LTV, conversion rates)
7. Alert monitoring - Checking if daily order volume is within expected range

Current Reality: Your BI team likely spends 30-40% of time here. This is the frustration zone.