Data Warehouse Query Costs

import matplotlib.pyplot as plt
import squarify
import numpy as np

# Query costs (monthly in dollars)
labels = ['Analytics Team', 'ML Pipeline', 'BI Dashboards', 'Ad-hoc Queries',
          'Data Science', 'Marketing', 'Finance Reports', 'Executive Dash']
sizes = [4500, 8200, 3200, 2800, 5500, 1800, 2200, 950]
total = sum(sizes)

# CLAUDE.md colors
colors = ['#27D3F5', '#5314E6', '#F5276C', '#6CF527', '#F5B027',
          '#276CF5', '#F54927', '#27F5B0']

fig, ax = plt.subplots(figsize=(12, 8), facecolor='#0a0a0f')
ax.set_facecolor('#0a0a0f')

pct = [s/total*100 for s in sizes]
squarify.plot(sizes=sizes, 
              label=[f'{l}\n${s:,} ({p:.1f}%)' for l, s, p in zip(labels, sizes, pct)],
              color=colors, alpha=0.85, ax=ax,
              text_kwargs={'fontsize': 9, 'color': 'white', 'fontweight': 'bold'})

ax.axis('off')
ax.set_title(f'Monthly Query Costs - ${total:,}', 
             fontsize=18, color='#f8fafc', fontweight='bold', pad=20)

plt.tight_layout()
plt.show()