summit 2010 edw_and_bi_the_quest_for_stability
DESCRIPTION
Presentation in 2010 on EDW and BI stabilityTRANSCRIPT
![Page 1: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/1.jpg)
Enterprise Data Warehousing and Business Intelligence
“The Quest for Stability”
The nitty-gritty balancing act for creating a quality reporting environment… while enforcing rules and design specifications
that add value to the data you collect.
Tennessee Board of Regents
![Page 2: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/2.jpg)
Tennessee Board of Regents
How do customers shape your decisions?
Executive Management FocusSenior Business Office ManagementSenior IT ManagementFunctional Department ManagementDepartmental StaffFederal AgenciesState of Tennessee Agencies…and our Competition!
![Page 3: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/3.jpg)
Tennessee Board of Regents
Life cycle:
Providing value to all stakeholders during light or heavy system restructuring, data collection, human, cost, or other resource challenges….
![Page 4: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/4.jpg)
Tennessee Board of Regents
Information Portfolio Management?
What Information is collectedInformation qualityCosting factors, both capital and humanTiming – Planned vs. Dramatic changeProject Life‐cycles
![Page 5: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/5.jpg)
Tennessee Board of Regents
Portfolio Management: How does a planned or unplanned system change affect my data?
![Page 6: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/6.jpg)
Tennessee Board of Regents
Design Flexibility or Pre‐determined Rules
Collection activities: bulk, streamed…Transformation rules: in‐flight and postDashboarding Results Dynamic Analytical IntelligenceArchiving policies
![Page 7: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/7.jpg)
Tennessee Board of Regents
Transformation Rules:
Analytical Rules:
1:1 Relationships:
Transformation rules: in‐flight and post
![Page 8: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/8.jpg)
Tennessee Board of Regents
SGHE Developed Analytical Rules: ODS 8.1* The value add to Enterprise data collection
![Page 9: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/9.jpg)
Tennessee Board of Regents
SGHE Developed Analytical Rules: ODS 8.2
![Page 10: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/10.jpg)
Tennessee Board of Regents
Gaining a perspective on your operation based on metrics and analysis on pre‐determined elements…
…and then presented both as a dynamically adjusting portal or via static results.
http://www.diskel.co.uk/dashboards.htm
Dashboards:
![Page 11: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/11.jpg)
Tennessee Board of Regents
Star and Snowflake designs
Architectural Impact to Data:
Poor or Improper Star or Snowflake designs can impact how data is stored and therefore the results on specific elements being researched can be skewed.
Validation of Business Rules against the designs is a very important step in quality assurance efforts.
![Page 12: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/12.jpg)
Tennessee Board of Regents
Dimensional Growth Patterns
Legacy dataNew data requirementsOther source systemsArchiving Processes
![Page 13: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/13.jpg)
Tennessee Board of Regents
Data Security is not an after thought:* It must be our first thought!
Gather the business requirementsIntegrate planning (systems & rules)Incorporate a clean designa. Content filteringb. Intrusion Preventionc. Identity ManagementTracking: Analyzing provides project focus(Everyone’s) reputation is on the line
![Page 14: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/14.jpg)
Tennessee Board of Regents
http://veimages.gsfc.nasa.gov/174/BlueMarble.jpg
Students, networks, data , datacenters are now located around the world from within the US, Tennessee, and even foreign places.
Globalization:
![Page 15: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/15.jpg)
Tennessee Board of Regents
What’s next… I have a plan, a design, data:
Reporting!
Performance Financial Processes Student Achievement Budgetary RelationshipsEstablishing Effective BaselinesComparisons with peers and competition
![Page 16: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/16.jpg)
Tennessee Board of Regents
Integrating Departmental requirements and project “needs” into a matrix that can be used to determine where human inteland development efforts will go.
Spheres of InfluenceLayers of RequirementsLevels of PrioritiesMultiple Project Directions
Adaptable Priorities
![Page 17: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/17.jpg)
Tennessee Board of Regents
Summary:
Customer OrientationInformation ManagementDesign and RulesData SecurityWhat’s next
![Page 18: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/18.jpg)
Tennessee Board of Regents
Advice: The lack of a Disciplined approach in your Information Technology solutions and decision making practices:
Will lead to complexity in the system and application environments… Which then {logically} leads to ever increasing
challenges in controlling costs… And eventually leads to data integrity issues… And a full spectrum of dissatisfaction.
![Page 19: Summit 2010 edw_and_bi_the_quest_for_stability](https://reader033.vdocuments.us/reader033/viewer/2022052901/55660fffd8b42a7d608b4606/html5/thumbnails/19.jpg)
Tennessee Board of Regents
Contact details:
Greg TurmelSr. Database AdministratorTennessee Board of Regents1415 Murfreesboro Rd. #358Nashville, TN. 37217615.366.4467 (Office)itinfo.tbr.edu (IT website)http://twitter.com/datahaulr http://www.linkedin.com/in/gturmel