Converting and analyzing wage and business data from PDFs

Some wage and business data is electronic but is not analyzable in the format that it is maintained by the employer or company.

For instance,some employers use computerized data systems for recording the start times, lunch periods, and end periods for certain employees.  When reviewing this data in the regular course of business some of these employers review standardized, pre-formatted reports of the time punch data instead of the actual underlying time punches that were made by each individual employee.  Many of these standardized reports are presented in a PDF or other non-analyzable electronic format.

Similarly, some businesses retain certain information, such as itemized copies of purchase orders, only in a PDF or other non-analyzable electronic format.

The task when addressing economic damage issues that rely on this type of non-analyzable electronic information, is to accurately and efficiently translate the data into a format that can analyzed using statistical programs, such as STATA.  In cases with relatively small amounts of data spreadsheet programs such as EXCEL could also be used.

How is this done? Next>>>>

Published by

Dwight Steward, Ph.D.

Dr. Steward regularly writes and speaks on topics involving business and individual economic damages, employment audits, and the analysis of payroll and time data in wage and hour investigations. Dr. Steward has also held teaching positions at The University of Texas-Austin in the Department of Economics and in the Red McCombs School of Business, The College of Business at Sam Houston State University, and at The University of Iowa. He has taught numerous courses in statistics, corporate finance, labor economics, business policies, managerial economics, and microeconomics.