CBRE · Tableau & PostgreSQL · Professional experience
Owning the business intelligence delivery lifecycle
Connecting requirements, data investigation, transformation and reporting.
Context
Walmart Canada facilities operations span 400+ stores, approximately 150,000 assets and 400,000 work orders annually.
My contribution
Own and continually enhance approximately 15–20 Tableau dashboards, primarily for janitorial and financial reporting, with additional maintenance-and-repair analytical support.
Approach
Lead delivery from requirements and KPI definitions through source-data investigation, SQL transformations, validation, visualization and ongoing enhancements. Representative reporting solutions join approximately 10 tables through 5–10 CTEs. Used fact-and-dimension concepts when structuring reporting tables where practical.
Value
Provide ongoing analytical support for operational reporting, vendor discussions and management decision-making.