Udemy Certificate 0

Microsoft 70-467 Designing Intelligence Solutions w/SQL 2012

Name: Microsoft 70-467 Designing Intelligence Solutions w/SQL 2012
Price: 199.99 USD
Availability: InStock

About this course

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.

62/100

CourseAsk score

What the provider tells you: 38/45
Who stands behind it: 8/35
How complete the listing is: 16/20

Scores how much the provider publishes and who stands behind it — not how well it is taught.

What you'll learn

designing a BI solution architecture
creating and managing data warehouses and data marts
designing OLAP cubes
formulating reporting services datasets
developing SQL partitioning and backup strategies
planning for scalability and upgrades

Data Analysis #business intelligence #data warehousing #security strategies #olap #data acquisition #performance planning #backup strategies #ssis #microsoft sql server #data mart #mdx #reporting services #scalability planning

$199.99

Price shown by Udemy — confirm on their site.

Enroll on Udemy

You'll be redirected to Udemy to complete enrollment.