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

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.

  • 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
  • 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
  • Using SQL Server Data Tools Demo
  • Building An IS Integration Services Package Demo
  • Loading Data From Remote Sources Demo
  • 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
  • Drill Through Reports
  • Data Visualization
  • Creating Stored Procedure From Scratch
  • Memory Optimize Table
  • 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
  • Backup Enhancements
  • Index Enhancements
  • Online DB Enhancements
  • Backup To The Cloud
  • Partition Data
  • 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.
Copyright © 2024 London College of Online Learning Limited. Registered in the UK: 12747658. | Sitemap
Open chat
We are available 24/7
Hello there 👋

Can we help you today?