Implementing Data Models and Reports with Microsoft SQL Server 2012


Note: Course retiring Jan 31 2015. Replaced with 20466-Implementing Data Models and Reports with Microsoft® SQL Server® 2014

Introduction

Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.
This five-day instructor-led course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.

Outcomes

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.



User Reviews

Good Stuff (Rating based on 10 reviews)

80%
of respondents recommend this course to a friend.


Reviewd by 10 participants
« previous12next »

A good overview

Rating


Comment:
This course is a good general overview of the various components of SQL Server Analysis Services and Reporting Services. It was a good opportunity to play with the tools in a \'safe\' learning environment with a knowledgeable instructor to bounce questions off. Was it an in-depth technical course? No. But has it given me a good place to start? Yes. Not recommended for people who are already kicking goals developing cubes etc., but good for someone just starting out.

I recommend this course.

by Anon
Date: 2014-09-19 14:59:34




Student

Rating


Comment:
was good course to helped with what works needs me to learn and implement

I recommend this course.

by Student1
Date: 2014-09-19 14:58:36




Good overview of technologies available.

Rating


Comment:
I wanted to become familiar with what reporting tools were available with MSSQL. This course gave me a very good introduction.

I recommend this course.

by jdownie
Date: 2014-09-19 14:55:34




.

Rating


Comment:
.

I recommend this course.

by .
Date: 2014-06-06 12:29:43




A good studying environment and lab exercises

Rating


Comment:
This course helps me in understanding more with cube, powerpivot and powerview.

I recommend this course.

by LD
Date: 2014-06-06 12:29:01




Course Info

  • Code: 10778(Retired)
  • Duration: 5 days
  • Price: Call for price
  • Rating:
    Good Stuff


Next Step

Enquire Now
Tell a Friend