Microsoft SQL Server 2012: Business Intelligence Skills Upgrade

Online Training

Time stretched?

If you would prefer something more flexible, we can now offer Online Training related to this topic.

Click to see a list of courses »

Course Overview

SQL Server 2012 provides the latest advances necessary for administrators and developers to build cutting-edge business intelligence systems and critical reports. In this hands-on course, you gain the skills necessary to take advantage of these new abilities in SQL Server 2012, which include enhancements in data models, analytical features and self-service reporting.

CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.

Related Courses

Audience

Experienced SQL Server administrators and developers working in a business intelligence environment who are considering or currently migrating to SQL Server 2012. Practical experience with Microsoft business intelligence tools and Visual Studio is assumed.

Skills Gained

Learn How To

Leverage the new business intelligence features and tools available in SQL Server 2012
Improve data warehouse performance with the new indexing structures
Develop enhanced SSIS packages using the new BIDS 2010 environment
Build an SSAS database using the BISM tabular model
Import tabular models into Excel PowerPivot
Create a visually dynamic self-service reporting environment with Project Crescent

Course Outline

Throughout this course, extensive hands-on exercises provide practical experience working with SQL Server 2012 business intelligence tools. Exercises include:

Maximising data warehouse performance with specialised indexes
Customising SSIS packages with new toolbox components
Designing and deploying a SQL Server 2012 tabular model database
Building a Excel PowerPivot workbook from an SSAS Tabular database
Creating Project Crescent reports for SharePoint

Introducing the New Features of the Microsoft Business Intelligence Platform

Exploring the new capabilities of the BI architecture
Applying the Business Intelligence Semantic Model (BISM) to specific business needs
Taking advantage of new BI lifecycle options
Providing self-service tools for data analysis and reporting

Enhancing SQL Server Data Warehouse Performance

Optimising the data warehouse with new database structures of SQL Server 2012

Identifying data warehouse structures that benefit from performance tuning
Matching SQL Server relational design to the Semantic Model

Applying columnstore indexes to a data warehouse

Identifying appropriate columns for columnstore indexing
Creating the columnstore index and monitoring performance

Maintaining data integrity with Data Quality Services (DQS)

Creating a standard quality data reference table
Checking new data against reference standards

Optimising the Data Load with SQL Server Integration Services (SSIS)

Navigating the Business Intelligence Development Studio (BIDS) 2010 user interface

Streamlining package development in the new environment
Migrating data into Analysis Services

Inspecting the new SSIS toolbox

Customising SSIS packages with the parameterised task component for flexibility and package reuse
Managing data quality in SSIS using the correction component

Building Tabular and Cube Structures with SQL Server Analysis Services (SSAS)

Creating a tabular model database project in BIDS 2010

Managing data sources in the BIDS 2010 environment
Establishing relationships between tables
Utilising multiple table relationships for a more robust database design
Deploying a BISM tabular model database

Selecting DirectQuery mode for a SSAS tabular database

Evaluating the advantages of DirectQuery mode
Implementing and deploying a SSAS tabular database for DirectQuery mode

Preparing a tabular model for use in Excel PowerPivot

Customising a database design for PowerPivot
Creating a tabular database for PowerPivot users

Leveraging new querying and data mining features

Querying tabular databases and cubes with the Multidimensional Expressions (MDX) language
Taking advantage of data mining enhancements for SQL Server 2012