ETL pipeline in Tableau Prep. Finely tuned to suit CRTC short and long-term needs. Proof-of-concept for automating ETL with larger datasets. "For the CRTC, Bronson's efforts included aligning measurement unit data discrepancies using a matrix to present all relevant data in a single dataset." Project Description Bronson [...]
Bronson conducted a QA review of Conservation and Demand Management (CDM) Program Administration in Ontario. The project scope encompassed all 73 Local Distribution Companies (LDCs) delivering electricity in the Province and 15 different CDM initiatives being administered through them. As part of the review process, Bronson made four separate appearances before the OPA/IESO Audit [...]