Preview

Huffman Trucking Data Warehouse Report

Good Essays
Open Document
Open Document
891 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Huffman Trucking Data Warehouse Report
Huffman Trucking Data Warehouse
Jason Raines
DBM/502
06/26/2014
Anup Majumder
Huffman Trucking Data Warehouse
Huffman trucking was founded by K Huffman in 1936 with a single tractor trailer. The massive and fast growth of the company was a direct result of WWII because of the increase in carrier services east to west. “By 1945, the fleet had increased in size to 16 tractors and 36 trailers. The business relationship forged with the U.S. Government continues today” (Apollo Group, 2012).This growth continued for Huffman when internal sales sky rocketed. Soon after Huffman acquired 5 eastern regional carries helping the company spread its business ventures further enabling more business to thrive. Huffman trucking has grown to 1,400 employees and has more than 800 trailers on the open road providing carrier services all over the country. Along with its growth Huffman has to think about securing it data and implementing a process in order to control this data. The implementation of a data warehousing project would greatly improve the integrity of their data.
The most important aspect of having data warehousing is the fact that it allows for data storage and presentation of this data enabling executives to make sound decisions. Another important use of data warehousing is it takes the separate areas the company is divided up in and takes it all and lumps it in to one single entity. One great benefit of data warehousing is that Huffman will be able to handle server task connected to all queries which is not commonly found in all systems. “Another powerful benefit of data warehouses is that they allow companies to use data modeling for querying tasks that are quite difficult for transaction processing” (Exforsys, 2007). Huffman trucking is already successful but by implementing a success data warehousing system they would be able to understand and analyze all data coming in and leaving the system better and at a more efficient rate. Attached to this report is a

