Microsoft SQL Business Intelligence (BI) (MCP/MCTS)Laajuus (5 ECTS)

Objective

Learn Business Intelligence solutions in Microsoft's SQL Server 2008. Prepares for 70-533 certification.

Content

Implementing an SSIS Solution (17%)
Configuring, Deploying, and Maintaining SSIS (15%)
Implementing an SSAS Solution (21%)
Configuring, Deploying, and Maintaining SSAS (17%)
Implementing an SSRS Solution (17%)
Configuring, Deploying, and Maintaining SSRS (13%)

Assessment criteria, satisfactory (1)

Implementing an SSIS Solution
- the student understands what is/are and is able to implement: control flow; data flow; dynamic package behavior by using property expressions; auditing, logging, and event handling.

Configuring, Deploying, and Maintaining SSIS
- the student understands what is/are and is able to: install and maintain maintain SSIS components; deploy an SSIS solution; manage SSIS package execution, configure SSIS security settings.

Implementing an SSAS Solution
- the student understands what is/are and is able to implement: dimensions in a cube; measures in a cube; a data source view; data mining.

Configuring, Deploying, and Maintaining SSAS
- the student understands what is/are and is able to: configure permissions and roles in SSAS, deploy SSAS databases and objects, install and maintain an SSAS instance; diagnose and resolve performance issues; implement processing options;

Implementing an SSRS Solution
- the student understands what is/are and is able to: implement report data sources and datasets, implement a report layout; extend an SSRS report using an SSAS data source; create an SSRS report by using an SSAS data source.

Assessment criteria, good (3)

Implementing an SSIS Solution
- the student understands what is/are and is able to implement: control flow; data flow; dynamic package behavior by using property expressions; auditing, logging, and event handling.
- the student shows independent solutions.

Configuring, Deploying, and Maintaining SSIS
- the student understands what is/are and is able to: install and maintain maintain SSIS components; deploy an SSIS solution; manage SSIS package execution, configure SSIS security settings;
- the student shows independent solutions.

Implementing an SSAS Solution
- the student understands what is/are and is able to implement: dimensions in a cube; measures in a cube; a data source view; data mining;
- the student shows independent solutions.

Configuring, Deploying, and Maintaining SSAS
- the student understands what is/are and is able to: configure permissions and roles in SSAS, deploy SSAS databases and objects, install and maintain an SSAS instance; diagnose and resolve performance issues; implement processing options;
- the student shows independent solutions.

Implementing an SSRS Solution
- the student understands what is/are and is able to: implement report data sources and datasets, implement a report layout; extend an SSRS report using an SSAS data source; create an SSRS report by using an SSAS data source;
- the student shows independent solutions.

Assessment criteria, excellent (5)

Implementing an SSIS Solution
- the student understands what is/are and is able to implement: control flow; data flow; dynamic package behavior by using property expressions; auditing, logging, and event handling;
- the student shows independent solutions and critical evaluation.

Configuring, Deploying, and Maintaining SSIS
- the student understands what is/are and is able to: install and maintain maintain SSIS components; deploy an SSIS solution; manage SSIS package execution, configure SSIS security settings;
- the student shows independent solutions and critical evaluation.

Implementing an SSAS Solution
- the student understands what is/are and is able to implement: dimensions in a cube; measures in a cube; a data source view; data mining;
- the student shows independent solutions and critical evaluation.

Configuring, Deploying, and Maintaining SSAS
- the student understands what is/are and is able to: configure permissions and roles in SSAS, deploy SSAS databases and objects, install and maintain an SSAS instance; diagnose and resolve performance issues; implement processing options;
- the student shows independent solutions and critical evaluation.

Implementing an SSRS Solution
- the student understands what is/are and is able to: implement report data sources and datasets, implement a report layout; extend an SSRS report using an SSAS data source; create an SSRS report by using an SSAS data source;
- the student shows independent solutions and critical evaluation.

Further information

http://www.microsoft.com/learning