ppt课件-online analytical processing（在线分析处理）.pptVIP

* * * * * Business Intelligence - 1 BUS 782 Topics Scenario Management Chart Online Analytical Process, OLAP Excel’s Pivot table/Pivot chart Import/Export Data Scenario A scenario is an assumption about input variables. Excel’s Scenarios is a what-if-analysis tool. A scenario is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results. Data/What If analysis/Scenario Creating a Scenario Add scenario Changing cells Scenario Summary Resulting cells Demo: benefit.xls Charts Charting Decision Rules An Internet Service Provider charges customers based on hours used: First 10 hours $15 Each of the next 20 hours $2 per hour Hours over 30 hours $1 per hour Comparing Decision Rules Plan 2: First 20 hours: $20 Hours over 20 $1.5 Plan 3: $35 unlimited access. Charting Functions Demand function: P = 150 – 6*Q^2 Supply function: P = 10* Q^2 + 2*Q Note: Positive area Value axis maximum/minimum value: Format Value Axis Chart Stock Market Data Download Dow Jones Historical Data Yahoo/Finance/Dow/Historical Prices Enter criteria Copy/Paste to Excel To chart: Insert/Chart/Other Charts/Stock chart On-Line Analytical Processing (OLAP) Tools The use of a set of graphical tools that provides users with multidimensional views of their data and allows them to analyze the data using simple windowing techniques OLAP Operations Cube slicing–come up with 2-D view of data Drill-down–going from summary to more detailed views Roll-up – the opposite direction of drill-down Reaggregation – rearrange the order of dimensions Slicing a data cube Example of drill-down Summary report Drill-down with color added Starting with summary data, users can obtain details for particular cells Excel’s Pivot Table Insert/Pivot Table or Pivot Chart Drill down, rol