Data Migration

Hargrove & Associates has successfully completed migration of AEM North America Crane Statistics data into its data processing platform, iSTAT, with strong leadership and support from AEM and the association’s Market Share Statistics Department.

The one-year-long migration process covered all historical data for participating companies, for all of the following crane types reported: All Terrain Cranes, Boom Trucks, Rough Terrain Cranes, and three types of Tower Cranes. Ultimately, the processing, report generation and publication of accurate data allows members to receive it by month, by year, by crane type since 2015, including the month of January 2022.

“This is a true success story, with credit and thanks going to a wide range of team members within HAI and AEM,” said HAI President and CEO/CTO Brian Seebacher. “We at HAI look forward to seeing this program continue to thrive and provide its members with the key market insights they need to run their businesses.”

HAI owned the responsibly for the project preparation, planning and execution that involved the set up and preparation of the iSTAT system to:

  • Receive the data
  • Review and analyze preliminary industry files received
  • Review and analyze individual company records
  • Import all historical data for participating companies, for all crane types to be reported

Key project stakeholders from HAI, AEM and AEM’s Crane Statistics Committee included:

  • Todd Snell – HAI
  • Charles Wesenberg – HAI
  • Laurel Ogren – HAI
  • Erin Peters – HAI
  • Mike Liekte – AEM
  • Rex Sprietsma – AEM
  • Robert Ritter – AEM Crane Statistics Committee Chair, Manitowoc
  • Kelly Fiechter, AEM Crane Statistics Committee Vice Chair, Link-Belt Cranes

Driven by HAI, the migration process necessitated coordination with the previous provider, member training, data modeling and checking and frequent communication to ensure the entirety of the project’s scope was captured. In addition, AEM helped facilitate meetings and interviews between HAI staff and member company representatives to establish transparency throughout the process – from the earliest planning stages through publication in early March of this year.

“This project was a tremendous challenge given the short time-frame to execute, and it took the efforts of many to ensure its success,” said AEM Vice President of Business Intelligence Larry Buzecky. “I cannot overstate how effective the coordination needed to be to pull the transition off, as well as produce data that aligns perfectly with the seven-plus years of data the previous provider had captured.”

For more information about AEM Market Share Statistics, contact AEM’s Mike Lietke at mlietke@aem.org.

For more AEM news and updates, subscribe to the AEM Industry Advisor. 

 

×