global energy forumdownload.microsoft.com/download/a/1/3/a13c22ea-1544-4ff4... · 2018-10-16 ·...
Post on 30-Jul-2020
0 Views
Preview:
TRANSCRIPT
Journey To Self Service BI
GLOBALENERGY FORUM
February 20, 2014Houston, Texas
22
Hello
Global Energy Forum
33
• Eric Vogelpohl:
– BI Manager
• Interests:
– Science & Skepticism
– Photography
– Data-Driven Journalism
– Sucker for old homes
(Err, money pits…)
Intros
• Williams:
– Founded in 1908
– ~4900 Employees
– Gathering & Processing
– Natural Gas Liquids
– Natural Gas Pipelines
44
Background: CIO Directive for BI
Challenge Convention. New Vision
Today: Vision is Unfolding (Solutions)
Lessons Learned. Q&A
Today’s Discussion…
55
Directive to Reboot BI
“Take on BI @ Williams. Form New Habits & Modernize!”
Q2 2012
“Ok, We have some
ideas…
66
BI-Financial
Corp. Perf. Mgmt.
• Key Financials
• KPIs
• Forecast Cycle
• Cost Centers
• Segment P&L
BI-Business
Comm.,Ops,Support
• Major Rev. Gen. Apps
• Project Mgmt.
• SCADA / Measurement
• Asset Reliability, Maint.
• Credit, Contracts, Risk
Tale of Two BI Focus AreasQ3 2012
77
Challenge Convention
Only Finance Benefits from Slice/Dice !?
Massive Enterprise DW. Why?
BI Renaissance: Entitlement, Agile, Rapid. Are We Ready?
New-Gen Tools: Cloud, Lightwt., Quick-2-Value, Mobile
App-ISVs. “BI Bolt-ons” – Can We Do Better?
For BI-Business, Question
Everything…
Bi Maturity Curve? Analytical Skills for Predictive-BI. Fast Track
Q3 2012
88
New VisionQ1 2013 +
People:
• Lightweight OLAP / Data Modeling
• Kimball Method
Behaviors:
• Agile, Engaging, Consultative
• DO NOT ask for Requirements!
Technology:
• Latest MSBI. Tabular + Excel
• DAX DAX DAX DAX
Partners:
• Microsoft – Partner, Not a Vendor
• Wipro. Conversions & Net-new.
BI CoE Formed
1. Hi-Value Solutions
(BI-Business)
2. Partnerships
3. Platform & Vendor
Mgmt.Empowered +
Responsible + Engaged
= Self Service BI
99
• Now, Let’s See the Vision Unfold
– Solution Showcase
1010
Mission
•Sunset Bus.
Objects
•Tabular / Excel
Svc
•Save $$$
Today
•Wipro On/
Offshore
•Complete:
•Credit Risk
•Gas Mktg
•Land-RoW
•Wave – 2
Starting
•SNIPE –
Conversion
Accelerator
Outcomes
•SSRS & Tabular
effective
•New Habits
(Odata)
•New BI-
vocabulary
emerging
Showcase #1: Business Objects –to- MSBI Project
1111
Showcase #2: Partnership w/ OSISoft Pi Team
Mission
•Asset
Performance
&
Benchmarking
Team –
Partnership
•Leverage Ops
data,
New/novel
ways.
Today
•Exposing ~50
Pi/Asset
reports –
Mobile
•Model in Dev
– Downtime
Analysis)
•Wipro Leading
Advanced
Analytics
Workshop
Outcomes
•Bi CoE
Partnership
Model
Working
•Employees @
Asset-sites.
Engaging in
Self Service
1212
Showcase #3: Commercial & Nat Gas Transportation
Mission
•Model
Transco
Pipeline’s
Customer &
Nominations
+ Financial
System
•Enable Self-
Service – 3
Years of Data
Today
•Model 95%
Complete
•250M Rows in
Tabular
•Business
learning Data-
manipulation
& pivoting
skills
Outcomes
•Bridging Skills
•Working w/
the business
•Synergies with
other groups
1313
Leadership
•Buy-in. Establish Maturity Model Point.
•Don’t Backslide into “Report Team”. Push!
•Quick-Wins, Agile, Engaging
BI Team / People
•Watch the Trends, Invest.
•Technical proficiency is a must. Invest.
•Don’t over commit.
Partnerships
•Marketing Slide – Use it often. Spread the love.
•Shared Responsibilities. COE Can’t Do it All.
•Don’t “Standards” to Death. Degree of Freedom
Business
•“Analysts” title <> Easy/Pre-Cooked.
•Develop Common Language
•You’re not a customer. You’re a partner.
Lessons From our Journey (thus far)
“Perfection is the enemy of done.” -Unknown
top related