> > > 10778

Implementing Data Models and Reports with Microsoft SQL Server 2012 (10778)

Course Description Schedule Course Outline
 

Who should attend

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

  • Implementing reporting solutions by using SQL Server Reporting Services.
  • Implementing multidimensional databases by using SQL Server Analysis Services.
  • Creating tabular semantic data models for analysis by using SQL Server Analysis Services.
  • Create visualizations of data by using PowerView.
  • Create data mining solutions by using SQL Server Analysis Services.

Course Objectives

After completing this course, students will be able to:

  • Describe the components, architecture, and nature of a BI solution.
  • Create reports with Reporting Services.
  • Create reusable report items that simplify self-service reporting.
  • Manage report execution and delivery.
  • 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 Data Model in PowerPivot.
  • Use DAX to query a tabular model.
  • Implement a Tabular Database.
  • Use PowerView to create interactive data visualizations.
  • Use Data Mining for Predictive Analysis.

Course Content

This 5-day instructor-led course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.

Classroom Training
Modality: G

Duration 5 days

Enroll now
 
Schedule

Currently there are no training dates scheduled for this course.  Enquire a date

 

Accessing our website tells us you are happy to receive all our cookies. However you can change your cookie settings at any time. Find out more.   Got it!