MOC 20467C Designing Self-Service Business Intelligence and Big Data Solutions

How To Take This Class

Live Instructor-Led Online Class

Cost: $2,250.00 or 5 Vouchers

  • Open enrollment class for individuals
  • Live class with an instructor
  • Free class retakes forever!
  • Six months of instructor email support
  • Hands-on exercises and student labs
  • Classes never cancelled due to low enrollment
  • Money-back guarantee

    Sorry, no courses are scheduled at this time. Please Contact Us to schedule this course.

Onsite or Offsite Group Training

Cost: Based on number of students

  • For groups as small as 3 people
  • Class Held at our location or yours
  • Hands-on exercises and student labs
  • Customization at no extra charge
  • Six months of instructor email support
  • All-inclusive pricing
  • Money-back guarantee
Request Group Pricing Proposal

Course Duration

5 Days

What Students Receive

Each student will receive:
  • A printed courseware manual with samples and hands-on exercises for use during and after class.
  • Sample course files and solutions
  • Access to a complete, online lab environment both during and after class to practice your new skills.
  • A course completion certificate upon successful completion of the course

Course Description

This five-day instructor-led course teaches students how to design and implement a BI infrastructure. The course discusses design, installation and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

Course Objectives

Upon successful completion of this course students will be able to:
  • Plan the components of a BI solution.
  • Plan a BI infrastructure.
  • Design a data warehouse.
  • Design an ETL solution.
  • Plan analytical data models.
  • Plan a BI delivery solution.
  • Design a Reporting Services solution.
  • Design an Excel reporting solution.
  • Plan a SharePoint Server BI solution.
  • Monitor and optimize a BI solution.
  • Plan for BI operations.

Course Audience

This course is intended for BI professionals such as BI Architects or database professionals who need to design BI solutions. BI Architects are responsible for the overall design of the BI infrastructure, including how it relates to other data systems in use. In addition, their responsibilities include Online Analytical Processing (OLAP) cube design and integration with Microsoft SharePoint or line-of-business applications.

Course Prerequisites

Before attending this course, students must have:
  • A basic understanding of dimensional modeling (star schema) for data warehouses.
  • The ability to create Integration Services packages that include control flows and data flows.
  • The ability to create a basic multidimensional cube with Analysis Services.
  • The ability to create a basic tabular model with PowerPivot and Analysis Services.
  • The ability to create Reporting Services reports with Report Designer.
  • The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services.
  • Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel.

Course Syllabus

  • Planning a BI Solution
    • Elements of a BI Solution
    • The Microsoft BI Platform
    • Planning a BI Project
    • Lab : Planning a BI Solution
      • Scoping a BI Solution
      • Determining Software Requirements
  • Planning SQL Server Business Intelligence Infrastructure
    • Considerations for BI Infrastructure
    • Planning Data Warehouse Hardware
    • Lab : Planning a BI Infrastructure
      • Planning Server Topology
      • Planning Data Warehouse Server Hardware
  • Designing a Data Warehouse
    • Data Warehouse Design Overview
    • Designing Dimension Tables
    • Designing Fact Tables
    • Designing a Data Warehouse Physical Implementation
    • Lab : Designing a Data Warehouse Logical Schema
      • Identifying Business Processes and Dimensions
      • Designing Dimension Models and Data Warehouse Tables
    • Lab : Designing a Data Warehouse Physical Implementation
      • Designing File Storage
      • Designing Warehouse Data Structures
  • Designing an ETL Solution
    • ETL Overview
    • Planning Data Extraction
    • Planning Data Transformation
    • Planning Data Loads
    • Lab : Designing an ETL Solution
      • Preparing for ETL Design
      • Creating Source-to-Target Documentation
      • Using SSIS To Load a Partitioned Fact Table
  • Designing Analytical Data Models
    • Introduction to Analytical Data Models
    • Designing an Analytical Data Model
    • Designing Dimensions
    • Enhancing Data Models
    • Lab : Comparing Analytical Data Models
      • Creating a Multidimensional Data Model
      • Creating a Tabular Data Model
    • Lab : Designing Dimensions and Hierarchies
      • Creating Dimensions in a Multidimensional Data Model
      • Creating Dimensions in a Tabular Data Model
    • Lab : Enhancing Analytical Data Models
      • Enhancing a Multidimensional Data Model
      • Enhancing a Tabular Data Model
  • Planning a BI Delivery Solution
    • Considerations for Delivering BI
    • Common Reporting Scenarios
    • Choosing a Reporting Tool
    • Lab : Planning a BI Delivery Solution
      • Assessing Reporting Requirements
  • Designing a Reporting Services Solution
    • Planning a Reporting Services Solution
    • Designing Reports
    • Planning Report Consistency
    • Lab : Designing a Reporting Services Solution
      • Designing a Reporting Environment
      • Creating Reusable Report Item
      • Creating Reports
  • Designing a Microsoft Excel-Based Reporting Solution
    • Using Excel for Data Analysis and Reporting
    • PowerPivot for Excel
    • Power View for Excel
    • Lab : Designing an Excel Reporting Solution
      • Planning Excel Features
      • Analyzing a Cube with Excel
      • Creating a PowerPivot Workbook
      • Using Power View in Excel
  • Planning a SharePoint Server BI Solution
    • Introduction to SharePoint Server as a BI Platform
    • Planning Security for a SharePoint Server BI Solution
    • Planning Reporting Services Configuration
    • Planning PowerPivot Configuration
    • Planning for PerformancePoint Services
    • Lab : Implementing a SharePoint Server BI Solution
      • Creating a SharePoint Server Site for BI
      • Configuring Reporting Services in SharePoint Server
      • Configuring PowerPivot for SharePoint
    • Lab : Implementing a PerformancePoint Services
      • Creating a PerformancePoint Dashboard
  • Monitoring and Optimizing a BI Solution
    • Overview of BI Monitoring
    • Monitoring and Optimizing the Data Warehouse
    • Monitoring and Optimizing Analysis Services
    • Monitoring and Optimizing Reporting Services
    • Lab : Monitoring and Optimizing a BI Solution
      • Monitoring and Optimizing a Data Warehouse
      • Monitoring and Optimizing Analysis Services
      • Monitoring and Optimizing Reporting Services
  • Operating a BI Solution
    • Overview of BI Operations
    • ETL Operations
    • Data Warehouse Operations
    • Analysis Services Operations
    • Reporting Services Operations
    • Lab : Operating a BI Solution
      • Configuring SQL Server Integration Services
      • Automate Data Warehouse Load Tasks
      • Test Automated Operations