Market Share Trend Analyzer

Download the data files below and upload to Copilot Chat before running this prompt.

Prompt

Analyze the market share breakdown data I'm uploading and tell me the full story of what's happening in this market.

Context about this market: [INDUSTRY OR MARKET NAME]
Time period covered: [DATE RANGE IN YOUR DATA]
My company: [YOUR COMPANY NAME]

Please produce:

1. **Snapshot: Current State**
   - Rank all players by current market share (table)
   - Top 3 observations about the current distribution

2. **Trend Analysis**
   - Who has gained the most share over the period? By how much?
   - Who has lost the most? Is the decline accelerating or slowing?
   - Any companies that appear to be stalling (flat share)?

3. **Segment Deep Dive**
   - Which segments are growing fastest?
   - Which player dominates each segment?
   - Segments where share is most contested (multiple players within 5%)

4. **Velocity & Momentum**
   - Calculate quarter-over-quarter change for the top 5 players
   - Flag any inflection points (sharp gains or drops)

5. **Strategic Implications for [YOUR COMPANY NAME]**
   - Best opportunity segments
   - Biggest threats
   - Recommended positioning move