Skip to content

EWE Numera Documentation

Welcome to the EWE Numera data platform documentation. This platform provides energy trading analytics including P&L reporting, volume analysis, credit exposure management, and clearing bank statement processing.

Quick Start by Role

Role Description
Business Analysts Explore energy trading data for P&L, volumes, credit exposure, and risk analysis. Get started →
Developers Set up your development environment and understand the data architecture. Get started →

What Data is Available?

The EWE Numera platform provides access to:

Domain Description Key Models
P&L Daily MTM, realized/unrealized P&L by portfolio, counterparty, delivery month fct_pnl, fct_pnl_deal
Volumes Scheduled deliveries, buy/sell positions, 15-minute power profiles fct_volume, fct_schedule, fct_ewe_volume_pwr_by_business_case
Credit Exposure Current exposure, potential exposure, PEX factors by counterparty fct_credit_exposure, fct_credit_exposure_month
Clearing Statements ABN AMRO and BNP Paribas clearing bank positions and settlements fct_clearing_statement_open_position
Deals Active trades, counterparty relationships, deal lifecycle fct_deal, dim_deal_attribute
Risk Delta exposure by index, VaR by portfolio fct_delta, fct_var_pfolio

Documentation Structure

Narrative Documentation (This Site)

  • For Business Analysts: Business-focused guides with query examples
  • For Developers: Technical setup, architecture, and troubleshooting
  • Model Reference: Detailed documentation of all data models
  • Data Dictionary: Business glossary and concept explanations

dbt Documentation

The dbt Documentation provides:

  • Interactive model lineage graph (DAG viewer)
  • Column-level documentation from schema YAML files
  • Test coverage information
  • Source-to-target data flow visualization

Key Resources

Resource Description
Business Glossary Definitions of energy trading terms
Query Patterns Copy-paste SQL examples
Model Reference Complete table and column documentation
Troubleshooting Common issues and solutions

Connecting to the Data

From BI Tools (Power BI, Tableau)

Connect to Snowflake using:

  • Database: NUMERA_EWE_PROD_CORE
  • Schema: NUMERA_DIM_MODEL
  • Role: NUMERA_EWE_PROD_REPORTER
  • Warehouse: NUMERA_PROD_REPORTING

From Python

import snowflake.connector

conn = snowflake.connector.connect(
    user="your_user",
    password="your_password",
    account="your_account.snowflakecomputing.com",
    database="NUMERA_EWE_PROD_CORE",
    schema="NUMERA_DIM_MODEL",
    warehouse="NUMERA_PROD_REPORTING",
    role="NUMERA_EWE_PROD_REPORTER"
)

See Connecting to Data for detailed setup instructions.

Getting Help