Course details

This 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.

Course Outline

  • Lesson 1: Introduction to Business Intelligence and Data Modeling
  • Lesson 2: Implementing Reports with Reporting Services
  • Lesson 3: Supporting Self-Service Reporting
  • Lesson 4: Managing a Reporting Infrastructure
  • Lesson 5: Creating Multidimensional Databases
  • Lesson 6: Working with Cubes and Dimensions
  • Lesson 7: Working with Measures and Measure Groups
  • Lesson 8: Introduction to MDX
  • Lesson 9: Customizing Cube Functionality
  • Lesson 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot
  • Lesson 11: Introduction to Data Analysis Expression (DAX)
  • Lesson 12: Implementing an Analysis Services Tabular Data Model
  • Lesson 13: Creating Data Visualizations With Power View
  • Lesson 14: Performing Predictive Analysis with Data Mining

Prerequisites

In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

  • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL
Updated on 08 November, 2015

About New Horizons Singapore

Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

See all New Horizons Singapore courses
Are you from New Horizons Singapore ? Claim your course!
Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or