SQL Server 2012 Business Intelligence Overview

Course:   SSBIO
Duration:   2 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/SSBIO.html
 
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.

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:

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.

Related Courses
Code Course Title Duration Level
MSBI
Accelerated Microsoft Business Intelligence: From SQL 2008 through SharePoint and Office 2007
4 Days
I
Details
SP10BI
SharePoint 2010 Business Intelligence
4 Days
II
Details

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.