Designing BI Report Solutions with SQL Server Reporting Services and SharePoint (SQBI16)



SQL Server 2016 adds many new features for the on premise business intelligence suite. Although this workshop covers the majority of the new features for the server-side products, it is impossible to list all of them in a short abstract. However, just to tease you, here are some of the most exciting new features announced by Microsoft. Please note that Microsoft might change some of the features listed in this abstract for the SQL Server 2016 RTM version.


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


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


  • SSAS Tabular support for many-to-many relationships
  • DBCC and extended events for SSAS
  • Adding the SSISDB database to AlwaysOn
  • SSIS support for Power Query data sources
  • SSRS HTML 5 rendering engine
  • SSRS Tree Map and Sunburst Charts
  • Using Power Query and R in SSRS reports
  • MDS many-to-many relationships for derived hierarchies
  • Building MDS business rules in Excel
  • Using R in SQL Server Database Engine
Classroom Training

Dauer 4 Tage

Sprache der Kursunterlagen: englisch


Derzeit gibt es keine Trainingstermine für diesen Kurs.  Termin anfragen