Transport Advisory
- multimodal Transport Data Structure Design
- Transport Modelling (SIDRA, Aimsun, SATURN & Spreadsheet Models)
- Transport Economics following NZ standards
- Intersection and corridor operation and optimizations
- Business Case development
- Traffic Impact Assessment
Data collection
- Traffic counts
- Pedestrian and cyclist counts
- Parking survey
- Travel Time Studies
- Video Collection
- Asset information Data Collection
Business Intelligence
- development of Enterprise BI solutions
- Data Visualization using PowerBI, Arcgis and SSRS
- Administration ETL solutions within BI tools
Enterprise Data Warehouse
- Development of data profiling and modelling
- Design of ETL process and dat extraction package using SSIS
- Engineering of EDW infrastructure for BI tools
Business Analysis
- Outcome driven BI solution development using BI tools and SQL and DAX.