Skip to content

erayguner/aws-cur-2

Repository files navigation

AWS CUR 2.0 FinOps Looker Project

Version: 3.0 Last Updated: 2025-11-17 Total Dashboards: 60 (23 production-ready) CUR 2.0 Fields: 324


🎯 Project Overview

Comprehensive Looker analytics platform for AWS Cost and Usage Report (CUR) 2.0 data, implementing 2025 FinOps Foundation best practices with future-proof dashboard architecture designed for 5+ year relevance.

Key Features

60 Comprehensive Dashboards

  • 23 production-ready dashboards (validated, zero errors)
  • 5 persona-based dashboards (Executive, FinOps, Engineering, Finance, Product)
  • 3 time-comparison dashboards (daily, weekly, monthly analysis)
  • Advanced analytics: forecasting, anomaly detection, optimization

324 CUR 2.0 Fields

  • 1 primary key
  • 4 dimension groups (28 time-based fields)
  • 166 dimensions (accounts, services, tags, resources)
  • 153 measures (costs, savings, efficiency, sustainability)

Future-Proof Architecture

  • Built on timeless FinOps principles (unit economics, waste, variance)
  • AI/ML cost tracking patterns (SageMaker, Bedrock, GPU instances)
  • Sustainability metrics (carbon emissions, renewable energy)
  • Multi-cloud ready design

