Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

 

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.

Request a quote Review training schedules

Learn more about the course below.

TRAINING SCHEDULES

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Training course overview

This course is designed for BI Developers who most-likely 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 but are not limited to:

  • 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 Crescent

 

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

The course curriculum

The curriculum for this Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 training incorporates all updates a list of broad topics covered

  • SQL Server 2012 Business Intelligence
  • Introduction to Business Intelligence
  • Data Warehouse
  • Extract, Transform and Load (ETL)
  • SQL Server Integration Services
  • SQL Server 2012 BI Tools
  • Developer Tools
  • Exam Scenarios
  • SQL Server Reporting Services
  • Introduction to SSRS
  • Creation and Delivery
  • SSRS Reports
  • Report Grouping
  • Expressions
  • Drilldown Report
  • Parameters
  • Visual Components
  • Creating SQL Server
  • Exam Scenarios
  • Module Review
  • SSRS Management
  • Deploying Reports
  • Report Security
  • Executing Reports
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Managing Reporting Services
  • Exam Scenarios
  • Module Review
  • Multidimensional Cubes
  • Introduction to Cubes
  • Cube Components
  • Creating & Configuring Analysis Services Cube
  • Exam Scenarios
  • Module Review
  • Advanced Cube Concepts
  • Measures
  • Formatting Measures
  • Measure Groups
  • Measure Group Storage
  • Aggregations
  • Dimensions
  • Dimension Storage
  • Grouping and Sorting
  • Working with Measures
  • Exam Scenarios
  • Module Review
  • Customizing Cubes and Security
  • Actions
  • Perspectives
  • Key Performance Indicators
  • Translations
  • SSAS Security
  • Cell Permissions
  • Dimension Permissions
  • Customizing Cubes & Cube Security
  • Exam Scenarios
  • Module Review
  • MultiDimensional eXpressions (MDX)
  • Introduction to MDX
  • Why Use MDX?
  • MDX Syntax
  • MDX Queries and Filters
  • Sets
  • Applying MDX
  • Working with MDX
  • Exam Scenarios
  • Module Review
  • Tabular Data Models
  • Introduction to TDM
  • PowerPivot
  • Linked and Non-Linked Tables
  • PowerPivot
  • Server Based Tabular Data Models
  • Creating a Tabular Data Model
  • Workspace Database
  • Tabular Data Model
  • Working with Tabular Data Modeling
  • Exam Scenarios
  • Module Review
  • Data Analysis eXpressions (DAX)
  • Introduction to DAX
  • Working with DAX
  • DAX Functions
  • DAX Queries
  • Calculated Columns
  • Measures
  • Multiple Relationships
  • Working with DAX within PowerPivot
  • Exam Scenarios
  • Module Review
  • Data Mining
  • Introduction to Data Mining
  • Data Mining Algorithms
  • Data Mining Components
  • Validating Mining Models
  • Presenting Mining Data
  • Creating a Mining Structure
  • Exam Scenarios
  • Module Review
  • Course Review