Microsoft 70-466: Implementing Data Models & Reports With Sql Server 2012

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
This course prepares students for the 70-466: Implementing Data Models and Reports with SQL Server 2012 exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, delivering reports with Microsoft SQL Server Reporting Services, creating dashboards with Microsoft SharePoint Server Performance Point Services, and discovering business insights by using data mining.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

Who Is This Course For?
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.

Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.

Certification Details
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Data Mining
  • Server
  • SQL
  • Business Intelligence

Course programme

Module 1: Introduction to Business Intelligence and Data Modeling

  • 1.1 Introduction to Business Intelligence and Data Modeling Part 1
  • 1.2 Introduction to Business Intelligence and Data Modeling Part 2
  • 1.3 The Microsoft Business Intelligence Platform Part 1
  • 1.4 The Microsoft Business Intelligence Platform Part 2
  • 1.5 The Microsoft Business Intelligence Platform Part 3
  • 1.6 The Microsoft Business Intelligence Platform Part 4

Module 2: Implementing Reports The SQL Server Reporting Services

  • 2.1 Implementing Reports the SQL Server Reporting Services Part 1
  • 2.2 Implementing Reports the SQL Server Reporting Services Part 2
  • 2.3 Implementing Reports the SQL Server Reporting Services Part 3
  • 2.4 Implementing Reports the SQL Server Reporting Services Part 4
  • 2.5 Implementing Reports the SQL Server Reporting Services Part 5
  • 2.6 Implementing Reports the SQL Server Reporting Services Part 6
  • 2.7 Implementing Reports the SQL Server Reporting Services Part 7
  • 2.8 Implementing Reports the SQL Server Reporting Services Part 8

Module 3: Supporting Self Service Reporting

  • 3.1 Supporting Self Service Reporting Part 1
  • 3.2 Supporting Self Service Reporting Part 2

Module 4: Managing Report Execution and Delivery

  • 4.1 Managing Report Execution and Delivery
  • 4.2 Managing Report Execution
  • 4.3 Subscriptions and Data Alerts

Module 5: Creating Multidimensional Databases

  • 5.1 Creating Multidimensional Databases
  • 5.2 Creating Data Sources and Data Source Views
  • 5.3 Creating and Browsing a Cube

Module 6: Working with Cubes and Dimensions

  • 6.1 Working with Cubes and Dimensions
  • 6.2 Sorting and Grouping Attributes

Module 7: Working with Measures and Measure Groups

  • 7.1 Working with Measures and Measure Groups

Module 8: Introduction to MDX

  • 8.1 Introduction to MDX
  • 8.2 Adding Calculations to A Cube

Module 9: Customizing Cube Functionality

  • 9.1 Customizing Cube Functionality Part 1
  • 9.2 Customizing Cube Functionality Part 2
  • 9.3 Customizing Cube Functionality Part 3

Module 10: Implementing A Tabular Data Model

  • 10.1 Implementing A Tabular Data Model Part 1
  • 10.2 Implementing A Tabular Data Model Part 2

Module 11: Introduction to DAX

  • 11.1 Introduction to DAX
  • 11.2 Demonstration Making a Tabular Model Part 1
  • 11.3 Demonstration Making a Tabular Model Part 2
  • 11.4 Using DAX

Module 12: Implementing an Analysis Services Tabular Data Model

  • 12.1 Implementing an Analysis Services Tabular Data Model Part 1
  • 12.2 Implementing an Analysis Services Tabular Data Model Part 2
  • 12.3 Deploying A Tabular Data Model

Module 13: SQL Analysis Services

  • 13.1 SQL Analysis Services Part 1
  • 13.2 SQL Analysis Services Part 2

Module 14: Creating Data Visualizations with Power View

  • 14.1 Creating Data Visualizations with Power View

Module 15: Supporting Self Service Reporting

  • 15.1 Supporting Self Service Reporting

Module 16: Performing Predictive Analysis with Data Mining

  • 16.1 Performing Predictive Analysis with Data Mining
  • 16.2 Using the Data Mining Wizard

Module 17: Predictive Analytics

  • 17.1 Predictive Analytics Part 1
  • 17.2 Predictive Analytics Part 2

Microsoft 70-466: Implementing Data Models & Reports With Sql Server 2012

Price on request