Cieľ kurzu: Pripraviť IT profesionálov, navrhujúcich a plánujúcich riešenia business intelligence použitím nástrojov SQL Servera 2008, tak, aby mohli sebavedome podstúpiť certifikačnú skúšku 70-452. Kurz je vedený plne certifikovaným lektorom na SQL Server 2008.
Vstupné požiadavky: dva až tri roky skúseností s používaním BI komponentov SQL Servera 2008
Trvanie: 5 dní
Obsahová náplň:
Designing and Managing Reports
- Designing report architecture
- Designing a data acquisition strategy
- Defining a report parameter strategy
- Designing a report layout
- Designing reports by using Report Builder
- Managing a report environment
Designing Data Mining Models
- Designing a mining model and structure
- Designing strategies for staging data for mining
- Selecting a strategy for visualizing data mining results
- Selecting data mining algorithms
- Refining testing models
Administering a BI Solution
- Maintaining server health
- Selecting a subscription strategy
- Managing integration services
- Designing a backup strategy
- Planning and managing upgrades
- Planning and managing reporting services configuration
Designing the BI Architecture
- Designing integration between data visualization components
- Designing the data warehouse
- Planning for scalability
- Planning for performance
- Managing team development issues
- Planning the configuration of a primary data source
- Designing a security strategy
Designing and Deploying SSIS Packages
- Designing control flow
- Designing data flow
- Planning the deployment of SSIS packages
- Designing the configuration file for an SSIS package
- Designing a logging and auditing strategy
Designing an Analysis Services Database
- Designing cube architecture
- Designing for international implementation
- Designing a data source view
- Designing perspectives
- Designing and creating business-driven Multidimensional Expressions (MDX) calculations
- Analysing cube performance