safety driven performance conference 2013 capstone rbmi spotlight: report server 2008 r2 chand...
TRANSCRIPT
Safety Driven Performance Conference 2013
Capstone RBMI spotlight: Report Server 2008 R2
Chand Paruchuri, MBA PMP
Sr. Software Quality Assurance Specialist
Jeff Popp
IS Consulting Manager
Lloyd’s Register Technical Services Inc.
10/10/2013
Safety Driven Performance Conference 2013
Safety Moment
Emergency evacuation plan•Whenever you hear the alarm sound, LEAVE IMMEDIATELY! Always assume it is real until you are told otherwise by the proper authorities. •Use stairways, NOT elevators! •Do not enter in to evacuated place until it was instructed to do so by proper authorities.
Safety Driven Performance Conference 2013
Agenda
• Introduction• Significance of Key Performance Indicator (KPI) Reports• Different KPIs in Capstone RBMI• New features in SQL Server Reporting Services (SSRS) 2008 R2
upgrade • What’s New in SSRS 2008 R2 upgrade & Demonstration
• Introduction of Report Builder (Jeff)• Demonstration of Report Builder (Jeff)
• Q & A (Chand, Jeff and LR Team)• Contact information
Safety Driven Performance Conference 2013
Significance of Key Performance Indicator (KPI) Reports• Information sharing• Provides better visibility• Can be used for Decision making
Safety Driven Performance Conference 2013
Different KPIs in Capstone RBMI (1 of 4 slides)
Total of 33 reports in Lagging & Leading categories
Lagging (12): Definition of ‘Lagging’: ‘To fail to keep up a pace’
Asset Remaining life Based on NDE Only
Assets Near Failure - Fractional Wall Loss
Closed NCR's by Criticality
Closed NCR's by Rank
Individual Criticality Report
Individual Criticality Report - Multiple Plants
Inspections Due
Inspections Due - No Date
NCR And Reportable Leaks
Near Failures
Relief Devices Out Of Tolerance
Thickness Data Half-Life
Safety Driven Performance Conference 2013
Different KPIs in Capstone RBMI (2 of 4 slides)
Total of 33 reports in Lagging & Leading categories
Leading (21): Definition of ‘Leading’: ‘Work to be performed in future’
Inspections (13)
Overdue Tasks (7)
Overdue Tasks by Age
Overdue Tasks by Age with Cost
Overdue Tasks by Criticality
Overdue Tasks by Criticality with Cost
Overdue Tasks by Priority
Overdue Tasks by Priority with Cost
Overdue Tasks by Unacceptable Risk
Safety Driven Performance Conference 2013
Different KPIs in Capstone RBMI (3 of 4 slides)
Total of 33 reports in Lagging & Leading categories
Leading (21)
Inspections (13)
Scheduled Tasks (6)
Scheduled Tasks by Age
Scheduled Tasks by Age with Cost
Scheduled Tasks by Criticality
Scheduled Tasks by Criticality with Cost
Scheduled Tasks by Priority
Scheduled Tasks by Priority with Cost
Safety Driven Performance Conference 2013
Different KPIs in Capstone RBMI (4 of 4 slides)
Total of 33 reports in Lagging & Leading categories
Leading (21)
Overdue Tasks Ratio
Overdue Tasks Ratio by Unacceptable Risk
NCR's (4)
Overdue NCR's by Age
Overdue NCR's by Criticality
Overdue NCR's by Rank
Overdue NCR's by Ratio
Risk (1)
Unacceptable Risks
Shutdown And Planning Report
Safety Driven Performance Conference 2013
New features in SSRS 2008 R2 upgrade
• Report Builder 3.0 is much powerful which include features such as
Shared datasets, Collaboration, Data visualization• Report Manager enhancements• All of the older MS Excel Views, the “vwAll”, have been replicated in
the data sets.• Significantly improved Performance
Our new Reporting Solution provide maximum business value to User
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade(1 of 10 slides)Screenshot of navigation to login
• Login screen utilize Windows Authentication (Active Directory) so that User is not required to enter User Name, Password.
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (2 of 10 slides)Screenshot of navigation to Report Server 2008 R2 from Capstone RBMI• With just 2 clicks, User can navigate to RS (not required to enter
User Name, Password)
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (3 of 10 slides)Usability Changes
• UI changed to improve visibility• Cleaner UI, easier to navigate portal
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (4 of 10 slides)Usability Changes• Each Report has a convenient actionable menu
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (5 of 10 slides)Improved Reports
• Added Plant, Unit, Equipment ID filters
Now User get the ‘required’ data only!!!
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (6 of 10 slides)Improved Subscriptions
• Ability to filter data with Plant, Unit and Equipment ID parameters
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (7 of 10 slides)Improved Exporting
• Ability to Export Reports in to Word format
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (8 of 10 slides)Create reports from KPIs
• Ability to download KPIs or custom built Reports directly from RS
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (9 of 10 slides)Create reports from KPIs (continued)
• Ability to Modify Report and upload it back to Report Server
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade (10 of 10 slides)Create reports from KPIs (continued)
Safety Driven Performance Conference 2013
What’s New in SSRS 2008 R2 upgrade
Summary
• Convenient to customize Reports based on business needs• Easy to move Reports from different environments (test, staging,
prod)• Easy to generate, share Reports of different Plant’s Data• Easy to login, navigate, enhanced UI, Menu, Plant parameters,
Subscriptions, new Export format, modification of Reports
Safety Driven Performance Conference 2013
Report Builder 3.0
Jeff Popp
IS Consulting Manager
Introduction & Demo
Safety Driven Performance Conference 2013
For more information, please contact:
Vicki Locke, Support Specialist
Lloyd’s Register Technical Services Inc.
1330 Enclave Parkway, Suite 200Houston, TX 77077T +1 281 649 2248
F +1 281 596 4375 E [email protected] www.lrenergy.org
Contact information