1 / 17

Enhancing Decision Making with Consistent Data Mart Solutions at DTE Energy

This presentation, delivered at the AEIC Load Research Annual Meeting, explores the vital role of Data Marts in optimizing billing data for Load Research at DTE Energy. It highlights the demand for accurate data, discusses the benefits of Data Mart development, and outlines the drivers behind its implementation. Key topics include the architecture of data extraction, analysis of billing determinants, and operational benefits that lead to better decision-making. The strategic vision for the Load Research team aims to ensure access to reliable data for improved corporate initiatives.

winda
Télécharger la présentation

Enhancing Decision Making with Consistent Data Mart Solutions at DTE Energy

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. LOADRESEARCHDATAMART VISION Consistent Data For Faster & Better Decision Making PRESENTED AT AEIC LOAD RESEARCH ANNUAL MEETING MYRTLE BEACH, SOUTH CAROLINA JULY 2005 By SYED ALEEM DTE ENERGY

  2. BILLING DATA – A VALUABLE RESOURCE Load Research groups have continuously struggled to receive timely and accurate data from corporate billing systems. Quality billing system data is in greater demand than ever.

  3. TOPIC OF DISCUSSION Conceptual Overview of Data Mart Role of LDM Benefits of LDM Drivers to LDM Development Implementation (Solution/Security/Maintenance) Deliverables Success Vision Conclusion

  4. CONCEPTUAL OVERVIEW What is a Data mart? A data mart is a collection of subject specific transaction data contained in the corporation’s multiple operational or production systems. Data marts are developed with a focused objective that helps departments to strategize based on analysis of past trends and experiences.

  5. From Support Systems LDM Dataflow * Samples Interval Demand Data * Billing Interval Demand Data * Meter Data From Billing Systems Calculated Values LDM * Customer Info * Site Info * SIC Code * Energy * Demand * Revenues * Load Factor Calc. * Hours Use Calc. * Demands Calc Using DCT. * Choice To Bundled Relationships Value Added * Margin Analysis * Detailed SIC Classification Analysis * Detailed Class Analysis * Bill Frequencies * Billing Determinants ROLEOF LDM

  6. BENEFITS OF LDM Benefits can be categorized into: Business Benefits Operational Benefits Information Technology Benefits

  7. BUSINESS BENEFITS Easily Accessible Data Analyze Large Amount of Data Consolidated Data Increased Productivity Consistent View of Data

  8. OPERATIONAL BENEFITS Relieves Production Systems of Performing Decision Support Summarized Data Unlimited Access to Users

  9. INFORMATION TECHNOLOGY BENEFITS Flexible Architecture for Enhancements Less Load on Production Systems Eliminates Enhancements to Production Systems High Quality Data

  10. DRIVERS TO LDM DEVELOPMENT LR Extract Architecture Residential & Small Commercial Customers Billing System LRDB Customer Information & Billing Data Files

  11. IMPLEMENTATION Analysis of Existing Process Identify Key Users/Requirements Identify Subject Areas Perform Data Analysis Database Physical Design Extraction & Loading Process Security Maintenance

  12. DELIVERABLES Billing Determinants Bill Frequency Class Analysis Unbilled Revenues Individual Customer/Site Analysis Customer Counts Billed Usage and Summed Interval Demands Validation Class Average Demands

  13. SUCCESS Major Contributor to DTE’s Three Rate Cases Electric Rate Case Interim Order Implementation PSCR and Equalization Adjustments Refunds Michigan Electric Choice Legislation reform efforts AES Collaborative Meetings Provides information to Pricing, Cost of Service, Forecasting, Legislative and Marketing Teams

  14. VISION LDM is a vision of the Load Research team to be self reliant and have access to consistent and reliable billing data

  15. VISION Enhancements: Sample Design Class Analysis (Total System Analysis) Allocation Schedule Development Substation Load Analysis Data Elements Description

  16. CONCLUSION LDM is supporting Load Research’s goal to be a leader in formulating corporate initiatives and strategies.

  17. Syed, Wait! I have a Question..

More Related