Implementing Data Models and reports with Microsoft SQL Server Course overview

This course teaches students how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.

Apply Today

Instructor Led Learning

Duration: 5 Days
Registration Open Now!

Video Learning

Duration: 5 Days
Registration Open Now!

What you will learn

  • Lesson 1 : Introduction to Business Intelligence and Data Modeling
  • Lesson 2 : Exploring a BI Solution
  • Lesson 3 : Creating Multidimensional Databases
  • Lesson 4 : Creating a Multidimensional Database
  • Lesson 5 : Working with Cubes and Dimensions
  • Lesson 6 : Defining Dimensions
  • Lesson 7 : Working with Measures and Measure Groups
  • Lesson 8 : Introduction to MDX
  • Lesson 9 : Using MDX
  • Lesson 10 : Enhancing a Cube
  • Lesson 11 : Implementing an Analysis Services Tabular Data Model
  • Lesson 12 : Introduction to DAX
  • Lesson 13 : Implementing Reports with SQL Server Reporting Services
  • Lesson 14 : Enhancing Reports with SQL Server Reporting Services
  • Lesson 15 : Managing Report Execution and Delivery
  • Lesson 16 : Delivering BI with SharePoint PerformancePoint Services
  • Lesson 17 : Performing Predictive Analysis with Data Mining

Basic computer skills

Introduction to Microsoft SQL Server

FULL COURSE OUTLINE

Lesson 1: Introduction to Business Intelligence and Data Modeling

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

Lesson 2: Planning an Enterprise BI Project

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

Lesson 3: Working with Cubes and Dimensions

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

Lesson 4:Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Lesson 5:Introduction to MDX

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

Lesson 6: Enhancing a Cube

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

Lesson 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

Lesson 8: Introduction to DAX

  • DAX Fundamentals
  • Enhancing a Tabular Data Model with DAX

Lesson 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

Lesson 10: Enhancing Reports with SQL Server Reporting Services

  • Showing Data Graphically
  • Filtering Reports by Using Parameters

Lesson 11: Managing Report Execution and Delivery

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

Lesson 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

Lesson 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

Join Over 10,000 Students that have studied with MasterGrade IT Now

Become Part of MasterGrade IT to Further Your Career.

Contact Us