London College Of Online Learning

HOME >> IT CERTIFICATIONS >> DATABASES, MICROSOFT >> Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012

£59.00

Duration: 19 Hours 17 Minutes

47 Course Videos

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

Our Microsoft 70-467: Designing Business Intelligence Solutions with SQL Server 2012 is one of the many SQL courses available at LCOOL. This SQL course prepares students to use the Microsoft SQL Server 2012 BI tools and is focused on the Microsoft 70-467 exam.

Students taking this online course will learn Microsoft SQL Server 2012 can be used to build robust business intelligence solutions using the tools already available in Microsoft SQL Server 2012. Topics like Introduction to Business Intelligence, Power Pivot, Extract, Load and Transform (ETL) methods, Microsoft SSIS, creating drill-down reports, building business intelligence fact tables and more are included.

The exam covers the following key focused areas:

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%)

For the most recent information regarding this exam, we encourage you to visit the Microsoft website.

Course Videos

This course contains the following modules and videos. Click the down arrow to view video details.

Module 1: Intro To Business Intelligence

Introduction
The Business Intelligence Solution
Overview Of Business Intelligence
BI And Power Pivot Demo
ETL Intro
Designing Data Warehouses
Design For Speed
BI Semantic Model

Module 2: Database Essentials

Basic Database Objects Demo
Stored Procedures And Triggers Demo
Database Clusters Demo
SQL Server Management
Table Triggers
DB Config Options
DB Backup
DB Files And Restore

Module 3: Business Intelligence Development

Using SQL Server Data Tools Demo
Building An IS Integration Services Package Demo
Loading Data From Remote Sources Demo

Module 4: Business Intelligence Results

Report Building Intro Setup Demo
Using Report Builder Demo
Processing Data From Web Service Demo
Reporting From Multiple Tables Demo
Report Function And Matrix Demo
Interactive Reports Demo
Sorting Report Data Demo

Module 5: Advanced Reporting And Development

Drill Through Reports
Data Visualization
Creating Stored Procedure From Scratch
Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

Building Our First Integration Project
Data Transformation
Introduction To Big Data
Transformation Using Store Procedure
Transformation Using SSIS
Building Fact Table Using Store Procedure
Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

Backup Enhancements
Index Enhancements
Online DB Enhancements
Backup To The Cloud
Partition Data

Module 8: Course Review And Exam Prep

BI Review
SharePoint Overview
SharePoint Demo
Exam Prep
Before You Take The Exam
Conclusion

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.