Study Learn Grow
SQL Server 2016 Database Reporting

SQL Server 2016 Database Reporting

Create impressive reports from your SQL Server data.


Create impressive reports from your SQL Server data.

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 Information

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

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 for BI consultants or developers who are interested in using the reporting capabilities of SQL Server 2016.

• Lifetime Access to Each Course
• Certificate on Completion of Course
• No Extra Charges Or Admin Fees
• Easy Access to Courses
• High Priority Support After Sales.
• Big Discounts on Individual Courses

Course Specifications

IT and Computing courses are available to study on our learning platform. 

See All Courses

Adult education is the non-credential activity of gaining skills and improved education. 

See All Courses

Online education is electronically supported learning that relies on the Internet for teacher/student interaction. 

See All Courses

A short course is a learning programme that gives you combined content or specific skills training in a short period of time. Short courses often lean towards the more practical side of things and have less theory than a university course – this gives you a more hands-on experience within your field of interest.

See All Courses

Course duration is 24 hours.

See All Courses

Study Learn Grow

Related Jobs