Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012

4k learners

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.

  • 100% money-back guarantee

  • Course completion certificate

  • 1-year e-learning access

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

Microsoft 70-467: Designing Business Intelligence Solutions with Microsoft SQL Server 2012 Training course overview
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:
If you are currently a manager or a founder of your own business, instead of randomly doing your job, you must assume the leadership role and lead.
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.
 
The registration process
Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

Course Outline

Course Introduction
Course Modules
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
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
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
Deploying and Securing Packages
Deploying Options
Deploying Packages
Deploying Projects
Securing Packages
Deploying and Securing Packages
Exam Scenarios
Module Review
467_04_07_01h
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
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
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
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
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
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

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got queries?

Acknowledgements