Microsoft SQL Business Intelligence (BI) (MCP/MCTS) (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%)

Materials

N/A

Teaching methods

e-learning

Employer connections

N/A

International connections

N/A

Completion alternatives

N/A

Further information

Course is 100% online and you can enroll and start it whenever is suitable for you. Enrolmets via eform withch you can find in our website: http://www.metropolia.fi/en/degree-programmes/open-studies/technology/virtual-courses/

Evaluation scale

Hyväksytty/Hylätty

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

Further information

http://www.microsoft.com/learning