STATE
CITY
NSW
QLD
VIC
Sydney
DATE
Choose a date...
24 Mar 14 - 28 Mar 14
07 Apr 14 - 11 Apr 14
28 Apr 14 - 02 May 14
12 May 14 - 16 May 14
26 May 14 - 30 May 14
16 Jun 14 - 20 Jun 14
30 Jun 14 - 04 Jul 14
14 Jul 14 - 18 Jul 14
28 Jul 14 - 01 Aug 14
11 Aug 14 - 15 Aug 14
25 Aug 14 - 29 Aug 14
08 Sep 14 - 12 Sep 14
22 Sep 14 - 26 Sep 14
13 Oct 14 - 17 Oct 14
27 Oct 14 - 31 Oct 14
10 Nov 14 - 14 Nov 14
24 Nov 14 - 28 Nov 14
01 Dec 14 - 05 Dec 14
15 Dec 14 - 19 Dec 14
What is OLL?
PRICE
DURATION
$3,950.00 inc. GST
5 Days
Overview:
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.
Note: The Beta version of this course (20467AB) utilises pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 SP1 CTP4, Microsoft SharePoint Server 2013 Preview, Microsoft Office 2013 Preview, and Microsoft Visio 2013 Preview are used in this course.
Target 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. Finally, they may apply those skills in a Windows Azure SQL Server database environment.
Pre-requisites:
Before attending this course, students must have attended
10777: Implementing a Data Warehouse with Microsoft SQL Server 2012 and
10778: Implementing Data Models and Reports with Microsoft SQL Server 2012 or have the following equivalent knowledge:
A basic understanding of dimensional modelling (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
Show more
At Course Completion:
After completing 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 optimise a BI solution
Plan for BI operations
Show more
Module 1: Planning a BI Solution
This module discusses how to plan the components of a BI solution.
Lessons
Elements of a BI Solution
The Microsoft BI Platform
Planning a BI Project
Lab : Planning a BI Solution
Exercise 1: Scoping a BI Solution
Exercise 2: Determining Software Requirements
After completing this module, students will be able to:
Describe elements of a BI Solution
Describe how Microsoft products can be used to implement a BI solution
Describe considerations for a BI project
Module 2: Planning SQL Server Business Intelligence Infrastructure
This module explains how to plan an appropriate BI infrastructure for a given set of BI services.
Lessons
Considerations for BI Infrastructure
Planning Data Warehouse Hardware
Lab : Planning a BI Infrastructure
Exercise 1: Planning Server Topology
Exercise 2: Planning Data Warehouse Server Hardware
After completing this module, students will be able to:
Describe key considerations for BI infrastructure
Plan data warehouse infrastructure
Module 3: Designing a Data Warehouse
This module will explain how to design a data warehouse for a given set of user requirements.
Lessons
Data Warehouse Design Overview
Designing Dimension Tables
Designing Fact Tables
Designing a Data Warehouse Physical Implementation
Lab : Designing a Data Warehouse Logical Schema
Exercise 1: Identifying Business Processes and Dimensions
Exercise 2: Designing Dimension Models and Data Warehouse Tables
Lab : Designing a Data Warehouse Physical Implementation
Exercise 1: Designing File Storage
Exercise 2: Designing Warehouse Data Structures
After completing this module, students will be able to:
Describe a process for designing a dimensional model for a data warehouse
Design dimensions tables for a data warehouse
Design fact tables for a data warehouse
Design and implement effective physical data structures for a data warehouse
Module 4: Designing an ETL Solution
This module explains how to design an ETL solution for a data warehouse.
Lessons
ETL Overview
Planning Data Extraction
Planning Data Transformation
Planning Data Loads
Lab : Designing an ETL Solution
Exercise 1: Preparing for ETL Design
Exercise 2: Creating Source-to-Target Documentation
Exercise 3: Using SSIS To Load a Partitioned Fact Table
After completing this module, students will be able to:
Describe considerations for designing an ETL solution
Plan data extraction
Plan data transformations
Plan Data loads
Module 5: Designing Analytical Data Models
This module explains how to design analytical data models for specific BI scenarios.
Lessons
Introduction to Analytical Data Models
Designing an Analytical Data Model
Designing Dimensions
Enhancing Data Models
Lab : Comparing Analytical Data Models
Exercise 1: Creating a Multidimensional Model
Exercise 2: Creating a Tabular Model
Lab : Designing Data Models
Exercise 1: Creating Dimensions in a Multidimensional Data Model
Exercise 2: Creating Dimensions in a Tabular Data Model
Lab : Enhancing Analytical Data Models
Exercise 1: Enhancing a Multidimensional Data Model
Exercise 2: Enhancing a Tabular Data Model
After completing this module, students will be able to:
Describe options for analytical models
Design an initial multidimensional or tabular data model
Design dimensions in a multidimensional or tabular data model
Design measures and cubes in a multidimensional or tabular data model
Module 6: Planning a BI Delivery Solution
This module explains how to choose an appropriate delivery solution for a given scenario.
Lessons
Considerations for BI Delivery
Common Reporting Scenarios
Choosing a Reporting Tool
Lab : Planning a BI Delivery Solution
Exercise 1: Assessing Reporting Requirements
After completing this module, students will be able to:
Describe considerations for delivering BI to users
Describe the key features of common reporting scenarios
Choose an appropriate reporting tool for a particular reporting scenario
Module 7: Designing a Reporting Services Solution
This module explains how to design a Reporting Services solution.
Lessons
Planning a Reporting Services Solution
Designing Reports
Planning Report Consistency
Lab : Designing a Reporting Services Solution
Exercise 1: Designing a Reporting Environment
Exercise 2: Creating Reusable Report Item
Exercise 3: Creating Reports
After completing this module, students will be able to:
Plan a Reporting Services solution
Design reports
Plan report consistency
Module 8: Designing an Excel-Based Reporting Solution
This module explains how to design a reporting solution that uses Excel.
Lessons
Using Excel for Data Analysis and Reporting
PowerPivot in Excel
Power View in Excel
Lab : Designing an Excel Reporting Solution
Exercise 1: Planning Excel Features
Exercise 2: Analysing a Cube with Excel
Exercise 3: Using PowerPivot
Exercise 4: Using Power View in Excel
After completing this module, students will be able to:
Describe Excel features that enable users to analyse data
Configure and use PowerPivot for Excel
Configure and use Power View in an Excel workbook
Module 9: Planning a SharePoint Server BI Solution
This module explains how to design a SharePoint BI solution.
Lessons
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 : Planning a SharePoint Server BI Solution
Exercise 1: Creating a SharePoint Server Site for BI
Exercise 2: Configuring Reporting Services in SharePoint Server
Exercise 3: Configuring PowerPivot for SharePoint
Lab : Implementing a PerformancePoint Services
Exercise 1: Creating a PerformancePoint Dashboard
After completing this module, students will be able to:
Describe SharePoint Server as a BI platform
Plan security for a SharePoint Server BI solution
Plan Reporting Services configuration
Plan PowerPivot configuration
Plan for PerformancePoint Services
Module 10: Monitoring and Optimising a BI Solution
This module explains how to monitor and optimise a BI solution.
Lessons
Overview of BI Monitoring
Monitoring and Optimising the Data Warehouse
Monitoring and Optimising Analysis Services
Monitoring and Optimising Reporting Services
Lab : Monitoring and Optimising a BI Solution
Exercise 1: Monitoring and Optimising a Data Warehouse
Exercise 2: Monitoring and Optimising Analysis Services
Exercise 3: Monitoring and Optimising Reporting Services
After completing this module, students will be able to:
Describe key considerations for monitoring a BI solution
Monitor and optimize a data warehouse
Monitor and optimize SQL Server Analysis Services
Monitor and optimize SQL Server Reporting Services
Module 11: Planning BI Operations
This module explains how to plan management and maintenance operations for a BI solution.
Lessons
Overview of BI Operations
ETL Operations
Data Warehouse Operations
Analysis Services Operations
Reporting Services Operations
Lab : Operating a BI Solution
Exercise 1: Configuring SQL Server Integration Services
Exercise 2: Automate Data Warehouse Load Tasks
Exercise 3: Test Automated Operations
After completing this module, students will be able to:
Describe core considerations for BI operations
Describe considerations and strategies for managing ETL operations
Describe considerations and strategies for managing data warehouse operations
Describe considerations and strategies for managing Analysis Services operations
Describe considerations and strategies for managing Reporting Services operations
Course Ratings Averaged from 18 responses. Overall Satisfaction