Knight's Microsoft Business Intelligence 24-Hour Trainer

# Knight's Microsoft Business Intelligence 24-Hour Trainer

## Introduction
- Overview of Microsoft Business Intelligence (BI) Tools
  - What is Business Intelligence?
  - Importance of BI in Modern Businesses
  - Overview of the Microsoft BI Toolset
  - New BI Features in Office 2010
- How to Use This Book and Video Package
  - Structure of the Book
  - Accessing Video Lessons
  - Tips for Maximizing Learning

## Part I: Foundations of Business Intelligence and Data Modeling
- Chapter 1: Understanding Business Intelligence
  - Definition and Importance of BI
  - Key Components of BI Systems
  - Benefits of Using BI Tools
- Chapter 2: Basics of Data Modeling
  - What is Data Modeling?
  - Types of Data Models
  - Building a Simple Data Model
  - Best Practices for Data Modeling
- Chapter 3: Introduction to SQL Server
  - Overview of SQL Server
  - SQL Server Editions and Features
  - Setting Up Your SQL Server Environment

## Part II: Core Microsoft BI Tools
- Chapter 4: SQL Server Integration Services (SSIS)
  - What is SSIS?
  - Creating an SSIS Package
  - Data Extraction, Transformation, and Loading (ETL)
  - Deploying and Managing SSIS Packages
- Chapter 5: SQL Server Analysis Services (SSAS)
  - Introduction to SSAS
  - Building OLAP Cubes
  - Multidimensional vs. Tabular Models
  - Querying Data with MDX and DAX
- Chapter 6: SQL Server Reporting Services (SSRS)
  - Overview of SSRS
  - Designing Basic Reports
  - Adding Charts, Graphs, and Visualizations
  - Deploying and Sharing Reports

## Part III: Excel and PowerPivot for Business Intelligence
- Chapter 7: Excel as a BI Tool
  - Using Excel for Data Analysis
  - PivotTables and PivotCharts
  - Advanced Excel Features for BI
- Chapter 8: PowerPivot for Excel
  - Introduction to PowerPivot
  - Connecting to Data Sources
  - Creating Relationships and Calculations
  - Publishing PowerPivot Workbooks

## Part IV: SharePoint for BI Collaboration
- Chapter 9: Introduction to SharePoint
  - Overview of SharePoint
  - Setting Up a SharePoint Site
  - Integrating SharePoint with BI Tools
- Chapter 10: SharePoint Dashboards and Scorecards
  - Building Dashboards in SharePoint
  - Using PerformancePoint Services
  - Creating KPIs and Scorecards
  - Sharing and Collaborating on BI Content

## Part V: Hands-On Practice and Advanced Topics
- Chapter 11: Try It Out Exercises
  - Step-by-Step Exercises for Each Tool
  - Real-World Scenarios and Case Studies
  - Tips for Troubleshooting Common Issues
- Chapter 12: Advanced BI Techniques
  - Combining Multiple BI Tools
  - Automating BI Processes
  - Optimizing Performance
- Chapter 13: Future Trends in BI
  - Emerging Technologies in BI
  - Cloud-Based BI Solutions
  - Preparing for the Future of BI

## Appendices
- Appendix A: Installing and Configuring Microsoft BI Tools
  - System Requirements
  - Installation Steps for SQL Server, Excel, and SharePoint
- Appendix B: Additional Resources
  - Recommended Books and Websites
  - Online Communities and Forums
  - Certification Paths for Microsoft BI
- Appendix C: Answers to Try It Out Exercises
  - Solutions to All Exercises in the Book