Course description
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.
| 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 expert Microsoft Business Intelligence instructor. |
What you will learn
* 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
Who should attend
Database programmers, business analysts and project managers who want to get the most out of the Business Intelligence tools available with SQL Server
Prerequisites
Some experience of using SQL language (whether from SQL Server, Oracle, Sybase, MySQL…) to select, update and present data would be very useful.
BI with SQL Server 2008 R2 and Excel 2010 PowerPivot Training Course Syllabus
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
