Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®

by Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
Released September 2010
Publisher(s): Wrox
ISBN: 9780470889633

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

A book-and-video introduction to Microsoft's Business Intelligence tools

If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying Video on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint.

  • Integrates instructional videos with each of the lessons found in the book to enhance your learning experience

  • Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010

  • Encourages you to practice what you've learned in "Try It Out" sections

  • Contains video demonstrations that walk you through how to tackle each lesson featured in the book

With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately!

Table of contents

  1. Knight’s Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
    1. Copyright
    2. Dedication
    3. About the Authors
    4. About the Technical Editor
    5. Credits
    6. Acknowledgments
    7. Contents (1/2)
    8. Contents (2/2)
    9. Introduction
      1. Who This Book Is For
      2. What This Book Covers
      3. How This Book Is Structured
      4. What You Need to Use This Book
      5. Instructional Videos on DVD
      6. Conventions
      7. Supporting Packages and Code
      8. Errata
      9. p2p.wrox.com
    10. Section I: Data Warehousing and Business Intelligence
      1. Chapter 1: Why Business Intelligence? (1/2)
      2. Chapter 1: Why Business Intelligence? (2/2)
        1. How Intelligent Is Your Organization?
        2. Try It
      3. Chapter 2: Dimensional modeling (1/2)
      4. Chapter 2: Dimensional modeling (2/2)
        1. Key Dimensional Modeling Elements
        2. How Does Dimensional Modeling Work?
        3. Try It
      5. Chapter 3: Fact Table Modeling
        1. Try It
    11. Section II: SQL Server Integration Services
      1. Chapter 4: Understanding SSIS (1/3)
      2. Chapter 4: Understanding SSIS (2/3)
      3. Chapter 4: Understanding SSIS (3/3)
        1. Business Intelligence Development Studio (BIDS)
        2. Solution Explorer
        3. SSIS Designer
        4. Variables
        5. SSIS Architecture
        6. Try It
      4. Chapter 5: Using the Control Flow (1/2)
      5. Chapter 5: Using the Control Flow (2/2)
        1. Control Flow Containers
        2. Control Flow Tasks
        3. Precedence Constraints
        4. Connection Manager
        5. Control Flow Designer
        6. Try It
      6. Chapter 6: Using the Data Flow (1/3)
      7. Chapter 6: Using the Data Flow (2/3)
      8. Chapter 6: Using the Data Flow (3/3)
        1. Data Flow Sources (Extracting Data)
        2. Data Flow Transformations
        3. Data Flow Paths
        4. Data Flow Designer
        5. Try It
      9. Chapter 7: Solving Common SSIS Scenarios (1/2)
      10. Chapter 7: Solving Common SSIS Scenarios (2/2)
        1. Try It
      11. Chapter 8: Loading Dimensions (1/2)
      12. Chapter 8: Loading Dimensions (2/2)
        1. Using the Slowly Changing Dimension Task
        2. Try It
      13. Chapter 9: Loading a Fact Table (1/2)
      14. Chapter 9: Loading a Fact Table (2/2)
        1. Try It
      15. Chapter 10: Deploying SSIS Packages (1/2)
      16. Chapter 10: Deploying SSIS Packages (2/2)
        1. Deploying a Single Package Using SSMS
        2. Deploying a Single Package Using BIDS
        3. Creating a Deployment Utility Using BIDS
        4. Try It
    12. Section III: SQL Server Analysis Services
      1. Chapter 11: Understanding SSAS (1/2)
      2. Chapter 11: Understanding SSAS (2/2)
        1. SSAS Architecture
        2. Cubes
        3. MDX
        4. BIDS for SSAS
        5. Try It
      3. Chapter 12: Configuring a Data Source and Data Source View (1/2)
      4. Chapter 12: Configuring a Data Source and Data Source View (2/2)
        1. Creating a Data Source
        2. Creating a Data Source View
        3. Try It
      5. Chapter 13: Using the Cube Wizard (1/2)
      6. Chapter 13: Using the Cube Wizard (2/2)
        1. Try It
      7. Chapter 14: Editing Your Dimension (1/2)
      8. Chapter 14: Editing Your Dimension (2/2)
        1. Dimension Editor
        2. Attribute Relationships
        3. Key Columns
        4. Dimension and Attribute Types
        5. Try It
      9. Chapter 15: Editing Your Cube (1/2)
      10. Chapter 15: Editing Your Cube (2/2)
        1. Cube Editor Tour
        2. Browsing the Cube
        3. Try It
      11. Chapter 16: Adding New Dimensions and Measure Groups (1/2)
      12. Chapter 16: Adding New Dimensions and Measure Groups (2/2)
        1. Adding a Measure Group and Measures
        2. Adding a Dimension
        3. Try It
      13. Chapter 17: Using MDX (1/2)
      14. Chapter 17: Using MDX (2/2)
        1. Anatomy of Basic MDX
        2. Navigation Functions
        3. Try It
      15. Chapter 18: Creating Calculations (1/2)
      16. Chapter 18: Creating Calculations (2/2)
        1. Calculation Basics
        2. Color-Coding Measures
        3. Named Sets
        4. More Advanced Calculations
        5. Try It
      17. Chapter 19: Data Mining (1/3)
      18. Chapter 19: Data Mining (2/3)
      19. Chapter 19: Data Mining (3/3)
        1. Introduction to Data Mining
        2. Data-Mining Process
        3. Creating a Mining Model
        4. Exploring the Model
        5. Evaluating the Model
        6. Querying the Model
        7. Try It
      20. Chapter 20: Administering the SSAS Instance (1/3)
      21. Chapter 20: Administering the SSAS Instance (2/3)
      22. Chapter 20: Administering the SSAS Instance (3/3)
        1. Securing the Database
        2. Partitioning the Data
        3. Aggregations
        4. Usage-Based Optimization
        5. Processing the Cube
        6. Deploying Change
        7. Try It
    13. Section IV: SQL Server Reporting Services
      1. Chapter 21: Understanding SSRS (1/2)
      2. Chapter 21: Understanding SSRS (2/2)
        1. Building Your First Report
        2. Try It
      3. Chapter 22: Using Report Wizard (1/2)
      4. Chapter 22: Using Report Wizard (2/2)
        1. Try It
      5. Chapter 23: Building a Matrix Report (1/2)
      6. Chapter 23: Building a Matrix Report (2/2)
        1. Try It
      7. Chapter 24: Parameterizing Your Reports (1/2)
      8. Chapter 24: Parameterizing Your Reports (2/2)
        1. Creating Parameters
        2. Default Parameter Values
        3. Parameter Available Values
        4. Multi-Value Parameters
        5. Altering Properties with Parameters
        6. Try It
      9. Chapter 25: Building Reports on Your Cube (1/2)
      10. Chapter 25: Building Reports on Your Cube (2/2)
        1. Try It
      11. Chapter 26: Using Maps in Your Report (1/2)
      12. Chapter 26: Using Maps in Your Report (2/2)
        1. Try It
      13. Chapter 27: Building a Dashboard (1/2)
      14. Chapter 27: Building a Dashboard (2/2)
        1. Tables and Filters
        2. Drill-Downs
        3. Try It
      15. Chapter 28: Deploying and Administering SSRS (1/4)
      16. Chapter 28: Deploying and Administering SSRS (2/4)
      17. Chapter 28: Deploying and Administering SSRS (3/4)
      18. Chapter 28: Deploying and Administering SSRS (4/4)
        1. Stored Credentials
        2. Subscriptions
        3. Shared Schedules
        4. Security
        5. Datasets and Caching
        6. Report Builder 3.0
        7. Report Parts
        8. Viewing Reports
        9. Try It
      19. Chapter 29: New Reporting Services Visualizations — Sparklines, Data Bars, and Indicators (1/2)
      20. Chapter 29: New Reporting Services Visualizations — Sparklines, Data Bars, and Indicators (2/2)
        1. Adding Sparklines
        2. Using Data Bars
        3. Configuring Indicators
        4. Try It
      21. Chapter 30: Using Report Builder (1/2)
      22. Chapter 30: Using Report Builder (2/2)
        1. Opening Report Builder
        2. Working with the Table, Matrix, or Chart Wizard
        3. Report Parts
        4. Shared Datasets
        5. Try It
    14. Section V: Containers
      1. Chapter 31: Reporting against a Cube with Excel (1/2)
      2. Chapter 31: Reporting against a Cube with Excel (2/2)
        1. Try It
      3. Chapter 32: Loading Data into a PowerPivot Workbook (1/2)
      4. Chapter 32: Loading Data into a PowerPivot Workbook (2/2)
        1. What Is PowerPivot?
        2. Try It
      5. Chapter 33: Creating a PowerPivot Report (1/2)
      6. Chapter 33: Creating a PowerPivot Report (2/2)
        1. Components of a PowerPivot Report
        2. Building the Report
        3. Adding Bells and Whistles
        4. Try It
      7. Chapter 34: Data Mining in Excel (1/4)
      8. Chapter 34: Data Mining in Excel (2/4)
      9. Chapter 34: Data Mining in Excel (3/4)
      10. Chapter 34: Data Mining in Excel (4/4)
        1. Getting Ready for Excel Data Mining
        2. Exploring the Data Mining Add-Ins
        3. Analyzing Key Influencers in Excel
        4. Try It
    15. Section VI: SharePoint
      1. Chapter 35: Understanding SharePoint for Business Intelligence
        1. Try It
      2. Chapter 36: Deploying and Using Reporting Services in SharePoint 2010 (1/2)
      3. Chapter 36: Deploying and Using Reporting Services in SharePoint 2010 (2/2)
        1. Try It
      4. Chapter 37: Building PerformancePoint Dashboards in SharePoint 2010 (1/2)
      5. Chapter 37: Building PerformancePoint Dashboards in SharePoint 2010 (2/2)
        1. Try It
      6. Chapter 38: Deploying and Using Excel Services (1/2)
      7. Chapter 38: Deploying and Using Excel Services (2/2)
        1. Try It
      8. Chapter 39: Deploying and Using PowerPivot in SharePoint (1/2)
      9. Chapter 39: Deploying and Using PowerPivot in SharePoint (2/2)
        1. Try It
      10. Chapter 40: Managing SharePoint Business Intelligence
        1. Try It
    16. Appendix
      1. Appendix A: What’s on the DVD? (1/2)
      2. Appendix A: What’s on the DVD? (2/2)
        1. System Requirements
        2. Using the DVD
        3. What’s on the DVD
        4. Troubleshooting
        5. Customer Care
    17. Index (1/3)
    18. Index (2/3)
    19. Index (3/3)

Product information

  • Title: Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporting Services with Excel® and SharePoint®
  • Author(s): Brian Knight, Devin Knight, Adam Jorgensen, Patrick LeBlanc, Mike Davis
  • Release date: September 2010
  • Publisher(s): Wrox
  • ISBN: 9780470889633