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

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.

Request a quote Review training schedules

Learn more about the course below.


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

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:

If you are currently a manager or a founder of your own business, instead of randomly doing your job, you must assume the leadership role and lead.

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.


The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email ( or via our online chat system.

The course curriculum

The curriculum for this Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 training incorporates all updates a list of broad topics covered

  • 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
  • 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
  • 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
  • Transactions
  • Package Execution with Checkpoints
  • Working with SSIS Packages
  • Exam Scenarios
  • Module Review
  • Deploying and Securing Packages
  • Deploying Options
  • Deploying Packages
  • Deploying Projects
  • Securing Packages
  • Deploying and Securing Packages
  • Exam Scenarios
  • Module Review
  • 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
  • SSRS Reports
  • Deploying Reports
  • Report Security
  • Report Execution
  • Report Caching
  • Report Snapshot
  • Subscriptions
  • Data Alerts
  • Deploying Reports and Report Security
  • Exam Scenarios
  • Module Review
  • 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
  • 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
  • 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
  • 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