- 0
- 3-4 hours worth of material
- LinkedIn Learning
- English
Course Overview
Discover how to build, edit, and publish interactive reports using Reporting Services in SQL Server.
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.
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.
Course Circullum
Introduction
- Present SQL data with Reporting Services
- What you should know
- Set up the example database
- What is SQL Server Reporting Services (SSRS)?
- Install SSRS
- Configure the report server
- Access the web portal
- Install Report Builder
- Components of a report
- Create a report data source
- Create a dataset
- Add a data table with the wizard
- Joining data tables
- Format a report
- Reviewing report properties
- View, print, and export a report
- Create a shared data source
- Create a shared dataset
- Filtering data
- Grouping data in a report
- Understand matrixes
- Use aggregate functions
- Convert filters into parameters
- Report parameter properties
- Make a dynamic report title
- Add a parameter manually
- Report actions
- Sort records in a table
- Introduction to charts
- Create a chart
- Add additional data series
- Format charts
- Gauges
- Indicators
- Data bars
- Create a sparkline dataset
- Display a sparkline
- Maps
- Include header and footer details
- Add graphics and logos
- Align page elements
- Insert page breaks
- Add a key performance indicator (KPI)
- Create a dynamic KPI
- Organize the web portal with folders
- Customize the web portal branding
- What is Mobile Report Publisher?
- Tour Mobile Report Publisher
- Exploring visuals and themes
- Connect visuals to data
- Add a time chart
- Create device-specific layouts
- View reports in the Power BI mobile app
- Reuse report parts
- Subscribe to a report
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Present SQL data with Reporting Services
- What you should know
- Set up the example database
- What is SQL Server Reporting Services (SSRS)?
- Install SSRS
- Configure the report server
- Access the web portal
- Install Report Builder
- Components of a report
- Create a report data source
- Create a dataset
- Add a data table with the wizard
- Joining data tables
- Format a report
- Reviewing report properties
- View, print, and export a report
- Create a shared data source
- Create a shared dataset
- Filtering data
- Grouping data in a report
- Understand matrixes
- Use aggregate functions
- Convert filters into parameters
- Report parameter properties
- Make a dynamic report title
- Add a parameter manually
- Report actions
- Sort records in a table
- Introduction to charts
- Create a chart
- Add additional data series
- Format charts
- Gauges
- Indicators
- Data bars
- Create a sparkline dataset
- Display a sparkline
- Maps
- Include header and footer details
- Add graphics and logos
- Align page elements
- Insert page breaks
- Add a key performance indicator (KPI)
- Create a dynamic KPI
- Organize the web portal with folders
- Customize the web portal branding
- What is Mobile Report Publisher?
- Tour Mobile Report Publisher
- Exploring visuals and themes
- Connect visuals to data
- Add a time chart
- Create device-specific layouts
- View reports in the Power BI mobile app
- Reuse report parts
- Subscribe to a report
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:3-4 hours worth of material
- Language CC: