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

299 USD 9 USD 97%
Test scorm

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:

read more

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
  1. Module 1
7
Start
Data Warehouse Architecture
8
Start
Creating a Data Warehouse
8
Start
Creating a Data Warehouse
9
Start
Presenting On-Line Analytical Processing (OLAP) Data
10
Start
OLTP vs. OLAP Demonstration
11
Start
Exam Scenarios
12
Start
Module Review
  1. Module 2
13
Start
Designing a Data Warehouse
14
Start
Data Modeling
15
Start
Data Warehouse Schemas
16
Start
Time Dimensions
17
Start
Data Modeling Considerations
18
Start
Implementing a Data Model
19
Start
Logical Model
20
Start
Physical Model
21
Start
Working with Dimensions and Fact Tables
22
Start
Exam Scenarios
23
Start
Module Review
  1. Module 3
24
Start
Extraction, Transformation, and Load (ETL) with SSIS
25
Start
Introduction to SQL Server Integration Services (SSIS)
26
Start
Upgrading SSIS Packages
27
Start
SSIS Tools
28
Start
Introduction to Data Flow Tasks
29
Start
Data Sources
30
Start
Transformations
31
Start
Destinations
32
Start
Control Flow
33
Start
Variables
34
Start
Expressions
35
Start
Precedence

No reviews for this course !

Add New Discussion

How do you rate this product?
7 + 7 =

Select currency