Application Case 3.1 A Better Data Plan Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Questions for Discussion 1. What are the main challenges for tElcOs? 2. How can data warehousing and data analytics help tel COs in overcoming their challenges? 3. Why do you think telcos are well suited to take full advantage of data analytics? Pearson Copyright C 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved Application Case 3.1 A Better Data Plan: Well-Established TELCOs Leverage Data Warehousing and Analytics to Stay on Top in a Competitive Industry Questions for Discussion 1. What are the main challenges for TELCOs? 2. How can data warehousing and data analytics help TEL COs in overcoming their challenges? 3. Why do you think TELCOs are well suited to take full advantage of data analytics?
DW for Data-Driven Decision Making An example of a DW supporting data-driven decision making in automotive industry Data Warehouse One management and analytics platform for product configuration, warranty, and diagnostic readout dat Reduced Produced Warranty mproved Cost of IT Architecture ure Infrastructur Expenses Accurate Standardization Expense Improved reimbursement Faster identification Environmental ne strate 2/3 cost reduction through accuracy through improved prioritization, and resolution Performance business intelligence and data mart consolidation claim data quality of quality issues Reporting compliance reporting Pearson Copyright C 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved DW for Data-Driven Decision Making • An example of a DW supporting data-driven decision making in automotive industry Data Warehouse One management and analytics platform for product configuration, warranty, and diagnostic readout data Reduced Infrastructure Expenses 2/3 cost reduction through data mart consolidation Produced Warranty Expenses Improved reimbursement accuracy through improved claim data quality Improved Cost of Quality Faster identification, prioritization, and resolution of quality issues Accurate Environmental Performance Reporting IT Architecture Standardization One strategic platform for business intelligence and compliance reporting
A Generic Dw framework Data Applications Sources No data marts option (Visualization) Marts Routine ERP Bus E Process Reporting Data mart Select Metadata Data/text Ex Transform Enterprise (Operations) POS Data warehous OLAP Integrate Data mart ashoka OLTP/eb Data mart Custom built External applications Pearson Copyright C 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved A Generic DW Framework Data Sources ERP Legacy POS Other OLTP/Web External Data Select Transform Extract Integrate Load ETL Process Enterprise Data warehouse Metadata Replication A P I / Middleware Data/text mining Custom built applications OLAP, Dashboard, Web Routine Business Reporting Applications (Visualization) Data mart (Operations) Data mart (Marketing) Data mart (Finance) Data mart (...) Data Marts No data marts option
DW Architecture Three-tier architecture 1. Data acquisition software(back-end) 2. The data warehouse that contains the data software 3. Client (front-end) software that allows users to access and analyze data from the warehouse Two-tier architecture First two tiers in three-tier architecture are combined into one sometimes there is only one tier? Pearson Copyright C 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved DW Architecture • Three-tier architecture 1. Data acquisition software (back-end) 2. The data warehouse that contains the data & software 3. Client (front-end) software that allows users to access and analyze data from the warehouse • Two-tier architecture – First two tiers in three-tier architecture are combined into one … sometimes there is only one tier?
DW Architectures 3-tier architecture 日日 Tier 1 Tier 2. Tier 3. Client workstation Application server Database server 2-tier 1-tier architecture Architecture? Client workstation Application database server Pearson Copyright C 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved
Copyright © 2018, 2014, 2011 Pearson Education, Inc. All Rights Reserved DW Architectures 3-tier architecture Tier 2: Application server Tier 1: Client workstation Tier 3: Database server 2-tier architecture Tier 1: Client workstation Tier 2: Application & database server 1-tier Architecture?