LES15 Supporting End-User Access 数据仓库英文oracle99版 教学课件.ppt

Schedule: Timing Topic xx minutes Lecture xx minutes Practice xx minutes Total Supporting End-User Access Overview Project Management (Methodology, Maintaining Metadata) DefiningDW Concepts Terminology Planningfor a SuccessfulWarehouse AnalyzingUser QueryNeeds Choosing aComputingArchitecture Modeling the DataWarehouse PlanningWarehouseStorage ETT(Building theWarehouse) Meeting aBusinessNeed Managing the Data Warehouse SupportingEnd UserAccess Lesson Aim Enter lesson aim here. Objectives After completing this lesson, you should be able to do the following: Describe the importance of business intelligence Identify multidimensional query techniques Identify where data mining might be employed in a warehouse environment Identify data mining tools Gartner Group What Is Business Intelligence? 揃usiness Intelligence is the process of transforming data into information and through discovery transforming that information into knowledge.? Business Intelligence The purpose of business intelligence is to convert the volume of data into value for the end users. Decision Knowledge Information Data Stages (4) Volume Value Multidimensional Query Techniques Slicing Dicing Drillingdown Product Time Geography What? Why? Why? Why? Multidimensional Query Techniques Drilling up Drillingacross Pivoting What? Why? Why? Why? Categories of Business Intelligence Tools Reporting tools Query tools (data access) On-line analytical reporting (OLAP) tools Analytical suites Data mining tools Analytical applications Instructor Note For as long as there has been electronic data storage, there has been reporting. The evolution of reporting has been driven by the evolution of business systems and the constant drive for the expedient delivery of data to users. Mainframe In the mainframe era, batch reporting generated large, cumbersome reports. These reports were constructed from time consuming, difficult to