
SOLUTION SPOTLIGHT
Making Big Data Bite-Sized in AASHTO's CTTP Data Portal
CLIENT
The American Association of State Highway & Transportation Officials (AASHTO)
SERVICES
Data analysis, user experience (UX), human-centered design, web design, front-end development, natural language processing (NLP), chat bot development, strategic communications, big-data management
TOOLS
Artificial intelligence (AI), machine learning, advanced GIS functions, Microsoft Office 365, SharePoint
OUTCOMES
Eliminated information barriers; Accelerated data discovery; Enhanced regional insights; Modernized data experience; Continuous system learning

SOLUTION SPOTLIGHT
Making Big Data Bite-Sized in AASHTO's CTTP Data Portal
CLIENT
The American Association of State Highway & Transportation Officials (AASHTO)
SERVICES
AI-powered Natural Language Processing (NLP) chatbot development; Agile big data management; Human-centered design; Advanced GIS functions
TOOLS
Artificial intelligence (AI), machine learning, advanced GIS functions, Microsoft Office 365, SharePoint
OUTCOMES
The architecture of the new CTPP Data Portal is simple but robust: a powerful backend database, a flexible application programing interface for deeper programmatic access, and an intuitive front end with a load of new tools that use artificial intelligence and machine learning to constantly improve the user experience.
700+
Demographic variables incorporated into updated user experience
50
State departments of transportation and countless other policy analysts use the updated DTPP tool.
THANKS SO MUCH. THIS HAS BEEN (BY FAR) THE BEST TECH SUPPORT I'VE EVER ENCOUNTERED.
— CTPP user
700+
Demographic variables incorporated into updated user experience
50
State departments of transportation and countless other policy analysts use the updated DTPP tool.
THANKS SO MUCH. THIS HAS BEEN (BY FAR) THE BEST TECH SUPPORT I'VE EVER ENCOUNTERED.
— CTPP user
Making Complex Data Feel Simple
AASHTO is the voice of our transportation system and state departments of transportation. Their Census Transportation Planning Products (CTPP) are critical: They tell us how people get to and from work, the time it takes them to get there, and the modes of transportation they use. CTPP data also reveal geographic trends and how the working public travels through specific areas. Without these data, we’d be ignorant of commuting patterns, demographic-based trends, and travel behavior. But for a long time, CTPP data were too complex to read. MacroSys’s goal was to break down these complex data into something users could access and understand more quickly—without needing a PhD in traffic engineering.
Making Data Accessible and Usable for All
MacroSys reimagined the CTPP Data Portal, designing it with all users in mind—from engineers, to academics, to the general public. Our team distilled the data query process into clear and easy steps that enable users to self-train as they go, learning about the data structure organically and producing usable data outputs quickly. Today, users can explore transportation data visually with a map-based geographic tool, zoom in on specific regions to instantly see trends, and use the CTPP Chatbot.
The result? This Chatbot is AASHTO’s first smart assistant, making CTPP data navigation easier than ever. Our team eliminated the need for keywords and pages of information. Instead, users simply ask a question, and the Chatbot delivers a targeted answer in seconds. And its performance will get better with time as it learns from each user query.
Big Data Becomes Bite-Sized
MacroSys works with big data in agile ways. It’s not just about building a tool; it’s about reducing barriers, empowering different users, and finding the right shovel to dig into transportation data easily. Want to explore data visually with a map-based geographic tool? Done. Want to zoom in on specific regions and instantly see trends? Now you can. Users can also generate helpful visuals on the fly thanks to real-time charting capabilities.
MacroSys continues to apply user-centered designs and cutting-edge AI to pave a clear road to transportation data once and for all.


Big Data Become Bite-Sized
MacroSys works with big data in agile ways. It’s not just about building a tool; it’s about reducing barriers, empowering different users, and finding the right shovel to dig into transportation data easily. Want to explore data visually with a map-based geographic tool? Done. Want to zoom in on specific regions and instantly see trends? Now you can. Users can also generate helpful visuals on the fly thanks to real-time charting capabilities.
MacroSys continues to apply user-centered designs and cutting-edge AI to pave a clear road to transportation data once and for all.
Making Complex Data Feel Simple
AASHTO is the voice of our transportation system and state departments of transportation. Their Census Transportation Planning Products (CTPP) are critical: They tell us how people get to and from work, the time it takes them to get there, and the modes of transportation they use. CTPP data also reveal geographic trends and how the working public travels through specific areas. Without these data, we’d be ignorant of commuting patterns, demographic-based trends, and travel behavior. But for a long time, CTPP data were too complex to read. MacroSys’s goal was to break down these complex data into something users could access and understand more quickly—without needing a PhD in traffic engineering.
Making Data Accessible and Usable for All
MacroSys reimagined the CTPP Data Portal, designing it with all users in mind—from engineers, to academics, to the general public. Our team distilled the data query process into clear and easy steps that enable users to self-train as they go, learning about the data structure organically and producing usable data outputs quickly. Today, users can explore transportation data visually with a map-based geographic tool, zoom in on specific regions to instantly see trends, and use the CTPP Chatbot.
The result? This Chatbot is AASHTO’s first smart assistant, making CTPP data navigation easier than ever. Our team eliminated the need for keywords and pages of information. Instead, users simply ask a question, and the Chatbot delivers a targeted answer in seconds. And its performance will get better with time as it learns from each user query.
YOUR CHALLENGE
Let us help
Ready to get started? Let's talk.
Tel: 703-812-8380
Fax: 703-812-8381
MacroSys, LLC
522 21st Street NW, Suite 120A
Washington, DC 20006

















