Skip Main Navigation
Page Content
This event has ended

Save This Event

Event Saved

Microsoft Reporting & Analytics by Ted Stathakis (#SQLSatLA)

SQL Saturday in LA

Friday, June 14, 2019 from 8:30 AM to 4:30 PM (PDT)

Microsoft Reporting & Analytics by Ted Stathakis...

Ticket Information

Ticket Type Sales End Price Fee Quantity
Regular Price   more info Ended $149.00 $6.81

Share Microsoft Reporting & Analytics by Ted Stathakis (#SQLSatLA)

Event Details

Microsoft Reporting and Analytics by Ted Stathakis

Come join Ted Stathakis, a seasoned veteran of SQL Server Reporting Services, for a full day deep dive into SQL Server Reporting Services and Power BI. The day will start with a brief look some SSRS examples and take you through building and deploying reports, complete with a discussion of requirements gathering, user acceptance testing and using source control. The class will be using SQL Server 2016 but is applicable to older versions (with exception of new features such as Mobile Reports and KPIs) and newer versions. You will leave with numerous tips that you can put into place immediately and learn valuable lessons on report creation and management. The afternoon portion of the class will highlight using Power BI Desktop and Service to create reports for your organization’s analytical reporting needs.

About Ted

Ted has been using SSRS since its release in 2004 and has been teaching technology classes at regional and national conferences since 2014.  You can see a comprehensive list of past and upcoming classes on his blog at and learn more about his work history on LinkedIn.

Course Outline:

  1. Installation, Configuration & Presentation
    • Feature of SQL, Configuration Manager
    • Report Manager Portal
    • Presentation Alternatives
  2. Reporting Examples
    • Various Report Examples & an SSRS Dashboard Demo
  3. Report Creation
    • Visual Studio Data Tools & Report Builder
    • Shared Date Sources & Data Sets
    • Tables, Tablix and Charts
    • Mobile Report Publisher & KPIs
    • Using Templates
  4. Linked Reports
    • Pros & Cons
    • Creation & Maintenance
    • Security Considerations
  5. Advanced Reporting
    • Dashboards in SSRS
    • Drill Through Reports
    • Embedded Sub Reports
    • Exporting and Printing
    • Scheduling
  6. Fish Head Ted Footer
    • Custom footer full of report meta data and stats
  7. Publishing
    • Solutions & Configuration Manager
    • Folder Hierarchy Considerations
    • Report Portal & Alternatives
    • Report Portal Branding
    • Source Control
  8. Migration
    • Leveraging the ReportServer Database, Logging Settings
  9. End User Interaction
    • Requirements Gathering
    • Scope of Work & Documentation
    • Mock Ups
    • Rapid Prototyping
    • User Acceptance Testing
  10. Power BI
    • When to use Power BI as opposed to Reporting Services
    • Data Sources and ETL
    • Report Design fundamentals and considerations
    • Deployment and Security considerations

The event DOES include Coffee, Lunch and Afternoon Snacks & Refreshments.

This event DOES NOT include a parking fee of $20.

Brought to you by

Register to attend 2019 SQL Saturday in Los Angeles

Have questions about Microsoft Reporting & Analytics by Ted Stathakis (#SQLSatLA)? Contact SQL Saturday in LA
Attendee List Sort by: Date | First Name
Show More

When & Where

Loyola Marymount University (LMU) in Playa Vista
1 LMU Drive
Malone Student Center - 4th floor, room #460
Los Angeles, CA 90045

Friday, June 14, 2019 from 8:30 AM to 4:30 PM (PDT)

  Add to my calendar

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.