SSRS Introduction

Course ID: CLBIRS018

Introduction to SQL Server Reporting Services

  • Identifying deployment: native, integrated or single server
  • Managing web farm deployment with/without SharePoint

[accordion_item in="false" id_parent="faq" title="Developing Reports"]

  • Leveraging Reporting Services tools
    • Web reporting using Power View
    • Accessing the power of Visual Studio
  • Designing fundamental reports
    • Connecting to relational and multidimensional sources
    • Generating a Tablix reporting structure
  • Composing expressions
    • Computing custom fields
    • Linking expressions to properties
  • Arranging and sorting data
    • Multiple-level grouping and categorizing the results
    • Applying aggregate functions
  • Producing various outputs from a Tablix
    • Creating parallel dynamic group report formats
    • Combining dynamic and static columns
    • [/accordion_item]
      [accordion_item in="false" id_parent="faq" title="Integrating Parameters and Filters"]

      • Incorporating parameters into reports
        • Yielding subsets of data with query parameters
        • Constructing cascading report parameters
        • Transmitting parameters to stored procedures
      • Applying filters to report data
        • Augmenting performance with filters
        • Determining filters vs. query parameters
          [accordion_item in="false" id_parent="faq" title="Implementing Interactive Features"]

          • Combining multiple data regions in one report
            • Applying sequential and nested regions
            • Creating master/detail reports and linking sub reports
          • Showing robust data with relevant detail
            • Drilling through report detail and drilling down
            • Navigating reports with document maps

          [accordion_item in="false" id_parent="faq" title="Deploying and Delivering Reports"]

          • Deploying reports to the server
            • Publishing reports and configuring project properties
            • Verifying results with Report Manager
          • Identifying delivery options
            • Enhancing performance with cached instances
            • Configuring snapshot history
          • Dispatching subscription reports
            • Publishing reports via email and file share
            • Seamlessly delivering reports by data-driven subscriptions
          • Integrating reports with SharePoint
            • Deploying reports to SharePoint
            • Viewing results in Report Center and Data Connections

          [accordion_item in="false" id_parent="faq" title="Safeguarding Reporting Services"]

          • Structuring content security
            • Leveraging existing Windows authentication
            • Establishing permission levels on report items
          • Ensuring the RS system
            • Instituting varying levels of administrative roles
            • Granting and revoking system-level permissions

          [accordion_item in="true" id_parent="faq" title="Extended Reporting and Data Visualization"]

          • Creating reports on Analysis Services cubes
            • Exploiting cubes as intuitive data sources for nontechnical and power users
            • Generating parameterized reports with MDX Builder
          • Designing reports for data visualization
            • Improving data visualization with sparklines,data bars, maps and indicators
            • Implementing Key Performance Indicators (KPIs)
          • Delivering reports to users
            • Improving data visualization with sparklines,data bars, maps and indicators
            • Implementing Key Performance Indicators (KPIs)
          • Delivering reports to users
            • Accessing and controlling reports using URLs
            • Embedding reports in applications with the Report Viewer
            • Delivering reports through SharePoint

          [accordion_item in="false" id_parent="faq" title="What is this course about?"]
          SQL Server Reporting Services augments the ability of SQL Server, and other relational database management systems, to seamlessly deliver reports to customers, partners, suppliers and employees across the enterprise. In this course, you gain the knowledge required to author reports to extract business intelligence out of your data, deploy reports to a Report Server for centralized access and administration, and and share reports throughout the organization by deploying to SharePoint. A series of extensive hands-on exercises help you acquire the skills to exploit the full power of Reporting Services, and teaches you how to go beyond the physical limitations of your organization to deliver data and share information with others; when you want and how you want.
          [accordion_item in="false" id_parent="faq" title="Who will benefit from this course?"]
          This course is valuable for database developers, data analysts, application developers, administrators, managers, and anyone responsible for designing, creating or using reports. Those who need to understand Reporting Services, or plan to employ Reporting Services within their organization, will also greatly benefit.
          [accordion_item in="false" id_parent="faq" title="What background do I need?"]
          It is assumed that you have a working database knowledge (i.e., SQL statements, relational model concepts) at the level of Course 2107, SQL ServerĀ® 2012 Introduction: Hands-On, or equivalent experience on other relational database management systems such as Access or Oracle. A basic understanding of the Windows environment is assumed. Visual Studio knowledge and a fundamental programming background are helpful, but not required.
          [accordion_item in="false" id_parent="faq" title="What types of upgrades from earlier versions of SQL Server Reporting Services will I see in this course?"]
          This course introduces enhanced reporting features. You learn how to build a Tablix, an interactive report, which is a blending of a table and a matrix. You also learn how to create charts and gauge data regions.
          [accordion_item in="false" id_parent="faq" title="I am currently using a database other than SQL Server. Will this course benefit me?"]
          Yes! While SQL Server is the database used on the course, you will find that the material in this course is applicable to any OLE DB-compliant relational database management system (RDBMS), such as Access or Oracle. One of the primary advantages of SQL Server Reporting Services is that it supports any RDBMS.
          [accordion_item in="false" id_parent="faq" title="My organization uses multidimensional cubes to analyze data. Why do I need Reporting Services?"]
          SQL Server Reporting Services provides a centralized server-based solution with deployment options such as subscription-based delivery of reports, centralized management, enhanced security and snapshots, that exceed the feature set of Access. This course has a hands-on exercise that will show you how to create reports that are based on an Analysis Services cube.
          [accordion_item in="false" id_parent="faq" title="I'm a manager, will this course be too technical for me?"]
          Although there are strong technical elements of this course, as a manager, the more you understand about the capabilities and advantages of Reporting Services, the better you will be able to work with your team on an effective product implementation.
          [accordion_item in="false" id_parent="faq" title="I'm not a programmer. How much programming is done on this course?"]
          There is no programming on the course. However, the ability to write VB expressions would be beneficial. Learning Tree has been a pioneer in the application of “Active Learning” techniques, featuring paired hands-on exercises and group activities. This ensures that, even if you have basic programming skills, you can be teamed with a fellow course participant whose skills are stronger. With this method you can learn, not only from your instructor, but from the experience of other participants.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>