OneSource Professional Training Solutions, Inc. presents
 

Implementing Data Models and Reports with Microsoft SQL Server 2012 On-Site Training

Implementing Data Models and Reports with Microsoft SQL Server 2012

Course Description/Agenda

In this course, you will use the prerelease version of SQL Server 2012 to learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. Many of the labs are SQL Azure enabled.

What You'll Learn

• Components, architecture, and nature of a business intelligence (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, and measures and measure groups in a cube
• Use Multidimensional Expressions (MDX) Syntax
• Customize a cube
• Implement a tabular data model in PowerPivot
• Use Data Analysis Expressions (DAX) to query a tabular model
• Implement a tabular database
• Use Power View to create interactive data visualizations
• Use data mining for predictive analysis

Who Should Attend

• Database professionals who need to fulfill a BI developer role to create analysis and reporting solutions
• Database professionals responsible for:
  • Implementing reporting solutions by using SQL Server Reporting Services
  • Implementing multidimensional databases using SQL Server Analysis Services
  • Creating tabular semantic data models for analysis using SQL Server Analysis Services
  • Creating visualizations of data by using Power View
  • Creating data mining solutions using SQL Server Analysis Services

Course Prerequisites

• Knowledge of relational databases and basic knowledge of Microsoft Windows operating systems and its core functionality

Course Outline

1. Business Intelligence and Data Modeling

• BI
• The Microsoft BI Platform

2. Implementing Reports with Reporting Services

• Reporting Services
• Creating a Report with Report Designer
• Grouping and Aggregating Data in a Report
• Showing Data Graphically
• Filtering Reports using Parameters

3. Supporting Self-Service Reporting

• Report Builder
• Creating Reusable Report Items

4. Managing a Reporting Infrastructure

• Managing Security
• Managing Report Execution
• Delivering Reports with Subscriptions
• Troubleshooting Reporting Services

5. Creating Multidimensional Databases

• Multidimensional Analysis
• Creating Data Sources and Data Source Views
• Creating a Cube
• Cube Security

6. Working with Cubes and Dimensions

• Configuring Dimensions
• Attribute Hierarchies
• Sorting and Grouping Attributes

7. Working with Measures and Measure Groups

• Measures
• Measure Groups

8. Multidimensional Expressions (MDX)

• MDX Fundamentals
• Adding Calculations to a Cube
• Using MDX to Query a Cube

9. Customizing Cube Functionality

• Implementing Key Performance Indicators
• Implementing Actions, Perspectives, and Translations

10. Implementing a Tabular Data Model by Using Microsoft PowerPivot

• Tabular Data Models and PowerPivot Technologies
• Creating a Tabular Data Model by using PowerPivot for Excel
• Sharing a PowerPivot Workbook and using PowerPivot Gallery

11. Data Analysis Expression (DAX)

• DAX Fundamentals
• Using DAX to Create Calculated Columns and Measures in a Tabular Data Model

12. Implementing an Analysis Services Tabular Data Model

• Analysis Services Tabular Data Model Projects
• Implementing an Analysis Services Tabular Data Model in BI Development Studio

13. Creating Data Visualizations with Power View

• Power View
• Visualizing Data with Power View

14. Performing Predictive Analysis with Data Mining

• Data Mining
• Using the Data Mining Add-In for Excel
• Creating a Custom Data Mining Solution
• Validating a Data Mining Model
• Connecting to a Consuming a Data Mining Model

Labs

Lab 1: Report and Analyze Data

Lab 2: Implement Reports with Reporting Services

Lab 3: Support Self-Service Reporting

Lab 4: Implement Report Subscriptions

Lab 5: Create a Multidimensional Database

Lab 6: Work with Cubes and Dimensions

Lab 7: Configure Measures and Measure Groups

Lab 8: Use MDX

Lab 9: Customize a Cube

Lab 10: Use PowerPivot for Excel

Lab 11: Create Calculated Columns and Measures by using DAX

Lab 12: Work with an Analysis Services Tabular Data Model

Lab 13: Create Interactive Reports with Power View

Lab 14: Perform Predictive Analysis with Data Mining

More Seminar Information

OneSource Professional Training Solutions, Inc. Delivery Method  On-Site Training Also Available As  Seminar