DAYS

HRS

MIN

SEC
Flat 70% off on elearning bundle courses

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

4k learners

This course is designed to measure the knowledge and skills of participants in making suitable career choices in developing Microsoft SQL Server 2012 Databases. It is intended for Business Intelligence Architects who focus on the complete design of the BI structure, including how it associates with other data systems in use.

  • 1-year e-learning access

  • Course completion certificate

  • 100% money-back guarantee

Online Self Learning USD 99 (USD 129) Enroll Now
Live Online Training -- Get Quote
Traditional Classroom -- Get Quote

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

The Microsoft 70-467 course prepares you to pass the Microsoft 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 exam which validates your ability to design Business Intelligence Solutions with Microsoft SQL Server 2012. This course is suitable for IT professionals and anyone aspiring for a Microsoft certification.

Course Outline

Course Introduction
Course Modules
Introduction to Data Warehousing
On-Line Transaction Processing (OLTP) vs. OLAP
Data Warehousing
Data Warehouse Architecture
Creating a Data Warehouse Part2
Creating a Data Warehouse Part1
Presenting On-Line Analytical Processing (OLAP) Data
OLTP vs. OLAP Demonstration
Exam Scenarios
Module Review
467_01_02_01h
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
Control Flow Containers Part1
Control Flow Containers Part2
Transactions
Package Execution with Checkpoints
Working with SSIS Packages Part1
Working with SSIS Packages Part3
Working with SSIS Packages Part2
Exam Scenarios
Module Review
467_03_16_01h
Deploying and Securing Packages
Deploying Options
Deploying Packages
Deploying Projects
Securing Packages
Deploying and Securing Packages
Exam Scenarios
Module Review
467_04_07_01h
SQL Server Reporting Services (SSRS)
Introduction to Reporting Services Part2
Introduction to Reporting Services Part1
SSRS Reports Creation and Delivery
SSRS Reports
Grouping
Expressions
Drilldown
Parameters
Drillthrough
Visual Components
Creating Reports Within Reporting Services Part1
Creating Reports Within Reporting Services Part3
Creating Reports Within Reporting Services Part2
Creating Reports Within Reporting Services Part4
Exam Scenarios
Module Review
SSRS Reports
Deploying Reports
Report Security
Report Execution
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Deploying Reports and Report Security Part1
Deploying Reports and Report Security Part2
Exam Scenarios
Module Review
467_06_04_01h
Multidimensional Cubes
Introduction to Cubes Part1
Introduction to Cubes Part2
Components of a Multidimensional Cubes
Measures
Measure Format and Aggregation Functions
Measure Groups Part1
Measure Groups Part2
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 Part1
Creating and Configuring a Cube Part2
Creating and Configuring a Cube Part3
Creating and Configuring a Cube Part4
Exam Scenarios
Module Review
467_07_09_01h
Tabular Data Models
Introduction to Tabular Data Models
PowerPivot
Working with PowerPivot
Linked and Non-Linked Tables
PowerPivot Features
Server Based Tabular Data Models Part1
Server Based Tabular Data Models Part2
Creating a Tabular Data Model Using PowerPivot Part3
Tabular Models with SSDT
Workspace Database
Tabular Data Model
Tabular Data Model Security
Tabular Data Mode
Creating a Tabular Data Model Using PowerPivot Part4
Creating a Tabular Data Model Using PowerPivot Part1
Creating a Tabular Data Model Using PowerPivot Part2
Creating a Tabular Data Model Using PowerPivot Part4
Exam Scenarios
Module Review
467_08_13_02c
MDX/DAX
Introduction to Multidimensional Expressions (MDX)
Why Use MDX?
MDX Syntax
Sets
Where is MDX Used?
Introduction to Data Analysis eXpressions (DAX) Part1
Introduction to Data Analysis eXpressions (DAX) Part2
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 Part2
Creating a Data Mining Model Part1
Exam Scenarios
Module Review
Course Review.
467_10_04_01h

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements