Montacargas-300px.png


Data Warehouse

What is it?   

Platform Service’s Data Warehouse consulting service consists in one or more of the following services:

  1. Consultation and advice on the design and architecture of a Data Warehouse

  2. Consultation on sizing the Data Warehouse (this group deal with Warehouses under 400 TB only, anything larger than that, or that will grow larger than that will need “Big Data” Warehouse management)

  3. Consultation and advice on the project plan and management of a Data Warehouse project

  4. Project management assistance for Data Warehouse projects


Who is it for?  

SIL org units with executive approval and funding for the current stage of the project (Investigation, Design, Development, Deployment).  


Who do I contact?

   Greg Della-Croce, IT Architect, Greg_Della-Croce@SIL.org, 407-408-2572

   


What GTIS does…  

GTIS will provide a person or persons knowledgeable in the concepts, design, development, and deployment of data warehouse and data marts at the corporate, unit, and front line of an organization.   This person will assist in:

  1. The dialog about the data warehouse (uses, strengths, weaknesses, resources needed)

  2. The size and growth projections of the Warehouse  

  3. The Architecture and design of a Data Warehouse to meet the needs of the group

  4. The project plan and management of deliverables to accomplish a quality and flexible warehouse

  5. The dialog about reporting, data marts, quality controls (including data governance and metadata), and long term maintenance of the warehouse


What you will do…  

You have an executive sponsor for the project, a list of initial and long term stakeholders who will be active in the project, and a line of resources (financial and people) that will be assigned to the project.   You will need to provide:

  1. A well thought through and approved description of the purpose of the Data Warehouse (GTIS can help you with this if needed)

  2. A committed group of people(2-5) that will take ownership of both the processes and the final product (including Data Governance and Metadata maintenance)

  3. Finances for the project that are appropriate to the stage of the project.

  4. Access to the development staff that will be needed for the stage of the project

  5. Access to the IT infrastructure that will host the Data Warehouse (Production and Development)

  6. Access to the data needed to “feed” the Data Warehouse (both for analysis, design, and production)

  7. Access to the people who will be using the Data Warehouse in production for specifications and testing.

  8. Access to other resources and people that will be needed throughout the project.
  9. Feedback about the service.