PRE-CONFERENCE CODING DAY

Monday April 14, 2025

9:00 am Check-In & Networking Breakfast

Workshop A

10:00 am Delivered by Procore

Synopsis

Procore logo

12:00 pm Check in & Networking Lunch

Track 1
Coding Fundamentals

Workshop B

1:00 pm Mastering SQL Queries to More Seamlessly Extract & Organize Data

  • Jen Paré Data Solutions Lead, Garney Construction
  • Chad Lewis Director CRM Operations, Swinerton

Synopsis

  • Reviewing the typical challenges faced when extracting data, including data integrity issues, and ways to tackle that with SQL
  • Covering the SQL Query essentials and understanding how to use SELECT statements, joins (INNER, LEFT, RIGHT), and subqueries
  • Diagnosing and improving the efficiency of SQL queries with the help of available tools

Track 2
Advanced Coding & Data Strategies

Workshop C

1:00 pm Improving Dashboard Design to Tell a Story with Your Data

  • Chad Lewis Director CRM Operations, Swinerton
  • Jen Paré Data Solutions Lead, Garney Construction

Synopsis

  • Discovering how to tailor dashboards for different audiences, focusing on intuitive navigation and accessibility
  • Developing a process for creating repeatable, meaningful reports that are regularly updated with new data
  • Exploring how advanced features of Power BI – such as DAX for dynamic calculations, and Copilot integration for automated code generation – can further enhance user experience

3:00 pm Afternoon Refreshments

Workshop D

3:30 pm Connecting the Dots: A Practical Guide to Streamlining Data Transfer Between Platforms

Synopsis

  • Discussing different options for integrating data from different sources and database systems – such as Integration Platform as a Service (iPaaS), Application Programming Interfaces (APIs), Open Database Connectivity (ODBC) connectors, local databases, and more
  • Exploring how to select and build effective integrations to connect platforms and enhance data flow: How can you assess ROI?
  • Establishing data factories to automate ETL processes and ensure data is up-to-date and accurate while saving time and resources

Workshop E

3:30 pm Turning Images & Videos into Actionable Data for More Informed Project Decisions

Synopsis

  • Assessing whether converting images and videos into structured data is worth the investment
  • Using cloud-based image recognition models to analyze and categorize images and videos based on visual content, making project data more accessible and organized
  • Exploring how adding metadata and annotations can offer a more accessible way to make photos searchable and valuable resources

5:30 pm End of Workshop Day

FULL EVENT GUIDE
DAY ONE