SQL Server Reporting Services: Data Analysis Advanced Tutorial

SQL Server Reporting Services: Data Analysis Advanced Tutorial Exercise Files: Who it's for: This course introduces SQL Server users with Administrator access to SQL Server Reporting Services (SSRS). What it is: SQL Server Reporting Services (SSRS) is a comprehensive SQL Server-based tool used to create, test, and deploy a variety of reports. What you'll learn: Learn how SSRS tools can help you keep up with changing business requirements regarding information needed and how data is presented. We show you how to use data filters to present needed data to users, and report parameters that can enable users to filter the data when they run a report. We then move on to creating data visualizations in reports by using images and charts. Adding data bars, sparklines, indicators, and gauges to reports are some of the tools you can use for data visualization in SSRS. We’ll also use a dataset with spatial data to create a map report. Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content: For Private Group Trainings please visit: Join Offsite for our online community of teachers and peers: Manuals: Username: manuals Password: password Start 0:00 Introduction 0:03 Working with Reporting Services Data 1:28 Data Filters and Data Regions 2:19 Applying Report Filters in VS 4:55 Applying and Removing Report Filters in RB 7:38 Introduction to Report Parameters 8:43 Creating Parameters in RB 9:59 Adjusting and Testing Parameter Properties 15:25 Creating Parameters in VS 16:57 Working with Reporting Services Data Recap 21:48 Introduction to Visualizing Data with Report Services 22:47 Uploading Images to SSRS 23:51 Creating New Reports with Pie Charts in VS 24:52 Selecting Fields and Formatting Labels in Charts 28:02 Creating, Formatting, and Testing Two Parameters 34:43 Adding Page Headers to Display Parameter Values 39:49 Adjusting Parameter Placeholder Properties 42:53 Creating Website Hyperlinks in a Report 44:07 Adding Images to Reports 47:02 Reorganizing the Parameters Pane 49:34 Adding Two More Parameters to an Existing Report 50:58 Concatenating Wildcards into Parameter Definition 56:00 Displaying No Rows Message for No Results 58:15 Databars, Sparklines, Indicators, Gauges, and Maps 1:05:04 Inserting Data Bars into Table Reports 1:06:07 Inserting Sparklines into Table Reports 1:10:31 Inserting Indicators into Table Reports 1:13:49 Inserting Gauges into Table Reports 1:17:57 Creating Maps with Map Wizard 1:20:19 Adding Parameters to a Map Report 1:26:03 Introduction to Report Parts 1:32:01 Publishing Report Parts to the ReportServer 1:33:36 Viewing Report Parts Folder in SSRS 1:37:03 Adding Logos to Table Reports in RB 1:39:16 Visualizing Data with Report Services Recap 1:41:52 Conclusion 1:42:47 #sqlserver #ssrs #sqlservertutorial (C) 2023 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.