Search This Blog

Tuesday, March 5, 2013

Microsoft MSBI Certification Details

                                          Microsoft Certifications

MCSA (Microsoft Certified Solution Associate)

1. Querying Microsoft SQL Server 2012

2. Administering Microsoft SQL Server 2012 Databases

3. Implementing a Data Warehouse with Microsoft SQL Server 2012

MCSE (Microsoft Certified Solution Expert)
1. Implementing Data Models and Reports with Microsoft SQL Server 2012

2. Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Skills Measured:

MCSA - Querying Microsoft SQL Server 2012

1. Create Database Objects (24%)

a. Create and alter tables using T-SQL syntax (simple statements).

b. Create and alter views (simple statements).

c. Design views.

d. Create and modify constraints (simple statements).

e. Create and alter DML triggers.

2. Work with Data (27%)

a. Query data by using SELECT statements.

b. Implement sub-queries.

c. Implement data types.

d. Implement aggregate queries.

e. Query and manage XML data.

3. Modify Data (24%)

a. Create and alter stored procedures (simple statements).

b. Modify data by using INSERT, UPDATE, and DELETE statements.

c. Combine datasets.

d. Work with functions.

4. Troubleshoot & Optimize (25%)

a. Optimize queries.

b. Manage transactions.

c. Evaluate the use of row-based operations vs. set-based operations.

d. Implement error handling.

Cost :

The cost to take up this certification is 80 USD

MCSA - Administering Microsoft SQL Server 2012 Databases

1. Install and Configure (19%)

a. Plan installation.

b. Install SQL Server and related services.

c. Implement a migration strategy.

d. Configure additional SQL Server components.

e. Manage SQL Server Agent.

2. Maintain Instances and Databases (17%)

a. Manage and configure databases.

b. Configure SQL Server instances.

c. Implement a SQL Server clustered instance.

d. Manage SQL Server instances.

3. Optimize and Troubleshoot (14%)

a. Identify and resolve concurrency problems.

b. Collect and analyze troubleshooting data.

c. Audit SQL Server instances.

4. Manage Data (19%)

a. Configure and maintain a back up strategy.

b. Restore databases.

c. Implement and maintain indexes.

d. Import and export data.

5. Implement Security (18%)

a. Manage logins and server roles.

b. Manage database permissions.

c. Manage users and database roles.

d. Troubleshoot security.

6. Implement High Availability (12%)

a. Implement AlwaysOn.

b. Implement database mirroring.

c. Implement replication.


The cost to take up this certification is 80 USD

MCSA - Implementing a Data Warehouse with Microsoft SQL Server 2012

1. Design and Implement a Data Warehouse (11%)

a. Design and implement dimensions.

b. Design and implement fact tables.

2. Extract and Transform Data (23%)

a. Define connection managers.

b. Design data flow.

c. Implement data flow.

d. Manage SSIS package execution.

e. Implement script tasks in SSIS.

3. Load Data (27%)

a. Design control flow.

b. Implement package logic by using SSIS variables and parameters.

c. Implement control flow.

d. Implement data load options.

e. Implement script components in SSIS.

4. Configure and Deploy SSIS Solutions (24%)

a. Troubleshoot data integration issues.

b. Install and maintain SSIS components.

c. Implement auditing, logging, and event handling.

d. Deploy SSIS solutions.

e. Configure SSIS security settings.

5. Build Data Quality Solutions (15%)

a. Install and maintain Data Quality Services.

b. Implement master data management solutions.

c. Create a data quality project to clean data.


The cost to take up this certification is 80 USD

Note: We can take all the three certifications of MCSA in a shot with the cost of 204 USD

MCSE - Implementing Data Models and Reports with Microsoft SQL Server 2012

1. Build an Analysis Services Database (38%)

a. Design dimensions and measures.

b. Implement and configure dimensions in a cube.

c. Design a schema to support cube architecture.

d. Create measures.

e. Implement a cube.

f. Create Multidimensional Expressions (MDX) queries.

g. Implement custom logic in a data model.

h. Implement storage design in a multidimensional model.

i. Select an appropriate model for data analysis.

2. Manage, Maintain, and Troubleshoot an SSAS Database (18%)

a. Analyze data model performance.

b. Process data models.

c. Troubleshoot data analysis issues.

d. Deploy SSAS databases.

e. Install and maintain a SSAS instance.

3. Build a Tabular Data Model (17%)

a. Configure permissions and roles in Business Intelligence Semantic Model (BISM).

b. Implement a tabular data model.

c. Implement business logic in a tabular data model.

d. Implement data access for a tabular data model.

4. Build a Report with SQL Server Reporting Services (SSRS) (28%)

a. Design a report.

b. Implement a report layout.

c. Configure authentication and authorization for a reporting solution.

d. Implement interactivity in a report.

e. Troubleshoot reporting services issues.

f. Manage a report environment.

g. Configure report data sources and datasets.


The cost to take up this certification is 80 USD

MCSE - Designing Business Intelligence Solutions with Microsoft SQL Server 2012

1. Plan Business Intelligence (BI) Infrastructure (15%)

a. Plan for performance.

b. Plan for scalability.

c. Plan and manage upgrades.

d. Maintain server health.

2. Design BI Infrastructure (16%)

a. Design a security strategy.

b. Design a SQL partitioning strategy.

c. Design a backup strategy.

d. Design a logging and auditing strategy.

3. Design a Reporting Solution (24%)

a. Design a Reporting Services dataset.

b. Manage Excel Services/Reporting for SharePoint.

c. Design a data acquisition strategy.

d. Plan and manage reporting services configuration.

e. Design BI reporting solution architecture.

4. Design BI Data Models (34%)

a. Design the data warehouse.

b. Design a schema.

c. Design cube architecture.

d. Design fact tables.

e. Design BI Semantic Models.

f. Design and create MDX calculations.

5. Design an ETL Solution (11%)

a. Design SSIS package execution.

b. Plan to deploy SSIS solutions.

c. Design package configurations for SSIS packages.


The cost to take up this certification is 80 USD

Note: We can take all the two certifications of MCSE in a shot with the cost of 136 USD


  1. Resources like the one you mentioned here will be very useful to me! I will post a link to this page on my blog. I am sure my visitors will find that very useful.

  2. Your blog is much effective and thanks for sharing information.. Here we are providing training & materilas and dumps for those who are preparing for cca 175 spark and hadoop developer certification exam and in the related fields of cloudera hadoop developer certification exam.
    cca 175 certification
    cloudera hadoop developer certification
    cca 175 spark and hadoop developer certification
    hadoop developer certification

  3. Wonderful bloggers like yourself who would positively reply encouraged me to be more open and engaging in commenting. So know it's helpful..

    Dataware Housing Training in Chennai

  4. wow really superb you had posted one nice information through this. Definitely it will be useful for many people. So please keep update like this.

    MSBI Training in Chennai

    Software Testing Training in Chennai

  5. Interesting blog post.This blog shows that you have a great future as a content writer.waiting for more updates...
    Digital Marketing Company in India

  6. Useful information about MSBI, i am looking for best msbi online training.