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

Overview

This course will help you to pass the Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 exam with flying colours! Our course has been created by a qualified professional and is in line with the official exam, so you will be receiving learning material and teaching which has been specifically tailored to guarantee your success.

Learning with Study 365 has many advantages. The course material is delivered straight to you and can be adapted to fit in with your lifestyle. It is created by experts within the industry, meaning you are receiving accurate information, which is up-to-date and easy to understand.

This course is comprised of professionally narrated e-Learning modules, interactive quizzes, tests, and exams. All delivered through a system that you will have access to 24 hours a day, 7 days a week for 365 days (12 months).

What will I learn?

Plan business intelligence (BI) infrastructure (15–20%)
Design BI infrastructure (15–20%)
Design a reporting solution (20–25%)
Design BI data models (30–35%)
Design an ETL solution (10–15%)

Course Description:

This online training course is comprehensive and designed to cover the key topics listed under the curriculum.

Course Duration:

You will have 12 Months access to your online study platform from the date you purchased the course. The course is self-paced so you decide how fast or slow the training goes. You can complete the course in stages revisiting the training at any time.

Method of Assessment:

At the end of the course, learners will take an online multiple choice question assessment test (please be aware, this is not the official exam). The online test is marked straight away, so you will know immediately if you have passed the course.

Certification:

Successful candidates will be awarded a certificate for Designing Business Intelligence Solutions with Microsoft SQL Server 2012.

(This course is not included the official certificate)

Entry Requirement:

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Recommended Experience:

This exam is intended for business intelligence (BI) architects who are responsible for the overall design of a BI infrastructure and how it relates to other data systems in use.

PLEASE NOTE: We do not provide the official exam, which will need to be purchased separately.

Career Path:

This training course will lead you to become a:

Developer
.NET Developer
SQL Developer
C# Developer
DBA
C# .NET Developer
SQL DBA
Business Intelligence Developer
Senior Developer
Administrator
ASP.NET Developer
Analyst
SSIS Developer
C# ASP.NET Developer
SQL BI Developer
SQL Server Developer
SQL Server DBA
Senior .NET Developer
ASP.NET MVC Developer
SSRS Developer

Course Curriculum

free introduction
	Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012	FREE	00:00:00
	Course Brochure – Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012	FREE	00:00:00
1: Intro To Business Intelligence
	1. Introduction		00:00:00
	2. The Business Intelligence Solution		00:00:00
	3. Overview Of Business Intelligence		00:00:00
	4. BI And Power Pivot Demo		00:00:00
	5. ETL Intro		00:00:00
	6. Designing Data Warehouses		00:00:00
	7. Design For Speed		00:00:00
	8. BI Semantic Model		00:00:00
2: Database Essentials
	1. Basic Database Objects Demo		00:00:00
	2. Stored Procedures And Triggers Demo		00:00:00
	3. Database Clusters Demo		00:00:00
	4. SQL Server Management		00:00:00
	5. Table Triggers		00:00:00
	6. DB Config Options		00:00:00
	7. DB Backup		00:00:00
	8. DB Files And Restore		00:00:00
3: Business Intelligence Development
	1. Using SQL Server Data Tools Demo		00:00:00
	2. Building An IS Integration Services Package Demo		00:00:00
	3. Loading Data From Remote Sources Demo		00:00:00
4: Business Intelligence Results
	1. Report Building Intro Setup Demo		00:00:00
	2. Using Report Builder Demo		00:00:00
	3. Processing Data From Web Service Demo		00:00:00
	4. Reporting From Multiple Tables Demo		00:00:00
	5. Report Function And Matrix Demo		00:00:00
	6. Interactive Reports Demo		00:00:00
	7. Sorting Report Data Demo		00:00:00
5: Advanced Reporting And Development
	1. Drill Through Reports		00:00:00
	2. Data Visualization		00:00:00
	3. Creating Store Procedure From Scratch		00:00:00
	4. Memory Optimize Table		00:00:00
6: SQL Server Integration Services (SSIS)
	1. Building Our First Integration Project		00:00:00
	2. Data Transformation		00:00:00
	3. Introduction To Big Data		00:00:00
	4. Transformation Using Store Procedure		00:00:00
	5. Transformation Using SSIS		00:00:00
	6. Building Fact Table Using Store Procedure		00:00:00
	7. Building Fact Table Using SSIS		00:00:00
7: SQL Server 2014 New Features
	1. Backup Enhancements		00:00:00
	2. Index Enhancements		00:00:00
	3. Online DB Enhancements		00:00:00
	4. BackUp To The Cloud		00:00:00
	5. Partition Data		00:00:00
8: Course Review And Exam Prep
	1. BI Review		00:00:00
	2. SharePoint Overview		00:00:00
	3. SharePoint Demo		00:00:00
	4. Exam Prep		00:00:00
	5. Before You Take The Exam		00:00:00
	6. Conclusion		00:00:00