| |
| |
Introduction to Microsoft Business Intelligence from SQL 2008 through SharePoint and Office 2007 |
|
|
|
|
| Thème |
BASES DE DONNEES SQL SERVER |
| Objectif |
After completing this course, students will be able to: describe the Microsoft Business Intelligence stack, explain the Unified Dimension Model and when it can and cannot be used, use the new Business Intelligence Features in SQL 2008, create a SSAS Project using the Microsoft Unified Dimension Model, create a Data Mart using Business Intelligence Studio, create a Integration Services project and load a Data Mart, load a Data Mart from a flat file, model Dimensions, Measures and Cubes, learn The basics of MDX query language, understand the pros and cons of Integration into SharePoint, create a Report using Report Builder 3.0, load and Manage Reports with SharePoint, create Report Subscriptions in SharePoint, create and customize the SharePoint Report Center, realize the importance of and customize SharePoint Content Types, explain the differences in workflows in SharePoint, understand and Create a Shared Service Provider in SharePoint, understand and Create a Business Data Catalog in SharePoint, utilize the Business Intelligence add-ins for Excel 2007. |
| Pré requis |
Before attending this course, students must have: a working knowledge of RDBMS, a working knowledge of Business Intelligence Studio, a working knowledge of Excel and the Office Ribbon, understanding of the goals of Business Intelligence |
| Durée |
5 j |
|
Retour au calendrier |
Télécharger le PDF |
Se pré-inscrire |
| Mai | Juin | Juillet | Août | Septembre | Octobre |
| | Nous consulter | | | | |
| Contenu |
Module 1: Overview Of the Microsoft BI Stack
- The Goal of Business Intelligence
- SQL 2008 Business Intelligence Platform
- Integration Services
- Analysis Services
- Reporting Services
- SharePoint Report Center
- Multidimensional Space Terminology
- SharePoint 2007 Terminology
- Tools for Developers and Users
- Business Intelligence Project Skill Sets Required
- Business Intelligence Life Cycle
Module 2: Unified Data Model
- UDM Vision
- Problems UDM addresses
- Benefits
- Situations in which the UDM is inappropriate
Module 3: SQL Server Integration Services
- Major Components
- New or changed features
- Script task
- Change Data Capture
- Data Profiling Task and Viewer
- SSIS Connection Project
- Extract Transform Load
- Best Practices for Deployment
- Advanced Features of Packages
- Transactions
- Checkpoints
- Best Practices for Design
Module 4: SQL Server Analysis Server
- Cubes
- Multidimensional Space
- Measures
- Dimensions
- Special Dimensions, Time and Slowly Changing
- Schemas
- Cube Processing
- Partitions
- Proactive Caching
- Aggregations
- SSAS 2008 Enhancements
Module 5: MDX Query Language
- Overview
- Editor
- Select Statement
- Where Clause
- Tuples
- Cells
- Partial Tuples
- Sets
- Functions
- Limiting Sets
- Working With Time
|
Module 6: SQL Server Reporting Services
- Integration with SharePoint
- Report Processing and Rendering
- Report Authoring
- Data Access
- Data Sets
- Semantic Models
- Tablix
- Charts
- Geospatial Data
Module 7: SharePoint Server 2007 - SharePoint Terminology
- Functionality
- Portals
- Content Types
- Workflows
- Web Parts
- Data Connection Libraries
- Shared Service Provider
- Report Center
- Dashboards/Scorecards
- Key Performance Indicators
- Subscriptions
Module 8: SharePoint Business Data Catalog
- Why the BDC
- BDC Web Parts
- Application Definition Files
- Authentication and Security
Module 9: SharePoint Excel Services
- Excel on the Server
- Using Excel Services
- Limitations
- Trusted File Locations
- Excel Web Service
- Excel Web Access
- Excel Calculation Service
Module 10: Data Mining and Excel
- Notable Uses OF Data Mining
- Key Terms
- Types Of Data Mining Algorithms
- The Microsoft Implementations OF The Algorithms
- Excel and The BI Extensions
|
|
|
| | |
|
|
|