Session Abstracts

Here are the current abstracts for this event's available sessions.
Title
Speaker
  • Architecture of SSRS
    Sherri McDonald
    In this session Sherri reviews the Architecture of Reporting Services and highlights what some of the new 2008 and 2008R2 features are. The topic of data warehousing is covered so you understand the importance of it in respect to Reporting Services. You will also learn how to navigate your way around BIDS (Business Intelligence Development Studio) and how to build queries using the Query Designer. Once the query is constructed, you’ll learn how to build your first reports using the Report Wizard with the toolbox items Matrix and Table. Learn how to group your data in the hierarchy it was meant to be in as well as how to format and sum your results.

    Session Length: 1 hour, 47 minutes
  • Reports with Parameters
    Sherri McDonald
    In this session you will learn how to create reports that have Parameters as well as Cascading Parameters. This will allow the end user to decide what results gets displayed in the report. You will also learn where all the XML code is stored for the reports that you are building.

    Session Length: 24 minutes
  • Parameter Values
    Sherri McDonald
    In this session you will also learn how to set Available and Default values for your parameters. You will also learn how to create a query in BIDS that gives you a Drop Down list to allow Multiple Values to be present in your Report. Do you want to take that same query and create Stored Procedure with it? Learn how to do that with a Split Function. Need to know how to sort your columns if they are in Groups? You will get to build a report from scratch and learn how to use the Interactive Sorting options.

    Session Length: 52 minutes
  • Using Variables to Create Visually Dynamic Reports
    Sherri McDonald
    In this session you will learn how to create expressions, Variables and VB code to so your reports are visually dynamic for your end users. For example if you want to alternate your row colors, flag a column if goals are being met or not and learn how to set variables to be used through your report.

    Session Length: 44 minutes
  • MDX and DMX Reporting Tools
    Sherri McDonald
    In this session you will learn how to deploy your Sql Server Analysis Services database (SSAS) and write reports off of it using MDX and stored procedures as well as using DMX for Predictive Analytics. Don’t worry if you don’t know those querying languages because we’ll show you how to use the Query Designer to get the results you need.

    Session Length: 44 minutes
  • Dashboard Designs
    Sherri McDonald
    In this session we cover dashboard designs do’s and don’ts. Do you have SSRS 2008R2? Learn how create reports using the Map object add a hidden table with the Data Bar (R2) that can be viewed by toggling on other items. You will also be able to create reports with Multi-Series axis with different charts overlapping.

    Session Length: 40 minutes
  • Reporting Services Configuration Manager
    Sherri McDonald
    In this session we will learn how to navigate our way around Reporting Services Configuration Manager to get an understanding of what our options are for configurations. We will also be discussing how you access the Report Manager and understanding the Role Assignments for the Users of Report Manager. We are also going to take a look with us on how to set up security in Report Manager for individual reports and the project folder level.

    Session Length: 22 minutes
  • BIDS and the Report Manager
    Sherri McDonald
    In this session we will learn how to configure our Solution in BIDS in order to deploy our reports to the Report Manager. We’ll also talk about deployment of reports to SharePoint at a high level. If you want to set up subscriptions follow along to see how handle the set up of Sql Authenticated accounts. Take a look with us on how to set up email, file share and data driven subscriptions.

    Session Length: 44 minutes
  • Reporting Tools
    Sherri McDonald
    In this session we learn how to deploy individual report parts from the reports we’ve created in BIDS, create report models and develop reports with Report Builder 3.0. Have R2, take that report you created with Report Builder 3.0 and add a report part to it from the Report Parts Gallery.

    Session Length: 25 minutes
  • Report Lab #1
    Sherri McDonald
    In this session you will take one of the many labs that are provided in addition to the classroom instructional video and build it together. This report is meant for the student of this video who has gone through all sessions to apply what they have learned by creating a nice dashboard report.

    Session Length: 25 minutes
  • Report Lab #2
    Sherri McDonald
    In this session we will be building a report with two data sets using the R2 feature, Map, Map Layers and Spatial Data. Learn how to use the Bubble Map option, Parameter and alter the properties that are available in the Map.

    Session Length: 12 minutes
Panel Bottom