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:
- 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.
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.