SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting, available at $34.99, has an average rating of 4.25, with 56 lectures, based on 70 reviews, and has 681 subscribers.

You will learn about Define a SQL Server Reporting Services data source in the Report Wizard Add a new column and change the column headers in a report Create new data fields for use in the report without changing the query or stored procedure Write queries that are specialized for drill-down reports, and create the drill-down report object Explore different parameter types in SQL Server Reporting Services Configure the parent report to support drill-through actions Write queries that are optimized for maps and add maps to your reports Write queries to utilize gauges, spark lines, and indicators in a report Deploy and secure reports on the web portal This course is ideal for individuals who are This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016. It is particularly useful for This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016.

Enroll now: SQL Server 2016 Database Reporting

Summary

Title: SQL Server 2016 Database Reporting

Price: $34.99

Average Rating: 4.25

Number of Lectures: 56

Number of Published Lectures: 56

Number of Curriculum Items: 56

Number of Published Curriculum Objects: 56

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Define a SQL Server Reporting Services data source in the Report Wizard

Add a new column and change the column headers in a report

Create new data fields for use in the report without changing the query or stored procedure

Write queries that are specialized for drill-down reports, and create the drill-down report object

Explore different parameter types in SQL Server Reporting Services

Configure the parent report to support drill-through actions

Write queries that are optimized for maps and add maps to your reports

Write queries to utilize gauges, spark lines, and indicators in a report

Deploy and secure reports on the web portal

Who Should Attend

This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016.

Target Audiences

This course is for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016.

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.

About The Author

Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida. He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received a B.A. in Physics from Hendrix College. Before joining UWF, he worked as a data warehouse developer for Northrop Grumman Information Systems and prior to that as a database application developer for Acxiom. Dr. Snider’s teaching and research interests include data mining, data warehousing, information visualization, and cyber security.

Course Curriculum

Chapter 1: Installation and setup

Lecture 1: The Course Overview

Lecture 2: Installing and Configuring SQL Server 2016 Developer Edition

Lecture 3: Installing SQL Server Management Studio

Lecture 4: Installing Visual Studio

Lecture 5: Installing SQL Server 2016 Data Tools

Lecture 6: Installing SQL Server Sample Databases

Lecture 7: SQL Server 2016 Reporting Services Configuration Manager

Chapter 2: Wizarding Your First Report

Lecture 1: Data Sources

Lecture 2: Report Queries

Lecture 3: Tabular Report Types and Their Configuration

Lecture 4: Matrix Report Types and Their configuration

Lecture 5: Deployment Location and Completing the Wizard

Chapter 3: Formatting a Tabular Report

Lecture 1: Adding a Column after the Wizard

Lecture 2: Formatting Column Headers

Lecture 3: Interactive Sorting

Lecture 4: Adding Calculated Fields and Using Expressions

Lecture 5: Formatting Cells

Lecture 6: Viewing the Report on the Report Server

Lecture 7: Formatting the Report for Printing

Chapter 4: Adding Headers and Footers

Lecture 1: Adding the Header and Footer

Lecture 2: Using Built-in Fields

Lecture 3: Adding Query-Defined Fields

Lecture 4: Adding Images to the header

Lecture 5: The Importance of Displaying Report Metadata on the Report

Chapter 5: Creating a Drill-Down Report

Lecture 1: Queries Specialized for Drill- Down Reports

Lecture 2: Creating the Drill- Down Report

Lecture 3: Grouping in SSRS

Lecture 4: Toggling the Display

Lecture 5: Adding Summary Rows

Chapter 6: Using Parameters in a Report

Lecture 1: Parameter Types

Lecture 2: Available and Default Values

Lecture 3: Filtering by the Parameter Value

Lecture 4: Displaying Parameter Values Within the Report

Chapter 7: Creating a Drill-Through Report

Lecture 1: Creating a Child Report

Lecture 2: Adding a Parameter to a Query

Lecture 3: Configuring the Drill-Through Reporting Action

Lecture 4: Deploying the Drill-Through Reports to the Report Server

Chapter 8: Baking Pie and Bar Charts

Lecture 1: Queries Optimized for Pie Charts and Bar Charts

Lecture 2: Creating the Pie Chart Report

Lecture 3: Creating the Bar Chart Report

Lecture 4: Formatting the Legends and Labels

Lecture 5: Placing Two Subreports Onto One Report

Chapter 9: Gauges, Sparklines, and Indicators

Lecture 1: Queries Optimized for Gauges, Sparklines, and Indicators

Lecture 2: Creating a Report Containing a Gauge

Lecture 3: Creating a Report Containing a Sparkline

Lecture 4: Creating a Report Containing an Indicator

Lecture 5: Creating a Dashboard

Chapter 10: Analytical Maps

Lecture 1: Queries Optimized for Analytical Maps

Lecture 2: Creating a Point Map

Lecture 3: Creating an Analytical Line Map

Lecture 4: Creating a Bubble Map

Lecture 5: Creating a Polygon Map

Chapter 11: The Reporting Services Web Portal

Lecture 1: Web Portal Folder Structure

Lecture 2: Deploying Reports to the Portal

Lecture 3: Securing Reports on the Portal

Lecture 4: Web Portal Functionality

Instructors

Packt Publishing
Tech Knowledge in Motion

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 9 votes

4 stars: 32 votes

5 stars: 28 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!