【文章內(nèi)容簡介】 on and movement metadata with all other metadata activityThe Problems with Hand Codingw Writing COBOL to access multiple data sources as a coherent wholew Implementing a solution before user munity needs changew Gaining confidence of users by providing the right data from the right sourcesw No easy method for ensuring data consistency over timew Huge effort to change target DBMSThe DecisionBase Solution RepositorySimple Point ClickDevelopmentComplex TransformationsMade Easy+ +Unmatched data access from a variety of data sources, including ERP systems such as SAP R/3.SeamlessintegrationwithRepositoryThe DecisionBase Solutionw Generates code automaticallyw Combines data from multiple relational and nonrelational sources w Defines mappings quickly and graphicallyw Records transformations in Repository for future referencew Ensures data consistency through Repository technologyw Leverages ERwin data modelsInfoBeaconInfoReportsForest Trees Business ObjectsBrio *Cognos *DecisionBase TechnologyERwinData Design Mapper Workflow MetadataBrowserDataAcquisitionSAP/R3Flat FilesODBCVSAMSybaseInformixOracleDB2IMSMicrosoftDATASOURCESData WarehouseData MartDecisionBase ToolsDecisionBaseMetadataData Sources Targets w Oraclew Sybasew Microsoft SQL Serverw DB2/MVS and DB2 UDBw Informixw Flat files (both EBCDIC and ASCII)w SAP R/3 (source only)w AS/400w Various others via ODBCGraphical MappingDecisionBase WorkflowEnd User Toolsw Forest Treesw InfoBeaconw InfoReposrtsw Business Objects*w Cognos*w Brio*Single, integrated web browser–metadata, queries, Word documents all in one placeDecisionBaseMetadataExecute QueriesDecisionBase ArchitectureTARGETWAREHOUSESAP/R3InformixMETADATASOURCESDataMovementServerMetadataManagerMapperScanMetadataMap Transformations StoreMetadataGenerateMovementProgram Move DataFrom SourceDatabases toTarget? ODBCSybaseInformixOracleDB2MicrosoftDevelopment Environment Runtime EnvironmentSOURCEDATASAP/R3ODBCSybaseInformixOracleODBCDB2MicrosoftFlat Files? ?WorkflowHigh SpeedAggregationOption?Flat FilesInformixODBCVSAMSybaseOracleODBCDB2IMSMicrosoftCompetitive Advantagesw Single vendor solution– Data design: Erwin– Data movement: DecisionBase– Metadata: DecisionBase (based on the Microsoft Repository standard)– Data access: Forest Trees, InfoBeacon, w Integration with third party tools – Business Objects, Brio, CognosQ AThe Business ValuesChallenges? Liberalization Of Telemunication Industries in Year 2023? Merges and Acquisitions? Increase in Competition? Increase in Customer Sophistication? Uncertainty? Economic Climate? Which Way is the Industry Heading ?Monopolistic Market Liberalized MarketOpen MarketChallengesThe Rate of of Customer Acquisition is slowing downHigh Cost of AcquisitionHigh Churn RateWhy The Interest In Data ?Turning Data into Information to make Business Decisions? Anticipate Problems? Anticipate Trends? PredictionInformationHelps toTo Increase Business Competitive Advantage Through the Use of IT and InformationInformation is an ASSET to the OrganizationWhy The Interest In Data ? THE BOTTOM LINEUNDERSTAND THE CUSTOMER BETTER? Call Pattern? Service Item Usage? Payment Behavior? Customer Care? Response to Loyalty ProgramThe Information Warrior ? Knowledge? Customer Centric View? Identify New Services / Products? Identify and Control Escalating CostsAble to Deliver the Right Information to the Right Person at the Right Time in the Right FormatWhat Does Data Warehouse Offer ?What Does Data Warehouse Offer ?? Bringing together the data from disparate sources? Creating a single consistent view of corporate information? Transforming data into useful information? Delivering information to the right peopleKnowledge Management‘ Transforming Corporate Data into Information and Deliver the Information to the right people at the right time ‘ What Can You Do With The InformationSample of Key Performance IndicatorsChurnCall UsageCall DestinationNetwork AvailabilityActivation (Deactivation, Reactivation)CoverageSubscriber AnalysisResponsiveness to OrdersAnalysis of FaultsRevenueFraudDimensionTimeGeographicalCustomer SegmentProductCall PlanData Warehouse AnalysisMultidimensional AnalysisTrend AnalysisGeographical AnalysisComparative AnalysisException AnalysisRanking AnalysisCause and Effect AnalysisWhat If AnalysisInformationAnalysisData Warehouse AnalysisWhat is Data Warehouse Analysis and What Can It Do ? Data Warehouse Analysis“Data Warehouse Analytical Capability will help Decision Makers