O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Knight's Microsoft® Business Intelligence 24-Hour Trainer: Leveraging Microsoft SQL Server® Integration, Analysis, and Reporti

Video Description

Welcome to the video portion of Knight's Microsoft® Business Intelligence 24-Hour Trainer

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. Lesson 2: Dimensional Modeling 00:16:39
    2. Lesson 3: Fact Table Modeling 00:13:15
    3. Lesson 4: Understanding SSIS 00:17:28
    4. Lesson 5: Using the Control Flow 00:11:48
    5. Lesson 6: Using the Data Flow 00:16:51
    6. Lesson 7: Solving Common SSIS Scenarios 00:14:08
    7. Lesson 8: Loading Dimensions 00:15:33
    8. Lesson 9: Loading a Fact Table 00:10:30
    9. Lesson 10: Deploying SSIS Packages 00:07:23
    10. Lesson 11: Understanding SSAS (Whiteboard Video) 00:04:32
    11. Lesson 12: Configuring a Data Source and a Data Source View 00:20:23
    12. Lesson 13: Using the Cube Wizard 00:12:01
    13. Lesson 14: Editing Your Dimension 00:12:38
    14. Lesson 15: Editing Your Cube 00:10:59
    15. Lesson 16: Adding New Dimensions and Measure Groups 00:13:53
    16. Lesson 17: Using MDX 00:21:15
    17. Lesson 18: Creating Calculations 00:12:37
    18. Lesson 19: Data Mining 00:22:54
    19. Lesson 20: Administering the SSAS Instance 00:16:22
    20. Lesson 21: Understanding SSRS (Whiteboard Video) 00:01:35
    21. Lesson 22: Using Report Wizard 00:05:09
    22. Lesson 23: Building a Matrix Report 00:11:05
    23. Lesson 24: Parameterizing Your Reports 00:11:30
    24. Lesson 25: Building Reports on Your Cube 00:18:48
    25. Lesson 26: Using Maps in Your Report 00:11:30
    26. Lesson 27: Building a Dashboard 00:18:23
    27. Lesson 28: Deploying and Administering SSRS 00:15:23
    28. Lesson 29: New Reporting Services Visualizations-Sparklines, Data Bars, and Indicators 00:12:16
    29. Lesson 30: Using Report Builder 00:12:52
    30. Lesson 31: Reporting Against a Cube with Excel 00:09:25
    31. Lesson 32: Loading Data into a PowerPivot Workbook 00:10:18
    32. Lesson 33: Creating a PowerPivot Report 00:11:35
    33. Lesson 34: Data Mining in Excel 00:10:13
    34. Lesson 35: Understanding SharePoint for Business Intelligence 00:08:56
    35. Lesson 36: Deploying and Using Reporting Services in SharePoint 2010 00:15:41
    36. Lesson 37: Building PerformancePoint Dashboards in SharePoint 2010 00:21:37
    37. Lesson 38: Deploying and Using Excel Services 00:17:49
    38. Lesson 39: Deploying and Using PowerPivot in SharePoint 00:19:06
    39. Lesson 40: Managing SharePoint Business Intelligence 00:08:01