Microsoft 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Overview

The Microsoft 70-467 Designing Business Intelligence Solutions with Microsoft SQL Server 2012 from Hudson Courses Limited primary responsibilities may include but are not limited to:

• BI Solution architecture and design
• Provisioning of software and hardware
• Data warehouse and data mart design
• Online Analytical Processing (OLAP) cube design

• Integration with SharePoint or line of business applications

This course will provide all the skills and knowledge for the following areas:

• Performance planning
• Scalability planning
• Planning for managing upgrades
• Maintaining server health
• Designing a security strategy
• SQL partitioning strategy design
• Backup strategy design
• Designing a logging and auditing strategy
• Reporting Services dataset design
• Managing Excel Services/Reporting for SharePoint
• Data acquisition strategy design
• Planning and managing reporting services configuration
• BI reporting solution architecture design
• Data warehouse design
• Designing a schema
• Designing cube architecture
• Designing fact tables
• BI Semantic Model design
• Designing and creating MDX calculations
• Designing SSIS package execution
• Planning to deploy SSIS solutions
• Designing package configurations for SSIS packages