40009 - Updating your Business Intelligence Skills to Microsoft SQL Server 2012

STATE CITY
DATE
PRICE DURATION
$3,000.00 inc. GST
3 Days
COURSE REGISTRATION
Overview:
This three-day instructor-led course provides existing SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.
Target Audience:
This course is intended for BI professionals with experience of using SQL Server 2008 R2.
Pre-requisites:
Before attending this course, students must have:
  • Experience of creating database solutions in SQL Server, including basic Transact-SQL programming.
  • Familiarity with data warehousing and BI solutions, including extract, transform, and load (ETL), data modelling, and reporting.

Show more

At Course Completion:
After completing this course, students will be able to:
  • Describe key new and enhanced features for BI in SQL Server 2012.
  • Use new and enhanced features in SQL Server Integration Services.
  • Manage data quality by using SQL Server Data Quality Services.
  • Manage master data by using new and enhanced features of SQL Server Master Data Services.
  • Use new and enhanced features of SQL Server Reporting Services.
  • Create tabular data models with PowerPivot and DAX.
  • Implement a tabular data model in SQL Server Analysis Services.
  • Use Power View to create interactive data visualisations.
  • Integrate Microsoft cloud technologies into a BI solution.

Show more

Outline:
Module 1: Introduction to SQL Server 2012 for Business Intelligence
Module 2: New and Enhanced Features in SQL Server Integration Services
Module 3: Data Quality Services
Module 4: Master Data Services
Module 5: SQL Server 2012 Reporting Services
Module 6: Creating Tabular Data Models with PowerPivot
Module 7: Implementing an Analysis Services Tabular Data Model
Module 8: Creating Data Visualisations with Power View
Module 9: Using Cloud Technologies in a BI Solution
Course Ratings
Averaged from 60 responses.
Overall Satisfaction

Bookmark & Share
ShareTweetLinkShareDiggShareShare
 
 
 
CODE:A-A-NHA40009-ILT

Home | Search | Site Map | Legal | Privacy Policy | Terms of Use | Contact | Career Opportunities

Copyright © 2014 New Horizons Learning Centres Holdings Pty Ltd. All rights reserved. ABN: 86 168 459 086


 

9:00 AM - 5:00 PM