1 / 25

Measuring What Matters: BI and Business Decisions at the Royal Canadian Mint

Required Slide. SESSION CODE: BIC302. Measuring What Matters: BI and Business Decisions at the Royal Canadian Mint . Greg Smith CIO Royal Canadian Mint Howard Morgenstern Senior Technical Specialist – BI Microsoft. The Mint BI Solution. DELIVERY. COLLABORATION. CONTENT MANAGEMENT.

stacie
Télécharger la présentation

Measuring What Matters: BI and Business Decisions at the Royal Canadian Mint

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Required Slide SESSION CODE: BIC302 Measuring What Matters:BI and Business Decisionsat the Royal Canadian Mint Greg Smith CIORoyal Canadian Mint Howard Morgenstern Senior Technical Specialist – BIMicrosoft

  2. The Mint BI Solution DELIVERY COLLABORATION CONTENTMANAGEMENT SharePoint Server SEARCH Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS ProClarity Server PerformancePoint Server BI PLATFORM SQL Server Reporting Services SQL Server Analysis Services SQL Enterprise Server DBMS (BI HUB) SQL Server Integration Services Excel Online etc.

  3. The Royal Canadian Mint • Greg Smith • Chief Information Officer • smith@mint.ca • Locations • Ottawa: Head Office & Manufacturing • Winnipeg: Manufacturing • Revenue: $2B • Employees: ~950

  4. The Business Environment • Canadian Circulation • High volume (billions of units) • Precision manufacturing (EMS) • Must meet customer demand • Numismatic • Higher mix of SKUs • Extreme quality standards • “Don’t satisfy demand!” • Age sensitive product – minimize inventories • Foreign Circulation • Competitive bidding • Extreme price sensitivity • Manufacture to order • Engineer to order • Bullion & Refinery • Commodity market • Extreme demand fluctuations • Time sensitive delivery

  5. Key Learnings • #1: How technology & process relate in business processes re-engineering • Why we measure... • Measure what matters! • #2: Importance of culture, context & dialog in transforming the role of BI • Don’t forget the people • #3: Best practices for successful user adoption of the tools and technology • Business Intelligence Strategy & Roles • Our strategies and lessons learned

  6. “Veritas”PerformancePoint Demo Greg Smith CIO Royal Canadian Mint DEMO

  7. How technology and business process relate in business processes re-engineering Key Learning #1

  8. Why We Measure? • Measurement is essential and inherently neutral • Driving to work • (Speed, Gas, Temp., Radio) • Yet it drives behavior! • Many reasons we measure... • “Compliance” • Planning • Justification • Business cases, etc • Improvement • Validate process improvement • Rewards and Recognition • Performance reviews

  9. Measure what matters! • Measure what matters… • Unlimited opportunities but vast majority are “useless” • Key measures and causal relationships • Expect “evolution” • Lean Enterprise • Principles from Toyota • Focus on continuous improvement (kaizen) • Define value from your customer’s perspective • Seven Deadly Sins* • Vanity • Provincialism • Narcissism • Laziness • Pettiness • Inanity • Frivolity * The 7 Deadly Sins of Performance Measurement (Michael Hammer – Spring 2007 MIT Sloan Management Review)

  10. The importance of culture, context and dialog in transforming the role of BI Key Learning #2

  11. Don’t Forget The People - Context • Context is our perception of measurement • Continuum from negative to positive • Most important aspect of the system • Increased “self-management” indicates positive context • Beware of tight linkage to rewards and recognition • Most measurement should target improvement • Strive for transparency and a “no-fault” environment • Mistakes happen – Learn from them! • “If you never make mistakesyou’re not trying hard enough”

  12. Don’t Forget The People - Dialogue • Central to effective performance measurement • Dialogue means “Sharing a collective meaning” • A mutual search for shared meaning • Positive context is crucial • Dialogue thrives on openness, candor and multiple perspectives

  13. Performance Measurement Cycle + People Context Dialogue Adapted from: http://technet.microsoft.com/en-us/library/cc811594.aspx

  14. Best practices for successful user adoption of the tools and technology Key Learning #3

  15. How We Structure IT • Enterprise Performance Team • BI Manager • Business Analyst • Systems Analysts • Core Skills • Interpersonal skills are #1 • SSRS, SSAS, SSIS • PerformancePoint, ProClarity • Visual Studio, BI Studio

  16. BI Roles & the Microsoft Suite DELIVERY COLLABORATION CONTENTMANAGEMENT Role Discussion SharePoint Server SEARCH Delivery Reports Dashboards Excel Workbooks Analytic Views Scorecards Plans END USER TOOLS & PERFORMANCE MANAGEMENT APPS ProClarity Server PerformancePoint Server BI PLATFORM Dimensionality SQL Server Reporting Services SQL Server Analysis Services SQL Enterprise Server DBMS (BI HUB) SQL Server Integration Services Data Excel Online etc.

  17. Key Strategies • Alignment/Vocal champion(s) • Vision & Strategic objectives • Integration to Corporate and Operational plans • Executive buy-in & use • Balanced Views • “Conflicting” measures • Broad use • Large number of beta users • Training key influencers • Context & Dialogue • 100 days of “amnesty” • Scorecard discussed at Executive & Board meetings • IT “doesn’t do BI” • Build tools / Train users • Encourage self-service • Act as “Custodians”

  18. Key Lessons Learned • Don’t wait for “perfection” • Management behaviour is critical • Context & Dialogue are key • Dimensions/Definitions are hard! • Entrenched uses • Examples: Overtime, Organization • It’s easier when the news is good • Be willing to “revisit” what matters • Set timelines for adoption • “Be the change you want to see in the world” • - Mahatma Gandhi

  19. The Road Ahead • Upgrades Planned/Underway • Windows 7 Enterprise (x64) • SharePoint 2010 Enterprise • Microsoft SQL 2008 R2 Enterprise • Windows Server 2008 R2 • Pervasive and Proactive BI • Alerts • Workflows • Automation

  20. Recommended Reading Michael Hammer – Spring 2007 MIT Sloan Management Review

  21. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

  22. Required Slide Complete an evaluation on CommNet and enter to win!

  23. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

  24. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

  25. Required Slide

More Related