SQL Server 2016 Database Reporting

Video description

Create impressive reports from your SQL Server data

About This Video

Utilize graphical report elements in the SQL Server 2016 Reporting Services developer toolbox

Write SQL Server queries that are optimized for specific report types

Learn advanced concepts such as drill-through reports and analytical maps

In Detail

With SQL Server 2016 Reporting Services, users are excited about being able to visualize their data in new, creative ways for use in …

SQL Server 2016 Database Reporting

Video description

Create impressive reports from your SQL Server data

About This Video

Utilize graphical report elements in the SQL Server 2016 Reporting Services developer toolbox

Write SQL Server queries that are optimized for specific report types

Learn advanced concepts such as drill-through reports and analytical maps

In Detail

With SQL Server 2016 Reporting Services, users are excited about being able to visualize their data in new, creative ways for use in presentations, analysis, and decision support—even on mobile devices.

In this course, users will receive step-by-step instructions on how to create stunning, high-impact reports. The course starts with an introduction to the technologies employed. Next, users are shown how to create a basic report and then how to format it and add features (such as headers and footers) to make it more readable, impressive, and practical. The course teaches how to create drill-down and drill-through reports. Pie charts, gauges. and maps are next on the agenda and the course wraps up with lessons on how to assemble a dashboard on the SQL Server Reporting Services web portal. This course will empower you to overcome any obstacle while creating interactive, visually-appealing reports using SQL Server 2016 Reporting Services.

Audience

This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016. Previous experience with SSRS would be useful, but is not mandatory. A basic working knowledge of SQL Server is required to get the most out of this course.

Publisher resources

Download Example Code

Chapter 1 : Installation and setup

The Course Overview

Installing and Configuring SQL Server 2016 Developer Edition

Installing SQL Server Management Studio

Installing Visual Studio

Installing SQL Server 2016 Data Tools

Installing SQL Server Sample Databases

SQL Server 2016 Reporting Services Configuration Manager

Chapter 2 : Wizarding Your First Report

Data Sources

Report Queries

Tabular Report Types and Their Configuration

Matrix Report Types and Their configuration

Deployment Location and Completing the Wizard

Chapter 3 : Formatting a Tabular Report

Adding a Column after the Wizard

Formatting Column Headers

Interactive Sorting

Adding Calculated Fields and Using Expressions

Formatting Cells

Viewing the Report on the Report Server

Formatting the Report for Printing

Chapter 4 : Adding Headers and Footers

Adding the Header and Footer

Using Built-in Fields

Adding Query-Defined Fields

Adding Images to the header

The Importance of Displaying Report Metadata on the Report

Chapter 5 : Creating a Drill-Down Report

Queries Specialized for Drill- Down Reports

Creating the Drill- Down Report

Grouping in SSRS

Toggling the Display

Adding Summary Rows

Chapter 6 : Using Parameters in a Report

Parameter Types

Available and Default Values

Filtering by the Parameter Value

Displaying Parameter Values Within the Report

Chapter 7 : Creating a Drill-Through Report

Creating a Child Report

Adding a Parameter to a Query

Configuring the Drill-Through Reporting Action

Deploying the Drill-Through Reports to the Report Server

Chapter 8 : Baking Pie and Bar Charts

Queries Optimized for Pie Charts and Bar Charts

Creating the Pie Chart Report

Creating the Bar Chart Report

Formatting the Legends and Labels

Placing Two Subreports Onto One Report

Chapter 9 : Gauges, Sparklines, and Indicators

Queries Optimized for Gauges, Sparklines, and Indicators

Creating a Report Containing a Gauge

Creating a Report Containing a Sparkline

Creating a Report Containing an Indicator

Creating a Dashboard

Chapter 10 : Analytical Maps

Queries Optimized for Analytical Maps

Creating a Point Map

Creating an Analytical Line Map

Creating a Bubble Map

Creating a Polygon Map

Chapter 11 : The Reporting Services Web Portal

Web Portal Folder Structure

Deploying Reports to the Portal

Securing Reports on the Portal

Web Portal Functionality

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.