Learn to develop commercial Business Intelligence solutions with extensive hands-on labs using SQL Server Reporting Services, Analysis Services, Integration Services, and Excel 2010 PowerPivot, delivered by our expert Microsoft Business Intelligence instructor.

The majority of the course is based around the current stable release, SQL Server 2008 R2, but we will also be giving an overview of new Business Intelligence features in SQL Server 2012.

• Design reporting solutions on business-critical data with Reporting Services (SSRS)
• Build data mining solutions using Data Cubes within Analysis Services (SSAS)
• Deploy ETL packages with Integration Services (SSIS)
• Data mining with Excel 2010 PowerPivot

Database programmers, business analysts and project managers who want to get the most out of the Business Intelligence tools available with SQL Server

Some experience of using SQL language (whether from SQL Server, Oracle, Sybase, MySQL...) to select, update and present data would be very useful.

Introduction to Microsoft Business Intelligence

BI Features and capabilities

SQL Server Reporting Services - SSRS

Designing Reports:

• Report Designer
• Report Builder
• Business Intelligence Development Studio / Visual Studio 2010

SQL Server Analysis Services - SSAS

Overview of SSAS
Optimising Online Analytical Processing (OLAP) performance with Aggregation Designer
Data Sources and Data Source Views
Creating Cubes
Configuring Dimensions
Measures and Measure Groups
Multidimensional Expressions (MDX)
Key Performance Indicators (KPIs)
Actions, Perspectives & Translations
Deployment options
Logging and Monitoring
Data Mining Model
Data Mining Extensions (DMX)

SQL Server Integration Services - SSIS

Running an Integration Services Package
Building and Running an Integration Services Solution
Control Flow
Data Flow
Implementing Transformations
Logging
Error handling & Debugging
Managing, scheduling & securing an Integration Services Package

Excel 2010 / PowerPivot

Analysis Services engine
Data Analysis Expressions (DAX)

Overview of SQL Server 2012 Business Intelligence New Features

PowerPivot enhancements in SQL Server 2012
SQL Server 2012 Business Intelligence Semantic Model (BISM)
Extending Excel, Reporting Services and SharePoint Insights
PowerView (previously known as "Project Crescent)
Mobile Reporting / BI Dashboards

Related courses

BI2 Expert Business Intelligence with SQL Server Training Course

BI3 Business Intelligence with SharePoint and PerformancePoint Services Training Course

sharepoint1 SharePoint 2010 Development Training Course