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

Current Status
Not Enrolled
Price
£11.99
Get Started
or

Table of Contents

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

stay informed!

Subscribe to receive exclusive content and notifications

small_c_popup.png

Share this course

[geturl]
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Keep in touch

Fill in your details and we’ll get back to you in no time.