Existing User Login

New User? Create An Account

Request new password

We are iCollege

Established in 2003 under the parent company XpertSkills, iCollege is one of the most trusted marketplaces in E-Learning. Our dedication transcends mere content – we source learning products from only the best suppliers and vendors across the globe so you have the widest selection of educational courses designed to equip you for success.

Headquartered in stunning South Africa, our distributed company spans 3 continents with employees in the U.S., India, and of course, South Africa. Our customers call more than 120 countries home. We're proud to say iCollege is trusted by leading organizations in major tech hubs, including Silicon Valley, to train and equip employees to be the very best that they can be.

Whether partnering with Fortune 500 companies or being part of an individual's journey toward career growth, we are committed to the success of all who trust us as their source for education and training.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

EDUTAINMENT COURSE E-Learning

Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012

Interactive and entertaining talk-show style format presented by industry leading experts.
Overview

The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining. It describes how to consolidate SQL Server workloads and how to plan and implement high availability and disaster recovery solutions.

Objectives
  • Designing dimensions and measures
  • Implementing and configuring dimensions in a cube
  • Designing a schema to support a cube architecture
  • Creating measures
  • Implementing a cube
  • Creating Multidimensional Expressions (MDX) queries
  • Implementing custom logic in a data model
  • Implementing storage design in a multidimensional model
  • Selecting an appropriate model for data analysis
  • Analyzing data model performance
  • Processing data models
  • Troubleshooting data analysis issues
  • Deploying SSAS databases
  • Installing and maintaining an SSAS instance
  • Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)
  • Implementing a tabular data model
  • Implementing business logic in a tabular data model
  • Implementing data access for a tabular data model
  • Designing a report
  • Implementing a report layout
  • Configuring authentication and authorization for a reporting solution
  • Implementing interactivity in a report
  • Troubleshooting reporting service issues
  • Managing a report environment
  • Configuring report data sources and datasets
Prerequisites
  • Designing a normalized database.
  • Creating tables and relationships.
  • Querying with Transact-SQL.
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Target Audience

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

  • Supporting data mining and predictive analysis.
  • Creating business performance dashboards.
  • Implementing reports, and managing report delivery.
  • Implementing analytical data models, such as OLAP cubes.

Module 1

1.1 Course Introduction

1.2 Course Modules

1.3 SQL Server 2012 Business Intelligence

1.4 Introduction to Business Intelligence

1.5 Data Warehouse

1.6 Extract, Transform and Load (ETL)

1.7 SQL Server Integration Services

1.8 SQL Server 2012 BI Tools

1.9 Developer Tools

1.10 Exam Scenarios

Module 2

2.1 SQL Server Reporting Services

2.2 Introduction to SSRS

2.3 Creation and Delivery

2.4 SSRS Reports

2.5 Report Grouping

2.6 Expressions

2.7 Drilldown Report

2.8 Parameters

2.9 Visual Components

2.10 Creating SQL Server

2.11 Exam Scenarios

2.12 Module Review

Module 3

3.1 SSRS Management

3.2 Deploying Reports

3.3 Report Security

3.4 Executing Reports

3.5 Report Caching

3.6 Report Snapshot

3.7 Subscriptions

3.8 Data Alerts

3.9 Managing Reporting Services

3.10 Exam Scenarios

3.11 Module Review

Module 4

4.1 Multidimensional Cubes

4.2 Introduction to Cubes

4.3 Cube Components

4.4 Creating and Configuring Analysis Services Cube

4.5 Exam Scenarios

4.6 Module Review

Module 5

5.1 Advanced Cube Concepts

5.2 Measures

5.3 Formatting Measures

5.4 Measure Groups

5.5 Measure Group Storage

5.6 Aggregations

5.7 Dimensions

5.8 Dimension Storage

5.9 Hierarchies

5.10 Grouping and Sorting

5.11 Working with Measures

5.12 Exam Scenarios

5.13 Module Review

Module 6

6.1 Customizing Cubes and Security

6.2 Actions

6.3 Perspectives

6.4 Key Performance Indicators

6.5 Translations

6.6 SSAS Security

6.7 Cell Permissions

6.8 Dimension Permissions

6.9 Customizing Cubes and Cube Security

6.10 Exam Scenarios

6.11 Module Review

Module 7

7.1 MultiDimensional eXpressions (MDX)

7.2 Introduction to MDX

7.3 Why Use MDX?

7.4 MDX Syntax

7.5 MDX Queries and Filters

7.6 Sets

7.7 Applying MDX

7.8 Working with MDX

7.9 Exam Scenarios

7.10 Module Review

Module 8

8.1 Tabular Data Models

8.2 Introduction to TDM

8.3 PowerPivot

8.4 Linked and Non-Linked Tables

8.5 PowerPivot

8.6 Server Based Tabular Data Models

8.7 Creating a Tabular Data Model

8.8 Workspace Database

8.9 Tabular Data Model

8.10 Working with Tabular Data Modeling

8.11 Exam Scenarios

8.12 Module Review

Module 9

9.1 Data Analysis eXpressions (DAX)

9.2 Introduction to DAX

9.3 Working with DAX

9.4 DAX Functions

9.5 DAX Queries

9.6 Calculated Columns

9.7 Measures

9.8 Multiple Relationships

9.9 Working with DAX within PowerPivot

9.10 Exam Scenarios

9.11 Module Review

Module 10

10.1 Data Mining

10.2 Introduction to Data Mining

10.3 Data Mining Algorithms

10.4 Data Mining Components

10.5 Validating Mining Models

10.6 Presenting Mining Data

