Microsoft 70-467 Designing Business Intelligence Solution
3.3 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft 70-467 Designing Business Intelligence Solution to your Wishlist.

Add to Wishlist

Microsoft 70-467 Designing Business Intelligence Solution

Designing Business Intelligence Solutions with Microsoft SQL Server 2012
3.3 (14 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
156 students enrolled
Last updated 12/2016
English
Price: $200
30-Day Money-Back Guarantee
Includes:
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • This course will prepare you to pass the exam Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012
  • Passing this exam validates a candidate’s ability to designing Business Intelligence Solutions with Microsoft SQL Server 2012
View Curriculum
Requirements
  • Basics of Microsoft SQL Server 2012.
Description

This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around designing business intelligence solutions with Microsoft SQL Server 2012. 


This course is designed for BI Architects, who focus on the overall design of the BI infrastructure, including how it relates to other data systems in use. Primary responsibilities may include but are not limited to:

  • BI Solution architecture and design
  • Provisioning of software and hardware
  • Data warehouse and data mart design
  • Online Analytical Processing (OLAP) cube design
  • Integration with SharePoint or line of business applications

This training course on designing business intelligence solutions with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-467.

This course will provide all the skills and knowledge for the following areas:

  • Performance planning
  • Scalability planning
  • Planning for managing upgrades
  • Maintaining server health
  • Designing a security strategy
  • SQL partitioning strategy design
  • Backup strategy design
  • Designing a logging and auditing strategy
  • Reporting Services dataset design
  • Managing Excel Services/Reporting for SharePoint
  • Data acquisition strategy design
  • Planning and managing reporting services configuration
  • BI reporting solution architecture design
  • Data warehouse design
  • Designing a schema
  • Designing cube architecture
  • Designing fact tables
  • BI Semantic Model design
  • Designing and creating MDX calculations
  • Designing SSIS package execution
  • Planning to deploy SSIS solutions
  • Designing package configurations for SSIS packages

We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

Who is the target audience?
  • IT Professionals
Compare to Other Business Intelligence Courses
Curriculum For This Course
153 Lectures
04:34:19
+
Designing Business Intelligence Solutions with Microsoft SQL Server 2012
2 Lectures 01:51

Course Modules
01:21
+
Module 1
10 Lectures 23:11
Introduction to Data Warehousing
00:12

On-Line Transaction Processing (OLTP) vs. OLAP
03:02


Data Warehouse Architecture
01:54

Creating a Data Warehouse Part1
02:51

Creating a Data Warehouse Part2
01:15

Presenting On-Line Analytical Processing (OLAP) Data
04:27

OLTP vs. OLAP Demonstration
04:11

Exam Scenarios
02:43

Module Review
00:46
+
Module 2
11 Lectures 24:30
Designing a Data Warehouse
00:04

Data Modeling
01:05

Data Warehouse Schemas
01:38


Data Modeling Considerations
05:14

Implementing a Data Model
01:24

Logical Model
00:38

Physical Model
03:51

Working with Dimensions and Fact Tables
05:18

Exam Scenarios
02:05

Module Review
01:08
+
Module 3
22 Lectures 43:53
Extraction, Transformation, and Load (ETL) with SSIS
00:09


Upgrading SSIS Packages
01:00

SSIS Tools
00:41


Data Sources
00:34

Transformations
02:38

Destinations
02:58

Control Flow
01:24

Variables
02:37

Expressions
00:38

Precedence
00:56

Containers
00:22

Control Flow Containers Part1
01:56

Control Flow Containers Part2
02:19

Transactions
01:05

Package Execution with Checkpoints
02:58

Working with SSIS Packages Part1
05:21


Working with SSIS Packages Part3
04:07

Exam Scenarios
02:56

Module Review
01:29
+
Module 4
8 Lectures 10:59
Deploying and Securing Packages
00:08

Deploying Options
01:42

Deploying Packages
00:25

Deploying Projects
00:47


Deploying and Securing Packages
03:40

Exam Scenarios
02:18

Module Review
01:00
+
Module 5
17 Lectures 31:49
SQL Server Reporting Services (SSRS)
00:10

Introduction to Reporting Services Part1
00:10

Introduction to Reporting Services Part2
01:16

SSRS Reports Creation and Delivery
00:32

SSRS Reports
01:23

Grouping
00:51

Expressions
00:31

Drilldown
01:54

Parameters
02:09

Drillthrough
00:57


Creating Reports Within Reporting Services Part1
04:20

Creating Reports Within Reporting Services Part2
04:34

Creating Reports Within Reporting Services Part3
04:18

Creating Reports Within Reporting Services Part4
03:42

Exam Scenarios
02:48

Module Review
01:11
+
Module 6
12 Lectures 26:08
SSRS Reports
00:09

Deploying Reports
00:55

Report Security
04:04

Report Execution
00:53

Report Caching
03:02

Report Snapshot
02:22

Subscriptions
02:11

Data Alerts
01:49

Deploying Reports and Report Security Part1
04:50

Deploying Reports and Report Security Part2
02:48

Exam Scenarios
02:05

Module Review
01:00
+
Module 7
26 Lectures 45:21
Multidimensional Cubes
00:07

Introduction to Cubes Part1
00:11

Introduction to Cubes Part2
00:47

Components of a Multidimensional Cubes
01:18

Measures
01:05

Measure Format and Aggregation Functions
01:45

Measure Groups Part1
01:36

Measure Groups Part2
02:04

Aggregations
00:56

Dimensions
00:53

Dimension Storage
00:49

Dimensions Hierarchies
01:46

Grouping and Sorting
01:37

Actions
00:53

Perspectives
01:20

Key Performance Indicators
01:18

Translations
00:57


Cell Permissions
01:08

Dimension Permissions
00:41

Creating and Configuring a Cube Part1
04:39

Creating and Configuring a Cube Part2
05:23

Creating and Configuring a Cube Part3
03:00


Exam Scenarios
02:44

Module Review
01:13
+
Module 8
19 Lectures 30:01
Tabular Data Models
00:10

Introduction to Tabular Data Models
01:23

PowerPivot
00:47

Working with PowerPivot
01:28

Linked and Non-Linked Tables
00:40

PowerPivot Features
00:41

Server Based Tabular Data Models Part1
00:17

Server Based Tabular Data Models Part2
00:36

Creating a Tabular Data Model
00:37

Tabular Models with SSDT
00:41

Workspace Database
01:06

Tabular Data Model
01:50

Tabular Data Model Security
00:34

Creating a Tabular Data Model Using PowerPivot Part1
03:34

Creating a Tabular Data Model Using PowerPivot Part2
05:18

Creating a Tabular Data Model Using PowerPivot Part3
04:58

Creating a Tabular Data Model Using PowerPivot Part4
02:41

Exam Scenarios
01:46

Module Review
00:54
+
Module 9
16 Lectures 17:50
MDX/DAX
00:18

Introduction to Multidimensional Expressions (MDX)
00:56

Why Use MDX?
01:07

MDX Syntax
02:36

Sets
01:21

Where is MDX Used?
01:13

Introduction to Data Analysis eXpressions (DAX) Part1
00:13

Introduction to Data Analysis eXpressions (DAX) Part2
00:38

Working with DAX
02:11

DAX Functions
01:30


Calculated Columns
00:43

DAX Measures
00:29

Multiple Relationships
00:29

Exam Scenarios
02:22

Module Review
01:03
1 More Section
About the Instructor
iCollege Certifications
4.1 Average rating
2,094 Reviews
13,670 Students
100 Courses
Certification Leader

iCollege is a leading international provider of E-Learning courses, learning technologies and development services.

Utilizing state of the art technologies, highly experienced consultants and innovative methodologies, we provide, cutting-edge education products, services and solutions for individuals, corporate organizations, governmental institutions and education providers.

Our collective knowledge and experience in education and training sets the standard for service delivery in learning solutions.

Stone River eLearning
4.2 Average rating
17,282 Reviews
286,096 Students
203 Courses
280,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 450,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.