• LOGIN
    • No products in the cart.
Developing SQL Data Models

Developing SQL Data Models

$315.00

Product Description

MOD-20768

Audience: Data Professionals | Technology: SQL Server | Level: 300

Introduction

The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

Audience Profile

The primary audience for this course are database professionals who need to fulfil BI Developer role to create enterprise BI solutions. Primary responsibilities will include:

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX syntax
  • Customize a cube
  • Implement a tabular database
  • Use DAX to query a tabular model
  • Use data mining for predictive analysis

Prerequisites

Before attending this course, students must have:

  • Experience of querying data using Transact-SQL

At Course Completion

After completing this course, students will be able to:

  • Explain how Microsoft R Server and Microsoft R Client work
  • Use R Client with R Server to explore big data held in different data stores
  • Visualize data by using graphs and plots
  • Transform and clean big data sets
  • Implement options for splitting analysis jobs into parallel tasks
  • Build and evaluate regression models generated from big data
  • Create, score, and deploy partitioning models generated from big data
  • Use R in the SQL Server and Hadoop environments
Download Full Details
Website Designers © The Brand Institute. Microsoft Online Training Courses | MOC on Demand
MOC On-Demand
CONTACT US
Please send us your information and we will get back to you in regard to Software Assurance Training Vouchers
Thank You. We will contact you as soon as possible.
MOC On-Demand
CONTACT US
We look forward to hearing from you, please do feel free to leave us a message and we will get back to you soonest.
Thank You. We will contact you as soon as possible.
MOC On-Demand
REQUEST A DEMO
Please send us your information and we will get back to you in regard to a demo course.
Thank You. We will contact you as soon as possible.