PORTLAND, Ore. -- (BUSINESS WIRE) -- A full-day course on data warehouse automation will debut at the TDWI World Conference in Orlando, FL today, representing a major milestone in the maturation of the data warehouse automation market as a viable solution for accelerating data warehouse development. WhereScape customer case studies from Lamar Advertising and Union Bank will be among those profiled in the class. To learn more about the TDWI data warehouse automation class, please visit here.
Data Warehouse Automation: Better, Faster, Cheaper … You Can Have It All will be taught by TDWI faculty member Dave Wells, who also led the course development effort. Wells is a consultant, mentor, and teacher in the field of business intelligence (BI) with more than 35 years of experience.
Data Warehouse Automation Success Stories
Class attendees will hear how Lamar Advertising developed a new data mart using WhereScape to handle its extremely large volumes of big data and to scale with its growing electronic billboard inventory. Lamar is now able to deliver a more robust process, better documentation that is always up to date and a system that is much easier to maintain. Attendees will also hear how Union Bank developed a fully documented data mart in less than eight weeks using WhereScape that provided a clean, integrated set of consumer loans data for analysis and reporting.
According to Wells, one of the most pervasive problems in BI today is the fact that data warehouses take too long to build and they are hard to change. There are many moving parts—requirements, source data analysis, source-target mapping, data acquisition, data transformation logic, ETL design, database loading, scheduling, error handling—and “getting it right the first time isn’t easy,” he said. “And when finally you do get it right, something changes.”
According to Wells, data warehouse automation accelerates warehouse development and change cycles while simultaneously assuring quality and consistency. More than simply generating ETL scripts, data warehouse automation automates the entire life cycle from source system analysis to testing and documentation. “Productivity gains, cost savings, and quality improvement are all possible with data warehouse automation,” Wells said.
“Adoption of data warehouse automation changes the way that we think about building data warehouses,” Wells continued. “The widely accepted best practice of extensive up-front analysis, design, and modeling can be left behind as the mindset changes from ‘get it right the first time’ to ‘develop fast and develop frequently’ – an approach that is aligned with today’s agile development practices. Data warehouses must be sustained through a long life cycle where changes in source data, business requirements, and underlying technologies are ongoing considerations,” Wells said. “Automation helps to implement the right changes in the right ways and as quickly as they are needed.”
Through a combination of lecture, exercises and case study review, class attendees will learn how data warehouse automation can help accelerate data warehouse development and where to best apply the technology. Topics to be covered include:
WhereScape designs, develops, sells and supports WhereScape 3D, the industry’s first data warehouse planning tool; and WhereScape RED, the industry’s first and best integrated development environment for building, deploying, managing and renovating data warehouses. WhereScape’s products are used in every kind of business intelligence project found in today’s commercial environment: from normal-form enterprise data warehouses and data vaults, through user access layers and tiers of dependent data marts, to standalone data marts and reporting systems.
Our more than 600 customers are active and satisfied users of our technologies, and report that, with WhereScape’s products, they are able to build data warehouses with fewer people, few if any diversions, missed deadlines or unmet user expectations, and in record time: in days or weeks, instead of months or years. WhereScape has offices in Portland, Oregon; Auckland, New Zealand; and Reading, UK. For more information, please visit www.wherescape.com.
All products or company names herein may be trademarks of their respective owners.