Get started

By signing up, you agree to our Terms of Use and Privacy Policy.
Reset your password
Enter your email and we'll send you instructions on how to reset your password.

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.

  • Access to GreyCampus platform

  • GreyCampus course completion certificate

Subscribe to this course + 29 courses
USD 50

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.

  • 1-year access to audio-video lectures
  • GreyCampus course completion certificate

Course 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

Download full course agenda/brochure

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?
By submitting, you agree to our Terms of Use and Privacy Policy.

Acknowledgements

Our Accreditations

Call us

USA +1 518 302 6767
UK +44 20 8144 4436
IND +91 741 666 4433
HKG +852 8192 9294