"People do not invest in education because they are rich. They become rich because they invest in education."


- Gabriel Verhoef

Implementing Data Models and reports with Microsoft SQL Server

 

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

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

Duration:

Learning Materials:

Prerequisites:

What course next:

5 Days

All included

6235 »

MCPD
 

Get a Quote today »

 

Course Content
Implementing Data Models and reports with Microsoft SQL Server
 

  • Introduction to Business Intelligence and Data Modeling
  • Exploring a BI Solution
  • Creating Multidimensional Databases
  • Creating a Multidimensional Database
  • Working with Cubes and Dimensions
  • Defining Dimensions
  • Working with Measures and Measure Groups
  • Introduction to MDX
  • Using MDX
  • Enhancing a Cube
  • Implementing an Analysis Services Tabular Data Model
  • Introduction to DAX
  • Implementing Reports with SQL Server Reporting Services
  • Enhancing Reports with SQL Server Reporting Services
  • Managing Report Execution and Delivery
  • Delivering BI with SharePoint PerformancePoint Services
  • Performing Predictive Analysis with Data Mining

 

Quick Search
Register Here

Fill in your details below and one of our career specialists will assist you with your study needs

Sorry, your message could not be sent. Please check your details. Please complete all fields.

Name

Email

Phone

Location

Message


Thank you
For your request, one of our career specialists will assist you with your study needs.

It’s very fun and interesting. Love It!!

Shaun2.jpg
- Shaun Brown

I will recommend MasterGrade IT to anyone that is serious about getting certification.

zaheer1.jpg
- Zaheer Isaacs

Very informative; Excel is a great course to start off with. I like the neat classrooms and the personal attention!

rene1.jpg
- René Leandro Borges

I enjoyed doing the course in my own time!

sadia.jpg
- Sadia Abrahams

Already Engaged.

Thousands of companies around the world use and love our training every day.


Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup
Meetup

Procomp Computer Services CC trading as MasterGrade IT® Computer Learning Centre. Registration No. 2002/029621/23.