merger merger

Welcome to your new course portal!

On October 15th, moved to - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show as: Mobile

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

Course summary
229 GBP
e-learning / Online / Distance

Course description

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

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
  • 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 ModelsPowerPivot
  • 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
  • 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 ReviewCourse Review

Course Delivery:    Online

About provider

Hudson - Leaders in Learning

Hudson provide high spec e-learning to the consumer and corporate market all over the world. The majority of our online training is accessible across most devices including laptop, desktop, tablet, and smart phones. Our courses are designed to fit around...

Read more and show all courses with this provider

Customer Outreach Award 2019


We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Request info

Fill out your details to find out more about Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012.

  Contact the provider

  Get more information

  Register your interest

Contact info


 Show phone number

Request Information

Find out more about this Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 course - simply fill out your details:


There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in's second annual U.K. L&D Report!


Learn more