Implementing Data Models and reports with Microsoft SQL Server

Apply now for our Implementing Data Models and reports with Microsoft SQL Server Course



 
  • Introduction to Business Intelligence and Data Modeling
  • Exploring a BI Solution
  • Creating Multidimensional Databases
  • Creating a Multidimensional Database
  • Working with Cubes and Dimensions

 

Course Details and Pricing


Instructor Led Learning


  Duration: 5 Days

  Registration Open Now!

Video Learning


  Duration: 5 Days

  Registration Open Now!

Call us : 021 419 3213

Windows 7 overview

Implementing Data Models and reports with Microsoft SQL Server Course Overview


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

Implementing Data Models and reports with Microsoft SQL Server

Who should attend ?


This course is intended for database professionals who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions.

Implementing Data Models and reports with Microsoft SQL Server Course cape town south africa

About This Course

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

3 Steps to Master Implementing Data Models and reports with Microsoft SQL Server

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Designing a Microsoft Sharepoint 2010 Infrastructure Training Course

  • Course Overview Full course outline
    • 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

Full course outline
Implementing Data Models and reports with Microsoft SQL Server

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