Knight's Microsoft Business Intelligence 24-Hour Trainer -- About the Authors -- About the Technical Editor -- Acknowledgments -- Contents -- Introduction -- Who This Book Is For -- What This Book Covers -- How This Book Is Structured -- What You Need to Use This Book -- Instructional Videos on DVD -- Conventions -- Supporting Packages and Code -- Errata -- p2p.wrox.com -- Section I: Data Warehousing and Business Intelligence -- Chapter 1: Why Business Intelligence? -- How Intelligent Is Your Organization? -- Try It -- Chapter 2: Dimensional Modeling -- Key Dimensional Modeling Elements -- How Does Dimensional Modeling Work? -- Try It -- Chapter 3: Fact Table Modeling -- Try It -- Section II: SQL Server Integration Services -- Chapter 4: Understanding SSIS -- Business Intelligence Development Studio (BIDS) -- Solution Explorer -- SSIS Designer -- Variables -- SSIS Architecture -- Try It -- Chapter 5: Using the Control Flow -- Control Flow Containers -- Control Flow Tasks -- Precedence Constraints -- Connection Manager -- Control Flow Designer -- Try It -- Chapter 6: Using the Data Flow -- Data Flow Sources (Extracting Data) -- Data Flow Transformations -- Data Flow Paths -- Data Flow Designer -- Try It -- Chapter 7: Solving Common SSIS Scenarios -- Try It -- Chapter 8: Loading Dimensions -- Using the Slowly Changing Dimension Task -- Try It -- Chapter 9: Loading a Fact Table -- Try It -- Chapter 10: Deploying SSIS Packages -- Deploying a Single Package Using SSMS -- Deploying a Single Package Using BIDS -- Creating a Deployment Utility Using BIDS -- Try It -- Section III: SQL Server Analysis Services -- Chapter 11: Understanding SSAS -- SSAS Architecture -- Cubes -- MDX -- BIDS for SSAS -- Try It -- Chapter 12: Configuring a Data Source and Data Source View -- Creating a Data Source -- Creating a Data Source View -- Try It.

Chapter 13: Using the Cube Wizard -- Try It -- Chapter 14: Editing Your Dimension -- Dimension Editor -- Attribute Relationships -- Key Columns -- Dimension and Attribute Types -- Try It -- Chapter 15: Editing Your Cube -- Cube Editor Tour -- Browsing the Cube -- Try It -- Chapter 16: Adding New Dimensions and Measure Groups -- Adding a Measure Group and Measures -- Adding a Dimension -- Try It -- Chapter 17: Using MDX -- Anatomy of Basic MDX -- Navigation Functions -- Try It -- Chapter 18: Creating Calculations -- Calculation Basics -- Color-Coding Measures -- Named Sets -- More Advanced Calculations -- Try It -- Chapter 19: Data Mining -- Introduction to Data Mining -- Data-Mining Process -- Creating a Mining Model -- Exploring the Model -- Evaluating the Model -- Querying the Model -- Try It -- Chapter 20: Administering the SSAS Instance -- Securing the Database -- Partitioning the Data -- Aggregations -- Usage-Based Optimization -- Processing the Cube -- Deploying Change -- Try It -- Section IV: SQL Server Reporting Services -- Chapter 21: Understanding SSRS -- Building Your First Report -- Try It -- Chapter 22 -- Using Report Wizard -- Try It -- Chapter 23: Building a Matrix Report -- Try It -- Chapter 24: Parameterizing Your Reports -- Creating Parameters -- Default Parameter Values -- Parameter Available Values -- Multi-Value Parameters -- Altering Properties with Parameters -- Try It -- Chapter 25: Building Reports on Your Cube -- Try It -- Chapter 26: Using Maps in Your Report -- Try It -- Chapter 27: Building a Dashboard -- Tables and Filters -- Drill-Downs -- Try It -- Chapter 28: Deploying and Administering SSRS -- Stored Credentials -- Subscriptions -- Shared Schedules -- Security -- Datasets and Caching -- Report Builder 3.0 -- Report Parts -- Viewing Reports -- Try It.

Chapter 29: New Reporting Services Visualizations - ​Sparklines, Data Bars, and Indicators -- Adding Sparklines -- Using Data Bars -- Configuring Indicators -- Try It -- Chapter 30: Using Report Builder -- Opening Report Builder -- Working with the Table, Matrix, or Chart Wizard -- Report Parts -- Shared Datasets -- Try It -- Section V: Containers -- Chapter 31: Reporting against a Cube with Excel -- Try It -- Chapter 32: Loading Data into a PowerPivot Workbook -- What Is PowerPivot? -- Try It -- Chapter 33: Creating a PowerPivot Report -- Components of a PowerPivot Report -- Building the Report -- Adding Bells and Whistles -- Try It -- Chapter 34: Data Mining in Excel -- Getting Ready for Excel Data Mining -- Exploring the Data Mining Add-Ins -- Analyzing Key Influencers in Excel -- Try It -- Section VI: SharePoint -- Chapter 35: Understanding SharePoint for Business Intelligence -- Try It -- Chapter 36: Deploying and Using Reporting Services in SharePoint 2010 -- Try It -- Chapter 37: Building PerformancePoint Dashboards in SharePoint 2010 -- Try It -- Chapter 38: Deploying and Using Excel Services -- Try It -- Chapter 39: Deploying and Using PowerPivot in SharePoint -- Try It -- Chapter 40: Managing SharePoint Business Intelligence -- Try It -- Appendix: What's on the DVD? -- System Requirements -- Using the DVD -- What's on the DVD -- Troubleshooting -- Customer Care -- Index -- End-User License Agreement.