About this course:

This exam is intended for business intelligence (BI) developers who focus on creating BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.

Audience:

The Microsoft SQL Server training program is designed for students eager to analyze business tool and data as BI developers. Primary responsibilities include:

• Implementing analytical data models, such as OLAP cubes.

• Implementing reports, and managing report delivery.

• Creating business performance dashboards.

• Supporting data mining and predictive analysis.

Prerequisites:

This exam requires that you meet the following prerequisites:

• At least 2 years’ experience of working with relational databases, including:

• Designing a normalized database.

• Creating tables and relationships.

• Querying with Transact-SQL.

• Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).

• Some exposure to basic programming constructs (such as looping and branching).

• An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Certifications:

This exam qualifies as the 1 required exam to earn MCSE: Data Management and Analytics certification.