search
Customers
Customer List
Customer Testimonials
Examples of our Work
Mixed Solutions
Back Office Support System
Brazos Electric - RTLP Web System
Compaq Proposal Generator
HP PITTS Application
New Homes Connect
Shell Energy Self Service Portal - MyAccount
CM Examples
Bay Area Houston
BHP Billiton - Intranet
Central Houston
Departmental Intranet
DNV - Certification
Houston Downtown Alliance
Houston Downtown Management District
HoustonDowntown.com
Jakes Finer Foods
Paradise Pools
Pearland Economic Development Corporation
Quest Offshore Resources
SHAC Boy Scouts of America
Shell Energy Web Site
Texas 288
BI Examples
Shell Energy Business Intelligence
EAI Examples
Coral Energy EAI
Tibco Transaction Monitor
Print  |  E-mail

Shell Energy Business Intelligence

Business Need:

In retail energy it is critical to make an accurate prediction of how much gas will be purchased.  In order to make these predictions, massive amounts of information are analyzed.  Shell Energy wanted the ability to measure the following:

  • Total customers
  • Total gas usages by customer types, plan types, etc.
  • Total activities from call center for types of customer
  • Central data repository for analysis for millions of records

 

All this information gives Shell Energy the ability to make fast, accurate, and effective decisions on how much gas the supply group should buy.



Solution:

We work with an existing team in Shell Energy to design the star schema data warehouse, design Extract, Transform, and Load (ETL) process, and cube design. We allow the business to look at three years worth of consumption data and see the consumption trend.

 

Technology: 

  • Database: SQL Server, Oracle 8i, Oracle 9i
  • Application: Oracle Warehouse builder
  • Reporting tool: Cognos BI



Right Shift BulletTo find out how we can leverage and apply our industry experience to implement a similar solution for you, contact us.