Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (Microsoft 70-467 Course)

Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$376

Course Overview

Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Expand and prove your ability to work with Microsoft SQL Server 2012 with our engaging, tutor-led course.

The Designing Business Intelligence Solutions with Microsoft SQL Server 2012 70-467 exam is part two 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.

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

What will I learn?

  • Performance planning
  • Scalability planning
  • Planning for managing upgrades
  • Maintaining server health
  • Designing a security strategy
  • SQL partitioning strategy design
  • Backup strategy design
  • Designing a logging and auditing strategy
  • Reporting Services dataset design
  • Managing Excel Services/Reporting for SharePoint
  • Data acquisition strategy design
  • Planning and managing reporting services configuration
  • BI reporting solution architecture design
  • Data warehouse design
  • Designing a schema
  • Designing cube architecture
  • Designing fact tables
  • BI Semantic Model design
  • Designing and creating MDX calculations
  • Designing SSIS package execution
  • Planning to deploy SSIS solutions
  • Designing package configurations for SSIS packages

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

Who should take this course

Anyone interested to learn this course.

Accreditation

Designing Business Intelligence Solutions with Microsoft SQL Server 2012, Awarded by Microsoft

Course content

Course Outline

  • Module 1 - Course Introduction
  • Module 2 - Designing a Data Warehouse
  • Module 3 - Extraction, Transformation, and Load (ETL) with SSIS
  • Module 4 - Deploying and Securing Packages
  • Module 5 - SQL Server Reporting Services (SSRS)
  • Module 6 - SSRS Reports
  • Module 7 - Multidimensional Cubes
  • Module 8 - Tabular Data Models
  • Module 9 - MDX/DAX
  • Module 10 - Data Mining

About Course Provider

Located in Sittingbourne, Kent in the United Kingdom, ITonlinelearning was founded by Jeremy Dargie in 2009. Our aim is to help both aspiring and seasoned professionals gain internationally recognised, accredited certifications that enable them to begin and develop their careers and develop into sought after and well-versed professionals.

We are able to tailor your courses to your specific needs, giving you the opportunity to study courses on offer from world-leading companies such as Microsoft, Cisco, CompTIA, PRINCE2, Adobe, NEBOSH and CIW, to name but a few. These certifications will help you, like thousands others, reach your certification goals and beyond, ensuring that you develop your chosen career into a lucrative and rewarding profession.