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
Programme Structure
Courses include:
- Data Warehousing
- Data Warehouse Architecture
Creating a Data Warehouse
SQL Server Integration Services
SSIS Tools
Measure Format and Aggregation Functions
Tabular Data Models
Multidimensional Expressions (MDX)
Key information
Duration
- Part-time
- 12 months
Start dates & application deadlines
Language
Delivered
Campus Location
- London, United Kingdom
Disciplines
Business Intelligence View 7 other Short Courses in Business Intelligence in United KingdomWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- To obtain additional information about the program, we kindly suggest that you visit the programme website, where you can find further details and relevant resources.
Tuition Fees
-
International Applies to you
Applies to youNon-residents229 GBP / year≈ 229 GBP / year -
Domestic Applies to you
Applies to youCitizens or residents229 GBP / year≈ 229 GBP / year