3 Feb 2014
Framework Training Ltd
Business Environment Group
Call us to discuss cost-effective options for training your team.
Price per person
Learn to develop commercial Business Intelligence solutions with extensive hands-on labs using Microsoft’s core Business Intelligence tools: SQL Server Reporting Services, Analysis Services, Integration Services, and Excel 2010 PowerPivot, delivered by an expert Microsoft Business Intelligence professional.
The majority of the course is based around the current stable release of SQL Server 2012, but we will also be giving an overview of new Business Intelligence features in SQL Server 2012 R2 if time permits.
If you are interested in custom / on-site Business Intelligence training for any size of team, please get in touch – we would be glad to help build a course that meets your learning requirements.
We can take into account your existing technical skills, project requirements and timeframes, and specific topics of interest to tailor the most relevant and focussed course for you.
This can be particularly useful if you need to learn just the new features and Best Practices with SQL Server Business Intelligence tools, or need to include extra topics to help with pre-requisite skills.
We can also base custom courses on SQL Server 2008 if that is your current production platform.
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 2013 PowerPivot
Who should attend
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
- 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
Measures and Measure Groups
Multidimensional Expressions (MDX)
Key Performance Indicators (KPIs)
Actions, Perspectives & Translations
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
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