BI and Business Decisions at the Royal Canadian Mint Greg Smith CIO Royal Canadian Mint Howard Morgenstern Senior Technical Specialist BI Microsoft SESSION CODE BIC302 Required Slide END USER TOOLS amp PERFORMANCE MANAGEMENT APPS ID: 615960
Download Presentation The PPT/PDF document "Measuring What Matters:" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Measuring What Matters:BI and Business Decisionsat the Royal Canadian Mint
Greg SmithCIORoyal Canadian MintHoward MorgensternSenior Technical Specialist – BIMicrosoft
SESSION CODE: BIC302
Required SlideSlide2
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
ProClarity Server
PerformancePoint Server
etc.
Excel
Online
BI PLATFORM
SQL
Server
Reporting Services
SQL
Server
Analysis Services
SQL
Enterprise Server DBMS (BI HUB)
SQL
Server
Integration Services
SharePoint
Server
SEARCH
DELIVERY
Reports
Dashboards
Excel
Workbooks
Analytic
Views
Scorecards
Plans
CONTENT
MANAGEMENT
COLLABORATION
The Mint BI SolutionSlide3
The Royal Canadian MintGreg Smith
Chief Information Officersmith@mint.caLocationsOttawa: Head Office & ManufacturingWinnipeg: ManufacturingRevenue: $2BEmployees: ~950Slide4
The Business EnvironmentCanadian Circulation
High volume (billions of units)Precision manufacturing (EMS)Must meet customer demandNumismaticHigher mix of SKUsExtreme quality standards
“Don’t satisfy demand!”Age sensitive product – minimize inventoriesForeign CirculationCompetitive biddingExtreme price sensitivityManufacture to orderEngineer to order
Bullion & Refinery
Commodity market
Extreme demand fluctuations
Time sensitive delivery
4Slide5
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 BIDon’t forget the people#3: Best practices for successful user adoption of the tools and technologyBusiness Intelligence Strategy & Roles
Our strategies and lessons learnedSlide6
“Veritas” PerformancePoint Demo
Greg SmithCIORoyal Canadian MintDEMOSlide7
Key Learning #1How technology and business process relate in business processes re-engineeringSlide8
Why We Measure?Measurement is essential and inherently neutralDriving to work
(Speed, Gas, Temp., Radio)Yet it drives behavior!Many reasons we measure...“Compliance”Planning
JustificationBusiness cases, etcImprovementValidate process improvementRewards and RecognitionPerformance reviewsSlide9
Measure what matters!Measure what matters…Unlimited opportunities but vast majority are “useless”
Key measures and causal relationshipsExpect “evolution”Lean EnterprisePrinciples from ToyotaFocus on continuous improvement (kaizen)Define value from your customer’s perspective
Seven Deadly Sins*VanityProvincialismNarcissismLazinessPettinessInanityFrivolity
* The 7 Deadly Sins of Performance Measurement
(Michael Hammer – Spring 2007 MIT Sloan Management Review)Slide10
Key Learning #2The importance of culture, context and dialog in transforming the role of BISlide11
Don’t Forget The People - ContextContext is our perception of measurement
Continuum from negative to positiveMost important aspect of the systemIncreased “self-management” indicates positive contextBeware of tight linkage to rewards and recognitionMost measurement should target improvementStrive for transparency and a “no-fault” environment
Mistakes happen – Learn from them!“If you never make mistakesyou’re not trying hard enough”11Slide12
Don’t Forget The People - DialogueCentral to effective performance measurementDialogue means “Sharing a collective meaning”
A mutual search for shared meaningPositive context is crucialDialogue thrives on openness, candor and multiple perspectives
12Slide13
Performance Measurement Cycle + PeopleAdapted from:
http://technet.microsoft.com/en-us/library/cc811594.aspx
Context
DialogueSlide14
Key Learning #3Best practices for successful user adoption of the tools and technologySlide15
How We Structure IT
Enterprise Performance TeamBI ManagerBusiness Analyst
Systems AnalystsCore SkillsInterpersonal skills are #1SSRS, SSAS, SSISPerformancePoint, ProClarityVisual Studio, BI StudioSlide16
END USER TOOLS & PERFORMANCE MANAGEMENT APPS
ProClarity Server
PerformancePoint Server
etc.
Excel
Online
BI PLATFORM
SQL Server
Reporting Services
SQL Server
Analysis Services
SQL
Enterprise Server DBMS
(BI HUB)
SQL Server Integration Services
SharePoint Server
SEARCH
DELIVERY
Reports
Dashboards
Excel
Workbooks
Analytic
Views
Scorecards
Plans
CONTENT
MANAGEMENT
COLLABORATION
Data
Dimensionality
Delivery
Role
Discussion
BI Roles & the Microsoft SuiteSlide17
Key StrategiesAlignment/Vocal champion(s)Vision & Strategic objectives
Integration to Corporate and Operational plansExecutive buy-in & useBalanced Views“Conflicting” measuresBroad useLarge number of beta usersTraining key influencers
Context & Dialogue100 days of “amnesty”Scorecard discussed at Executive & Board meetingsIT “doesn’t do BI”Build tools / Train usersEncourage self-service
Act as “Custodians”Slide18
Key Lessons LearnedDon’t wait for “perfection”Management behaviour is critical
Context & Dialogue are keyDimensions/Definitions are hard!Entrenched usesExamples: Overtime, Organization
It’s easier when the news is goodBe willing to “revisit” what mattersSet timelines for adoption
“Be the change you want to see in the world”
- Mahatma Gandhi Slide19
The Road AheadUpgrades Planned/Underway
Windows 7 Enterprise (x64)SharePoint 2010 EnterpriseMicrosoft SQL 2008 R2 EnterpriseWindows Server 2008 R2Pervasive and Proactive BIAlertsWorkflowsAutomationSlide20
Recommended Reading
Michael Hammer – Spring 2007 MIT Sloan Management ReviewSlide21
Resources
Required Slide
www.microsoft.com/teched
Sessions On-Demand & Community
Microsoft Certification & Training Resources
Resources for IT Professionals
Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn
LearningSlide22
Complete an evaluation on
CommNet
and
enter to win!
Required SlideSlide23
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
Slide24
©
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.Slide25
Required Slide