Skip to content

Implementing Data Models and Reports with Microsoft SQL Server 2012 (Access to IT Library)

Study towards your MCSE: Data Management and Analytics certification.

ITonlinelearning

Summary

Price
£995 inc VAT
Finance options

Finance options available
Study method
Online
Duration
12 months · Self-paced
Certification
MCSE Data Management & Analytics IT
Professional certification What's this?
Additional info
  • Exam(s) / assessment(s) not included in price, and must be purchased separately

Overview

Expand and prove your ability to work with Microsoft SQL Server 2012 with our engaging, tutor-led course.

Implementing Data Models and Reports with Microsoft SQL Server 2012 70-466 exam is part one of a two-part series of courses to validate your skills and knowledge essential to make the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.

What will I learn?

  • Designing dimensions and measures
  • Implementing and configuring dimensions in a cube
  • Designing a schema to support a cube architecture
  • Creating measures
  • Implementing a cube
  • Creating Multidimensional Expressions (MDX) queries
  • Implementing custom logic in a data model
  • Implementing storage design in a multidimensional model
  • Selecting an appropriate model for data analysis
  • Analysing data model performance
  • Processing data models
  • Troubleshooting data analysis issues
  • Deploying SSAS databases
  • Installing and maintaining an SSAS instance
  • Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)
  • Implementing a tabular data model
  • Implementing business logic in a tabular data model
  • Implementing data access for a tabular data model
  • Designing a report
  • Implementing a report layout
  • Configuring authentication and authorisation for a reporting solution
  • Implementing interactivity in a report
  • Troubleshooting reporting service issues
  • Managing a report environment
  • Configuring report data sources and datasets

Why not try the training before you buy

Get access to a free trial of the course, explore different learning segments and get an exact idea how the training is delivered.

Credit toward the new MCSE SQL Server 2012

ITonlinelearning’s courses follow official Microsoft curriculum and Microsoft 70-466 Implementing Data Models and Reports with Microsoft SQL Server 2012 course contributes a credit toward the Microsoft Certified Solutions Expert (MCSE): Data Management and Analytics certification which ITonlinelearning also offers.

What do I Get?

  • Expert, instructor-led training delivered via video streaming
  • Extensive demonstrations and presentations delivered in a multimedia format
  • Practice tests and full exam simulators
  • Unlimited access to the course for 1 year

What Next?

Enquire today! Our Advisors can answer any questions you have and set up your learning page as soon as you are ready to start your studies.

** This course bundle is part of our IT Library which also includes Certified Network Professional (CCNP), CISSP, MCSA: Windows Server 2016, MCSE: Cloud Platform and Infrastructure and MCSE: Productivity and many more **

Certification

MCSE Data Management & Analytics IT

Awarded by Microsoft
Microsoft logo

Description

Module 1

  • Course Introduction
  • Course Modules
  • 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

Module 2

  • 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

Module 3

  • SSRS Management
  • Deploying Reports
  • Report Security
  • Executing Reports
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Managing Reporting Services
  • Exam Scenarios
  • Module Review

Module 4

  • Multidimensional Cubes
  • Introduction to Cubes
  • Cube Components
  • Creating and Configuring Analysis Services Cube
  • Exam Scenarios
  • Module Review

Module 5

  • Advanced Cube Concepts
  • Measures
  • Formatting Measures
  • Measure Groups
  • Measure Group Storage
  • Aggregations
  • Dimensions
  • Dimension Storage
  • Hierarchies
  • Grouping and Sorting
  • Working with Measures
  • Exam Scenarios
  • Module Review

Module 6

  • Customizing Cubes and Security
  • Actions
  • Perspectives
  • Key Performance Indicators
  • Translations
  • SSAS Security
  • Cell Permissions
  • Dimension Permissions
  • Customizing Cubes and Cube Security
  • Exam Scenarios
  • Module Review

Module 7

  • MultiDimensionaleXpressions (MDX)
  • Introduction to MDX
  • Why Use MDX?
  • MDX Syntax
  • MDX Queries and Filters
  • Sets
  • Applying MDX
  • Working with MDX
  • Exam Scenarios
  • Module Review

Module 8

  • 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

Module 9

  • 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

Module 10

  • 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

Who is this course for?

This course is aimed at anyone hoping to work towards obtaining the MCSE: Data Management and Analytics certification.

Requirements

In order to obtain the MCSE: Data Management and Analytics you must already have gained one of the prerequisite MCSA certifications:

  • MCSA: SQL Server 2012/2014
  • MCSA: SQL 2016 BI Development
  • MCSA: SQL 2016 Database Administration
  • MCSA: SQL 2016 Database Development
  • MCSA: Machine Learning
  • MCSA: BI Reporting
  • MCSA: Data Engineering with Azure

Career path

  • Database Analyst
  • Database Designer
  • Business Intelligence Analyst
  • Business Intelligence Consultant

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Database, SQL, IT, Coding
Related searches: Online courses