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

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

1. Designing Business Intelligence Solutions with Microsoft SQL Server 2012
   1. Course Introduction
   2. Course Modules
2. Module 1
   1. Introduction to Data Warehousing
   2. On-Line Transaction Processing (OLTP) vs. OLAP
   3. Data Warehousing
   4. Data Warehouse Architecture
   5. Creating a Data Warehouse Part2
   6. Creating a Data Warehouse Part1
   7. Presenting On-Line Analytical Processing (OLAP) Data
   8. OLTP vs. OLAP Demonstration
   9. Exam Scenarios
   10. Module Review
   11. 467_01_02_01h
3. Module 2
   1. Designing a Data Warehouse
   2. Data Modeling
   3. Data Warehouse Schemas
   4. Time Dimensions
   5. Data Modeling Considerations
   6. Implementing a Data Model
   7. Logical Model
   8. Physical Model
   9. Working with Dimensions and Fact Tables
   10. Exam Scenarios
   11. Module Review
4. Module 3
   1. Extraction, Transformation, and Load (ETL) with SSIS
   2. Introduction to SQL Server Integration Services (SSIS)
   3. Upgrading SSIS Packages
   4. SSIS Tools
   5. Introduction to Data Flow Tasks
   6. Data Sources
   7. Transformations
   8. Destinations
   9. Control Flow
   10. Variables
   11. Expressions
   12. Precedence
   13. Containers
   14. Control Flow Containers Part1
   15. Control Flow Containers Part2
   16. Transactions
   17. Package Execution with Checkpoints
   18. Working with SSIS Packages Part1
   19. Working with SSIS Packages Part3
   20. Working with SSIS Packages Part2
   21. Exam Scenarios
   22. Module Review
   23. 467_03_16_01h
5. Module 4
   1. Deploying and Securing Packages
   2. Deploying Options
   3. Deploying Packages
   4. Deploying Projects
   5. Securing Packages
   6. Deploying and Securing Packages
   7. Exam Scenarios
   8. Module Review
   9. 467_04_07_01h
6. Module 5
   1. SQL Server Reporting Services (SSRS)
   2. Introduction to Reporting Services Part2
   3. Introduction to Reporting Services Part1
   4. SSRS Reports Creation and Delivery
   5. SSRS Reports
   6. Grouping
   7. Expressions
   8. Drilldown
   9. Parameters
   10. Drillthrough
   11. Visual Components
   12. Creating Reports Within Reporting Services Part1
   13. Creating Reports Within Reporting Services Part3
   14. Creating Reports Within Reporting Services Part2
   15. Creating Reports Within Reporting Services Part4
   16. Exam Scenarios
   17. Module Review
7. Module 6
   1. SSRS Reports
   2. Deploying Reports
   3. Report Security
   4. Report Execution
   5. Report Caching
   6. Report Snapshot
   7. Subscriptions
   8. Data Alerts
   9. Deploying Reports and Report Security Part1
   10. Deploying Reports and Report Security Part2
   11. Exam Scenarios
   12. Module Review
   13. 467_06_04_01h
8. Module 7
   1. Multidimensional Cubes
   2. Introduction to Cubes Part1
   3. Introduction to Cubes Part2
   4. Components of a Multidimensional Cubes
   5. Measures
   6. Measure Format and Aggregation Functions
   7. Measure Groups Part1
   8. Measure Groups Part2
   9. Aggregations
   10. Dimensions
   11. Dimension Storage
   12. Dimensions Hierarchies
   13. Grouping and Sorting
   14. Actions
   15. Perspectives
   16. Key Performance Indicators
   17. Translations
   18. SSAS Security
   19. Cell Permissions
   20. Dimension Permissions
   21. Creating and Configuring a Cube Part1
   22. Creating and Configuring a Cube Part2
   23. Creating and Configuring a Cube Part3
   24. Creating and Configuring a Cube Part4
   25. Exam Scenarios
   26. Module Review
   27. 467_07_09_01h
9. Module 8
   1. Tabular Data Models
   2. Introduction to Tabular Data Models
   3. PowerPivot
   4. Working with PowerPivot
   5. Linked and Non-Linked Tables
   6. PowerPivot Features
   7. Server Based Tabular Data Models Part1
   8. Server Based Tabular Data Models Part2
   9. Creating a Tabular Data Model Using PowerPivot Part3
   10. Tabular Models with SSDT
   11. Workspace Database
   12. Tabular Data Model
   13. Tabular Data Model Security
   14. Tabular Data Mode
   15. Creating a Tabular Data Model Using PowerPivot Part4
   16. Creating a Tabular Data Model Using PowerPivot Part1
   17. Creating a Tabular Data Model Using PowerPivot Part2
   18. Creating a Tabular Data Model Using PowerPivot Part4
   19. Exam Scenarios
   20. Module Review
   21. 467_08_13_02c
10. Module 9
    1. MDX/DAX
    2. Introduction to Multidimensional Expressions (MDX)
    3. Why Use MDX?
    4. MDX Syntax
    5. Sets
    6. Where is MDX Used?
    7. Introduction to Data Analysis eXpressions (DAX) Part1
    8. Introduction to Data Analysis eXpressions (DAX) Part2
    9. Working with DAX
    10. DAX Functions
    11. DAX Queries
    12. Calculated Columns
    13. DAX Measures
    14. Multiple Relationships
    15. Exam Scenarios
    16. Module Review
11. Module 10
    1. Data Mining
    2. Introduction to Data Mining
    3. Data Mining Algorithms
    4. Data Mining Components
    5. Validating and Presenting Data Mining Models
    6. Creating a Data Mining Model Part2
    7. Creating a Data Mining Model Part1
    8. Exam Scenarios
    9. Module Review
    10. Course Review.
    11. 467_10_04_01h