Project Control Data Warehouse

Main Menu


Whats New:

ASA Blog

May 10, 2016

 Blog Launch - Mining | Data | Cost | IoT

Emerging Trends in Mining Labor

May 12, 2016

 85K U.S. Mine Sites with Employment Data - Commercial Edition Available Here

March 1, 2016

 85K U.S. Mine Sites with Employment Data - Community Edition Available Here

February 28, 2014

 Overview of Workforce Trends in US Aggregate and Industrial Minerals Industries - SME Annual Meeting


 Emerging Workforce Trends of the U.S. Energy and Mining Industries - National Academies Press

February 20, 2012

Emerging Workforce Trends in the U.S. Mining Industry - SME Annual Meeting

January 3, 2012

 Emerging Workforce Trends in the U.S. Mining Industry - White Paper (Sponsors: SME, NMA, NSSGA, and IMA-NA)

August 23, 2011 and November 9, 2011

Emerging Workforce Trends in Mining - Presentation to the National Academies.

September 1, 2011


Newest site launch. Replaces our original site from 2008


Mining labor to be in short supply

August 26, 2011

boy with haulpak in snowYour Future in mining....

Business Links:

Links to industry information

Current Links

demoSelect here to navigate to our news and business links area.

Would you like to see other charts or information here? Contact Us.

Gold charts on InfoMine.com


Copper charts on InfoMine.com


Silver charts on InfoMine.com



The Project Control Data Warehouse



In March 2009, ASA simultaneously released an Open Data Warehouse Model (ODWM) and an instance of that model for project control (PCDW). This was a first time a commercial data warehouse was released using an ‘Open’ model. The ODWM and PCDW were released to solve a specific data warehouse problem and to generate revenue.  

Making a data warehouse an ‘open’ product reduces a consumer’s initial construction cost and mitigates risk through rapid deployment. This approach allows data warehouse and other co-dependent technologies (Business Intelligence, Analytics, etc.) to be more attractive to a new and largely untouched midmarket.

This frontier opportunity has low barriers to entry which will make the proposition attractive to entrepreneurs interested in ‘owning’ an industry ‘slice’ (e.g. heath care - clinical records, small box retail – marketing, banking – loan evaluation, etc.).

Commercial ecologies designed to support and enhance each of these industry slices offer additional new market opportunities to developers. Availability of talent that can take advantage of this perishable opportunity is high due to current market conditions and will be very attractive to current technology providers who understand the economic benefit of becoming technology owners. Said another way; this approach could create a lot of new financial winners.

There are technical, social, and economic reasons that will move data warehousing and, perhaps all data models toward ‘open’ solutions. This move toward Open solutions will create new product and service markets and will have the effect of making data warehouse and business intelligence technology available to a broader audience.


   There are a number of development opportunities presented by the PCDW.  developers

The PCDW Model

   This space is reserved for ASA's products including the Project Control Data Warehouse (PCDW) versions/documentation and Open Data Warehouse content. Other content may also be available here. Note: This page does use cookies to count visits to the page. However, no personal data is collected. Thanks.


View PCDW License

PCDW Install Instructions

PCDW MS-SQL v0.00  PCDW MS Access v0.00  PCDW MySQL v0.00

PCDW MS-SQL v0.01  PCDW MS Access v0.01  PCDW MySQL v0.01