Accelerated Microsoft Business Intelligence 2008 - MSS390
This four-day, comprehensive course provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 in an integrated environment with SharePoint and Office 2007. The course introduces the students to Microsoft Unified Data Model, SQL 2008 Analysis Services, Integration Services, Reporting Services, Report Builder 2.0, SharePoint 2007 Integration, Reporting Services Content Types, Business Data Catalog, and Business Intelligence with Excel 2007 and Visio 2007
Course ID: MSS390
Duration: 4 days
Audience: DBAs, Developers,BI Professionals
Prerequisites: A working knowledge of RDBMS
Topics:
The Microsoft Business Intelligence Stack
- The Goal of Business Intelligence
- Informed and Timely Decisions
- The Microsoft BI Stack
- Key Concepts
- Data Warehouse
- Data Mart
- Cubes
- Dimensions
- Measures
- Fact Table
- Key Components
- SQL Server Analysis Server
- SQL Server Integration Server
- SQL Server Reporting Services
- Data Mining
- MDX
- Microsoft Office SharePoint Server 2007
- PerformancePoint Server
- Microsoft Office 2007
- Common Business Challenges in BI
Unified Data Model
- UDM Defined
- Definition
- Structure
- Data Sources
- Data Views
- Proactive Caching
- XML Definitions
- User Experience
- Relational Querying the Data Sources Directly
- UDM and Simplified Access
- Advantages
- OLAP Built on Transactional Data
- Extremely Low Latency
- Ease of Creation and Maintenance
- Design Versioning with Source Control
SharePoint 2007 and Business Intelligence
- What is SharePoint
- Collaboration
- Portals
- Enterprise Search
- Content Management
- Business Process and Forms
- Business Intelligence
- What Does SharePoint Bring to the MS BI Stack
- Key SharePoint Concepts
- SharePoint or WSS
- SharePoint Architecture
- Collections, Sites, Webs, SubSites
- Content Types
- Features
New BI Features in SQL 2008
- Integration Services
- Analysis Services
- Reporting Services
SQL Server Integration Services Major Components
- Major Components
- Data Import/Export Wizard
- ETL Tool
- Control Flow Engine
- Application Platform
- High Performance Data Transformation Data Pipeline
- New or Changed Features
- Code Samples
- The SSIS Object Model
- Downloading a File Using HTTP
- Loading the Contents of a Text File into a Variable
- Simple Custom Logging
- Handling Exceptions
SQL Services Integration Server Extract Transform and Load
- ETL
- ETL Life Cycle
- Extract
- Transform
- Load
- Transformers
- Best Practices for Deployment
- Scope
- Deploying Packages
- Testing Packages
- Data Flow Practices
- Package Design
- Best Practices for Design
SQL Server Analysis Server and Key Concepts in BI
- Key Concepts
- Cubes
- Multi Dimension Space
- Measures
- Dimensions
- Hierarchies
- Time Dimension
- Slowly Changing Dimension
- Schemas
SQL Server Analysis Server Details
- Cube Processing
- Partitions
- Proactive Caching
- Notification Settings
- Aggregations
- Design of Aggregations
- Monitoring Aggregations
SQL Server Reporting Services
- Integration with SharePoint
- SharePoint Integrated Mode
- Integrated Install
- Report Builder 2.0
- Tablix
- Charts
- New Chart Types
- Advanced Chart Functionality
- Parameters
- Interactive Sorting
- Actions
- Document Maps
- Sub-Reports
- Differences Between Environments
- Developers
- Basic Users
- Power Users
SharePoint Business Data Catalog
- Why a Business Data Catalog
- Special BDC Only Web Parts
- Business Data Web Parts
- Business Data List
- Business Data Item Web Pat
- Business Data Related List Web Part
- Business Data Item Builder
- Application Definition Files
- Line of Business
- Entity
- Method
- Parameter
- Filter Descriptor
- Association
- Action
- Authentication and Security
- PassThrough
- RevertToSelf
- WindowsCredentials/RDBCredentials
- Accelerated Microsoft Business Intelligence (SQL 2008)
- Credentials
Integrated Security and Report Management
- Understanding SharePoint Security
- Groups
- Securable Items
- Who Can See What
- All Those Groups
- Report Content Types
- Report Subscriptions
- Workflows
- Out of Box
- SharePoint Designer
- Visual Studio
- Exploring the Report Center
- Reports Library
- Data Connection Library
- Business Web Parts
- Dashboards
- KPIs
Excel Services
- Excel on the Server
- Utilizing Excel Services
- Limitations
- Excel Web Services
- Trusted File Locations
- Excel User Defined Functions
- SOAP
- Excel Web Access
- Web Parts
- User Controls
- Smart Part
Excel 2007 and Data Mining
- Notable Uses of Data Mining
- Pattern Mining
- Subject Based Mining
- Games
- Business
- Key Terms in Data Mining
- Data Mining Model
- Columns
- Cases
- Case Table sand Nested Tables
- Types of Data Mining Algorithms
- Classification Algorithms
- Regression Algorithms
- Segmentation Algorithms