You May Also Find These Documents Helpful

  • Good Essays

    Huffman Trucking is a large organization that provides transportation of goods and services to its customers. In order to better serve these customers and to compete and stay at a high level above other suppliers, Huffman Trucking management enlisted the assistance of Team B to upgrade their companies systems to be able to create, maintain, and report on a database, which tracks the servicing of Huffman Trucking vehicles.…

    • 686 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Service Request SR-ht-03

    • 569 Words
    • 2 Pages

    TechTarget says “Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles” (TechTarget pg. 1). This is exactly what Team A plans to accomplish for Huffman Trucking. Huffman Trucking is looking for fleet truck maintenance database to help keep track of all of their truck maintenance needs. The database began on April 1, 2013 and has a scheduled completion date on April 25, 2013. The scope of this service request is to keep track of parts, maintenance, vendors, and vehicles.…

    • 569 Words
    • 2 Pages
    Good Essays
  • Good Essays

    According to Service Request SR-ht-003, We were to develop a design for a fleet truck maintenance database, located on the Huffman Trucking IT Service Requests site. This paper will talk about how our team completed the Change Request that was on the Huffman Trucking Service Request.…

    • 820 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    As one of its goals, Huffman Trucking would like to be the industry leader in using its technology to the maximum efficiencies when providing their customer service and doing their day to day business. They are the first major freight carrier to outsource its information systems support. Their Finance and Accounting System applications are supported by Smith Systems Consulting and are integrated with the Flight Maintenance System and the Enterprise Transportation Application. These systems are tailored to capture the financial and accounting data and information related to the trucking business. Their system also allows them to maintain their customer data along with their historical sales. Marketing is able to make their plans and budgets electronically available to their management and present them as needed at sale meetings. The Sales Department has established a detailed database of its customers that can be shared with other team members. The Human Resource Department uses an HRIS system that was developed by in-house programmers that tracks employees operationally and financially. Smith Consulting has developed a system for Huffman Trucking and recommends that they convert over in order to further standardize their system.…

    • 474 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Huffman Trucking is a large company and has been around since the early 1900’s. When the company started there was one tractor trailer and now the corporation has seen quite an extensive progression throughout the years. With several types of trailers and large employee base the company has spread out and has facilities located all across the country from New Jersey to California. Huffman Trucking Company consulted with another company known as Smith Systems Consulting to develop entities and attributes for a database for the fleet truck maintenance, but was unable to complete the job successfully.…

    • 699 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Since the inception of the organization in 1936, Huffman trucking has grown their fleet of tractor-trailers from one to over 800 tractors, 2,100 45 foot trailers, and 260 roll on/ roll off units. Huffman trucking also employees 925 drivers and 425 technical support staff members, which is based from the increase in business that they have seen over the years from their acquisitions of five other freight companies. The mission of Huffman trucking is “to be a profitable, growing, adaptive company in an intensively competitive logistical services business environment”. Huffman Trucking according to the mission statement wants to be a competitive company within the logistics industry, and they also want to maintain the growth and profitability that they have experienced over the years. The vision statement of Huffman Trucking is “to be a model company to our stockholders, employees,…

    • 1443 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Trucking can convert certain of their assets to quick cash. It also tells how many times on…

    • 447 Words
    • 2 Pages
    Good Essays
  • Better Essays

    the company in choosing to keep all these OS, it is important that they are listed and described…

    • 1042 Words
    • 5 Pages
    Better Essays
  • Good Essays

    Huffman Trucking, a major national freight carrier has encountered tremendous growth over the past few years. The company now has over 1300 employees, 800 road tractors and 2100 trailers. The company has a diverse customer base and shipping ability. Management has realized that the company’s automated information systems infrastructure is lagging. To solve this problem management has decided to implement an Enterprise Resource Planning (ERP) system. Customer sales, orders, tracking, delivery, Maintenance, scheduling and accounting will all be integrated by the ERP.…

    • 1151 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Huffman trucking is a national transportation company that employs 1,400 people to work in its logistical hubs in Los Angeles, California, St. Louis, Missouri, and Bayonne, New Jersey, with its central maintenance facility located in Cleveland, Ohio.…

    • 608 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    To provide Huffman trucking with a comprehensive database the design team will first develop the requirements. During the requirements stage the team will conduct interviews with all the stakeholders as well as gather sample forms, reports, queries, and descriptions of all activities involved with the fleet maintenance process. The second portion of the requirements stage is for the team to create prototypes and working demonstrations of the proposed solution. These prototypes will be used to obtain additional feedback from the stakeholders and create the fine tune the database requirements (Kroenke & Auer, , 2010).…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    This document is a proposal for building a data warehouse architecture that will consolidate and transform data into useful information for the purpose of decision-making and for establishing a new function that offers a broad array of decision support services to all units at ABC Retail Chain Corporation. Executives and decision-makers often need information to analyze the past, describe current circumstances, and anticipate the future. Presently, decision-makers across the Institute rely on hard copy reports or Excel Sheets to provide information. Typically, any request for information is forwarded to the operational areas of the Organization, which provide hard copy reports reflecting the data gathered in their functional area. To analyze and transform data into useful information, decision-makers and their staff have to manually re-enter the non-integrated data into their own mini-systems. This type of operation hinders the ability of decision making and the executives are either drowning in too much data with no option to analyze it or too little data, which means they are back to square one and must request additional information. Often executives receive multiple, conflicting information or information that is based on incomplete assumptions about the types of analysis required.…

    • 641 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Our Internet based company with the gross revenues of more than $35 million dollars per year. We are planning to merge with multinational company of equal size. Our company currently uses operational systems and relational databases but desire to expand into data warehousing. We will be integrating different technologies from different solution providers and incorporate industry best practices in connection with the development of technological system.…

    • 1179 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Huffman recognized several years ago the inefficiencies of manually tracking their vast fleet of trucks, not knowing the exact location of their fleet at any given time, and accurate time of pickup and delivery to the…

    • 745 Words
    • 3 Pages
    Good Essays
  • Good Essays

    A shared database needs to be created so that all hub locations of Huffman Trucking can access information pertaining to the maintenance of the trucks in the fleet. The project will reduce the amount of time that the trucks in the fleet are off the road by having the parts in stock to handle all of the maintenance. Keeping more trucks on the road will maximize revenue for the company.…

    • 690 Words
    • 3 Pages
    Good Essays