About this Exam:

70-466 examination is planned for business intelligence developers whose main focus is on developing Business Intelligence solutions that need implementation of multi-dimensional data models, OLAP cubes implementation and maintenance, and creation of information that is displayed to use in business decisioning.

Targeted Audience:

This training program for MS SQL Server is intended for candidates with passion to pursue their career in business analysis as BI developers. Key responsibilities are:

• Executing analytical data models like OLAP cubes.
• Executing reports
• Managing reports delivery.
• Developing the dashboards for business performance.
• Support data mining and be able to do predictive analysis.

Prerequisites:

This examination has the below-mentioned requirements that you will be required to meet:

• Have minimum 2 years of work experience in working on relational DBs, such as:
  • Normalized DB designing.
  • Tables and relationships creation.
  • Querying with Transact SQL.
  • General understanding of DWH schema topology such as snowflake and star schemas.
  • Basic exposure to core programming constructs like branching and looping.
• Knowledge of core business priorities including profitability, revenue, and financial accounting is appreciated but not required.

Certifications:

This examination is required to get MCSE: Data Management and Analytics certification

Recommended Prerequisite Courses:

None