Overview

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. 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: BI Solution architecture and designProvisioning of software and hardwareData warehouse and data mart designOnline Analytical Processing (OLAP) cube designIntegration 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.This course will provide all the skills and knowledge for the following areas: Performance planningScalability planningPlanning for managing upgradesMaintaining server healthDesigning a security strategySQL partitioning strategy designBackup strategy designDesigning a logging and auditing strategyReporting Services dataset designManaging Excel Services/Reporting for SharePointData acquisition strategy designPlanning and managing reporting services configurationBI reporting solution architecture designData warehouse designDesigning a schemaDesigning cube architectureDesigning fact tablesBI Semantic Model designDesigning and creating MDX calculationsDesigning SSIS package executionPlanning to deploy SSIS solutionsDesigning package configurations for SSIS packages We create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.

Skills

Reviews