GCP Cost Analysis
Analyzes and visualizes Google Cloud Platform spending from L'Oréal's BTDP infrastructure through automated BigQuery queries and custom spreadsheet exports.
The source repository doesn't declare a license. Check its terms before reusing the code.
Key features
- Standardized financial calculations using cost-after-discount metrics
- Automated BigQuery query generation tailored for BTDP billing schemas
- Professional Google Sheets export with automated formulas and L'Oréal styling
- Advanced categorization of BigQuery usage into reservations, storage, and analysis
- Integration with master data retrieval for accurate resource identification
Use cases
- Reviewing monthly cloud budget consumption across specific IT organizations
- Generating formatted financial spreadsheets for quarterly cloud spend audits
- Identifying cost optimization opportunities within BigQuery reservation models
FAQ
Can this skill create shareable reports?
Yes. Upon request, it generates Google Sheets in specific L'Oréal directories, applying corporate styling, French currency formatting, and dynamic formulas so the reports are immediately ready for presentation.
How does it improve my cloud management workflow?
It eliminates the need to manually write complex SQL queries for BigQuery billing exports. By understanding specific schemas and categorization (like reservations vs. storage), it provides instant, accurate financial insights without manual data manipulation.
When should I use this Claude Code skill?
Use this skill whenever you need to investigate GCP expenses, breakdown costs by service or project, perform cloud cost optimization, or generate financial reports for stakeholders regarding cloud infrastructure spending.
What does the GCP Cost Analysis skill do?
This skill automates the retrieval, analysis, and visualization of Google Cloud Platform spending. It generates tailored BigQuery queries for the L'Oréal BTDP infrastructure and can export data into professionally styled Google Sheets with automated formulas.
Does it account for discounts and marketplace fees?
By default, the skill uses 'cost_after_discount_euro' to provide the most accurate spending data and excludes marketplace costs to focus on core infrastructure, though it can include marketplace data if explicitly requested.