A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(F1043) Fast Track: Customisation, Configuration and Workflows in Microsoft Dynamics CRM 2011/CRM Online - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
ASP.NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6317) Upgrading Your SQL Server 2000 Database Administration Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Windows 7 Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 Computing - Microsoft CRM Gold Partner
Windows 2003 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Web Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(0828) Deploying and Supporting Microsoft Systems Management Server 2.0 (SMS) - Microsoft Training Courses in London and South West
Course:(1934) Principles of Modeling Windows DNA-based Applications with Rational Rose - Microsoft Training Courses in London and South West
Visual FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8020) Microsoft Business Solutions CRM 1.2 Customization - Microsoft Training Courses in London and South West
BizTalk Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Business Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Training Course Index - F1Computing Microsoft Training Courses London South West UK
FoxPro Training Course Index - F1Computing Microsoft Training Courses London South West UK
Hyper-V and Virtualisation Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6446) Implementing and Administering Windows Essential Business Server 2008 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Exchange Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
C Sharp Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50511) The Microsoft Intelligence 2010 Stack - Microsoft Training Courses in London and South West
Office 2007 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50257) Upgrading to Microsoft ASP.NET 3.5 - Microsoft Training Courses in London and South West
SQL Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Security Training Course Index - F1Computing Microsoft Training Courses London South West UK
Windows Vista Training Course Index - F1Computing Microsoft Training Courses London South West UK
F1 - Training and Technology Blogs
Course:(6463) Visual Studio 2008 Connected Systems: ASP.NET 3.5 - Microsoft Training Courses in London and South West
Course:(7034) Implementing Microsoft Office Live Communications Server 2005 - Microsoft Training Courses in London and South West
Course:(2520) Deploying Microsoft Windows XP Professional - Microsoft Training Courses in London and South West
SharePoint Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10215) Implementing and Managing Microsoft Server Virtualization - Microsoft Training Courses in London and South West
Course:(10508) Planning, Deploying, and Managing Microsoft Exchange Server 2010 Unified Messaging - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Certification Fast-Track Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10337) Updating Your Microsoft SQL Server 2008 BI Skills to SQL Server 2008 R2 - Microsoft Training Courses in London and South West
Course:(10267) Introduction to Web Development with Microsoft Visual Studio 2010 - Microsoft Training Courses in London and South West
CRM Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1044) Learning to Program using Microsoft C# 2010 - Microsoft Training Courses in London and South West
Course:(2310) Developing Web Applications Using Microsoft Visual Studio 2008 - Microsoft Training Courses in London and South West
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(10534) Planning and Designing a Microsoft Lync Server 2010 Solution - Microsoft Training Courses in London and South West
Course:(80442) Introduction to Microsoft Dynamics CRM 2011 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50229) Understanding the Microsoft Solutions Framework - Microsoft Training Courses in London and South West
Windows Services Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(10778) Implementing Data Models and Reports with Microsoft SQL Server 2012 - Beta - Microsoft Training Courses in London and South West
Silverlight 4 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Fast-Track Courses Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
SQL Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(10232) Designing and Developing Microsoft SharePoint Server 2010 Applications - Microsoft Training Courses in London and South West
Course:(F1048) Microsoft BizTalk Server 2010 Administration - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates


Premier
SQL Server 2012

Implementing Data Models and Reports with Microsoft SQL Server 2012 - Beta
(Microsoft Training Course: 10778) - 5 days - £2095 exc VAT

 MayJunJulAugSepOctNovDecJanFebMarApr
London11 02 06 03 01 05 03 07 04 04
Ask a Question ?Print 2 Page PDF


> Target Audience
This course describes how to empower information workers through self-service analytics and reporting. The primary audience for this course are database professionals who need to fulfill BI Developer role to create analysis and reporting solutions. The Beta version of this course (10778AB) utilizes pre-release software in the virtual machine for the labs
> Course outline
  1. Introduction Business Intelligence and Data Modeling
  2. Implementing Reports with Reporting Services
  3. Supporting Self-Service Reporting
  4. Managing a Reporting Infrastructure
  5. Creating Multidimensional Databases
  6. Working with Cubes and Dimensions
  7. Working with Measures and Measure Groups
  8. Introduction to MDX
  9. Customizing Cube Functionality
  10. Implementing a Tabular Data Model by Using Microsoft PowerPivot
  11. Introduction to Data Analysis Expression (DAX)
  12. Implementing an Analysis Services Tabular Data Model
  13. Creating Data Visualizations With Power View
  14. Performing Predictive Analysis with Data Mining
Module 1: Introduction Business Intelligence and Data Modeling
  • Introduction to Business Intelligence, common BI scenarios, current trends in BI, and the typical roles involved in creating a BI solution
  • Introduction to the Microsoft BI platform, describing the roles that SQL Server 2012 and SharePoint 2010 play in Microsoft BI solutions
  • The Microsoft Business Intelligence Platform
  • Lab: Reporting and Analyzing Data
  • Exploring a Reporting Services report
  • Exploring a PowerPivot workbook
Skills
  • Describe the key BI concepts and the Microsoft BI product suite.
top
Module 2: Implementing Reports with Reporting Services
  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports Using Parameters
  • Lab: Implementing Reports with Reporting Services
  • Creating a Report
  • Grouping and Aggregating Data in a Report
  • Adding a Chart to a Report
  • Implementing Parameters in a Report
  • Publishing and Viewing a Report
  • Optional Exercise: Creating Visual Comparisons in a Report
  • Optional Exercise: Creating a Map Report
