Omnia and Casa dos Ventos sign $2bn power deal anchoring TikTok’s Brazil data centre

Introduction

In this tutorial, we'll explore how to work with energy data and power contracts using Python and data visualization tools. This tutorial is inspired by the recent $2 billion power deal between Omnia and Casa dos Ventos that supports TikTok's Brazil data center. We'll create a system to analyze and visualize power contract data, focusing on renewable energy agreements and their financial implications.

This intermediate-level tutorial assumes you have basic Python knowledge and experience with data analysis libraries. We'll cover how to parse energy contract data, perform financial analysis, and create visualizations that could help stakeholders understand power agreements like the one mentioned in the news article.

Prerequisites

• Python 3.7 or higher installed
• Basic understanding of data analysis with pandas
• Experience with data visualization using matplotlib/seaborn
• Knowledge of financial data analysis concepts
• Installed Python packages: pandas, matplotlib, seaborn, numpy

Step-by-Step Instructions

1. Install Required Libraries

First, we need to install the necessary Python packages for our energy data analysis:

pip install pandas matplotlib seaborn numpy

This step ensures we have all the tools needed to work with energy data and create meaningful visualizations.

2. Create Sample Energy Contract Data

Let's create a sample dataset that mimics the kind of data involved in power contracts like the one between Omnia and Casa dos Ventos:

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns

# Create sample energy contract data
np.random.seed(42)

# Generate data for 5 years of power contracts
contract_data = {
    'year': [2020, 2021, 2022, 2023, 2024],
    'contract_value_millions': [1500, 1800, 2100, 2400, 2700],
    'power_capacity_mw': [180, 190, 200, 210, 220],
    'renewable_percentage': [65, 70, 75, 80, 85],
    'cost_per_mwh': [0.08, 0.075, 0.07, 0.065, 0.06],
    'contract_duration_years': [5, 5, 5, 5, 5]
}

contract_df = pd.DataFrame(contract_data)
print(contract_df)

This creates a realistic dataset that mirrors the financial and technical aspects of large-scale renewable energy contracts.

3. Data Analysis and Financial Metrics

Now let's calculate key financial metrics that would be important for analyzing such contracts:

# Calculate financial metrics
contract_df['total_contract_value'] = contract_df['contract_value_millions'] * 1000000
contract_df['annual_revenue'] = contract_df['total_contract_value'] / contract_df['contract_duration_years']
contract_df['average_cost_per_mw'] = contract_df['total_contract_value'] / contract_df['power_capacity_mw']

# Display the enhanced dataset
print("\nEnhanced Contract Data:")
print(contract_df)

This step helps us understand the economic implications of the power agreement, including annual revenue and cost per megawatt.

4. Create Power Contract Visualization

Visualizing the data helps stakeholders quickly understand the growth and trends in the power contract:

# Set up the plotting style
plt.style.use('seaborn-v0_8')
fig, axes = plt.subplots(2, 2, figsize=(15, 10))
fig.suptitle('Energy Contract Analysis Dashboard', fontsize=16)

# Plot 1: Contract Value Over Time
axes[0, 0].plot(contract_df['year'], contract_df['contract_value_millions'], marker='o', linewidth=2, markersize=8)
axes[0, 0].set_title('Contract Value Growth (Millions USD)')
axes[0, 0].set_xlabel('Year')
axes[0, 0].set_ylabel('Value (Millions USD)')
axes[0, 0].grid(True, alpha=0.3)

# Plot 2: Renewable Energy Percentage
axes[0, 1].bar(contract_df['year'], contract_df['renewable_percentage'], color='green', alpha=0.7)
axes[0, 1].set_title('Renewable Energy Percentage')
axes[0, 1].set_xlabel('Year')
axes[0, 1].set_ylabel('Percentage')
axes[0, 1].grid(True, alpha=0.3)

# Plot 3: Power Capacity Growth
axes[1, 0].plot(contract_df['year'], contract_df['power_capacity_mw'], marker='s', linewidth=2, markersize=8, color='blue')
axes[1, 0].set_title('Power Capacity Growth (MW)')
axes[1, 0].set_xlabel('Year')
axes[1, 0].set_ylabel('Capacity (MW)')
axes[1, 0].grid(True, alpha=0.3)

# Plot 4: Cost Per MWh
axes[1, 1].plot(contract_df['year'], contract_df['cost_per_mwh'], marker='^', linewidth=2, markersize=8, color='red')
axes[1, 1].set_title('Cost Per MWh')
axes[1, 1].set_xlabel('Year')
axes[1, 1].set_ylabel('Cost (USD per MWh)')
axes[1, 1].grid(True, alpha=0.3)

plt.tight_layout()
plt.show()

This visualization dashboard provides a comprehensive view of the contract's financial and technical evolution over time.

5. Advanced Analysis with Correlation Matrix

Let's analyze the relationships between different contract parameters:

# Create correlation matrix
numeric_columns = ['contract_value_millions', 'power_capacity_mw', 'renewable_percentage', 'cost_per_mwh']
numeric_df = contract_df[numeric_columns]
correlation_matrix = numeric_df.corr()

# Plot correlation heatmap
plt.figure(figsize=(10, 8))
sns.heatmap(correlation_matrix, annot=True, cmap='coolwarm', center=0, square=True)
plt.title('Correlation Matrix of Energy Contract Parameters')
plt.show()

The correlation matrix helps identify how different contract aspects relate to each other, which is crucial for understanding the economic dynamics of renewable energy agreements.

6. Predictive Analysis for Future Contracts

Finally, let's create a simple predictive model to estimate future contract values:

# Simple linear regression for future value prediction
from sklearn.linear_model import LinearRegression
from sklearn.model_selection import train_test_split

# Prepare data for prediction
X = contract_df[['year']]
Y = contract_df['contract_value_millions']

# Create a simple model
model = LinearRegression()
model.fit(X, Y)

# Predict future values
future_years = np.array([[2025], [2026], [2027]])
future_predictions = model.predict(future_years)

# Display predictions
print("\nPredicted Contract Values for Future Years:")
for i, year in enumerate(future_years.flatten()):
    print(f"Year {year}: ${future_predictions[i]:.2f} million")

This predictive analysis allows stakeholders to forecast future contract values and plan accordingly, similar to how companies might analyze the growth of their energy agreements.

Summary

In this tutorial, we've created a comprehensive system for analyzing energy contracts similar to the $2 billion deal between Omnia and Casa dos Ventos. We've covered:

• Creating and manipulating energy contract data
• Calculating key financial metrics for large-scale energy agreements
• Visualizing contract data using multiple chart types
• Performing correlation analysis to understand parameter relationships
• Building predictive models for future contract values

This approach is directly applicable to real-world scenarios where energy companies need to analyze and plan large-scale renewable power agreements. The skills learned here can be extended to analyze actual data from power contracts, helping stakeholders make informed decisions about energy infrastructure investments.