SlideServe
Télécharger Obtenir Pro
Menu
Accueil Pro
Préférences
ApparenceLight Aide et commentaires
© SlideServe · v2026

Understanding Data Warehousing: Definitions, Benefits, and Risks

yves avatar
yves
8 diapositives · 215 Views · Oct 12, 2014

This document provides an overview of key data warehousing concepts, including definitions of data, information, databases, and data warehouses. It explains the purpose of a data warehouse, highlighting its role in collecting, merging, and storing data from various sources to aid decision-making. The benefits of data warehousing, such as improved consistency and quicker report generation, are discussed, alongside potential risks like data accuracy concerns and development costs. The text also outlines steps taken and proposed next actions for enhancing reporting options.

Understanding Data Warehousing: Definitions, Benefits, and Risks - slide 1
01 / 8Understanding Data Warehousing: Definitions, Benefits, and Risks
1 / 17

Télécharger la présentation

Understanding Data Warehousing: Definitions, Benefits, and Risks
Une image / un lien ci-dessous est fourni (tel quel) pour télécharger la présentation

Politique de téléchargement : le contenu du site vous est fourni TEL QUEL pour votre information et votre usage personnel ; il ne peut être vendu, concédé sous licence ni partagé sur d’autres sites sans l’accord de son auteur.Le contenu vous est fourni TEL QUEL, pour votre information et votre usage personnel uniquement. Téléchargez la présentation en cliquant sur ce lien. Lors du téléchargement, si vous ne parvenez pas à télécharger une présentation, l’éditeur a peut-être supprimé le fichier de son serveur.Pendant le téléchargement, si vous ne parvenez pas à obtenir une présentation, le fichier a peut-être été supprimé par l’éditeur.

F I N

Plus de contenu associé

Transcription de la présentation

  1. Data Warehousing - 101 January 16, 2009 Kristine Vreugdenhil, MS

  2. Definitions • Data - A collection of facts usually collected as the result of experience, observation or experiment. Datais often viewed as a lowest level of abstraction from which information and knowledge are derived. • Information - A collection of facts or data; the meaning given to data by the way it is interpreted. • Database - A structured collection of records or data.

  3. Definitions (continued) • Transactional Database – A database in which data is modified. Examples of Transaction Databases include BiTech, Zangle, Oasys, Edulog, etc. • Data Dictionary – A centralized repository of information about data such as meaning, relationships to other data, origin, usage and format.

  4. Definitions (continued) Data Warehouse – A copy of transaction data specifically structured and formatted for queries and reporting. A repository of an organization’s electronic data used for reporting and analysis. A well-designed data warehouse includes a data dictionary.

  5. Purpose of a Data Warehouse • To collect, merge, and store data, often from multiple sources or databases, for the purpose of decision-making and ongoing progress monitoring. • Pre-processing of data

  6. Data Warehouse Benefits • Central location for most-to-all reports. • Improved consistency and accuracy. • Fewer processing delays. • Transaction data is protected in a separate database. • New Reports may be added quickly with or without technology department intervention. • Ability to track data longitudinally.

  7. Data Warehouse Risks • Reports may not be used • Accuracy & relevancy of data • Potential for information overload • Staff education and learning curve • Development and maintenance costs • Is the value-added worth it?

  8. Progress to Date & Next Steps • Evaluation of reporting options – Fall 2007 • District staff needs assessment – February 2008 • Proposal for District Leadership staff – final draft completed