SQL Server 2012 Business Intelligence Overview

Course:  SSBIO
Duration:  2 Days
Level:  I
Course Summary

Business intelligence (BI) is critically important to organizations both large and small. In SQL Server 2012, there have been many BI enhancements added to. This course will discuss the requirements, new features and enhancements.

« Hide The Details
Topics Covered In This Course

Hardware and Software Requirements

  • NTFS file format vs. FAT32.
  • Mapped drives vs. compressed drives.
  • Using the "no-reboot" package
  • .NET Framework 4.0.
  • Virtualization.
  • Disk space.
  • Processors & RAM
  • Windows PowerShell.

Multi-Subnet Failover Clustering

  • Configure SQL Server failover cluster nodes connected to different subnet.
  • Geographical location considerations
  • Replication considerations.
  • Active Directory considerations.

Programming Enhancements

  • Sequences
  • Ad-Hoc Query Paging
  • Full Text Search

BI and Web Development Environment Improvements

  • PowerPivot enhancements
  • KPIs and drill through
  • Analysis Services BI Semantic Model (BISM)
    • Data Model
    • Business Logic
    • Data Access
  • Excel, Reporting Services and SharePoint Insights

Web Based Visualization - Project Crescent

  • Reporting and visualization
  • Drag and drop ad-hoc reporting functionality
  • Using the query tool and interactive storyboarding

Data Quality Services

  • Knowledge-based approach
  • Changes in SSIS (SQL Services Integration Services)
  • Impact Analysis and Lineage
What You Can Expect

At the end of this course, students will be able to:

  • Understand Hardware and Software Requirements
  • Use Multi-Subnet Failover Clustering
  • Use Programming Enhancements, including sequences, ad-hoc query paging and full-text search tweaks
  • Understand BI and Web Development Environment Improvements
  • Use Web-based Visualization
  • Explain Data Quality Services
  • Use xVelocity
Who Should Take This Course

Anyone interested in the BI edition of SQL Server 2012.

Training Style

Instructor led with 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007
4 Days
SharePoint 2010 Business Intelligence
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]