SQL Server: Reporting Services

سرفصل های دوره

Get an introduction to Reporting Services, one of the core add-on components to SQL Server. With Reporting Services, you can create report frameworks that incorporate data tables, charts, maps, and other visualizations to help make sense of the data stored in a database. Instructor Adam Wilbert shows you how to configure all of the components and add them to traditional paginated reports, and how to organize those reports on a centralized web portal.

01 - Introduction

01 - Present SQL data with Reporting Services

02 - What you should know

02 - 1. Get Started with SSRS

01 - What is SQL Server Reporting Services (SSRS)

02 - Installing SSRS

03 - Install a SQL Server instance for the report server

04 - Configure the report server

05 - Set up the example database

06 - Access the web portal

07 - Install Report Builder

03 - 2. Build Your First Report

01 - Components of a report

02 - Create a report data source

03 - Create a dataset

04 - Add a data table with the wizard

05 - Joining data tables

06 - Format a report

07 - Reviewing report properties

08 - View, print, and export a report

04 - 3. Work with Data

01 - Create a shared data source

02 - Create a shared dataset

03 - Filtering data

04 - Grouping data in a report

05 - Understand matrixes

06 - Use aggregate functions

05 - 4. Build Interactive Reports

01 - Convert filters into parameters

02 - Report parameter properties

03 - Make a dynamic report title

04 - Add a parameter manually

05 - Report actions

06 - Sort records in a table

06 - 5. Create Charts

01 - Introduction to charts

02 - Create a chart

03 - Add additional data series

04 - Format charts

07 - 6. Additional Data Visualizations

01 - Gauges

02 - Indicators

03 - Data bars

04 - Create a sparkline dataset

05 - Display a sparkline

06 - Maps

08 - 7. Improve the Presentation

01 - Include header and footer details

02 - Add graphics and logos

03 - Align page elements

04 - Insert page breaks

09 - 8. Build a Web Portal Dashboard

01 - Add a key performance indicator (KPI)

02 - Create a dynamic KPI

03 - Organize the web portal with folders

04 - Customize the web portal branding

05 - Create an SSRS user account

06 - Subscribe to a report

07 - Save report snapshots with historical data

10 - Conclusion

01 - Next steps

189,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)