Request new password

We Are All About You

XpertSkills - the parent company under which iCollege operates - was established in South Africa in 2003 and since then, we have grown globally in leaps and bounds with customers and partners in more than 120 countries. With employees on 3 continents and as a next-generation, virtual organization we are unconstrained by the limits that are usually associated with traditional “brick & mortar” companies.

This allows us to focus, without distraction, on reaching our ultimate goal – ensuring your ongoing success – by providing affordable, reliable, high quality and relevant learning products whilst remaining innovative and agile.

Contact Details:

Web: www.xpertskills.com
Skype: xpertskills
Mail: info@xpertskills.com

Physical Address:

Head Office - South Africa
16 Monte Carlo Crescent
Kyalami business Park
Johannesburg
South Africa 1684

You are here

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

E-COURSE:

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

Instructor-led video course with presentations, workbooks, games, flashcards and quizzes.
Overview

Business intelligence is an integral part of SQL Server and 70-467 is the certification designed for the associates who are responsible for the business intelligence design and solutions. Having a business intelligence certification is great value in IT as major platforms are designed with BI. The BI not only helps in simplification of solutions but also helps in implementing it effectively.

70-467 Designing Business Intelligence solutions video course is intended for the BI architects who are familiar with overall design and decisions around SQL Server 2012 Business intelligence solutions. The video course will judge the below skills of the professional:

  • Provisioning of hardware and software
  • Data mart design and warehouse
  • Integration with line-of-business applications or Microsoft SharePoint
  • BI Solution design and architecture
  • Windows Azure SQL Database environment designing
  • Online Analytical Processing (OLAP) cube designing 
Objectives
  • 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
Target Audience
  • Candidates who want to expertise their knowledge in SQL Server 2012 Business Intelligence
  • IT Professionals who have the basic knowledge in SQL Server 2012

Module 1: Intro To Business Intelligence

1.1 The Business Intelligence Solution

1.2 Overview Of Business Intelligence

1.3 BI And Power Pivot Demo

1.4 ETL Intro

1.5 Designing Data Warehouses

1.6 Design For Speed

1.7 BI Semantic Model

Module 2: Database Essentials

2.1 Basic Database Objects Demo

2.2 Stored Procedures And Triggers Demo

2.3 Database Clusters Demo

2.4 SQL Server Management

2.5 Table Triggers

2.6 DB Configuring Options

2.7 DB Backup

2.8 DB Files And Restore

Module 3: Business Intelligence Development

3.1 Using SQL Server Data Tools Demo

3.2 Building An IS Integration Services Package Demo

3.3 Loading Data From Remote Sources Demo

3.4 Processing Data From Web Service Demo

Module 4: Business Intelligence Results

4.1 Report Building Intro Setup Demo

4.2 Using Report Builder Demo

4.3 Reporting From Multiple Tables Demo

4.4 Report Function And Matrix Demo

4.5 Interactive Reports Demo

4.6 Sorting Report Data Demo

Module 5: Advanced Reporting And Development

5.1 Drill Through Reports

5.2 Data Visualization

5.3 Creating Store Procedure From Scratch

5.4 Memory Optimize Table

Module 6: SQL Server Integration Services (SSIS)

6.1 Building Our First Integration Project

6.2 Data Transformation

6.3 Introduction To Big Data

6.4 Transformation Using Store Procedure

6.5 Transformation Using SSIS

6.6 Building Fact Table Using Store Procedure

6.7 Building Fact Table Using SSIS

Module 7: SQL Server 2014 New Features

7.1 Backup Enhancements

7.2 Index Enhancements

7.3 Online DB Enhancements

7.4 Back Up To The Cloud

7.5 Partition Data

Module 8: Course Review And Exam Prep

8.1 BI Review

8.2 SharePoint Overview

8.3 SharePoint Demo

8.4 Exam Preparation

8.5 Before You Take The Exam

E-COURSE E-Learning Expert-led video course with presentations, workbooks, quizzes, games and flashcards.
  • 04:34:19
    + Hours Of learning
  • Includes video, presentations, workbooks, quizzes, flashcards & games
  • Receive a Certificate of Excellence on successful completion
  • Presented by highly qualified, industry leading experts
  • 12 Months access (Unless indicated otherwise)
  • 10-Day money-back guarantee
Back to Top