> > > 20466 Detailed outline

Implementing Data Models and Reports with Microsoft® SQL Server® (20466)

Course Description Kurs tarihleri Course Outline

Detailed Course Outline

Module 1: Introduction to Business Intelligence and Data Modeling

  • Elements of an Enterprise BI Solution
  • The Microsoft Enterprise BI Platform
  • Planning an Enterprise BI Project

Module 2: Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

Module 3: Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Hierarchies

Module 4: Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Module 5: Introduction to MDX

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

Module 6: Enhancing a Cube

  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations

Module 7: Implementing an Analysis Services Tabular Data Model

  • Introduction to Analysis Services Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in the Enterprise

Module 8: Introduction to DAX

  • DAX Fundamentals
  • Enhancing a Tabular Data Model with DAX

Module 9: Implementing Reports with SQL Server Reporting Services

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Publishing and Viewing a Report

Module 10: Enhancing Reports with SQL Server Reporting Services

  • Showing Data Graphically
  • Filtering Reports by Using Parameters

Module 11: Managing Report Execution and Delivery

  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alerts
  • Troubleshooting Reporting Services

Module 12: Delivering BI with SharePoint PerformancePoint Services

  • Introduction to SharePoint Server as a BI Platform
  • Introduction to PerformancePoint Services
  • PerformancePoint Data Sources and Time Intelligence
  • Reports, Scorecards, and Dashboards

Module 13: Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating a Data Mining Model
  • Consuming Data Mining Data

Labs

  • Exploring a BI Solution
  • Creating a Multidimensional Database
  • Defining Dimensions
  • Configuring Measures and Measure Groups
  • Using MDX
  • Customizing a Cube
  • Implementing an Analysis Services Tabular Data Model
  • Using DAX to Enhance a Tabular Data Model
  • Creating a Report with Report Designer
  • Enhancing a Report
  • Configuring Report Execution and Delivery
  • Implementing a SharePoint Server BI Solution
  • Using Data Mining to Support a Marketing Campaign
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!