Flylib.com
List of Figures
Previous page
Table of content
Next page
Chapter 1: Equipping the Organization for Effective Decision Making
Figure 1-1: Three keys to effective decision making
Figure 1-2: Required elements of a goal to be used in effective decision making
Figure 1-3: Measuring progress toward the goal
Figure 1-4: Aboard the Titanic, feedback information was not given to the decision makers in a timely manner.
Chapter 2: Making the Most of What You've Got—Using Business Intelligence
Figure 2-1: Specific goals at each level of the organization
Figure 2-2: Concrete measures at each level of the organization
Figure 2-3: Timing of the foundation and feedback information at each level of the organization
Figure 2-4: Sources for business intelligence at Max Min, Inc.
Chapter 3: Searching for the Source—The Source of Business Intelligence
Figure 3-1: The SalesFact table
Figure 3-2: The star schema
Figure 3-3: Attribute columns in the dimension tables
Figure 3-4: A star schema with hierarchies
Figure 3-5: The snowflake schema
Chapter 4: One-Stop Shopping—The Unified Dimensional Model
Figure 4-1: Total Sales cube
Figure 4-2: Total Sales cube with an aggregation for John's total sales for April
Figure 4-3: Total Sales cube with an aggregation for total sales for all salespersons for April
Figure 4-4: OLAP Architectures
Figure 4-5: Creating a cached web page in Internet Information Services
Figure 4-6: Retrieving a web page from the Internet Information Services Page Cache
Figure 4-7: Updating the Internet Information Services Page Cache when a web page is modified
Figure 4-8: Proactive caching with a Unified Dimensional Model
Figure 4-9: Even the first user receives the requested aggregate from the Proactive Cache.
Figure 4-10: The Proactive Cache is deleted and re-created in response to changes in the data source.
Chapter 5: First Steps—Beginning the Development of Business Intelligence
Figure 5-1: Business Intelligence Development Studio on the Start menu
Figure 5-2: The New Project Toolbar button
Figure 5-3: The New Project dialog box
Figure 5-4: The Business Intelligence Development Studio with an empty Analysis Services project
Figure 5-5: The Solution Explorer window with the View Code and View Designer Toolbar buttons
Figure 5-6: The Properties window with categorized properties
Figure 5-7: Displaying the Toolbox window when it is set to auto hide
Figure 5-8: The View menu
Figure 5-9: Toolbar buttons for opening Business Intelligence Development Studio windows
Figure 5-10: The Task List window
Figure 5-11: The Error List window
Figure 5-12: The Output window
Figure 5-13: The Find Results 1 window
Figure 5-14: The Designer window with the Dimension, Cube, and Data Source View designers open
Figure 5-15: Changing a window's state
Figure 5-16: The Solution Explorer as a floating window
Figure 5-17: The Properties window and the Solution Explorer window combined in a Tabbed window
Figure 5-18: The Solution Explorer window in a tabbed grouping on the Designer window
Figure 5-19: The Options dialog box
Figure 5-20: The Designer window with an MDI interface
Figure 5-21: Fonts and Colors options
Figure 5-22: Projects and Solutions—General options
Figure 5-23: SQL Server Management Studio on the Start menu
Figure 5-24: Connecting to a server on startup
Figure 5-25: The SQL Server Management Studio Default window layout
Figure 5-26: Registering a new server
Figure 5-27: The New Server Registration dialog box
Figure 5-28: Server groups in the Registered Servers window
Figure 5-29: Server types in the Registered Servers window
Figure 5-30: The Object Explorer window
Figure 5-31: The New Query Toolbar button
Figure 5-32: The SQL Server Management Studio with a SQL Server Query window
Figure 5-33: The SQL Server Management Studio with a solution and a project
Chapter 6: Building Foundations—Creating and Populating Data Marts
Figure 6-1: An Analysis Services cube receiving data from a data mart
Figure 6-2: The Unified Dimensional Model eliminates the need for a data mart
Figure 6-3: Situations where UDM cannot be used
Figure 6-4: Designing the measures in a data mart
Figure 6-5: Designing the dimensions and hierarchies in a data mart
Figure 6-6: Designing the attributes in a data mart
Figure 6-7: A star schema
Figure 6-8: A snowflake schema
Figure 6-9: Requested measures for the Manufacturing data mart
Figure 6-10: Finalized measures for the Manufacturing data mart
Figure 6-11: Requested dimensions for the Manufacturing data mart
Figure 6-12: Finalized dimensions and hierarchies for the Manufacturing data mart
Figure 6-13: Finalized attributes for the Manufacturing data mart
Figure 6-14: The Manufacturing data mart schema with measures in a fact table
Figure 6-15: The Manufacturing data mart schema with dimension tables added
Figure 6-16: The Manufacturing data mart schema with hierarchies added
Figure 6-17: The completed Manufacturing data mart schema
Figure 6-18: Building the relational data mart
Figure 6-19: The Database folder Context menu
Figure 6-20: The New Database dialog box
Figure 6-21: The SQL Server Management Studio ready to create a table
Figure 6-22: The tables in the MaxMinManufacturingDM with columns (Part 1)
Figure 6-23: The tables in the MaxMinManufacturingDM with columns (Part 2)
Figure 6-24: Selecting multiple fields to create a compound primary key
Figure 6-25: Entering the Tables and Columns Specifications for a foreign key
Figure 6-26: Activating the field drop-down list in the Tables and Columns dialog box
Figure 6-27: Setting the drop-down lists to <None> in the Tables and Columns dialog box
Figure 6-28: The tables in the MaxMinManufacturingDM with columns and keys (Part 1)
Figure 6-29: The tables in the MaxMinManufacturingDM with columns and keys (Part 2)
Figure 6-30: Building the Sales relational data mart and the Sales Analysis Services cube
Figure 6-31: After selecting measures in the Cube Wizard
Figure 6-32: The MaxMinSales cube preview in the Cube Wizard
Figure 6-33: The Schema Generation Progress dialog box with a successful process completion
Figure 6-34: The Schema Generation Progress dialog box after an error has occurred
Figure 6-35: The Max Min Sales star schema
Chapter 7: Fill'er Up—Using Integration Services for Populating Data Marts
Figure 7-1: The Integration Services package design layout in the Business Intelligence Development Studio
Figure 7-2: The Integration Services package structure Control Flow tab
Figure 7-3: The Integration Services package structure Data Flow Designer tab
Figure 7-4: The Integration Services package structure Event Handlers Designer tab
Figure 7-5: Defining a data flow task in an event handler control flow
Figure 7-6: Creating control flow tasks from the Toolbox
Figure 7-7: Setting the properties of a task using the task's Editor dialog box
Figure 7-8: Making a precedence connection between two tasks
Figure 7-9: The precedence arrow
Figure 7-10: The precedence arrow Context menu
Figure 7-11: A control flow task with a second precedence arrow
Figure 7-12: Using precedence arrows to make a complex sequence of tasks
Figure 7-13: The Precedence Constraint Editor dialog box
Figure 7-14: The Back Up Database Task dialog box
Figure 7-15: The database selection drop-down box
Figure 7-16: The Check Database Integrity Task dialog box
Figure 7-17: The Execute SQL Server Agent Job Task dialog box
Figure 7-18: The Execute T-SQL Statement Task dialog box
Figure 7-19: The History Cleanup Task dialog box
Figure 7-20: The Notify Operator Task dialog box
Figure 7-21: The Rebuild Index Task dialog box
Figure 7-22: The Reorganize Index Task dialog box
Figure 7-23: The Shrink Database Task dialog box
Figure 7-24: The Update Statistics Task dialog box
Figure 7-25: A For Loop container in a control flow
Figure 7-26: The For Loop Editor dialog box
Figure 7-27: The Nightly Transfer package using a Foreach Loop container
Figure 7-28: The Collection page of the Foreach Loop container in the Nightly Transfer package
Figure 7-29: Sequence Container 1 is showing its content. Sequence Container 2 is hiding its content.
Figure 7-30: The Script page of the ActiveX Script Task Editor dialog box
Figure 7-31: The Analysis Services Execute DDL Task Editor dialog box
Figure 7-32: The Analysis Services Processing Task Editor dialog box
Figure 7-33: The Bulk Insert Task Editor dialog box
Figure 7-34: The Mining Model tab of the Data Mining Query Task Editor dialog box
Figure 7-35: The Execute DTS 2000 Package Task Editor dialog box.
Figure 7-36: The Execute Package Task Editor dialog box
Figure 7-37: The Execute Process Task Editor dialog box
Figure 7-38: The Execute SQL Task Editor dialog box
Figure 7-39: The File System Task Editor dialog box
Figure 7-40: The File Transfer Protocol Task Editor dialog box
Figure 7-41: The Message Queue Task Editor dialog box
Figure 7-42: The Script Task Editor dialog box
Figure 7-43: The Script Editing window
Figure 7-44: The Send Mail Task Editor dialog box
Figure 7-45: The Web Service Task Editor dialog box
Figure 7-46: The WMI Data Reader Task Editor dialog box
Figure 7-47: The WMI Event Watcher Task Editor dialog box
Figure 7-48: The XML Task Editor dialog box
Figure 7-49: The Component Properties tab of the Advanced Editor for DataReader Source dialog box
Figure 7-50: The Excel Source Editor dialog box
Figure 7-51: The General page of the Flat File Connection Manager Editor dialog box
Figure 7-52: The Columns page of the Flat File Connection Manager Editor dialog box
Figure 7-53: The Advanced page of the Flat File Connection Manager Editor dialog box
Figure 7-54: The Connection Manager page of the OLE DB Source Editor dialog box
Figure 7-55: The Query Builder
Figure 7-56: The Advanced Editor for the Raw File Source dialog box
Figure 7-57: The XML Source Editor dialog box
Figure 7-58: The Aggregate Transformation Editor dialog box
Figure 7-59: The Audit Transformation Editor dialog box
Figure 7-60: The Character Map Transformation Editor dialog box
Figure 7-61: The Configure Error Output dialog box
Figure 7-62: The Conditional Split Transformation Editor dialog box
Figure 7-63: A Conditional Split transformation in a data flow
Figure 7-64: The Copy Column Transformation Editor dialog box
Figure 7-65: The Data Conversion Transformation Editor dialog box
Figure 7-66: The Mining Model tab of the Data Mining Query Transformation Editor dialog box
Figure 7-67: The Derived Column Transformation Editor dialog box
Figure 7-68: The Export Column Transformation Editor dialog box
Figure 7-69: The Columns tab of the Fuzzy Grouping Transformation Editor dialog box
Figure 7-70: The Advanced tab of the Fuzzy Grouping Transformation Editor dialog box
Figure 7-71: The Reference Table tab of the Fuzzy Lookup Transformation Editor dialog box
Figure 7-72: The Advanced Editor for Import Column dialog box
Figure 7-73: The Advanced tab of the Lookup Transformation Editor dialog box
Figure 7-74: The Merge Transformation Editor dialog box
Figure 7-75: The Merge Join Transformation Editor dialog box
Figure 7-76: The Multicast Transformation Editor dialog box
Figure 7-77: The Advanced Editor for OLE DB Command dialog box
Figure 7-78: The Percentage Sampling Transformation Editor dialog box
Figure 7-79: The Advanced Editor for Pivot dialog box
Figure 7-80: The Advanced Editor for Row Count dialog box
Figure 7-81: The Row Sampling Transformation Editor dialog box
Figure 7-82: The Inputs and Outputs page of the Script Transformation Editor dialog box
Figure 7-83: The Microsoft Visual Studio for Applications dialog box
Figure 7-84: The Select a Dimension Table and Keys page of the Slowly Changing Dimension Wizard
Figure 7-85: The Slowly Changing Dimension Columns page of the Slowly Changing Dimension Wizard
Figure 7-86: The Historical Attribute Options page of the Slowly Changing Dimension Wizard
Figure 7-87: The results of the Slowly Changing Dimension Wizard
Figure 7-88: The Sort Transformation Editor dialog box
Figure 7-89: The Advanced tab of the Term Extraction Transformation Editor dialog box
Figure 7-90: The Term Lookup tab of the Term Lookup Transformation Editor dialog box
Figure 7-91: The Union All Transformation Editor dialog box
Figure 7-92: The Unpivot Transformation Editor dialog box
Figure 7-93: The Variables window
Figure 7-94: The Event Handlers tab
Figure 7-95: The Advanced Editor for Row Count dialog box
Figure 7-96: The Providers and Logs tab of the Configure SSIS Logs dialog box
Figure 7-97: The Details tab of the Configure SSIS Logs dialog box
Figure 7-98: Sample Integration Services package
Figure 7-99: Transactions created when executing the Sample Integration Services package
Figure 7-100: The Set Breakpoints dialog box
Figure 7-101: The Configure Data Viewer dialog box
Figure 7-102: Data Viewer windows
Chapter 8: Cubism—Measures and Dimensions
Figure 8-1: The InventoryFact table
Figure 8-2: The Data Flow tab for the Load DimBatch Data Flow task
Figure 8-3: The Data Flow tab for the Load ManufacturingFact Data Flow task
Figure 8-4: The Data Flow tab for the Load InventoryFact Data Flow task
Figure 8-5: The Control Flow tab for the FactLoad.dtsx package
Figure 8-6: The Data Source View Design tab for the Max Min Manufacturing DM data source view
Figure 8-7: The Business Intelligence Development Studio windows after the Cube Wizard completes
Figure 8-8: Measure groups and dimensions
Figure 8-9: The Calculations tab
Figure 8-10: The Calculated Member form view
Figure 8-11: The Script view
Figure 8-12: Setting the aggregate function for a measure
Figure 8-13: Inventory level is a semiadditive measure.
Figure 8-14: The Max Min Manufacturing DM cube with the Inventory Fact measure group
Figure 8-15: The Dimension Design tab with the Dim Product dimension
Figure 8-16: The modified Dim Time dimension
Figure 8-17: The Dimension Usage tab of the Max Min Manufacturing DM cube
Figure 8-18: The Define Relationship dialog box for a fact dimension
Figure 8-19: An employee table with a self-referential field
Figure 8-20: The state of the salesperson Type 1 SCD in May
Figure 8-21: The state of the salesperson Type 1 SCD after August
Figure 8-22: The state of the salesperson Type 2 SCD in May
Figure 8-23: The state of the salesperson Type 2 SCD after August
Chapter 9: Bells and Whistles—Special Features of OLAP Cubes
Figure 9-1: The Project Property Pages dialog box
Figure 9-2: Deploying an Analysis Services project from the Business Intelligence Development Studio
Figure 9-3: The Browse window in the SQL Server Management Studio
Figure 9-4: Browsing the Max Min Manufacturing DM cube
Figure 9-5: Two levels of rows in the Browse window
Figure 9-6: Adding a column level to the Browse window
Figure 9-7: Two levels of rows and columns in the Browse window
Figure 9-8: Dragging an item off the Pivot table
Figure 9-9: The Specify Source Analysis Services Database page of the Analysis Services Deployment Wizard
Figure 9-10: The Installation Target page of the Analysis Services Deployment Wizard
Figure 9-11: The Specify Options for Partitions and Roles page of the Analysis Services Deployment Wizard
Figure 9-12: The Specify Configuration Properties page of the Analysis Services Deployment Wizard
Figure 9-13: The Select Processing Options page of the Analysis Services Deployment Wizard
Figure 9-14: The Confirm Deployment page of the Analysis Services Deployment Wizard
Figure 9-15: The Deploying Database page of the Analysis Services Deployment Wizard
Figure 9-16: The Deployment Script loaded in a SQL Server Management Stuclio XMLA Query window
Figure 9-17: Creating a linked object
Figure 9-18: The Select Objects page of the Linked Object Wizard
Figure 9-19: A cube definition with linked objects
Figure 9-20: Launching the Business Intelligence Wizard
Figure 9-21: The KPIs tab on the Cube Design tab
Figure 9-22: The Browser View toolbar button
Figure 9-23: The KPI browser with the Percent Rejected KPI for the entire cube
Figure 9-24: The KPI browser with the Percent Rejected KPI for January 1, 2005
Figure 9-25: The Actions tab on the Cube Design tab
Figure 9-26: The Partitions tab on the Cube Design tab
Figure 9-27: A partitioned view
Figure 9-28: A measure group with multiple partitions from multiple relational tables
Figure 9-29: A measure group with multiple partitions from a single relational table
Figure 9-30: Creating a New Named Query
Figure 9-31: The ManufacturingFact 2003 Named Query definition
Figure 9-32: The Manufacturing Fact measure group with three partitions
Figure 9-33: The Storage Settings dialog box
Figure 9-34: The General tab of the Storage Options dialog box
Figure 9-35: The Notifications tab of the Storage Options dialog box
Figure 9-36: The Specify Object Counts page of the Aggregation Design Wizard
Figure 9-37: The Set Aggregation Options page of the Aggregation Design Wizard
Figure 9-38: The Partitions tab with aggregation design completed
Figure 9-39: The Enable Writeback dialog box
Figure 9-40: The Partitions tab with a writeback partition
Figure 9-41: The Perspectives tab
Figure 9-42: The Translations tab
Figure 9-43: The Select Language dialog box
Chapter 10: Writing a New Script—MDX Scripting
Figure 10-1: A simplified Max Min Manufacturing DM cube
Figure 10-2: The Dim Product dimension
Figure 10-3: The path to the Dragon w/Knight product
Figure 10-4: The path to the WWII product type
Figure 10-5: A shortcut path to the WWII product type
Figure 10-6: A more complex version of the Max Min Manufacturing DM cube
Figure 10-7: A tuple with one dimension omitted
Figure 10-8: Another aggregate cell in the Max Min Manufacturing DM cube
Figure 10-9: A multicell set
Figure 10-10: A cell group requiring a set
Figure 10-11: A cell group using a set with ranges
Figure 10-12: The Set Default Member dialog box
Figure 10-13: The Dim Time dimension with revised hierarchy level names
Figure 10-14: The Dim Product dimension with revised hierarchy level names
Figure 10-15: The Dim Machine dimension with revised hierarchy level names
Figure 10-16: The Dim Batch dimension with revised hierarchy level names
Figure 10-17: Comparing measures from two cells using relative location
Figure 10-18: MDX relative position functions within the same hierarchy
Figure 10-19: MDX immediate relative position functions within the same hierarchy
Figure 10-20: MDX distant relative position functions within the same hierarchy
Figure 10-21: The General page of the Role Design tab
Figure 10-22: The Membership page of the Role Design tab
Figure 10-23: The Data Sources page of the Role Design tab
Figure 10-24: The Cubes page of the Role Design tab
Figure 10-25: The Cell Data page of the Role Design tab
Figure 10-26: The Dimensions page of the Role Design tab
Figure 10-27: The Basic tab of the Dimension Data page of the Role Design tab
Figure 10-28: The Advanced tab of the Dimension Data page for the Dim Machine dimension
Figure 10-29: The Advanced tab of the Dimension Data page for the Dim Product dimension
Figure 10-30: The Browser tab using administrative credentials
Figure 10-31: The Security Context dialog box
Figure 10-32: The Browser tab using the Kawaguchi Plant security role
Figure 10-33: The Prey Year Percent Rejected calculated measure
Figure 10-34: The Year-Jo-Date Total Products calculated measure
Figure 10-35: Browsing the calculated members
Chapter 11: Pulling It Out and Building It Up—MDX Queries
Figure 11-1: The SQL Server Management Studio with an MDX Query window
Figure 11-2: The most basic MDX SELECT statement
Figure 11-3: An MDX SELECT statement with a query dimension
Figure 11-4: Creating a result with a COLUMNS query dimension
Figure 11-5: An MDX SELECT statement with two query dimensions
Figure 11-6: Creating a result with two query dimensions
Figure 11-7: Measures dimension members in the COLUMNS query dimension
Figure 11-8: An MDX SELECT statement with a slicer dimension
Figure 11-9: An MDX SELECT statement with a tuple in the slicer dimension
Figure 11-10: Creating a result with a slicer tuple
Figure 11-11: An MDX SELECT statement using the FILTER function
Figure 11-12: An MDX SELECT statement using a named set
Figure 11-13: An MDX SELECT statement using temporary calculated members
Figure 11-14: An MDX SELECT statement using a temporary calculated member of the Measures dimension
Figure 11-15: An MDX SELECT statement using the CROSSJOIN function
Figure 11-16: An MDX SELECT statement using the NON EMPTY keyword
Figure 11-17: An MDX SELECT statement using the TOPCOUNT function
Figure 11-18: An MDX SELECT statement using the BOTTOMCOUNT function
Figure 11-19: An MDX SELECT statement using the TOP COUNT function along with a ROWS query dimension
Figure 11-20: An MDX SELECT statement using SUM and COUNT aggregates
Figure 11-21: An MDX SELECT statement using AXIS(0) and AXIS(1)
Figure 11-22: A front-end Query window error when trying to use three query dimensions
Chapter 12: Panning for Gold—Introduction to Data Mining
Figure 12-1: Topographic information data overload
Figure 12-2: A topographic map
Figure 12-3: Planning a route using a topographic map
Figure 12-4: Data overload leads to confusion
Figure 12-5: Making predictions from the topographic map
Figure 12-6: Classification
Figure 12-7: Regression
Figure 12-8: Segmentation
Figure 12-9: Association
Figure 12-10: Sequence analysis
Figure 12-11: The Microsoft Decision Trees algorithm
Figure 12-12: The Naïve Bayes algorithm
Figure 12-13: The Microsoft Clustering algorithm
Figure 12-14: The Microsoft Association algorithm
Figure 12-15: The Microsoft Sequence Clustering algorithm
Figure 12-16: The Microsoft Time Series algorithm
Figure 12-17: The Microsoft Neural Network algorithm
Chapter 13: Building the Mine—Working with the Data Mining Model
Figure 13-1: The Select the Definition Method page of the Data Mining Wizard
Figure 13-2: The Select the Data Mining Technique page of the Data Mining Wizard
Figure 13-3: The Select the Source Cube Dimension page of the Data Mining Wizard
Figure 13-4: The Select the Case Key page of the Data Mining Wizard
Figure 13-5: The Select Case Level Columns page of the Data Mining Wizard
Figure 13-6: The Specify Mining Model Column Usage page of the Data Mining Wizard
Figure 13-7: The Specify Columns' Content and Data Type page of the Data Mining Wizard
Figure 13-8: The Filter Members dialog box
Figure 13-9: The Slice Source Cube page of the Data Mining Wizard
Figure 13-10: The Completing the Wizard page of the Data Mining Wizard
Figure 13-11: The Mining Structure tab on the Data Mining Design tab
Figure 13-12: Changing the column usage
Figure 13-13: The New Mining Model dialog box
Figure 13-14: The Mining Models tab on the Data Mining Design tab
Figure 13-15: The Process Mining Structure dialog box
Figure 13-16: The Process Progress dialog box
Figure 13-17: The decision tree view for the Microsoft Decision Tree algorithm
Figure 13-18: The decision tree with 0 Children At Home versus 1 or More Children At Home
Figure 13-19: The Dependency Network tab for the Microsoft Decision Tree algorithm
Figure 13-20: The strongest influence in this data mining model
Figure 13-21: The Microsoft Mining Content Viewer
Figure 13-22: The Dependency Network Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-23: The strongest influence in this mining model
Figure 13-24: The Attribute Profiles Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-25: The Attribute Characteristics Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-26: The Attribute Discrimination Viewer for the Microsoft Naïve Bayes algorithm
Figure 13-27: The Cluster Diagram Viewer for the Microsoft Clustering algorithm
Figure 13-28: The Cluster Profiles Viewer for the Microsoft Clustering algorithm
Figure 13-29: The Cluster Characteristics Viewer for the Microsoft Clustering algorithm
Figure 13-30: The Cluster Discrimination Viewer for Microsoft Clustering algorithm
Figure 13-31: The Discrimination Viewer for the Microsoft Neural Network algorithm
Figure 13-32: The Itemsets Viewer for the Microsoft Association algorithm
Figure 13-33: The Rules Viewer for the Microsoft Association algorithm
Figure 13-34: The Dependency Network Viewer for the Microsoft Association algorithm
Figure 13-35: The Chart Viewer for the Microsoft Time Series algorithm
Chapter 14: Spelunking—Exploration Using Data Mining
Figure 14-1: The Column Mapping tab before configuration
Figure 14-2: The Select Mining Structure dialog box
Figure 14-3: The Select Table dialog box
Figure 14-4: Deleting a column mapping
Figure 14-5: the Column Mapping tab after configuration
Figure 14-6: The Lift Chart with no prediction value specified
Figure 14-7: The Lift Chart for the Classification - Children At Home mining model
Figure 14-8: The Lift Chart at 10%
Figure 14-9: The Lift Chart at 20%
Figure 14-10: The Lift Chart at 35%
Figure 14-11: The Profit Chart Settings dialog box
Figure 14-12: The Profit Chart
Figure 14-13: The Classification Matrix
Figure 14-14: The Singleton Query toolbar button
Figure 14-15: The Select Mining Model dialog box
Figure 14-16: Selecting the columns in the singleton query result set
Figure 14-17: The completed singleton query
Figure 14-18: Selecting the result view
Figure 14-19: The singleton query result set in the result view
Figure 14-20: The completed prediction join query
Figure 14-21: The prediction join query result set in the result view
Figure 14-22: The prediction join query with filter criteria
Figure 14-23: The prediction join query result set with filter criteria
Figure 14-24: The save data mining query result dialog box
Figure 14-25: A DMX prediction join query
Figure 14-26: An empty prediction query in the SQL Server Management Studio
Figure 14-27: A singleton query in the SQL Server Management Studio
Chapter 15: On Report—Delivering Business Intelligence with Reporting Services
Figure 15-1: Report structure
Figure 15-2: Report Server functional structure
Figure 15-3: Reporting Services component parts
Figure 15-4: A distributed installation of Reporting Services
Figure 15-5: A web farm installation of Reporting Services
Figure 15-6: The Query Builder screen
Figure 15-7: The Design the Table page of the Report Wizard
Figure 15-8: The Choose the Table Layout page of the Report Wizard
Figure 15-9: The Completing the Wizard page of the Report Wizard
Figure 15-10: The table data region created by the Report Wizard
Figure 15-11: Widening a table column
Figure 15-12: The Textbox Properties dialog box
Figure 15-13: The Manufacturing By Machine Report preview
Figure 15-14: The database field expression for a detail cell
Figure 15-15: The database field expression with an aggregate function for a group header cell
Figure 15-16: The General tab of the Table Properties dialog box
Figure 15-17: The Visibility tab of the Table Properties dialog box
Figure 15-18: The Navigation tab of the Table Properties dialog box
Figure 15-19: The Sorting tab of the Table Properties dialog box
Figure 15-20: The Groups tab of the Table Properties dialog box
Figure 15-21: The Grouping and Sorting Properties dialog box
Figure 15-22: The General tab of the Details Grouping dialog box
Figure 15-23: The Visibility tab of the Details Grouping dialog box
Figure 15-24: The Filters tab of the Table Properties dialog box
Figure 15-25: The Data Output tab of the Table Properties dialog box
Figure 15-26: The MDX Query Builder with the query for the Wholesale Sales By Month Report
Figure 15-27: The report layout for the Wholesale Sales By Month Report
Figure 15-28: The Matrix Properties dialog box
Figure 15-29: The Wholesale Sales By Month Report preview
Figure 15-30: The matrix layout with multiple cells selected
Figure 15-31: The final version of the Wholesale Sales By Month Report
Figure 15-32: The Wholesale Sales By Month Report preview—almost done
Figure 15-33: The Wholesale Sales By Month Report preview—completed
Figure 15-34: The DMX Query Builder
Figure 15-35: The initial field layout for the Customer List With Prediction Report
Figure 15-36: The Customer List With Prediction Report layout with labels added
Figure 15-37: The Select the Image Source page of the Image Wizard
Figure 15-38: The Choose the Embedded Image page of the Image Wizard
Figure 15-39: The Customer List With Prediction Report with the Mythic World Buyer image
Figure 15-40: The Layout tab of the Report Properties dialog box
Figure 15-41: The page number expression for the text box in the page footer
Figure 15-42: The Sorting tab of the List Properties dialog box
Figure 15-43: The Navigation tab of the Textbox Properties dialog box
Figure 15-44: A page of the completed Customer List With Prediction Report
Figure 15-45: A page from the Customer List With Prediction Report print preview
Figure 15-46: The stored procedure version of the Query Builder
Figure 15-47: The Report Parameters dialog box
Figure 15-48: The chart data region with drag-and-drop targets
Figure 15-49: The basic Inventory Levels By Month Report layout
Figure 15-50: The basic Inventory Levels By Month Report preview
Figure 15-51: The General tab of the Chart Properties dialog box
Figure 15-52: The Data tab of the Chart Properties dialog box
Figure 15-53: The Appearance tab of the Edit Chart Value dialog box
Figure 15-54: The X Axis tab of the Chart Properties dialog box
Figure 15-55: The Y Axis tab of the Chart Properties dialog box
Figure 15-56: The Legend tab of the Chart Properties dialog box
Figure 15-57: The 3D Effect tab of the Chart Properties dialog box
Figure 15-58: The completed chart in the Inventory Levels By Month Report
Figure 15-59: The General tab of the Subreport Properties dialog box
Figure 15-60: The Parameters tab of the Subreport Properties dialog box
Figure 15-61: The Inventory Levels By Month Report layout with a subreport
Figure 15-62: The Inventory Levels By Month Report preview with a subreport
Figure 15-63: The Report Manager with no folders defined
Figure 15-64: The MaxMinReports Property Pages dialog box
Figure 15-65: The Upload File page
Figure 15-66: The Reporting Services Error page
Figure 15-67: The New Data Source page
Figure 15-68: RMUpload folder detail view
Figure 15-69: The Security page for the Home folder
Figure 15-70: The New Role Assignment page
Figure 15-71: A linked report
Figure 15-72: The Execution Properties page
Figure 15-73: The Select Report Model Generation Rules page of the Report Model Wizard
Figure 15-74: Entities in the Manufacturing Data Mart Report Model
Figure 15-75: Attributes and roles of the Dim Machine entity in the Manufacturing Data Mart Report Model
Figure 15-76: The Manufacturing Data Mart Report Model deployed to the Report Server
Figure 15-77: The Report Model Properties dialog box in the SQL Server Management Studio
Figure 15-78: The Model Item Security page of the Report Model Properties dialog box
Figure 15-79: Selecting a source of data from a Report Model with four perspectives
Figure 15-80: The Report Builder screen
Figure 15-81: The Define Formula dialog box
Chapter 16: Let's Get Together—Integrating Olap with Your Applications
Figure 16-1: A partial view of the CellSet structure
Figure 16-2: The Prospect Analyzer sample application with a three-dimensional MDX query result viewer
Figure 16-3: The Add Reference dialog box with the entry for the ADOMD.NET client highlighted
Figure 16-4: The References page of the Project Properties tab
Figure 16-5: A URL-rendered report
Figure 16-6: Browsing folder contents using URL access
Figure 16-7: A report parameter passed in the URL
Figure 16-8: The Parameter management page with a hidden parameter
Figure 16-9: The report without a parameter area
Figure 16-10: The Parameter management page with a read-only parameter
Figure 16-11: The parameters are suppressed.
Figure 16-12: The suppressed toolbar
Figure 16-13: The HTML form for requesting a report using an HTTP method
Figure 16-14: The Report Front End form
Figure 16-15: Placing a Report Viewer control on a Windows form
Figure 16-16: Opening the Reportviewer Tasks dialog box
Figure 16-17: The Report Viewer displaying a report with drilldown
Figure 16-18: Creating a new report
Figure 16-19: The Choose a Data Source Type page of the Data Source Configuration Wizard
Figure 16-20: The Choose Your Data Connection page of the Data Source Configuration Wizard
Figure 16-21: The Save the Connection String to the Application Configuration File page of the Data Source Configuration Wizard
Figure 16-22: The Choose Your Database Objects page of the Data Source Configuration Wizard
Figure 16-23: The ProductList Data Source in the Data Sources window
Figure 16-24: Layout of the local report
Figure 16-25: The Product List local report
Chapter 17: Another Point of View—Excel Pivot Tables and Pivot Charts
Figure 17-1: Starting the PivotTable and PivotChart Wizard
Figure 17-2: Step 1 of the PivotTable and PivotChart Wizard
Figure 17-3: Step 2 of the PivotToble and PivotChart Wizard
Figure 17-4: The Choose Data Source dialog box
Figure 17-5: The Create New Data Source dialog box
Figure 17-6: The Multidimensional Connection 9.0 dialog box
Figure 17-7: Selecting a database in the Multidimensional Connection 9.0 dialog box
Figure 17-8: The Create New Data Source dialog box with an Analysis Services database and cube selected
Figure 17-9: The Choose Data Source dialog box with the new data source
Figure 17-10: Step 2 of the PivotTable And PivotChart Wizard with data retrieved
Figure 17-11: Step 3 of the PivotTable and PivotChart Wizard
Figure 17-12: The Layout page of the PivotTable and PivotChart Wizard with an empty layout
Figure 17-13: The Layout page of the PivotTable and PivotChart Wizard with a completed layout
Figure 17-14: The PivotTable Options dialog box
Figure 17-15: The empty PivotTable layout in the Excel spreadsheet
Figure 17-16: Defining the page dimension of the PivotTable
Figure 17-17: Using the drop-down window to select dimension members
Figure 17-18: Selecting 2005Q1 and 2005Q2 for the page dimension
Figure 17-19: The double checkmark, indicating all members selected at the next lower level in the hierarchy
Figure 17-20: The PivotTable layout with Product Types and Product Subtypes
Figure 17-21: The Plant Hierarchy added to the PivotTable layout
Figure 17-22: The Accepted Products measure added to the PivotTable layout
Figure 17-23: Both the Accepted Products and Rejected Products measures in the PivotTable layout
Figure 17-24: The Hide Field List button in the PivotTable toolbar
Figure 17-25: The Accepted Products measure label changed to # Accepted
Figure 17-26: The Field Settings button in the PivotTable toolbar
Figure 17-27: The AutoFormat dialog box
Figure 17-28: The PivotTable with an AutoFormat applied
Figure 17-29: The PivotChart layout
Figure 17-30: A PivotChart
Figure 17-31: The Format Axis dialog box
Figure 17-32: The Format Chart Area dialog box
Figure 17-33: Choosing a color in the Format Data Series dialog box
Figure 17-34: The completed PivotChart with stacked bars
Figure 17-35: The 3-D Column Chart in the Chart Type drop-down window
Figure 17-36: The PivotChart with 3-D columns
Figure 17-37: The PivotChart with a drilldown into the quarters of 2005
Figure 17-38: The PivotChart with a data table
Figure 17-39: The PivotTable underlying the PivotChart
Previous page
Table of content
Next page
Delivering Business Intelligence with Microsoft SQL Server 2005: Utilize Microsofts Data Warehousing, Mining & Reporting Tools to Provide Critical Intelligence to A
ISBN: 0072260904
EAN: 2147483647
Year: 2007
Pages: 112
Authors:
Brian Larson
BUY ON AMAZON
Software Configuration Management
The DoD CM Process Model
Configuration Control
Configuration Status Accounting
Appendix T Software Configuration Management Plan (SCMP)
Appendix V Functional Configuration Audit (FCA) Checklist
Adobe After Effects 7.0 Studio Techniques
Articulated Mattes
Paint and Cloning
Tracking for Rotoscoping
Conclusion
Backlighting, Flares, Light Volume
Twisted Network Programming Essentials
Storing Web Data in an SQL Database
Mail Clients
Accepting Mail with SMTP
Setting Up a Custom SSH Server
Running a Twisted Application as a Daemon
InDesign Type: Professional Typography with Adobe InDesign CS2
Paragraph Indents and Spacing
Up Next
Mo Style
Sequential Styles
Up Next
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Seeing Services Through Your Customers Eyes-Becoming a customer-centered organization
Success Story #2 Bank One Bigger… Now Better
Success Story #4 Stanford Hospital and Clinics At the forefront of the quality revolution
Phase 3 Mobilization
Designing World-Class Services (Design for Lean Six Sigma)
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Getting Started with Visio 2007
Working Within the Visio Environment
Adding Shapes to Diagrams
Applying Themes to Entire Diagrams
Connecting Shapes in Network Diagrams
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies