SQL Server: Reporting Services

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

Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server. In this course, author Adam Wilbert shows how to create, format, and share reports that leverage a variety of data sources. First, he takes you through the setup process, followed by the step-by-step process of building a report. He covers interactive elements, formatting, charts, sorting, filtering, web viewing, and mobile viewing. Adam also shares best practices, tips, and tricks that you can use to ensure your reports are dynamic.

01 - Introduction

01 - Present SQL data with Reporting Services

02 - What you should know

03 - Set up the example database

02 - 1. Get Started with SSRS

01 - What is SQL Server Reporting Services (SSRS)

02 - Install SSRS

03 - Configure the report server

04 - Access the web portal

05 - Install Report Builder

03 - 2. Build a 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

10 - 9. Mobile Report Publisher

01 - What is Mobile Report Publisher

02 - Tour Mobile Report Publisher

03 - Exploring visuals and themes

04 - Connect visuals to data

05 - Add a time chart

06 - Create device-specific layouts

07 - View reports in the Power BI mobile app

11 - 10. SSRS Tips and Tricks

01 - Reuse report parts

02 - Subscribe to a report

12 - Conclusion

01 - Next steps

439,000 تومان

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

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

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

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