Implementing Data Models and Reports with Microsoft SQL Server 2012 هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course describes how to empower information workers through self-service analytics and reporting. Students will 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.

Course Outline

• Lesson 1: Introduction to Business Intelligence and Data Modeling
• Lesson 2: Implementing Reports with Reporting Services
• Lesson 3: Supporting Self-Service Reporting
• Lesson 4: Managing a Reporting Infrastructure
• Lesson 5: Creating Multidimensional Databases
• Lesson 6: Working with Cubes and Dimensions
• Lesson 7: Working with Measures and Measure Groups
• Lesson 8: Introduction to MDX
• Lesson 9: Customizing Cube Functionality
• Lesson 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot
• Lesson 11: Introduction to Data Analysis Expression (DAX)
• Lesson 12: Implementing an Analysis Services Tabular Data Model
• Lesson 13: Creating Data Visualizations With Power View
• Lesson 14: Performing Predictive Analysis with Data Mining

Prerequisites

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