Skills
  • Create reports with Reporting Services.
top
Module 3: Supporting Self-Service Reporting
  • Introduction to Report Builder
  • Creating Reusable Report Items
  • Lab: Supporting Self-Service Reporting
  • Using Report Builder
  • Creating a shared data source
  • Creating shared data sets
  • Creating a Report Part
Skills
  • Create reusable report items that simplify self-service reporting.
top
Module 4: Managing a Reporting Infrastructure
  • Managing Security
  • Managing Report Execution
  • Delivering Reports with Subscriptions
  • Troubleshooting Reporting Services
  • Lab: Implementing Report Subscriptions
  • Configuring Report Execution
  • Implementing a Standard Subscription
  • Implementing a Data-Driven Subscription
Skills
  • Manage a reporting infrastructure.
top
Module 5: Creating Multidimensional Databases
  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security
  • Lab: Creating a Multidimensional Database
  • Creating a Data Source
  • Creating and Modifying a Data Source View
  • Creating and Modifying a Cube
Skills
  • Create a multidimensional database with Analysis Services.
top
Module 6: Working with Cubes and Dimensions
  • How to create multidimensional databases and introducing the core components of an OLAP cube
  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes
  • Lab: Working with Cubes and Dimensions
  • Configuring Dimensions
  • Defining Relationships and Hierarchies
  • Sorting and Grouping Dimension Attributes
Skills
  • Implement dimensions in a cube.
top
Module 7: Working with Measures and Measure Groups
  • Working With Measures
  • Working with Measure Groups
  • Lab: Configuring Measures and Measure Groups
  • Configuring Measures
  • Defining Dimension Usage and Relationships
  • Configuring Measure Group Storage
Skills
  • Implement measures and measure groups in a cube
top
Module 8: Introduction to MDX
  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX To Query a Cube
  • Lab: Using MDX
  • Querying a Cube by Using MDX
  • Creating a Calculated Member
Skills
  • Use MDX Syntax.
top
Module 9: Customizing Cube Functionality
  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations
  • Lab: Customizing a Cube
  • Implementing a KPI
  • Implementing an Action
  • Implementing a Perspective
  • Implementing a Translation
Skills
  • Customize a cube.
top
Module 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot
  • Installation and use of PowerPivot for Excel add-in and the PowerPivot for SharePoint gallery
  • Introduction to Tabular Data Models and PowerPivot Technologies
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Sharing a PowerPivot Workbook and Using PowerPivot Gallery
  • Lab: Using PowerPivot for Excel
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Using a Tabular Data Model in Excel
  • Sharing a PowerPivot Workbook to PowerPivot Gallery
  • Using a PowerPivot Workbook as a Data Source
Skills
  • Implement a Tabular Data Model in PowerPivot.
top
Module 11: Introduction to Data Analysis Expression (DAX)
  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular Data Model
  • Lab: Creating Calculated Columns and Measures by Using DAX
  • Creating Calculated Columns & Measures
  • Using Time Intelligence
  • Creating a Dynamic Measure
Skills
  • Use DAX to create measures and calculated columns in a tabular data model.
top
Module 12: Implementing an Analysis Services Tabular Data Model
  • Introduction to Analysis Services Tabular Data Model Projects
  • Implementing an Analysis Services Tabular Data Model in Business Intelligence Development Studio
  • Lab: Working with an Analysis Services Tabular Data Model
  • Creating an Analysis Services Tabular Data Model Project from a PowerPivot Workbook
  • Implementing a Perspective
  • Implementing Partitions
  • Deploying an Analysis Services Tabular Data Model
  • Enabling Access to a Tabular Data Model
  • Configuring DirectQuery Storage Mode
  • Implementing Security in a Tabular Data Model
Skills
  • Implement a Tabular database.
top
Module 13: Creating Data Visualizations With Power View
  • Introduction to Power View
  • Visualizing Data with Power View
  • Lab: Creating Interactive Reports with Power View
  • Modify the Tabular Data Model
  • Create a Simple Power View Report
  • Interactive Visualizations
  • Create a Scatter Chart and a Play Axis
Skills
  • Use Power View to create interactive data visualizations.
top
Module 14: Performing Predictive Analysis with Data Mining
  • Overview of Data Mining
  • Using the Data Mining Add-In for Excel
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to a and Consuming a Data-Mining Model
  • Lab: Performing Predictive Analysis with Data Mining
  • Using the Excel Data Mining Add-In
  • Creating a Data Mining Structure and Model
  • Exploring Data Mining Models
  • Validating Data Mining Models
  • Consuming a Data Mining Model
Skills
  • Use Data Mining for Predictive Analysis.
top
> Pre-Requisites
In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:
  • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL
> Purpose
After completing this course, students will be able to: describe the components, architecture, and nature of a BI solution; create reports with Reporting Services; create reusable report items that simplify self-service reporting; manage a reporting infrastructure; create a multidimensional database with Analysis Services; implement dimensions in a cube; implement measures and measure groups in a cube; use MDX Syntax; customize a cube; implement a Tabular Data Model in PowerPivot; use DAX to query a tabular model; implement a Tabular Database; use Power View to create interactive data visualizations; use Data Mining for predictive analysis.
> EXAMS
There are no exams directly associated with this course