1 / 14

Keeping your eye on the ROI!

Keeping your eye on the ROI!. Business Intelligence from an “ROI” perspective…. Agenda:. BI Projects: Traditional Projects How does that “Jibe” ? Another Approach Techniques Questions. BI Projects: The Promise. “C” Level Executives, Data Warehouses and Dashboards

fordon
Download Presentation

Keeping your eye on the ROI!

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. Keeping your eyeon the ROI! Business Intelligence from an “ROI” perspective…

  2. Agenda: • BI Projects: Traditional Projects • How does that “Jibe” ? • Another Approach • Techniques • Questions

  3. BI Projects: The Promise • “C” Level Executives, Data Warehouses and Dashboards • Users will Surf and Drilling “Up, Down and all around…” • Data Warehouses will be “Active” • Data Warehouse projects will make you famous…

  4. BI Projects: The Reality • “C” level executives may glance at a dashboard, but they don’t steer by it! • Decision makers don’t spend a lot of time surfing data, they call their “Go To” person and get the boiled down answer. • Data Warehouse projects are more likely to make you “Infamous”… • Creating yet another version of the truth • Threatening the existing providers of information • Unleash undeliverable user expectations

  5. Traditional Projects • The traditional architecture • Source -> ETL -> ODS -> ETL -> DW • Then: DW -> ETL -> DM -> Tools, Portals… • Value Propositions • Visibility – The “Wind Tunnel” & smoke traces • Reporting and Analysis • Alerts and Triggers • Organic and Exogenous Information

  6. How does that “jibe” with reality? • Expected versus Actual Use Cases • Analytical Users • Decision Makers • Time Horizons • Some facet on a time over time basis • Before, Now, Next • Multiple simultaneous perspectives • Business Transaction Lifecycle • Perspectives and Alternate Dimensions • Scenarios, Plans and Write-back

  7. Emerging Approaches: • Operational BI • Low hanging Fruit • Number of Beneficiaries • EII versus ETL • Pulling “live” data versus compiling • Building a catalog of measures and metrics • Template Driven Presentation • Template Technologies: Simple and beyond • Benefits of Templates

  8. What’s BI really all about? • “Actionable” Information • Data > Information > Knowledge > Understanding • What’s the difference between them? • Providing for Action • Right stuff in the right hands at the right time • Creating a “Destination for Action” • Get data • Draw attention or Alert • Provide for triggering action • Trigger the followup

  9. What’s an ‘Agile” Approach? • User Stories versus Use Cases • Two heads are better than one • Test first: If you can’t explain how to test it then you don’t understand it well enough to build it! • Build just enough to get going and then evolve the functionality and platform • Don’t “Plan to throw one away anyway” – plan on continuous refactoring!

  10. Techniques – Technology • Tools • EII • ETL • Temporary Data Structures • Materialized Views • Partitions and their uses • Template Driven Architecture • Source Acquisition • Presentation Configuration • BPM, Six-Sigma and Building Blocks

  11. Techniques – Methodology • Every Team Member an Evangelist • The “Circle of Friends”: leveraging opinion leaders in the organization • The Importance of “Change Management” • Project Leadership • Short and Choppy Steps - Duration • Taking an Island “One” platoon at a time • Plan – but don’t take your plans too seriously

  12. Methodology - continued • The many values of Pilots • Technology • Tools, Patches and Integration • Performance, dependencies • User Story Confirmation • Fingerspitzen-Gefeuler • How did Thomas Jefferson design the sidewalks at UVA? • Teamwork • Direct Team Interaction • Extended Team Interaction • A chance to find out what you don’t know you don’t know!

  13. Review • ROI is: • We add to it by: • We can accomplish this through: • Which can be actioned in the BI project when we: • Questions?

  14. Questions

More Related