Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

Microsoft SQL Server Reporting Services (SSRS)

In SQL Server Reporting Services (SSRS) - Analyzing Data training course, you will learn to implement a SQL Server Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

In SQL Server Reporting Services (SSRS) - Report Development training course, you will learn to filter and summarize data, develop and customize tabular, matrix, chart and free-form business reports, deploy them to a Report Server and SharePoint, and automate report delivery by email.

By attending SQL Server Reporting Services (SSRS) - Analyzing Data workshop, delegates will learn to:

  • Describe reporting services and it's components
  • Describe reporting services data sources
  • Implement paginated reports
  • Work with reporting services data
  • Visualize data with reporting services
  • Aggregate report data
  • Share reporting services reports
  • Administer reporting services
  • Expand and integrate reporting services
  • Describe mobile reports
  • Develop mobile reports

By attending SQL Server Reporting Services (SSRS) - Report Development workshop, delegates will learn to:

  • Create simple reports from relational data sources
  • Leverage SQL Server Data Tools to build tabular reports
  • Filter reports with parameters
  • Summarize reports by implementing grouping and drill-down

For SQL Server Reporting Services (SSRS) - Analyzing Data

  • Attend a training on Transact-SQL or having equivalent knowledge

For SQL Server Reporting Services (SSRS) - Report Development

  • Basic understanding of relational database systems like SQL Server, Access, Oracle, or DB2

COURSE AGENDA

Microsoft SQL Server Reporting Services (SSRS) - Analyzing Data
(Duration : 5 Days)

1

Introduction to Reporting Services

  • Introduction to reporting services
  • Reporting services components
  • Reporting service tools
2

Reporting Services Data Sources

  • Data sources
  • Connection strings
  • Datasets
3

Creating Paginated Reports

  • Creating a report with the report wizard
  • Creating a report
  • Publishing a report
4

Working with Report Services Data

  • Data Filters
  • Report parameters
  • Implementing report filters and parameters
5

Visualization Data Report Services

  • Formatting data
  • Images and charts
  • Databars, sparklines, indicators, gauges, and maps
6

Summarizing Report Data

  • Sorting and grouping
  • Report sub-reports
  • Drilldown and drill through
7

Sharing Reporting Services Reports

on-list chevron-right">
  • Schedules
  • Report caching, snapshots, and comments
  • Report subscription and delivery
  • 8

    Administering Reporting Services

    • Administering reporting services
    • Reporting services configuration
    • Reporting services performance
    9

    Extending and Integrating Reporting Services

    • Expressions and embedded code
    • Extending reporting services
    • Integrating reporting services
    10

    Introduction to Mobile Reports

    • Overview of mobile reports
    • Preparing data for mobile reports
    • Mobile report publisher
    11

    Developing Mobile Reports

    • Designing and publishing mobile reports
    • Drillthrough in mobile reports
    Microsoft SQL Server Reporting Services (SSRS) - Report Development
    (Duration : 1 Day)

    1

    Retrieving data from a relational database with dataset queries

    2

    Building tabular reports

    3

    Customizing reports with built-in fields

    4

    Enhancing user experience with drill-down

    5

    Delivering reports by e-mail subscription

    Encarta Labs Advantage

    • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
    • All courses are delivered by Industry Veterans
    • Get jumpstarted from newbie to production ready in a matter of few days
    • Trained more than 50,000 Corporate executives across the Globe
    • All our trainings are conducted in workshop mode with more focus on hands-on sessions

    View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

    Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

    Top