2025 FinOps Trends

  • AI cost management (63% of orgs now track AI spending)
  • Sustainability tracking (carbon footprint, green computing)
  • Waste reduction (#1 FinOps priority)
  • Automation & governance (policy compliance)

🚀 Quick Start

Prerequisites

  1. Looker Instance - Version 22.0+ (recommended 24.0+)
  2. AWS CUR 2.0 Data - Queryable in Athena, Redshift, or compatible warehouse
  3. Database Connection - Configured in Looker

Installation

# 1. Clone or download this repository
git clone <repository-url>

# 2. Update manifest.lkml with your configuration
# Edit these constants:
constant: AWS_SCHEMA_NAME {
  value: "your_schema_name"
}

constant: AWS_TABLE_NAME {
  value: "your_cur_table_name"
}

# 3. Deploy to Looker
# - Upload all files to your Looker project
# - Validate LookML
# - Commit changes
# - Deploy to production

# 4. Verify deployment
# - Check cur2.view.lkml loads without errors
# - Test a production-ready dashboard
# - Validate data appears correctly

📊 Dashboard Portfolio

Production-Ready Dashboards (23)

🎯 Core Strategic (4)

  • executive_cost_overview - C-level strategic KPIs, board-ready
  • finops_master_dashboard - Comprehensive FinOps command center
  • detailed_cost_analysis - Deep-dive cost analysis
  • infrastructure_overview - Infrastructure metrics and trends

👥 2025 Persona Dashboards (5)

  • persona_executive_2025 - CFO/CTO/CEO dashboard
  • persona_finops_practitioner_2025 - FinOps Lead dashboard
  • persona_engineer_devops_2025 - Engineering/DevOps dashboard
  • persona_finance_procurement_2025 - Finance/Accounts Payable dashboard
  • persona_product_manager_2025 - Product Manager dashboard

📅 Time-Comparison (3)

  • daily_cost_comparison - 90-day day-over-day analysis
  • weekly_cost_comparison - 26-week week-over-week trends
  • monthly_cost_comparison - 24-month MoM/YoY comparison

⚙️ Operational (11)

  • multi_account_cost_allocation
  • discount_attribution
  • cost_comparison_analytics
  • resource_usage_analytics
  • tagging_compliance_governance
  • showback_chargeback_billing
  • realtime_cost_visibility
  • resource_rightsizing_waste
  • And 3 more...

📚 Documentation

Essential Documentation

  1. Complete Dashboard Validation Report

    • Validation status for all 60 dashboards
    • Deployment priorities and action plan
    • Testing checklist
  2. CUR 2.0 Field Inventory

    • Complete reference of all 324 fields
    • Organized by category
    • Dashboard reference guide
  3. Future-Proof Dashboard Architecture

    • Architecture designed for 5+ year relevance
    • 2025 FinOps persona framework
    • Design principles and best practices
    • Implementation roadmap
  4. New Dashboards Validation 2025

    • Validation report for 8 newest dashboards
    • 100% pass rate, zero errors
    • Field coverage statistics
  5. Documentation Index

    • Complete documentation guide
    • Quick reference links

🏗️ Project Structure

aws-cur-2/
├── README.md                       # This file
├── CLAUDE.md                       # Claude configuration
├── manifest.lkml                   # Project configuration
├── cur2.model.lkml                 # Main data model
├── cur2.view.lkml                  # Enhanced view (324 fields)
├── cur2.explore.lkml               # Explore configuration
├── .lams-manifest.lkml             # LAMS validation config
│
├── dashboards/                     # 60 LookML dashboards
│   ├── persona_executive_2025.dashboard.lookml
│   ├── persona_finops_practitioner_2025.dashboard.lookml
│   ├── persona_engineer_devops_2025.dashboard.lookml
│   ├── persona_finance_procurement_2025.dashboard.lookml
│   ├── persona_product_manager_2025.dashboard.lookml
│   ├── daily_cost_comparison.dashboard.lookml
│   ├── weekly_cost_comparison.dashboard.lookml
│   ├── monthly_cost_comparison.dashboard.lookml
│   └── ... (60 total dashboards)
│
└── docs/                           # Documentation
    ├── README.md                   # Documentation index
    ├── COMPLETE_DASHBOARD_VALIDATION_REPORT.md
    ├── MASTER_DASHBOARD_STRATEGY_2025_2035.md
    ├── cur2_field_inventory.md
    ├── future_proof_dashboard_architecture.md
    ├── new_dashboards_validation_2025.md
    ├── finops-focus/               # FinOps FOCUS specification
    ├── governance-research/        # Governance & security docs
    ├── looker-validation/          # Looker validation reports
    └── performance-dashboards/     # Performance dashboard research

📈 Deployment Status

Status Count % Description
✅ Production Ready 23 39% Zero errors, validated, ready to deploy
⚠️ Minor Fixes 5 8% Functional, need parameter fixes
❌ Critical Issues 31 53% Missing fields or wrong explores

Immediate Action:

  • Deploy 23 production-ready dashboards now
  • Fix 5 dashboards with minor issues (1-2 days)
  • Plan field additions for remaining 31 dashboards

🎯 FinOps Personas

Each persona dashboard is tailored to specific roles and responsibilities:

1. Executive (CFO, CTO, CEO)

  • Strategic KPIs and business impact
  • Monthly/quarterly trends
  • Sustainability metrics
  • Board presentation ready

2. FinOps Practitioner (FinOps Lead, Cloud Economist)

  • Commitment optimization (RI/SP)
  • Waste detection and reduction
  • Cost allocation and chargeback
  • Anomaly detection

3. Engineering/DevOps (Engineering Managers, SRE)

  • Team and project costs
  • Resource-level analysis
  • Infrastructure optimization
  • Network cost analysis

4. Finance/Procurement (Finance Analysts, AP)

  • Invoice reconciliation
  • Budget tracking
  • GL code mapping
  • Payment terms analysis

5. Product Manager (Product Owners, Business Leaders)

  • Unit economics
  • Product-level costs
  • ROI analysis
  • Cost per feature

🔧 Configuration

Required Constants

Edit manifest.lkml:

constant: AWS_SCHEMA_NAME {
  value: "your_athena_database"
}

constant: AWS_TABLE_NAME {
  value: "your_cur_table_name"
}

Optional Constants

constant: COST_THRESHOLD_HIGH {
  value: "10000"  # Alert threshold for high costs
}

constant: DEFAULT_CURRENCY {
  value: "USD"
}

🧪 Testing

Validation Checklist

Pre-Deployment:

  • LookML validation passes
  • Database connection works
  • cur2.view.lkml loads without errors
  • Test dashboard loads data
  • Filters work correctly

Post-Deployment:

  • All production dashboards load
  • Data accuracy verified
  • Performance acceptable (<5s load)
  • Cross-filtering works
  • Exports function correctly

📊 Key Metrics Available

Cost Metrics

  • Total unblended/blended/net costs
  • Month-over-month/year-over-year changes
  • Average daily costs
  • Cost per resource/compute hour/GB

Optimization Metrics

  • Right-sizing opportunities
  • Waste percentage
  • Commitment utilization (RI/SP)
  • Discount attribution

Efficiency Metrics

  • Tag compliance rate
  • Resource efficiency score
  • Optimization score
  • FinOps maturity score

Sustainability Metrics

  • Carbon emissions (kg CO₂)
  • Renewable energy percentage
  • Sustainability score
  • Green computing adoption

🚀 Roadmap

Phase 1: Foundation (Complete)

  • ✅ Core dashboards validated
  • ✅ Persona dashboards created
  • ✅ Time-comparison dashboards built
  • ✅ Documentation consolidated

Phase 2: Enhancement (In Progress)

  • 🔄 Fix dashboards with minor issues
  • 🔄 Add missing fields to cur2.view.lkml
  • 🔄 Deploy remaining dashboards

Phase 3: Advanced Features (Planned)

  • 📋 ML/AI cost forecasting
  • 📋 Advanced anomaly detection
  • 📋 Automated optimization recommendations
  • 📋 Multi-cloud support

🤝 Contributing

This project follows FinOps Foundation best practices and Looker LookML standards.

Development Process

  1. Create feature branch
  2. Make changes
  3. Validate LookML
  4. Test with sample data
  5. Submit pull request
  6. Review and merge

📞 Support

Documentation

  • Complete validation report: docs/COMPLETE_DASHBOARD_VALIDATION_REPORT.md
  • Field reference: docs/cur2_field_inventory.md
  • Architecture guide: docs/future_proof_dashboard_architecture.md

Resources


📄 License

Copyright © 2025 - AWS CUR 2.0 FinOps Looker Project


🔖 Version History

v3.0 - 2025-11-17

  • Added 8 future-proof persona and time-comparison dashboards
  • Consolidated documentation
  • 100% validation on new dashboards
  • Updated to 60 total dashboards

v2.0 - 2025-11-17

  • Initial validation of 51 dashboards
  • Created field inventory (324 fields)
  • Established deployment priorities

Ready to deploy? Start with the 23 production-ready dashboards and expand from there! 🚀

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors