SQL Server Reporting Services - Data Analysis Master Tutorial

Overview

Master SQL Server Reporting Services (SSRS) for advanced data analysis in this comprehensive tutorial. Learn to extend report services using expressions, embedded code, and custom assemblies. Create a Class Library project for Visual Basic code and save Report Templates with embedded code. Explore mobile report design and publication for smartphones and tablets. Discover various element types for SSRS mobile reports, and learn to design, create, test, and publish them. Access reports through the web portal and Power BI app. Gain hands-on experience with time charts, number gauges, time navigators, and chart data grids. Write queries, create KPIs, and investigate query results for pertinent fields. Perfect for SQL Server users with Administrator access looking to enhance their SSRS skills.

Syllabus

Start
Introduction
Introduction to Extending Reporting Services
Expressions and Embedded Code Overview
Creating Expressions to Determine Colors
Creating Expressions Using Global Fields
Embedding Code in a Report
Creating a Class Library Project
Creating Function Procedures in VB Using Code Editor Help
Reviewing the Function Procedure
Copying Code from Class Library to Report Properties
Saving Blank Reports with Embedded Code as a Template
Using Templates with Embedded Code to Create New Reports
Custom Assemblies Overview
Modifying Functions to Public and Shared
Adding CS Projects to the Solution
Pasting DLL Files Into Directories
Testing a Custom Assembly
Extending Reporting Services Recap
Organizing in SSRS
Software Requirements for Mobile Reports
Introduction to Mobile Reports
Creating a Dataset for Mobile Reports
Creating Datasets for Mobile with Data by Year
Touring the Mobile Report Publisher Interface
Launching and Verifying Mobile Report Publisher from SSRS
Adding Time Charts to the Design Grid
Connecting to Mobile Datasets and Viewing Data
Changing Time Chart Visualization and Data Properties
Adding and Adjusting Number Gauges
Adding and Adjusting Time Navigators
Adding and Adjusting Chart Data Grids
Setting Chart Data Grids to Respond to the Time Navigator
Applying and Designing Palletes in the Mobile Report
Saving the Report to the Report Server
Viewing a Mobile Report in the SSRS Web Portal
Writing Queries to See All Table Fields in SSMS
Investigating Query Results for Pertinent Fields
Writing the KPI Query
Creating a KPI in SSRS
Viewing KPI Related Content in the Web Portal
Accessing KPIs and Mobile Reports from Power BI Mobile App
Mobile Reports Recap
Conclusion