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.
Key Features
- 1-year e-learning access
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.
Outline
- Designing Business Intelligence Solutions with Microsoft SQL Server 2012
- Course Introduction
- Course Modules
- Module 1
- 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
- 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 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
- Module 4
- Deploying and Securing Packages
- Deploying Options
- Deploying Packages
- Deploying Projects
- Securing Packages
- Deploying and Securing Packages
- Exam Scenarios
- Module Review
- 467_04_07_01h
- Module 5
- 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
- Module 6
- 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
- Module 7
- 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
- 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 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
- 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) 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
- 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 Part2
- Creating a Data Mining Model Part1
- Exam Scenarios
- Module Review
- Course Review.
- 467_10_04_01h
.