Home Forums Data Warehousing Strategies and Ideas Data Warehouse automation tool suggestions? RE: Data Warehouse automation tool suggestions?

  • June 17, 2015 at 4:20 pm

    #1806235

    Andrew P (6/17/2015)

    Thanks Thomas - I appreciate the offer, but not at the moment. I've had a read through the TimeXtender 2014 user guide and have somewhat of an idea of what it can do. I will get in touch should the project grow to a position where it receives the management support required for financial investment in a Data Warehouse automation tool.

    The current scale is very small (a Data Mart for a specific department) and is an initial step into Data Warehousing - I expect ideal for learning how to develop and maintain a small-scale Data Warehouse manually before any automation, with "Microsoft Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012" as a guide.

    That's a good book. I would also look at the Kimball Data Warehouse Toolkit (Microsoft version); it's excellent and gives you a great overview of the DW/BI development life cycle. It's worth noting that it includes how to provide constant deliverables so as to see a quick RIO.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001