10.7 Creating a Mining Structure

10.8 Exam Scenarios

10.9 Module Review

10.10 Course Review

  1. Implementing Data Models and Reports with Microsoft SQL Server 2012
1
Start
Course Introduction
2
Start
Course Modules
  1. Module 1
3
Start
SQL Server 2012 Business Intelligence
5
Start
Introduction to Business Intelligence
5
Start
Introduction to Business Intelligence
6
Start
Data Warehouse
7
Start
Extract, Transform and Load (ETL)
8
Start
SQL Server Integration Services
9
Start
SQL Server 2012 BI Tools
10
Start
Developer Tools
11
Start
Exam Scenarios
  1. Module 2
12
Start
SQL Server Reporting Services
13
Start
Introduction to SSRS
13
Start
Introduction to SSRS
14
Start
Creation and Delivery
15
Start
SSRS Reports
16
Start
Report Grouping
17
Start
Expressions
18
Start
Drilldown Report
18
Start
Drilldown Report
19
Start
Parameters
20
Start
Visual Components
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
21
Start
Creating SQL Server
22
Start
Exam Scenarios
23
Start
Module Review
  1. Module 3
24
Start
SSRS Management
25
Start
Deploying Reports
25
Start
Deploying Reports
26
Start
Report Security
26
Start
Report Security
27
Start
Executing Reports
28
Start
Report Caching
29
Start
Report Snapshot
30
Start
Subscriptions
31
Start
Data Alerts
32
Start
Managing Reporting Services
32
Start
Managing Reporting Services
32
Start
Managing Reporting Services
32
Start
Managing Reporting Services
33
Start
Exam Scenarios
34
Start
Module Review
  1. Module 4
35
Start
Multidimensional Cubes
36
Start
Introduction to Cubes
37
Start
Cube Components
38
Start
Creating and Configuring Analysis Services Cube
38
Start
Creating and Configuring Analysis Services Cube
38
Start
Creating and Configuring Analysis Services Cube
38
Start
Creating and Configuring Analysis Services Cube
38
Start
Creating and Configuring Analysis Services Cube
38
Start
Creating and Configuring Analysis Services Cube
39
Start
Exam Scenarios
40
Start
Module Review
  1. Module 5
41
Start
Advanced Cube Concepts
42
Start
Measures
43
Start
Formatting Measures
44
Start
Measure Groups
45
Start
Measure Group Storage
46
Start
Aggregations
47
Start
Dimensions
47
Start
Dimensions
48
Start
Dimension Storage
48
Start
Dimension Storage
50
Start
Grouping and Sorting
51
Start
Working with Measures
51
Start
Working with Measures
51
Start
Working with Measures
51
Start
Working with Measures
51
Start
Working with Measures
51
Start
Working with Measures
52
Start
Exam Scenarios
53
Start
Module Review
  1. Module 6
54
Start
Customizing Cubes and Security
55
Start
Actions
56
Start
Perspectives
57
Start
Key Performance Indicators
58
Start
Translations
59
Start
SSAS Security
60
Start
Cell Permissions
61
Start
Dimension Permissions
62
Start
Customizing Cubes and Cube Security
62
Start
Customizing Cubes and Cube Security
62
Start
Customizing Cubes and Cube Security
62
Start
Customizing Cubes and Cube Security
63
Start
Exam Scenarios
64
Start
Module Review
  1. Module 7
65
Start
MultiDimensional eXpressions (MDX)
66
Start
Introduction to MDX
67
Start
Why Use MDX?
68
Start
MDX Syntax
69
Start
MDX Queries and Filters
69
Start
MDX Queries and Filters
70
Start
Sets
71
Start
Applying MDX
72
Start
Working with MDX
72
Start
Working with MDX
72
Start
Working with MDX
73
Start
Exam Scenarios
74
Start
Module Review
  1. Module 8
75
Start
Tabular Data Models
76
Start
Introduction to TDM
76
Start
Introduction to TDM
77
Start
PowerPivot
78
Start
Linked and Non-Linked Tables
79
Start
PowerPivot
80
Start
Server Based Tabular Data Models
81
Start
Creating a Tabular Data Model
82
Start
Workspace Database
83
Start
Tabular Data Model
83
Start
Tabular Data Model
84
Start
Working with Tabular Data Modeling
84
Start
Working with Tabular Data Modeling
84
Start
Working with Tabular Data Modeling
84
Start
Working with Tabular Data Modeling
84
Start
Working with Tabular Data Modeling
84
Start
Working with Tabular Data Modeling
85
Start
Exam Scenarios
86
Start
Module Review
  1. Module 9
87
Start
Data Analysis eXpressions (DAX)
88
Start
Introduction to DAX
88
Start
Introduction to DAX
89
Start
Working with DAX
90
Start
DAX Functions
91
Start
DAX Queries
92
Start
Calculated Columns
93
Start
Measures
94
Start
Multiple Relationships
95
Start
Working with DAX within PowerPivot
96
Start
Exam Scenarios
97
Start
Module Review
  1. Module 10
98
Start
Data Mining
99
Start
Introduction to Data Mining
100
Start
Data Mining Algorithms
101
Start
Data Mining Components
102
Start
Validating Mining Models
103
Start
Presenting Mining Data
104
Start
Creating a Mining Structure
104
Start
Creating a Mining Structure
105
Start
Exam Scenarios
106
Start
Module Review
107
Start
Course Review
EDUTAINMENT COURSE E-Learning
?Interactive and entertaining talk-show style format presented by industry leading experts.
USD 59
  • 05:17:55
    Hours of learning
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months Access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top