 |
GET IN THE LEAD - get certified today!
Experience the benefits of classroom learning - anytime, anywhere! QuickCert's expert instruction and multi-media courses are to get you certified - or your money back!
Read why successful professionals choose QuickCert > |
This Quickcert course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.
This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. Primary responsibilities may include but are not limited to:
- Working with large data sets across multiple database systems
- Cube/warehouse/views fundamentals
- Data model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)
- Develop Cubes and Multidimensional Expressions (MDX) queries to support analysts
- Online Analytical Processing (OLAP) cube performance
- Building pivot tables from cubes
- Building PowerPivot solutions
- Design and test report models, layouts and templates
- Manage reporting system: configuration and subscriptions
- Using report builder to create reports
- Develop complex SQL queries for reports
- Building reports Using Crescent
This Quickcert training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466.
This course will provide all the skills and knowledge for the following areas:
- 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
QuickCert creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. QuickCert is so certain this course meets and exceeds the exam objectives, we guarantee you will pass your exam!
Not sure what course is right for you?
Contact one of our Career Advisors at 888.840.2378 for assistance.
Your QuickCert Microsoft Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Certification Training Package Includes:
| Delivery Format |
Instructor Led Modules |
Hardbook Supplement |
Practice Exam Simulator |
Exam Pass Guarantee |
| DVDs or online |
|
|
|
|
Exam Pass Guarantee - Learn More
Free Product Upgrades
Toll Free Educational Support
Compatibility with:
98 | 2000 | ME | XP | 2003| Vista | Windows 7 | Windows 8
“I’m 100% satisfied with QuickCert’s training program. I love that it’s broken into manageable sections. This is an all-inclusive training solution… they give you the manuals, the lectures broken into short segments, and practice tests that really mirror the actual tests I’ve taken. I plan to renew my membership!!”
— Karen S., Network Administrator, Calabasas, California
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
Microsoft Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 Certification Training Course Curriculum:
Instructor Introduction
Course Outline
Module 1
Course Introduction
Course Modules
SQL Server 2012 Business Intelligence
Introduction to Business Intelligence
Data Warehouse
Extract, Transform and Load (ETL)
SQL Server Integration Services
SQL Server 2012 BI Tools
Developer Tools
Exam Scenarios
Module 2
SQL Server Reporting Services
Introduction to SSRS
Creation and Delivery
SSRS Reports
Report Grouping
Expressions
Drilldown Report
Parameters
Visual Components
Creating SQL Server
Exam Scenarios
Module Review
Module 3
SSRS Management
Deploying Reports
Report Security
Executing Reports
Report Caching
Report Snapshot
Subscriptions
Data Alerts
Managing Reporting Services
Exam Scenarios
Module Review
Module 4
Multidimensional Cubes
Introduction to Cubes
Cube Components
Creating and Configuring Analysis Services Cube
Exam Scenarios
Module Review
Module 5
Advanced Cube Concepts
Measures
Formatting Measures
Measure Groups
Measure Group Storage
Aggregations
Dimensions
Dimension Storage
Hierarchies
Grouping and Sorting
Working with Measures
Exam Scenarios
Module Review
Module 6
Customizing Cubes and Security
Actions
Perspectives
Key Performance Indicators
Translations
SSAS Security
Cell Permissions
Dimension Permissions
Customizing Cubes and Cube Security
Exam Scenarios
Module Review
Module 7
MultiDimensional eXpressions (MDX)
Introduction to MDX
Why Use MDX?
MDX Syntax
MDX Queries and Filters
Sets
Applying MDX
Working with MDX
Exam Scenarios
Module Review
Module 8
Tabular Data Models
Introduction to TDM
PowerPivot
Linked and Non-Linked Tables
PowerPivot
Server Based Tabular Data Models
Creating a Tabular Data Model
Workspace Database
Tabular Data Model
Working with Tabular Data Modeling
Exam Scenarios
Module Review
Module 9
Data Analysis eXpressions (DAX)
Introduction to DAX
Working with DAX
DAX Functions
DAX Queries
Calculated Columns
Measures
Multiple Relationships
Working with DAX within PowerPivot
Exam Scenarios
Module Review
Module 10
Data Mining
Introduction to Data Mining
Data Mining Algorithms
Data Mining Components
Validating Mining Models
Presenting Mining Data
Creating a Mining Structure
Exam Scenarios
Module Review
Course Review
Questions? Contact one of our Career Advisors at 888.840.2378 for assistance or email sales@quickcert.com.
