Course code: GOC634« Back

Microsoft SQL Server Reporting Services – Upgrade your Knowledge to SQL Server 2008R2/2012

In this course students will learn to work with new functions of MS SQL reporting services 2008R2/2012. Due to the little difference between the 2012 version and 2008R2 version, it is possible to take part in the course in case you are planning to use any of the two versions.

GOPAS Official Curriculum
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 9 000 CZK included in course price 20
Brno2 9 000 CZK included in course price 20
Bratislava2 350,00 EUR included in course price 20

User intensity level

Who is the course for

  • The course aims at participants of MOC 6236 course who want to broaden their knowledge of innovations of MSSQL 2008R2 or MSSQL 2012.

After completing this course, students will be able :

  • To work with new graphical items of Reporting Services
  • To work with data types geometer and geography
  • To convert vector map sources to the SQL server database
  • To create map reports
  • To create PowerView (new to 2012)

Required skills

  • Reporting services knowledge based on the content of the MOC 6236 course
  • Creating of basic reports, their deployment on Report Manager and administration of reports in Report Manager.

Teaching methods

Expert instruction with practical examples, computer practice

Literature

Printed presentation

Course Outline

What’s new in v SSRS 2008R2 / 2012
  • Graphical items
  • Modification and correction
  • Summary of new features in SSRS administration
New features
  • Shared datasets
  • Indicators
  • Sparklines
  • Report parts
  • Databars
Spatial data types
  • Geometry
  • Geography
  • Compare, querying in TSQL
Map reports
  • Authoring
  • Deployment and administration
  • Deployment to SSRS / SQL Azure
  • Limitations
Map data
  • Where to find
  • Custom creation – warehouse map
  • Convert vector to spatial data types
  • Compare ERSI format and DB located vector graphic
Report Builder 3.0
  • BIDS / SSDT vs. Report Builder 3.0
PowerView
  • User reporting on Sharepoint 2010 based on PowerPivot

        Previous courses

        no preceding courses

        Next courses

        no following course
        Tištěné nebo elektronické studijní materiály GOPAS

        Price:
        included in course price
        The prices are without VAT.