Get Close to Your Customers Wherever They Are, and Whenever They Need You!

Our extensive Logistics Infrastructure enables us to provide you with the nationwide reach and capabilities that you need to achieve a local presence in virtually any market without making direct investments in your own infrastructure.

National logisitics company providing over 200 distribution centers, 70 forward stocking locations and 450 owned, co-located and agent partner logistics locations. With Over 450 Locations between our Agent Partners and directly owned facilities, 200 Distribution Centers and 70 Forward Stocking Locations; our clients can move materials from Anywhere in the US to Anywhere in the US, at Anytime; or establish close to customer stocking and re-supply services.

Our locations are strategically located to minimize costs and time to market. As a non asset based Logistics Group we can add centers as your geographical requirements change.

Our Distribution Centers have true warehouse capabilities:

Secure Access and Storage
Dock Height
Fork Lifts, Pallets and Racks
Climate Control

In addition we can provide Cold Storage Locations.

Our network of company owned offices, Agents, Distribution Centers and Forward Stocking Locations provides you one stop shopping for your Nationwide Logistics needs.

For more information and a no obligation consultation please Contact Us directly, or submit a Request for Consultation form.

Warehousing Solution

DATA WAREHOUSING AT THE NATIONAL
AGRICULTURAL STATISTICS SERVICE
Jack Nealon and Mickey Yost
National Agricultural Statistics Service, U.S. Department of Agriculture

Each year, several thousand data files containing agricultural survey data from farmers, ranchers, and agri-businesses are generated on different platforms, using different software systems, and different data definitions or metadata. This has caused an under-utilization of previous data in our survey process, which inhibits some improvements to our survey and estimation program. Therefore, NASS recently developed an easy-to-understand and easy-to-use Data Warehouse System that integrates previous survey and census data, and makes the data readily accessible to all NASS employees. This system answers the Agency's strategic need to improve the quality of our agricultural statistics program by making maximum use of previous survey and census data. Examples include: improving sampling efficiency, enhancing survey planning and administration, streamlining survey data collection, expanding analytic capability for all employees, and broadening statistical estimation opportunities.
Considerable research and evaluation were conducted to find the best Data Warehouse solution to satisfy our ambitious strategic objectives. This research, along with a great deal of senior management and user support, produced an easy-to-use and high performance Data Warehouse. About 700 NASS employees can readily access and review data from a single, integrated database, which contains over one-half billion survey responses extracted from several thousand data files. The Data Warehouse already contains data from over 80 different surveys from 1997, 1998, and 1999, and the complete set of census data (keyed, edited, and final) from the 1997 Census of Agriculture. Users of our integrated and generalized Data Warehouse must navigate only seven tables--a central data table containing all the survey and census data, and six corresponding dimension tables that provide all the necessary metadata to access the data readily. These dimension tables allow slicing and dicing of the data by any combination of rich analytic attributes, such as state, county, survey, commodity, questionnaire item, demographic characteristics, mode of data collection, sample design, and respondent. NASS's survey and census programs are benefitting from utilizing this powerful Data Warehouse System.
Three lessons learned that were critical to the success of our implementation are: (1) selecting the dimensional or star schema design for our Data Warehouse, (2) choosing a data base that is optimized for very fast data loading and data access using this dimensional design, and (3) selecting a primary data access tool that is very approachable by users using a drag and drop/point and click user interface. Currently, simple queries from our 500 million record database, such as deriving a weighted total for a census item for a county or retrieving all responses in a state for a survey item from a particular survey, are impressively resolved in less than five seconds.
Our live demonstrations will illustrate the three critical success factors mentioned previously, namely: (1) our easy-to- understand dimensional data warehouse design, (2) the rapid query response times for ad-hoc queries against our data warehouse, and (3) the ease of using the system.

Credits

For more details on Single Source Solutions, please click to the Solutions Section of our web site. You may also connect with us as shown on our Contact Page, or fill out the Request for Consultation form. One of our representatives will contact you within 24 hours to discuss your needs and potential solutions.

to top

Home Site Map Contact NLG 877-OKWORLD

warehousing solution

Get Close to Your Customers Wherever They Are, and Whenever They Need You!

Our locations are strategically located to minimize costs and time to market. As a non asset based Logistics Group we can add centers as your geographical requirements change.

Warehousing Solution