go backexam details

αναλυτικές πληροφορίες εξέτασης

70-466

Implementing Data Models and Reports with Microsoft SQL Server 2012

SQL Server Version : 2012
Απευθύνεται σε : Developers

EXAM OVERVIEW

 

The primary audience for this exam is BI Developer. They are most likely to focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. Primary responsibilities may include:


  • Working with large data sets across multiple database systems
  • Cube/warehouse/views fundamentals
  • Data model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)
  • Develop Cubes and Multidimensional Expressions (MDX) queries to support analysts
  • Online Analytical Processing (OLAP) cube performance
  • Building pivot tables from cubes
  • Building PowerPivot solutions
  • Design and test report models, layouts and templates
  • Manage reporting system: configuration and subscriptions
  • Using report builder to create reports
  • Develop complex SQL queries for reports
  • Building reports Using Power View
Share it:

newsletter subscription

Εάν επιθυμείτε να λαμβάνετε ενημέρωση από εμάς, δώστε μας το e-mail σας.
PASS chapter logo
Official Professional Association for SQL Server (PASS) chapter for Greece
Join to PASS