A Masterclass on Data Warehouse Automation
17
Flexible and efficient Business Intelligence MASTER CLASS: Data Warehouse Automation Better, Faster and Cheaper
-
Upload
heath-turner -
Category
Technology
-
view
178 -
download
2
description
We explain the new Data Warehouse Automation positioning termed in TDWI and how TimeXtender and the methodology of Agile BI & ETL Development fits well within this segment. For companies looking to optimise performance, reduce build costs and time, along with Maintenance Costs and Effort. This will
Transcript of A Masterclass on Data Warehouse Automation
Flexible and efficient Business Intelligence
MASTER CLASS:
Data Warehouse AutomationBetter, Faster and Cheaper
Agenda
• Group Introduction – 5min
• Heath Turner (Director: Karabina Software) – 15 min
Introduction: Data Warehouse Automation Positioning
• Colin McGuire – 40 to 50 min
Subject Matter Expert & Practical Experience
TimeXtender 2014 Features
What is Data Warehouse Automation
New Class of Technology providing ability to speed up Data Warehouse development using
automation
Improve overall Quality and ensure Consistency across your development
Reduces overall operating Costs of providing BI, remove repetitive tasks
Automates the entire life cycle from source system analysis to testing and documentation.
Data Warehouse Approach
The Business Case:
Reduce Costs, Improve Time To Value
• Iterative Development with Short releases• Prioritise releases and start with what's important• Add Incremental Value• No Need to rebuild, Automation enables configuration
According to Kimball
“Average BI iteration lasts six
months” -with TimeXtender we
can offer you the same process
in about 6 weeks.
The Business Case:
“People Adding Business Value” versus “People Maintaining Environment”
Remove 18 months Build effort
70% Reduction in Build Cost
68% Reduction in Maint. Cost
TimeXtender Value Proposition
Data Warehouse Automation
• Extract Transform Load Process
Dynamics
Oracle
SAP
Forecast API
Etc.
Data Sources
StageData
Warehouse
Reporting
Dashboards
Analysis
TX 2014 Data Warehouse Automation
DWA Example: Zonke Monitoring Systems
Points to Highlight:• Large investment in Qlikview• Required a Data Warehouse, for LPO Machines• 6 weeks Project Deployment
– 3 underlying Data Sources– Full Data Warehouse with staging & Cleansing– Conformed Naming Conventions with Cubes for
Machine Operations and Route Operators– Centralise Qlikview Scripts in SQL– Support for Multiple Presentation layers – Sharepoint,
Excel And Qlikview
Get the Case Study http://www.karabinasoftware.com/Pages/Customers.aspx
A bit about timeXtender
X
X
X
XX
X
• Over 8 years in Agile BI / Data Warehouse Automation• Worldwide - 6 TimeXtender Offices (including JHB, HQ = Denmark)• Strategic partners - >54 strategic partners
X
X
X
XXX
X
XX
X
X XXX
X
XX
X
X
X
XX
• Our customers – >2600 installations in all segments
References
- International - - Africa -
What do TimeXtender customers say?
What do TimeXtender customers say?
Masterclass Subject Matter Export:
Colin Mcguire
Conclusion:
What have we learnt?
Watch the Agile ETL Videohttp://youtu.be/VaPwbUURZP0
• Better because– ability to respond to changed and new requirements quickly– business is able to make changes far later in the development process
• Faster because you there are:– faster timer to build and deploy new capabilities, to adopt and modify
existing warehouse, and to build and review prototypes
• Cheaper by:– reducing cost through time savings, labor savings, and better quality
Read the Bloghttp://www.karabinasoftware.com/blogs
1) Watch the Agile ETL Videohttp://youtu.be/VaPwbUURZP0
2) Read the DWA Bloghttp://www.karabinasoftware.com/blogs
3) Attend our Agile BI Training http://www.karabinasoftware.com/blogs
4) Download the Trialhttp://www.timeXtender.com
www.karabinasoftware.com
+2711 463-8155
http://www.karabinasoftware.com
http://www.linkedin.com/company/karabina-software
http://www.youtube.com/karabinasa
http://twitter.com/karabina
