Processing your application. Please be patient while we make sure we receive every piece of it.
SharePoint 2010
Designing BI Report Solutions with SQL Server 2012 Reporting Services and SharePoint 2010
5 Day(s)
Course OverviewThis course will teach students to apply industry design patterns and best practices to create business reports and reporting solutions based on years of field experience with the product in a variety of industries and business scenarios. Students will learn to avoid common pitfalls and to apply effective design techniques to meet business requirements. This course is focused on business intelligence solutions, dashboards and analytical reports deployed to an integrated SharePoint business portal environment. SQL Server Reporting Services is the industry-standard reporting tool from Microsoft, available in the SQL Server product suite. It can be used to report on data from many different data sources and database platforms, for operational, business intelligence and analytical reporting. Many of the techniques and practices taught in this course can be applied to a variety of reporting styles and environments with and without SharePoint integration.Upon completion of this course, the student will be able to: • Define, articulate and document business report requirements• Use Report Builder and SQL Server Data Tools to design reports and report solutions• Create data sources and datasets to retrieve data from business data stores• Use fundamental T-SQL and MDX queries to retrieve data• Filter data using a query or dataset filter definition• Design basic report styles including tables, lists, matrices and charts• Group, sort and summarize data using report data regions• Define report layout and formatting elements to present information• Build dynamic drill-down and drill-through reports using report actions• Use advanced report design techniques to present complex data• Use parameters and expressions to create a dynamic reporting experience• Design analytical reports based on semantic data models and OLAP cubes• Apply industry standard design patterns and best practices• Use shared data sources, shared datasets and report parts• Design and build BI dashboards using KPI indicators, sparklines and gauges• Use maps to visualize and analyse geographic and spatial data• Deploy and manage reports to test, and production environments• Manage report folders and document libraries• Integrate reports into SharePoint document libraries• Understand and articulate report management and security requirements• Define and manage a self-service reporting solution using Report Builder• Enable user data discovery and insights with PowerPivot, BI semantic tabular models and Power View• Use subscriptions, snapshots and cached report instances to define business report solutions• Enable business user solutions by planning a self-service reporting solution for users to design their own reports, simply, using report parts and shared objects AudienceThis course is intended for business users and IT professionals who need to design business reports to support operational or analytical reporting needs. Report designers can leverage their skills using other reporting tools or start fresh with no prior report design experience. Less experienced business users should be prepared to keep pace with advanced users and to follow directions using common Windows menus, controls and dialogs. IT professionals and developers who do not have prior experience with Reporting Services will find this course helpful for learning to design and manage reports that may be used in integrated applications and enterprise reporting solutions. Students with prior Reporting Services version experience will find this course useful for learning to use capabilities introduced in the new product version.PrerequisitesStudents will learn fundamental query design and data manipulation and are not required to have these skills before attending this course. They must be proficient using Windows and business productivity software, common Windows dialogs and controls, and should be able to use Windows Explorer to manage files and navigate a folder structure. They should be proficient using Internet Explorer to navigate hyperlinks and Internet addresses. Students who are very proficient using Microsoft Windows, Word and Excel should be comfortable with this course. Advanced skills with Visual Studio and SQL Server are helpful but not required.
Price: $4,595
To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:

To find out more available information
about this course, please contact us:


Designing BI Report Solutions withSQL Server 2012 Reporting Services and SharePoint 2010


Module 1 - Report Solutions & Architecture

  • SQL Server Reporting Services (SSRS) architecture at a high level
  • Introduction to databases and semantic models
  • SSRS in SharePoint

Module 2 - Basic Report Design

  • Report design tools overview
  • Report builder

Module 3 - Report Layout & Formatting

  • Essential components: Data sources, datasets, and data regions
  • Table design
  • Groups and headers
  • Formatting numeric measures
  • Aggregates and totals

Module 4 - Designing Data Access

  • Shared and embedded data sources
  • Database objects
  • T-SQL query basics
  • Query grouping and aggregation

Module 5 - Chart Report Design

  • Chart essentials
  • Chart design environment
  • Chart type criteria
  • Chart object anatomy

Module 6 - Groups and Totals

  • Report body, headers, and footers
  • Totals and subtotals

Module 7 - Expressions and Custom Logic

  • Using properties and expressions
  • Introducing the Expression Builder
  • Using expressions and parameters to customize report behavior
  • Introducing custom Visual Basic functions

Module 8 - Dynamic Reports and Actions

  • Dynamic visibility and drill-down reports

Module 9 - Semantic Models and Analytical Data Sources

  • Introduction to dimensional data modeling
  • Microsoft Business Intelligence and the BI Semantic Model
  • PowerPivot for Excel and PowerPivot for SharePoint
  • Tabular BI Semantic Models
  • Migrating PowerPivot to a tabular model
  • The SSDT tabular model designer

Module 10 - Multidimensional Reporting with SSAS and MDX

  • Basic MDX report design
  • Graphical MDX query designer
  • Manual query modification
  • Report design provisions
  • MDX essentials

Module 11 - Map Report Design and Geospatial Reporting

  • Map report basics
  • Using the map wizard
  • Working with spatial data
  • Shape layers and point layers
  • Color scales, callouts, and point labels
  • Bing Maps layers
  • Geocoding and geospatial queries
  • Map design techniques and design patterns

Module 12 - BI Dashboard Design

  • Dashboard concepts
  • The art of dashboard design - examples, patterns, and expert recommendations
  • Using and reporting KPIs
  • Gauges and bullet graphs
  • Scorecards and indicator sets

Module 13 - Enabling Report Delivery and Self-Service Reporting

  • Reporting in the Cloud
  • Planning a self-service reporting solution
  • Report content planning
  • Organizing reports
  • Report ownership
  • Report execution options
  • Automated delivery options