HomePortfolio Building a BI Tool for Monitoring Multicloud Operations

Building a BI Tool for Monitoring Multicloud Operations

Azure
AWS
Google Cloud
.NET

Building a BI Tool for Monitoring Multicloud Operations

About the project

A consulting company providing end-to-end IT solutions to federal agencies turned to Altoros to create a dashboard for tracking costs and other metrics by users of milticloud deployments that combine AWS, Microsoft Azure, and Google Cloud Platform.

The need

In addition to its consulting and development practice, the customer decided to create a BI platform giving multicloud users an overview of their current and forecasted spendings on AWS, Azure, and GCP. The tool will also monitor cloud operations, tracking numerous application metrics, statuses, load, storage capacity, utilization, etc.

After exploring the functionality of Power BI but failing to reach the goals set, the customer turned to Altoros for the business intelligence and .NET expertise for assistance, seeking to build an MVP of such a system from scratch.

The challenges

The team had to address the following issues:

  • Different cloud platforms required different approaches to retrieving the same information via the APIs.
  • The customer wanted to display historical data for periods exceeding the available ones in the cloud platforms’ APIs (e.g., for up to 1 year).
  • The tool needs to be platform-independent, capable of being deployed on different private environments.

The solution

To successfully initiate the project, Altoros assigned expert Power BI engineers with multicloud expertise. Working closely with the customer, a dedicated business analyst helped to deliver a detailed project plan, organizing/prioritizing backlog and milestones.

After retrieving necessary metrics from all the 3 APIs, developers from Altoros unified diverse data structures to feed Power BI with standardized information. The dashboard was populated with metrics and insights for each cloud (e.g., top 10 most consuming instances, monthly forecasts, etc.)—displayed within a second.

To enable reports based on historical data, the team deployed a time series database storing information that may become unavailable through APIs over time.

The outcome

Altoros has delivered a minimum viable product (MVP), enabling the customer to get revenue right away and collect early feedback from users who want to drill down into their multicloud costs. Besides, with this hands-on functionality, the company can now seek additional funding to expand the product. Currently, the team—enhanced with engineers from Altoros—is moving to Phase 2 to implement the tracking of more sophisticated analytical metrics.

Want to develop something similar?

Preloader
Damian Castelli

Damian Castelli

Chief Delivery Officer

d.castelli@altoros.com 617 841-2121