Cart Subtotal: $0.00

Welcome Student!

  • Contact Us
  • (888) 840-2378
  • Tech Support: (866) 830-9276
  • Click here to chat!

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

Click on image to zoom

Be the first to review this product

SKU# 147456

Availability: In stock

$199.00

$59.00

Secure shopping trustmarks

Quick Overview

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

QuickCert Exam Pass Guarantee

QuickCert’s online IT training programs are guaranteed to get you certified – or we will pay for your make-up exam. Our quality online IT courseware, packed with instruction, exercises, practice exams and test simulators will ensure you pass the exam. Learn more.

Course Description

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012.

This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include but are not limited to:

  • BI Solution architecture and design
  • Provisioning of software and hardware
  • Data warehouse and data mart design
  • Online Analytical Processing (OLAP) cube design
  • Integration with SharePoint or line of business applications

This training course on designing business intelligence solutions with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-467.

This course will provide all the skills and knowledge for the following areas:
  • 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

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Syllabus
Instructor Introduction
Course Outline

Module 1

Course Introduction
Course Modules
Introduction to Data Warehousing
On-Line Transaction Processing (OLTP) vs. OLAP
Data Warehousing
Data Warehouse Architecture
Creating a Data Warehouse
Presenting On-Line Analytical Processing (OLAP) Data
OLTP vs. OLAP Demonstration
Exam Scenarios
Module Review

Module 2

Designing a Data Warehouse
Data Modeling
Data Warehouse Schemas
Time Dimensions
Data Modeling Considerations
Implementing a Data Model
Logical Model
Physical Model
Working with Dimensions and Fact Tables
Exam Scenarios
Module Review

Module 3

Extraction, Transformation, and Load (ETL) with SSIS
Introduction to SQL Server Integration Services (SSIS)
Upgrading SSIS Packages
SSIS Tools
Introduction to Data Flow Tasks
Data Sources
Transformations
Destinations
Control Flow
Variables
Expressions
Precedence
Containers
Control Flow Containers
Transactions
Package Execution with Checkpoints
Working with SSIS Packages
Exam Scenarios
Module Review

Module 4

Deploying and Securing Packages
Deploying Options
Deploying Packages
Deploying Projects
Securing Packages
Deploying and Securing Packages
Exam Scenarios
Module Review

Module 5

SQL Server Reporting Services (SSRS)
Introduction to Reporting Services
SSRS Reports Creation and Delivery
SSRS Reports
Grouping
Expressions
Drilldown
Parameters
Drillthrough
Visual Components
Creating Reports Within Reporting Services
Exam Scenarios
Module Review

Module 6

SSRS Reports
Deploying Reports
Report Security
Report Execution
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Deploying Reports and Report Security
Exam Scenarios
Module Review

Module 7

Multidimensional Cubes
Introduction to Cubes
Components of a Multidimensional Cubes
Measures
Measure Format and Aggregation Functions
Measure Groups
Aggregations
Dimensions
Dimension Storage
Dimensions Hierarchies
Grouping and Sorting
Actions
Perspectives
Key Performance Indicators
Translations
SSAS Security
Cell Permissions
Dimension Permissions
Creating and Configuring a Cube
Exam Scenarios
Module Review

Module 8

Tabular Data Models
Introduction to Tabular Data Models
PowerPivot
Working with PowerPivot
Linked and Non-Linked Tables
PowerPivot Features
Server Based Tabular Data Models
Creating a Tabular Data Model
Tabular Models with SSDT
Workspace Database
Tabular Data Model
Tabular Data Model Security
Creating a Tabular Data Model Using PowerPivot
Exam Scenarios
Module Review

Module 9

MDX/DAX
Introduction to Multidimensional Expressions (MDX)
Why Use MDX?
MDX Syntax
Sets
Where is MDX Used?
Introduction to Data Analysis eXpressions (DAX)
Working with DAX
DAX Functions
DAX Queries
Calculated Columns
DAX Measures
Multiple Relationships
Exam Scenarios
Module Review

Module 10

Data Mining
Introduction to Data Mining
Data Mining Algorithms
Data Mining Components
Validating and Presenting Data Mining Models
Creating a Data Mining Model
Exam Scenarios
Module Review
Course Review

Instructor Bio

David Dye

Reviews
Write Your Own Review

You're reviewing: Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

  •  
    1 star
    2 stars
    3 stars
    4 stars
    5 stars
    Quality
    Price
    Value

* Required Fields