Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Course
Online
This certification will take your skills to the next level!
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
-
Online campus
Yes
-
Delivery of study materials
Yes
-
Support service
Yes
-
Virtual classes
Yes
This 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 analyst
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"
Facilities
Location
Start date
Start date
About this course
This 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
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
- Server
- SQL
- Design
- Business Intelligence
- Javascript training
- HTML
- Javascript
- Web
- Writing
- Programming
- Networking
- Windows
- Office IT
- DNS
- Proxy
- Active Directory
- Rights Management
- Pilot
- Ms Office
- Install
Course programme
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
- 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
- SSRS Management
- Deploying Reports
- Report Security
- Executing Reports
- Report Caching
- Report Snapshot
- Subscriptions
- Data Alerts
- Managing Reporting Services
- Exam Scenarios
- Module Review
- Multidimensional Cubes
- Introduction to Cubes
- Cube Components
- Creating and Configuring Analysis Services Cube
- Exam Scenarios
- Module Review
- 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
- 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
- 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
- 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
- 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
- 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
Microsoft 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012