Sistema para Registro de Pedidos Mediante GSM/GPRS PACASA

Sistema para Registro de Pedidos Mediante GSM/GPRS PACASA

Parte 2 El aspecto tcnico de Datawarehousing en el mundo real Hector Figueroa ([email protected]) Regional Directors aren't Microsoft employees--they're independent developers, architects, trainers, and other professionals who provide a vital link between Microsoft and the developer community. These technical experts can give you the insight and informed perspective you need to start developing .NET-connected software today--whether you need help learning about the .NET Framework, training developers, or implementing all aspects of a solution. Contact a Microsoft-endorsed Regional Director to kick off your project today. Charla en Cuatro Partes

Parte 1: Requerimientos esenciales antes de comenzar una implementacin en la institucin Parte 2: Objetivos y roles formales para dar comienzo, continuidad y evolucin a su Datawarehouse

Parte 3: Organizar objetivos institucionales sobre la informacin que la organizacin requiere en todos los niveles para ser competitiva y rentable Parte 4: Cmo se establece el ciclo de mejoramiento continuo utilizando las herramientas de SQL2005 / Anlisis Services DW en el Mundo Real Parte 2

Agenda: DataMarts = Roles Formales Separacin y Granularidad en Diseo Monitoreo y Adaptabilidad Crecimiento y Seguimiento (Ao a Ao) Considerar las nuevas posibilidades en Dimensiones DataMarts = Roles OLAP Datawarehouse DataMart DataMart

DataMart DataMart DataMart Separacin y Granularidad Evaluaciones Datos OLAP Decisiones

Informacin Separacin y Granularidad OLAP Team Datos Evaluaciones Decisiones Informacin Monitoreo y Adaptabilidad

Implementacin Piramidal: Al Alto Nivel DW Administrator Al Bajo Nivel DW en el Mundo Real Parte 2 Crecimiento y Seguimiento (Ao a Ao) Las comparaciones de ao a ao requieren de particiones en el Analysis Services 2003 Est Oest

Sur e Nortee Comida Bebida Herramientas Deportes 2004 2005 2006 Nuevas Posibilidades (GIGO) Windows 2003

SQL 2005 Internet Information Server Facturacin y Cobranza Ren Lan TCP/IP ISA Server (Firewall) A B C

D E F G H SEL ECT ED ON-L INE ALO Internet Pblico

GSM/GPRS Ventas Table PC Ventas Pocket PC Nuevas Posibilidades Write-Backs: La nueva informacin (cubos) produce nuevos datos

Estos datos en combinacin con el almacn producen nuevas dimensiones y medidas Resumen Los roles en el DW son reales, permanentes y dinmicos Un supervisor a tiempo completo para el

DW es necesario Herramientas como el Analysis Services facilitan la inclusin de datos histricos en el anlisis comparativo Un DW administrado provee nuevas posibilidades para anlisis permanentemente Final de Parte 2 El aspecto tcnico de Datawarehousing en el mundo real Hector Figueroa ([email protected])

Recently Viewed Presentations

  • מודל מוכר העיתונים newsvendor model

    מודל מוכר העיתונים newsvendor model

    מודל מוכר העיתונים newsvendor model newsvendor model מודל שמטרתו לקבוע מלאי אופטימאלי של מוצרים, כאשר למוכר (או למנהל הרכש) אפשרות אחת ויחידה להזמין את המוצרים, לפני שמתחיל הביקוש.
  • GI Histology 1 - Med Study Group

    GI Histology 1 - Med Study Group

    Water, vitamins, and minerals are also absorbed from ingested food. In addition, the inner layer of the digestive tract is a protective barrier between the content of the tract's lumen and the internal milieu of the body.
  • Marine Medical Group Patient Participation Group Supporting patients

    Marine Medical Group Patient Participation Group Supporting patients

    Marine Medical Group Patient Participation Group. ... Blyth PCN. 1 of 6 PCNs in the county. Recruited 2 Link Workers and a Pharmacist. 3rd Link Worker to be recruited by April 2020. Meet patients a few times. Assess needs and...
  • Hook em!  I recommend starting the unit or

    Hook em! I recommend starting the unit or

    Tropical Easterlies: From 0-30 degrees latitude (aka Trade Winds). Jet Streams. Jet Streams function as steering currents for air masses and as zonal boundaries for sharp differences in temperature. Jets are something like "rivers of air" found at high altitudes...
  • Nematodes and Tree Fruits

    Nematodes and Tree Fruits

    Cause mechanical injury to cells and tissues Cause cell death Modify cell development Modify cell function Disrupt uptake of water and nutrients Alter photosynthate partitioning Create avenues of ingress Predispose plants to other stresses Signs and symptoms…..
  • Mining Latent Entity Structures

    Mining Latent Entity Structures

    Lift(B, C) may tell how B and C are correlated. Lift(B, C) = 1: B and C are independent > 1: positively correlated < 1: negatively correlated. For our example, Thus, B and C are negatively correlated since lift(B, C)...
  • Prefix Prefix or Suffix  Prefix or Suffix  Suffix

    Prefix Prefix or Suffix Prefix or Suffix Suffix

    Prefix Prefix or Suffix Prefix or Suffix Suffix Prefix 100 100 100 100 100 200 200 200 200 200 300 300 300 300 300 400 400 400 400 400 500 500 500 500 500 Pertaining to self Auto- against Anti-...
  • To Kill a Mockingbird Vocabulary Vocab Cards Bac

    To Kill a Mockingbird Vocabulary Vocab Cards Bac

    Chapter 1. assuage: to soothe, to ease apothecary: pharmacist, druggist. taciturn: reluctant to speak. quaint: old-fashioned. flivver: a junky old car. malevolent ...