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

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

We've put together a list of relevant job titles you can apply for after achieving the Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):

• Database Administrator
• Database Developer
• Database Analyst

• 

  Flexible Learning

  Study247 anytime, anywhere on any device.

• 

  World Class E-learning Platform

  Study in a user friendly, state-of-the-art e-learning platform.

• 

  Expert Instructor-Led Training

  Access step-by-step video tutorials delivered by leading industry experts.

• 

  Visual Demonstrations & Multimedia Presentations

  Develop your skills based on real world scenarios.

• 

  Quizzes & Mock Exam

  Interactive quizzes after each module and a mock exam at the end of your course to ensure you're fully prepared for your final certification exam.

• 

  Flash Cards & Educational Games

  Allow you to train in ways that keep you engaged and focus.

• 

  Social Learning & Networking

  Interact and collaborate with other students, form study groups, engage in discussions, rate different courses and stay up to date with all the latest industry knowledge.

• 

  Navigation & Controls

  Allows you to study in bite-size chunks. You can pause, rewind or fast forward your tutorials, take study notes and more.

As a bolt-on option, we offer Practice Labs as it provides users with an online lab platform to develop their practical skills in IT technologies such as CompTIA, Microsoft, Cisco and VMWare.

In addition to the hardware you require, you also gain access to high quality practical exercises covering exam topics to help you to maximize your study time and increase your results. Practice Labs are highly effective and offer a cheaper alternative to setting up your own test environment.

You will gain unlimited access to the Practice Labs for 12 months- helping you to consolidate your learning and prepare you for work.Learn More

When you enrol on a course with us, you automatically qualify for an XO student discount card which will enable you to enjoy savings from not only high street retailers, bars and restaurants, but also travel companies across the United Kingdom. Learn More