Creating Reports with SQL Server 2012 Reporting Services

Creating Reports with SQL Server 2012 Reporting Services , available at $34.99, has an average rating of 3.9, with 39 lectures, based on 135 reviews, and has 819 subscribers.

You will learn about Utilize the Report Wizard to quickly get a report started Format data in tables and matrices Add interactive sorting and high-impact visualizations such as pie charts, gauges, and bar graphs Build expressions and implement built-in variables Create drill-down and drill-through reports Maximize report flexibility through the use of parameters Combine report objects to create a dashboard This course is ideal for individuals who are Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting. It is particularly useful for Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting.

Enroll now: Creating Reports with SQL Server 2012 Reporting Services

Summary

Title: Creating Reports with SQL Server 2012 Reporting Services

Price: $34.99

Average Rating: 3.9

Number of Lectures: 39

Number of Published Lectures: 39

Number of Curriculum Items: 39

Number of Published Curriculum Objects: 39

Original Price: $74.99

Quality Status: approved

Status: Live

What You Will Learn

Utilize the Report Wizard to quickly get a report started

Format data in tables and matrices

Add interactive sorting and high-impact visualizations such as pie charts, gauges, and bar graphs

Build expressions and implement built-in variables

Create drill-down and drill-through reports

Maximize report flexibility through the use of parameters

Combine report objects to create a dashboard

Who Should Attend

Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting.

Target Audiences

Creating Reports with SQL Server 2012 Reporting Services is designed for those who have a working knowledge of SQL and who need to deliver business intelligence via impressive, interactive reports. You will need a version of SQL Server 2012 that includes the SQL Server Data Tools. This thorough course requires basic experience with SQL Server and reporting.

Creating Reports with SQL Server 2012 Reporting Serviceswill show you how to develop practical reports that utilize tables and matrices, along with bold objects such as pie charts and gauges that quickly gain the attention of the viewer and deliver your message. With this course, you can acquire the essential skills you need to make an impression on your customers, your audience, or your boss.

About the Author

Dr. Dallas Snideris an Assistant Professor in the Computer Science Department at the University of West Florida (UWF). He received his Ph.D. in Integrated Computing and M.S. in Instrumental Sciences from the University of Arkansas at Little Rock. He received his B.A. in Physics from Hendrix College in Conway, Arkansas. 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 and Euronet. Dr. Sniders research and teaching interests include data mining, data warehousing, software development, and security.

Course Curriculum

Chapter 1: The Report Wizard

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 2: Creating a Tabular Report

Lecture 1: Formatting Column Headers

Lecture 2: Interactive Sorting

Lecture 3: Adding Calculated Fields and Using Expressions

Lecture 4: Formatting Cells

Lecture 5: Viewing the Report on the Report Server

Lecture 6: Formatting the Report for Printing

Chapter 3: Formatting of Report Headers and Footers

Lecture 1: Adding the Header and Footer

Lecture 2: Using the 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 4: Creating a Drilldown Report

Lecture 1: Queries Specialized for Drilldown Report

Lecture 2: Creating the Drilldown Report

Lecture 3: Grouping in SSRS

Lecture 4: Toggling the Display

Lecture 5: Adding Summary Rows

Chapter 5: 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 6: Creating a Drillthrough Report

Lecture 1: Creating a Drillthrough Report

Lecture 2: Adding a Parameter to a Query

Lecture 3: Configuring the Drillthrough Reporting Action

Lecture 4: Deploying the Drillthrough Reports to the Report Server

Chapter 7: Creating 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 8: Utilizing 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

Instructors

Packt Publishing
Tech Knowledge in Motion

Rating Distribution

1 stars: 0 votes

2 stars: 6 votes

3 stars: 19 votes

4 stars: 64 votes

5 stars: 46 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!