CoffeeCAST – #32 – Talking Data Warehousing and Integration

Coffeecup_26 Welcome to the 32nd CoffeeCAST with Stephen Hayward of Project X.  Well welcome back.  Today I have captured Graham for another fun discussion on Data Warehousing and Integration.  So I am just finishing a great Starbucks Grande Bold and hope you have found a good coffee yourself for this CoffeeCAST and sit back while Grham and I chat about:

  • Discussion on Cars – Environmentally friendly started by MIP‘s Smartcar (see my pic/post)
  • Datawarehouse
    • New Trends – Out from build to Support and Enhance
    • Marts vs Warehouses (logical/physical)
    • Master Data Management
      • Customer Master File (CMF)
      • Customer Information File (CIF)
  • Data Integration

So as always it was great to grab a chance to talk with Graham.

Download cc_32_warehouses_and_integration.mp3

Listen in and we hope you enjoy and more importantly, hope you join in the conversation.  So drop a comment in the blog or send me an email and share your thoughts on the topic.

The audiocast is available on iTunes (as a Podcast) or here for download.  Have a great day and join the conversation.

  1. Stephen Reply

    Who would have thought that the little warm-up dialogue in the beginning would elicite some great conversation.

  2. mip Reply
  3. mip Reply

    Thanks for the link and added info. Those numbers being used are not the actual mileage being achieve though. Reference this study, done by governments across Canada who have been using the Prius. The study is here http://www.hybridexperience.ca/Toyota_Prius_Fuel_Performance.htm and indicates early on, for example, that the Prius as used by the BC government (one of the largest fleets in Canada) were only realizing 5.83L / 100KM.
    This was one of the reasons I didn’t go for a hybrid. People I know who own one told me that their day-to-day driving habits (i.e. being stuck in traffic rather than continuous driving) did not allow them to realize the published fuel consumption targets. The Smart, I can confirm, is meeting those expectations. The rankings need to take into consideration the various “realities” of driving, such as weather. The first study I linked to took the various states of weather into consideration. Perhaps if you were going to drive a Prius all year long in Florida you might realize those rates, but, as per the study I linked to above, in Canada, they are not realizing those rates of consumption.

  4. Graham Boundy Reply

    I agree with MIP completely, you’d have to buy a lot of gas to make up for the $14,000 difference in price between the Prius and the ForTwo. Assuming the third and fourth passengers are okay hanging onto the roof racks.
    The source I was quoting from was:
    http://oee.nrcan.gc.ca/transportation/personal/buying/energuide-winners.cfm?attr=8
    There’s also a search page
    http://oee.nrcan.gc.ca/transportation/tools/fuelratings/ratings-results.cfm?attr=8
    Sorry about the lack of formating…The top 7 were:
    Make/Model Class Eng Size/
    # Cyl Trans #gears Fuel Consumption Rank CO2 kg per year
    Type $/yr L/yr L/100km Class All
    City Hwy
    HONDA INSIGHT (HYBRID) T 1.0 / 3 M5+ X $504 720 3.9 3.3 1 1 1728
    TOYOTA PRIUS (HYBRID) M 1.5 / 4 V X $574 820 4.0 4.2 1 2 1968
    MERCEDES-BENZ SMART FORTWO CDI T 0.8 / 3 M6+ D $563 840 4.6 3.8 2 3 2269
    MERCEDES-BENZ SMART FORTWO CDI CABRIOLET T 0.8 / 3 M6+ D $563 840 4.6 3.8 2 3 2269
    HONDA CIVIC HYBRID C 1.3 / 4 V X $630 900 4.7 4.3 1 5 2160
    VOLKSWAGEN GOLF TDI DIESEL C 1.9 / 4 M5+ D $737 1100 6.2 4.6 2 6 2970
    VOLKSWAGEN NEW BEETLE TDI DIESEL S 1.9 / 4 M5+ D $737 1100 6.2 4.6 1 6 2970

  5. mip Reply

    Good coffeeCast but your research on fuel efficiency is a bit off. The Smart consumes less fuel than the Prius in tests that involve city driving, highway driving and combined driving, across all four seasons. How comes there is no link in your show notes to the data that is referenced? Here is a report that I looked at from transport Canada that shows that the Smart consumes 3.1L of fuel to go 100KM while he Prius consumes 3.8L of fuel to go 100KM.
    http://www.tc.gc.ca/programs/environment/atvpgm/reports/tests/fc_9903.pdf
    As well, the Prius starts at $31,000 which is considerably more than where the Smart starts which is approximately $17,000. You’d have to save a lot of gas to make up the $14,000 difference.

Leave a Reply to mip Cancel reply

captcha *