Load Aggregation In XDL Flashcards
(32 cards)
What fixes are related to Problem Load Aggregation?
Manual, multi-week transformer load studies.
What raw input is needed for load aggregation?
Interval reads + two mapping CSVs (NME & PCR).
What is the core SQL object name for transformer data?
v_xfmr_daily
How is the daily kW peak defined?
Max 15-min interval for each transformer each day.
What is the dashboard latency from meter to map?
~10 minutes.
What is the top user action after seeing red transformers?
Rebalance load or fast-track upgrade.
Which file provides ratings for transformers?
NME (asset master).
What is the overload rule of thumb?
Flag >90 % of kVA rating.
What is the GUI tool name used for BI?
Superset (open-source BI inside XDL).
What is the key value proposition of the system?
Turns raw AMI data into a transformer heat-map—no spreadsheets required.
What is the ingest path from RNI to XDL?
RNI ➜ S3 landing bucket ➜ AWS Glue job ➜ Redshift electric_intervals table.
What is the default interval granularity supported?
15-min, 30-min, or hourly (config flag in Glue job).
Why do we prefer a SQL VIEW over a Materialized View by default?
Zero ops overhead; always up-to-date; Redshift handles daily roll-ups fast enough for most utilities.
When should you convert to a Materialized View?
> 10 M rows per day or dashboard latency >5 s; schedule nightly REFRESH.
What column was added to NME for the GreyStone pilot?
transformer_type (OH / UG) to enable dashboard filter.
What are two ways to join meter ratings if NME is incomplete?
1) supplemental custom_tbl_xfmr_map; 2) left join to GIS export with kVA field.
What is the Superset dataset security model?
Tenant schema isolation + optional row-level security filters via roles.
What is the API endpoint pattern to pull daily kW peak JSON?
/xdl/api/v1/dataset/v_xfmr_daily?transformer_id=XXXX&date=YYYY-MM-DD
What is a common root cause of ‘missing transformer dots’?
PCR file missing child-to-parent links or duplicate device_id values.
What is the first upsell module after Load Aggregation?
AI anomaly scoring (flags transformers whose load pattern deviates from historical norm).
Why does Load Aggregation matter for EVs?
It aggregates meter data at the transformer level to identify evening charging spikes and spot overloaded assets early.
What is the typical EV-charging surge window?
5 PM – 10 PM local time (post-commute plug-ins).
What KPI is added to the dashboard for EV analysis?
Evening Peak kW (max kW between 5-10 PM).
What is the rule of thumb overload threshold with high-EV adoption?
≥ 75 % of kVA rating during surge window (lower than 90 % to leave headroom).
