...F4: DW Architecture and Lifecycle Erik Perjons, DSV, SU/KTH perjons@dsv.su.se The data warehouse architecture The back room The front room Analysis/OLAP Productt Product2 Product3 Product4 Time1 Time2 Time3 Time4 Value1 Value2 Value3 Value4 Value11 Value21 Value31 Value41 Data warehouse External sources Extract Transform Load Serve Query/Reporting Operational source systems Data marts Data mining Falö aöldf flaöd aklöd falö alksdf Operational source Data staging systems (RK) area (RK) Legacy systems Back end tools OLTP/TP systems Data presentation area (RK) ”The data warehouse” Presentation (OLAP) servers Data access tools (RK) End user applications Business Intelligence tools Operational Source Systems Operational source systems characteristics: Operational source systems • the source data often in OLTP (Online Transaction Processing) systems, also called TPS (Transaction Processing Systems) • high level of performance and availability • often one-record-at-a time queries • already occupied by the normal operations of the organisation OLTP vs. DSS (Decision Support Systems) OLTP vs. OLAP (Online analytical processing) Operational Source Systems More operational source systems characteristics: Operational source systems • a OLTP system may be reliable and consistent, but there are often inconsistencies between different OLTP systems • different types of data format and data structures in different OLTP systems AND DIFFERENT...
Words: 2902 - Pages: 12
...Word Module Page Strategy definition 1 Strategy evolution 1 Carl von Clausewitz 1 Adam smith 1 insivible hand 1 Competitive strategy 1 19; 20 Mintzberg 1 day-to-day operations vs strategy 1 Operationnal effectiveness vs strategic positioning1 Productivity frontier 1 mission, company 1 vision company 1 Strategic planning process 1 Leadership vs management 1 management vs leadership 1 Leadership definition 1 ethics and leadership 1 leadership and ethics 1 Friedman, 1 neoclassical economy 1 Sociioeconomic view of ethics 1 Stratetgy approaches 1 Appraoches to strategy 1 Rational approach, strategy 1 Ansoff 1 Processual approach 1 Loigcal incrementalism 1 planning vs crafting 1 crafting vs planning 1 Rational approach vs processual 1 evolutionary approach 1 Systemic approach 1 Startegic thinking 1 Strategic thinks vs planning 1 Startegic planning vs thinking 1 thinking vs planning 1 planning vs thinking 1 Fit vs stretch 1 Stretch vs fit 1 Levels of strategy 1 strategy level 1 Corporate strategy 1 Business strategy 1 functional strategy 1 global context of business 1 globalisation drivers 1 Competitive forces 1 technological forces 1 social forces 1 political forces 1 Globalisation challenges 1 Competition 1 distribution 1 macro-economic 1 socio-economic 1 financial 1 legal 1 Physical 1 Political 1 sociocultural 1 labour 1 technological forces 1 Globalisation...
Words: 2428 - Pages: 10
...Table of Contents EXECUTIVE SUMMARY 1 INTRODUCTION TO ENGRO PAKISTAN 2 FOOD INDUSTRY IN PAKISTAN 3 ENGRO FOODS 3 RESEARCH AND DEVELOPMENT AT ENGROFOODS 4 STRATEGIC INTERNAL AND EXTERNAL AUDIT 4 STEEPLE ANALYSIS 4 PORTER’S FIVE FORCES MODEL 6 THREAT OF NEW ENTRANTS 6 BARGAINING POWER OF SUPPLIERS 7 BARGAINING POWER OF BUYERS 7 AVAILABILITY OF SUBSTITUTES 7 COMPETITIVE RIVALRY 8 SWOT ANALYSIS 8 STRENGTH 8 WEAKNESSES 9 OPPORTUNITIES 10 THREATS 11 INDUSTRIAL SWOT ANALYSIS 12 IFA AND EFA FOR ENGROOFOODDS 15 COMPETITIVE PROFILE MATRIX (CPM) 17 CORE COMPETENCIES & KEY SUCCESS FACTORS 18 COMPETITIVE ANALYSIS 19 INTERNAL EXTERNAL (IE) MATRIX 20 GRAND STRATEGY MATRIX 21 SUGGESTIONS AND RECOMMENDATIONS 22 REFERENCES 23 Executive Summary The repot at hand provides useful overview about Engro Pakistan Ltd, a private fertilizer firm that keeps about 22 % of market share in the milk food industry Pakistan, established in 2005, a 100% owned subsidiary –First investment of dairy plant Processed milk market is growing at approx: 20% per year. Olper’s achieved peak market shares of 12.3% within 6 months of launch. Other products are launched such as –Olper’s Cream, OLwell –High Calcium Low Fat Milk (Premium Brand) Plans to expand product portfolio Milk processing capacity to increase by 200 million liters annually will become the only company in Pakistan covering the entire milk catchments area. It already has the 2ND largest cooled milk collection system in the country. Distribution network...
Words: 5753 - Pages: 24