CTX insight
Power BI for Construction, by Construction
Your data made clear. From bid, to build, to bottom line
We are an independent Business Intelligence consulting firm. We are based in the Dallas Metroplex, but our safety boots have (literally) been around the world. We combine a deep understanding of construction and construction management with cutting edge data analytic techniques to help our clients bring clarity to their data.
Find out more about our consultants below.
Collin Tsui, P.Eng.
Bringing Clarity to Data
Collin is a Business Intelligence professional with 22 years of experience in EPC and data analytics, including at a top Power BI Consultant, Fortune 200 company and startup EPC. He combines business acumen with digital fluency and an innovative mindset to improve data comprehension and facilitate data-driven decision making. Collin chaired Data Analytics Community at the Construction Industry Institute and was featured in BD+C Magazine's 40 Under 40.
Connect on LinkedIn.
Experience
EPC & BI Roles
Managing Consultant (since 2024)
Principal Power BI Consultant (2024)
Business Intelligence / Project Controls Manager (2023-2024)
Construction Performance / Turnover Manager (2020-2023)
Global Manager of Construction Performance (2018-2020)
Global Operations Coordinator (2016-2018)
Indirect Cost Lead (2015-2016)
Construction Project Engineer (2012-2014)
Sales Coordinator (2010-2012)
Interface Engineer (2009-2010)
Turnaround Engineer (2009)
Mechanical Engineering Lead (2009)
Process Engineer (2008)
Field Engineer (2006-2008)
Mechanical Engineer (2006)
Expeditor (2005)
Engineering Assistant (2004)
Oilfield Operator (2002-2003)
Education & Certification
PL-300 Power BI Data Analyst Associate (Microsoft)
Professional Engineer (APEGA)
B.Sc Mechanical Engineering (University of Calgary)
Collin brings international project execution experience from four continents
Working with Collin...
”When a Big Four consulting firm determined our data model had hit Power BI's performance and size limits, Collin rebuilt it into a performant, scalable model, then went further, turning our monthly consultant-led data refresh into an automated process.”
- Karl, Senior Manager Enterprise Analytics
at a $1B+ software company
”One hour on the phone with Collin just gives me so much to think about. His understanding of the construction industry is very helpful.”
- Khush, Regional Sales Managers
at a major construction equipment distributor
Power BI Projects
Executive Management
Profit and Loss Dashboard
COVID Office and Site Closure Executive Dashboard
Finance
Accounts Receivable Aging Report
Payapp and Invoice Dashboard / Detail Reports
Profit Erosion Analysis
Project Management
Project Management Dashboard
Work In Progress Report
Work To Go Report
Revizto Issues Log
Construction
Time on Tools Analysis
Completion and Turnover Dashboard
Commissioning Dashboard
Sales
Sales Commission Report
Upselling / Cross-Selling Opportunities Explorer
New and Lost Customer Report
Recurring Revenue and Churn Report
Operations
Project Performance Benchmarking
Project Health Dashboard
Portfolio-Wide Critical Path Report
Overhead Cost and Labor Utilization Report
Human Resources
Workforce Management Prototype
Consultant Scheduling Report
Engineering
Master Equipment List
Duplicate Tags Report
Engineering Project Resources Levelling Report
Supply Chain
Procurement Savings Dashboard
Vendor Ecosystem Directory
Customs and Duty Exemptions Report
Material Consignment Report
Inventory Search Utility
Stock Cycling Dashboard
Other
Cloud Software Usage Dashboard
Cloud Software Product Dashboard
Data Quality Dashboard
DataBricks Data Ingestion Validation
Off The Clock
Collin lives near Dallas with his wife Joey and daughters Hazel and Khloe. In his spare time, he enjoys sim racing and strategy games. He learned to fly with the Royal Canadian Air Cadets, earning his Pilot License before he can drive, and still looks up anytime he hears an airplane.
Oh no, where did the ground go?
Our Location
Our consultants can work remotely or in person.
Location
Plano, TX 75025
Hours
Monday to Friday
8am - 6pm CT
