7 min read
|
Saved February 14, 2026
|
Copied!
Do you care about this?
This article outlines the creation of a unified dashboard for tracking costs across multiple cloud platforms, including AWS and GCP. It details the implementation steps using tools like dlt, SQL, and Rill to visualize data and combines cloud costs with revenue metrics for better financial insights.
If you do, here's more
Many companies juggle multiple cloud platforms like AWS, GCP, and various AI services, complicating cost tracking. Without a unified dashboard, teams face the challenge of managing scattered invoices and spreadsheets. This article outlines a project aimed at creating a comprehensive, reusable dashboard to monitor multi-cloud costs while integrating revenue data. It emphasizes the need for a combined view of expenses and recurring revenue, making it easier for businesses to understand their financial health.
The project employs dlt for data integration, storing information in DuckDB or ClickHouse, and visualizing it with Rill. The author lays out a roadmap for implementation, which includes integrating revenue from Stripe, setting up AWS and GCP cost exports, and developing a dimensional model for meaningful insights. Key tasks involve automating the cost export process, ensuring compatibility with other providers, and creating demo data for testing. The integration challenges with AWS and GCP, particularly regarding authentication and data formatting, are notable hurdles that the author navigates.
The result is a GitHub repository that offers a scaffold for generating a cost report. Users can run this project locally after configuring their cloud cost reports. The dashboards provide insights into spending trends, breaking down costs by services and products. Visualizations highlight key metrics like total costs, revenue, and margins, allowing users to drill down into specific areas for further analysis. By combining various data sources, the project aims to simplify financial oversight for organizations using multiple cloud services.
Questions about this article
No questions yet.