|
|
|
You Will Learn How To
- Leverage the new business intelligence features and tools available in SQL Server 2012
- Improve data warehouse performance with the new indexing structures
- Develop enhanced SSIS packages using the new BIDS 2010 environment
- Build an SSAS database using the BISM tabular model
- Import tabular models into Excel PowerPivot
- Create a visually dynamic self-service reporting environment with Project Crescent
Course Benefits SQL Server 2012 provides the latest advances necessary for administrators and developers to build cutting-edge business intelligence systems and critical reports. In this hands-on course, you gain the skills necessary to take advantage of these new capabilities in SQL Server 2012, which include enhancements in data models, analytical features and self-service reporting.
Who Should Attend Experienced SQL Server administrators and developers working in a business intelligence environment who are considering or currently migrating to SQL Server 2012. Practical experience with Microsoft business intelligence tools and Visual Studio is assumed.
Hands-On Training Throughout this course, extensive hands-on exercises provide practical experience working with SQL Server 2012 business intelligence tools. Exercises include:
- Maximising data warehouse performance with specialised indexes
- Customising SSIS packages with new toolbox components
- Designing and deploying a SQL Server 2012 tabular model database
- Building a Excel PowerPivot workbook from an SSAS Tabular database
- Creating Project Crescent reports for SharePoint
Course Content Introducing the New Features of the Microsoft Business Intelligence Platform
- Exploring the new capabilities of the BI architecture
- Applying the Business Intelligence Semantic Model (BISM) to specific business needs
- Taking advantage of new BI lifecycle options
- Providing self-service tools for data analysis and reporting
Enhancing SQL Server Data Warehouse Performance
Optimising the data warehouse with new database structures of SQL Server 2012
- Identifying data warehouse structures that benefit from performance tuning
- Matching SQL Server relational design to the Semantic Model
Applying columnstore indexes to a data warehouse
- Identifying appropriate columns for columnstore indexing
- Creating the columnstore index and monitoring performance
Maintaining data integrity with Data Quality Services (DQS)
- Creating a standard quality data reference table
- Checking new data against reference standards
Optimising the Data Load with SQL Server Integration Services (SSIS)
Navigating the Business Intelligence Development Studio (BIDS) 2010 user interface
- Streamlining package development in the new environment
- Migrating data into Analysis Services
Inspecting the new SSIS toolbox
- Customising SSIS packages with the parameterised task component for flexibility and package reuse
- Managing data quality in SSIS using the correction component
Building Tabular and Cube Structures with SQL Server Analysis Services (SSAS)
Creating a tabular model database project in BIDS 2010
- Managing data sources in the BIDS 2010 environment
- Establishing relationships between tables
- Utilising multiple table relationships for a more robust database design
- Deploying a BISM tabular model database
Selecting DirectQuery mode for a SSAS tabular database
- Evaluating the advantages of DirectQuery mode
- Implementing and deploying a SSAS tabular database for DirectQuery mode
Preparing a tabular model for use in Excel PowerPivot
- Customising a database design for PowerPivot
- Creating a tabular database for PowerPivot users
Leveraging new querying and data mining features
- Querying tabular databases and cubes with the Multidimensional Expressions (MDX) language
- Taking advantage of data mining enhancements for SQL Server 2012
Analysing Data in Tabular Structures with Excel PowerPivot
Accessing data through an SSAS tabular database
- Importing tables from a BISM tabular model database
- Adding tables from relational and other data sources
- Unravelling detail with drillthrough
Exploiting the new Data Analysis Expressions (DAX) functions
- Applying DAX functions for data exploration and analysis in Excel
- Expanding the scope of analysis with new table relationship support
Self-Service Reporting with SharePoint Server
Creating self-service reports with Project Crescent
- Contrasting Project Crescent and Report Builder
- Enabling SharePoint support for Project Crescent
- Designing reports with ad hoc queries and high-quality graphics
- Publishing reports for access by other users
Managing the self-service reporting environment
- Keeping current with end-user alerts
- Setting up Project Crescent and PowerPivot data to work with PowerPoint presentations and Microsoft Word
|
<< Back to SQL Server
Related Courses
|
|
Course Dates
UK Dates | | 16-18 May | London enrol | | 5-7 Sep | London enrol | | 28-30 Nov | London enrol | US East Coast Dates | | 25-27 Apr | Washington, DC enrol* | | 30 May - 1 Jun | New York enrol* | | 13-15 Jun | Washington, DC enrol* |
*New York and Washington DC Courses – Available online with a run time of 2pm to 9pm BST. For AnyWare enrolments, please register at least 10 days prior to the start of the course.
More Dates and Locations.
|
|
|
|
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customised for your organisation.
|
Participants selecting the appropriate Business Intelligence Semantic Model for a project design.
|
|
|
|
E-mail 
Print 
Q&A 
PDF 
Facebook 
Twitter
