MCSE SQL Server 2012 Business Intelligence (Live Labs Included)

Provided by

  • Sector IT
  • Course Type Online
  • Duration 1 Year
  • Price £170

Enquire about this course

About the course

About Microsoft

Microsoft are the world’s leading tech company, and they are one of the biggest brands in the world, let alone in IT. Their aim is to empower individuals and organisations to achieve more through their three key areas: certifications, technology and business support.

Course Units

Microsoft 70-461: Querying SQL Server 2012

Microsoft 70-462: Administering SQL Server 2012 Databases

Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012

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

  • Introduction to Business Intelligence and Data Modelling
  • Implementing Reports – The SQL Server Reporting Services
  • Supporting Self Service Reporting
  • Managing Report Execution and Delivery
  • Creating Multidimensional Databases
  • Working with Cubes and Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Customising Cube Functionality
  • Implementing a Tabular Data Model
  • Introduction to DAX
  • Implementing an Analysis Services Tabular Data Model
  • SQL Analysis Services
  • Creating Data Visualisations with Power View
  • Supporting Self Service Reporting
  • Performing Predictive Analysis with Data Mining
  • Predictive Analysis

Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

  • Intro to Business Intelligence
  • Database Essentials
  • Business Intelligence Development
  • Business Intelligence Results
  • Advanced Reporting and Development
  • SQL Server Integration Services (SSIS)
  • SQL Server 2014 New Features
  • Course Review and Exam Prep

Related article

Bag yourself a course this Black Friday