Resource Library

TDWI eBook: Delivering Advanced Analytics in the Era of Big Data

Webinars

Advanced analytics is an umbrella term for a new class of technologies that apply the techniques of statistical and mathematical analysis, along with other cutting-edge domains, to common business problems. Advanced analytics makes use of new and existing data sources—as well as new technologies for managing, processing, and analyzing data at scale—to accelerate, and, in some cases, to automate, the development of analytics models and the identification of analytics insights.

Learn More

Delta Community Credit Union & WhereScape RED

Webinars

Want to learn how Delta Community Credit Union used WhereScape RED to achieve significant business value in just 90 days? Watch the webinar replay to find out…

Learn More

Data Warehouse Automation: Hype or Reality?

Webinars

Is your data warehouse failing to deliver real business benefits? Could Data Warehouse Automation be the key to solving these problems? Watch this Webinar and learn why it’s time for data warehouse automation, from independent industry expert Rick F. van der Lans.

Learn More

Smarter Analytics: Supporting the Enterprise with Automation

Webinars

The data warehouse is intended to support analysis by making the right data available to the right people in a timely fashion. Watch the webinar now...

Learn More

WhereScape Featured on The Bloor Group

Webinars

Learn how data warehouse automation is helping bridge the gap between business and IT to deliver value faster. Watch now to learn more…

Learn More

Ovum Report: Building an Agile Data Environment

White Papers

Learn More

Improving Design for Data Warehouse Automation with WhereScape 3D 2.5

White Papers

This Enterprise Management Associates (EMA) product brief reviews WhereScape 3D, an automated data-driven design tool. In this product brief EMA recognizes WhereScape as a leader in data warehouse discovery and design and describes how WhereScape 3D allows organizations to quickly and productively scan, catalog, and detail the metadata of existing analytical environments.

Learn More

9sight Consulting: BI, Built to Order, On-demand

White Papers

This white paper by data warehousing pioneer Dr. Barry Devlin examines three key ways in which data warehouse automation has changed the design, development, and ongoing maintenance of data warehouses and analytic platforms.

Learn More

Decision Guide, Data Warehouse Automation

White Papers

How do you know if your organization is prepared for data warehouse automation?
Use this tool to test your preparedness and decide which level of warehouse automation you’re ready for.

Learn More

Moving Your Data Infrastructure To The Cloud

White Papers

Industry expert Claudia Imhoff dispels cloud migration myths and shares best practices.

Learn More

Moving Your Data Infrastructure To The Cloud – Things You Should Know

Webinars

Learn from industry expert Claudia Imhoff how you can best prepare your organization to successfully transition your data infrastructure to the cloud.

Learn More

How WhereScape Data Automation Ensures You Are GDPR Compliant

White Papers

Learn how WhereScape automation helps your organization deliver key requirements of the General Data Protection Regulation (GDPR) and avoid huge fines in the process.

Learn More

9sight Consulting – Meeting The Six Data Vault Challenges

White Papers

Industry expert Dr. Barry Devlin shares the six most common issues organizations have encountered when implementing the Data Vault 2.0 methodology and provides practical advice on how to successfully overcome.

Learn More

Turning The Data Vault Methodology Into A Practical Reality

Webinars

Review this recorded webcast and learn from industry expert Dr. Barry Devlin of 9sight Consulting how you can benefit from Data Vault 2.0 within your organization and easily overcome the six most common issues to its adoption.

Learn More

WhereScape® Automation for Snowflake™

Brochures

Wherescape® automation for Snowflake combines the best practices and native capabilities of Snowflake with automation to help its teams deliver actionable, reliable data infrastructure projects in the cloud faster. From data warehouse design and development to deployment and operation, WhereScape removes the repetitive and time-intensive so you can more quickly support the business with solutions that are primed and ready for change.

Learn More

#InsideAnalysis Streaming Radio Show & Deep Dive Webcast

Webinars

WhereScape® automation for Snowflake debuts on #InsideAnalysis Streaming Radio Show & Deep Dive Webcast

Learn More

WhereScape® Data Vault Express™

Brochures

Automate the design, creation, and operation of enterprise Data Vaults with WhereScape® Data Vault Express™, specifically engineered and integrated for Data Vault 2.0.

Learn More

9sight Consulting - Into the Data Vault via Data Warehouse Automation

White Papers

Barry Devlin, the founder and principal of 9sight Consulting and one of the founders of data warehousing, offers his thoughts on how Data Vault and WhereScape combine to deliver robust yet agile design and highly automated, repeatable delivery of enterprise data warehouses.

Learn More

Automation Drives DW Development at Delta Community Credit Union

Webinars

Watch this webinar replay to learn how Delta Community Credit Union used WhereScape’s automation software to quickly build a Teradata data warehouse with a limited staff and budget that immediately delivered business value.

Learn More

Automating Data Warehouse Development at WSECU

Webinars

Watch this webinar replay to hear Joe Horton share how WSECU is using WhereScape’s data warehouse automation software to integrate new subject areas into its Microsoft SQL Server data warehouse with speed and agility.

Learn More

Accelerating Data Vault 2.0 Development with Data Warehouse Automation

Webinars

Are you currently working with Data Vault 2.0 or considering it? WhereScape and our strategic partner, Data Vault Inventor Dan Linstedt, invite you to watch a replay of our webinar to hear the latest updates on Data Vault 2.0 and how data warehouse automation enables rapid and agile Data Vault 2.0 development.

Learn More

Getting Your Analytics Platform up to Business Speed

Webinars

If you think building out a data warehouse to optimize agility is too complex and time-consuming, think again. Tune in to learn about the importance of connecting data-driven analytics with business outcome and the latest tools for rapidly building out a data warehouse.

Learn More

Vodafone Netherlands

Videos

Watch this video to learn how WhereScape’s automation solutions helped solve the data integration challenges at Vodafone Netherlands. Vodafone is using WhereScape to generate Data Vault 2.0 models for its Teradata data warehouse. Watch to learn more.

Learn More

451 Group Report: WhereScape has Designs on Total Data Warehouse Automation

Data Sheets

The DWA specialist is seeing increasing demand for its data-warehouse design and development software on Apache Hadoop, complementing its existing support for a variety of analytic databases.

Learn More

Forrester Report: Data Warehouse Automation Helps Close the Data-To-Insight Gap

Data Sheets

Agile business intelligence (BI) platforms only partially support the iterative development of BI applications. Parts of the process, like data integration and modeling, still follow a less flexible waterfall development life cycle. 

Learn More

Renold

Case Studies

WhereScape provides missing link for Renold’s Business Intelligence.

Learn More

Key Findings: EMA Research Study on Data Warehouse Automation

Data Sheets

EMA, a leading IT and data management research and consulting firm headquartered in Boulder, CO, implemented the study to investigate the adoption of data warehouse automation strategies within a community of organizations.

Learn More

Automation “Makes the Grade” at Cornell University

Webinars

Watch a replay of our second in a series of webinars focused on the higher education market.

Learn More

Hall Hunter Partnership

Case Studies

Hall Hunter calls on WhereScape to deliver quick, accurate insight from complex data processing.

Learn More

Welcome to Teradata Partners

Videos

Meet WhereScape at Teradata Partners, the world's preeminent data conference.

Learn More

WhereScape and Data Vault 2.0

Data Sheets

Developing Data Vault models with agility is crucial to building today’s modern data warehouse. The project and database design need to react to a progressively deeper understanding of data, data quality, data opportunities and adapting requirements as the project evolves.

Learn More

Vodafone Netherlands

Case Studies

WhereScape talked with Jos Driessen, Manager, BICC Strategy & Architecture and Ronald Seinen, BI Architect, BICC Strategy and Architecture about Vodafone Netherland’s successes using WhereScape RED to generate Data Vault 2.0 models for its Teradata data warehouse.

Learn More

Cornell University

Videos

Watch this five-minute video to learn how Cornell University used WhereScape’s automation software to successfully migrate from IBM Cognos Data Manager to WhereScape RED for moving data into Cornell’s Oracle financial data warehouse. Watch Cornell Data Warehouse Manager Jeff Christen explain why “WhereScape is a good for higher ed and a great fit for Cornell.”

Learn More

Colorado Christian University Develops Microsoft SQL Server Data Warehouse with Agility

Webinars

Watch this webinar replay with WhereScape President Mark Budzinski and CCU Business Intelligence Manager Kevin McNamara to learn how CCU, aided by WhereScape’s automation software, deployed and manages a fully documented, metadata-driven data warehouse that is receiving high praise from University officials for its data-driven approach to reporting and analytics.

Learn More

Canadian National Railway Company

Videos

Hear Alain Bond, BI Manager for Canadian National Railway Company, discuss how CN used WhereScape to greatly enhance their agile development processes.

By taking this iterative approach, CN can respond to business units much faster and more efficiently. Watch the video clip to learn more.

Learn More

Group Health

Case Studies

Group Health coordinates health care and coverage for more than 600,000 residents of Washington and North Idaho.  Group Health used WhereScape RED to build and deploy a fully documented Enrollment and Membership subject area for its Teradata data warehouse that supports the healthcare provider’s reporting, governance and compliance efforts.

Learn More

Eckerson Group Profiles Data Warehouse Automation Pioneer WhereScape

White Papers

In this product profile and evaluation of WhereScape, learn why IT departments from over 700 unique businesses chose WhereScape to create subject-area data marts, new data warehouses, build prototypes, and more.

Learn More

How to Successfully Lead a Business Intelligence Project

White Papers

The primary reason why a business embarks on a business intelligence (BI) project is to gain knowledge that is used to make better, faster, and fact-based decisions to increase profits. Given the benefits and potential pitfalls, it is imperative that senior management ask AND answer 5 key questions about their BI project before they start and periodically to ensure they can effectively lead the project. Read the whitepaper now and find out from Adnan Chishti, Chief Risk Officer at Stone Milliner, what these key questions are.

Learn More

Data Warehousing, the Requirements Spiral

White Papers

Industry analysts have observed publicly that large-scale decision support systems — data warehouses, data marts, and business intelligence applications — have a dangerous characteristic.

Learn More

Canadian National Railway Company

Case Studies

The prototype and iterate approach using WhereScape’s data warehouse automation platform is working incredibly well at CN, dramatically aiding and increasing the delivery velocity and clarity in the early phases of our agile process.

Learn More

WhereScape Test Drive - Amsterdam

Videos

Watch this short video to experience a WhereScape Test Drive, where attendees learn first-hand about the power of data warehouse automation and build a fully functioning data warehouse in two hours.

Also hear from industry expert Rick F. van der Lans about how complex architectures and hand-coded ETL programs are no longer acceptable in this new BI world and why it’s time for automation of the data warehouse.

Learn More

Ask the Experts - Wayne Eckerson

Videos

Watch this short video to hear data warehouse and BI expert Wayne Eckerson explain why data warehouse automation is a must-have for organizations looking to accelerate the delivery of a data warehouse or data mart.

Learn More

Cornell University

Case Studies

WhereScape talked with Data Warehousing Manager Jeff Christen and Data Warehouse Developer Chris Grippin about the University’s conversion from IBM Cognos Data Manager to WhereScape RED. WhereScape RED is providing Cornell automated data integration for its Oracle data warehouses that manage crucial student, constituent and financial data.

Learn More

Ask the Experts Video - Dave Wells

Videos

Watch this video with Dave Wells, a leading authority on data warehouse automation, to hear how automation enables organizations to reduce the time to value from their data warehouse, BI, analytic and big data platforms.

Learn More

MGM Macau

Case Studies

MGM Macau, an award-winning premium integrated resort located on the Macau Peninsula used WhereScape RED Data Warehouse Automation software to build its data warehouse quickly and iteratively instead of the traditional approach of designing a complex enterprise data model up-front.

Learn More

Lamar Advertising

Case Studies

Lamar Advertising is using WhereScape to quickly develop targeted business solutions with agility.

Learn More

Weber State University

Case Studies

Weber State Develops Comprehensive Oracle Data Warehouse in Nine Months Using WhereScape. Founded in 1889, Weber State University is a coeducational, publicly supported university offering professional, liberal arts and technical certificates, as well as associate’s, bachelor’s and master’s degrees.

Learn More

One-On-One Series--Wayne Eckerson Interviews Mark Budzinski, Features Wherescape RED

Webinars

President of WhereScape, Mark Budzinski, and Wayne Eckerson, Founder and Director Eckerson Group, discuss the challenges and benefits of data warehouse automation today, the use cases for automation, key product differentiators that set WhereScape apart from the competition, and present a 5-minute demo of building a data warehouse with WhereScape RED.

Learn More

Infographic: EMA Data Warehouse Automation Survey Results

Infographics

Speeding Analytics Success with Data Warehouse Automation.

Learn More

Volkswagen

Case Studies

Volkswagen Commercial Vehicles (VGSG) has selected a WhereScape Data Warehouse Automation solution to enable quick and iterative delivery of their Business Intelligence (BI) goals.

Learn More

Smith & Williamson

Case Studies

Smith & Williamson is an independently owned professional and financial services group and is one of the top ten largest firms of accountants in the UK. As part of their IT landscape program of modernization, WhereScape was chosen to automate the design, implementation and operation of a SQL Server data warehouse, allowing it to migrate off a legacy platform.

Learn More

Union Bank

Videos

Learn how Union Bank used WhereScape RED’s data warehouse automation solution to achieve a 5x performance increase in developer productivity. Watch the video now.

Learn More

The Evolution of Data Warehouse Automation

Webinars

While the ongoing work of delivering business value through daily decision making still continues through business intelligence and data warehousing efforts, a quiet but conspicuous evolution has occurred in the ease with which these projects proceed. Data warehouse automation (DWA) has spurred that evolution.

Learn More

BBBT Podcast/WhereScape & Data Warehouse Automation

Podcasts

Is ETL still the answer for heavy duty data integration? What about Data Warehouse Automation (DWA) – where does that fit, and when should I use it? This presentation will position DWA and WhereScape’s comprehensive DWA offering.

Learn More

Eckerson Group: Data Warehouse Automation Tools – Product Categories and Positioning

White Papers

Eckerson Group is a research and consulting firm that helps business and analytics leaders use data and technology to drive better insights and actions with the overall purpose of helping companies develop strategies to maximize their investment in technology.

Learn More

WSECU - Washington’s Second Largest Credit Union

Videos

Learn how WSECU has used WhereScape’s data warehouse automation software to integrate new subject areas into its Microsoft SQL Server data warehouse in 3 weeks as opposed to 3-4 months.

Learn More

Mark Budzinski Interviewed by Wayne Eckerson at Teradata Partners

Podcasts

Mark Budzinski, President of WhereScape, and Wayne Eckerson of the Eckerson Group discuss how data warehouse automation can benefit organizations and IT departments in any industry by building and managing data warehouses of all shapes and sizes.

Learn More

WhereScape and the Modern Data Warehouse

Podcasts

This is an excerpt from an interview Bloor Group CEO Eric Kavanagh, conducted with Mark Budzinski, President of WhereScape, to discuss the findings of the research report, The Modern Data Warehouse: Agile, Automated and Adaptive.

Learn More

Union Bank

Case Studies

MUFG Union Bank, N.A., a full-service bank with offices across the United States, is using WhereScape RED to rapidly build Microsoft SQL Server business-facing data marts - in weeks instead of months - that are supporting critical reporting and analytic needs.

Learn More

Ask the Experts - Claudia Imhoff, Founder, Intelligence Solutions

Videos

WhereScape sits down with Claudia Imhoff to discuss how data warehouse automation achieves agility, increases productivity, reduces costs, and simplifies maintenance.

Learn More

Ask the Experts - Share Insight into Data Warehouse Automation

Videos

Industry experts talk about why data warehouse automation is important today; the need to automate big data; and how WhereScape is the key to accelerate development, deployment, and delivery. Experts cited from TDWI. Intelligent Solutions, InfoCentric, Enterprise Managing Associates, The Bloor Group, and more.

Learn More

BBBT Podcast / WhereScape & MedAssets

Podcasts

At this BBBT gathering, Claudia Imhoff talks with WhereScape CEO Michael Whitehead and Chris Stewart of MedAssets.

Learn More

Ask the Experts - John Myers

Videos

John Myers discusses the impact of big data on development.  

Learn More

Ask the Experts - David Stodder, Director of Research Business Intelligence, TDWI

Videos

WhereScape and David Stodder discuss new trends in data warehouse automation and how agile data warehouse tools deliver business value.

Learn More

Ask the Experts - William McKnight, President, McKnight Consulting Group

Videos

Watch as William McKnight, President of McKnight Consulting Group, explains how organizations can achieve agile data warehouse development and the role data warehouse automation plays in achieving rapid time to value.

Learn More

Ask the Experts - Len Silverston, Founder, Universal Data Models

Videos

WhereScape and Len Silverston discuss critical aspects of data modeling and agile data warehouse development necessary to deliver business value.

Learn More

Delta Community Credit Union

Videos

Watch this short video to learn how Delta Community Credit Union used WhereScape’s automation software to quickly build a Teradata data warehouse with a limited staff and budget that immediately delivered value to the business and is a “huge success story and something the credit union is very proud of.”

Learn More

MedAssets

Videos

Learn how MedAssets has helped hospitals improve operational efficiency and increased revenue performance using data warehouse automation. Watch the video now.

Learn More

Ask the Experts - Robin Bloor, Chief Analyst, The Bloor Group

Videos

WhereScape sits down with Robin Bloor to discuss strategies for integrating new data sources into your organization and why data warehouse automation can be the answer.

Learn More

Ask the Experts - Krish Krishnan

Krish Krishnan’s perspective on the evolution of big data integration within the enterprise. 

Learn More

Ask the Experts - Ralph Hughes, Chief Systems Architect, Ceregenics

Learn the four pillars of agile data warehousing and the real-world business benefits of data warehouse automation in this interview with Ralph Hughes, Chief Systems Architect for Ceregenics.

Learn More

Xero - The World's Most Beautiful Accounting Software

Learn how Xero used WhereScape’s data warehouse automation software to rapidly build a Microsoft SQL Server data warehouse. Xero will also be using WhereScape RED to migrate from SQL Server to Redshift on the Amazon Web Services platform quickly and painlessly.

Learn More

Ask the Experts - Chris Adamson

Watch this three minute video with data modeling expert Chris Adamson to learn the challenges associated with building a good data model, as well as the unique skill set required of a great data modeler.

Learn More

Video: Ask the Experts - Interview with Mark Peco, Partner at InQvis, Inc.

Watch as Mark Peco, Partner at InQvis Inc., discusses information requirements gathering and the importance of data automation in gathering timely and valuable information for end-users. Peco offers his insight into the discovery process that is inherent in information gathering.

Learn More

EMA Review: Data Warehouse Automation Changes Everything

Infographics

Industry analyst firm, Enterprise Management Associates (EMA), provides insight into Data Warehouse Automation (DWA), as the key to competitive advantage in our modern data-driven analytical culture

Learn More

Ask the Experts - Lawrence Corr, Author of 'Agile Data Warehouse Design'

Hear Lawrence Corr talk about how WhereScape is uniquely placed to help organizations take a truly agile approach to managing increasing data volumes and complexity.

Learn More

Ask the Experts - Ronald Damhof, Principal Consultant, Prudenza

Ronald Damhof talks about the importance of understanding ALL of the data and how this can only be made possible by automation techniques such as WhereScape.

Learn More

WhereScape Test Drive

Watch this short video to experience a WhereScape Test Drive, where attendees learn first-hand about the power of data warehouse automation and build a fully functioning mart in two hours.

Learn More

The Body Shop

Case Studies

Using WhereScape, The Body Shop Indonesia team were able to deliver a fully functional new data warehouse system in just three months, smashing the previous development estimate of 12 months.

Learn More

New Zealand Lotteries

Case Studies

Using WhereScape RED, New Zealand Lotteries (Lotto NZ) quickly delivered accurate and timely customer data enabling informed business decisions.

Learn More

Let’s not repeat past mistakes with Big Data

Data Sheets

It's been 15 years since the data management (DM) industry botched the decision support revolution by delivering inflexible data warehouse systems and developing unusable business intelligence (BI) tools.

Learn More

Tackling the success conundrum with data warehouse automation

Data Sheets

Automation has the potential to free scarce resources for high-value tasks in data warehousing, business intelligence and big data teams. It can also enable IT teams to rebuild cordial, collegial relationships with internal customers in business units and functional groups at a time when their attention and budgets are shifting toward other sources of ingenuity for business intelligence and advanced analytical needs.

Learn More

The data warehouse isn’t dead: it just needs an automation overhaul

Data Sheets

Traditional data warehouses are so last millennium – automation brings us up to date and ready for the future.

Learn More

SKYCITY Entertainment Group

Case Studies

SKYCITY has found that the specific, timely access to data has made a huge difference. Data from all over the business is integrated and can be used to create manual reports for specific analysis or in automated daily reporting – critical data for all levels of the business. Since its initial implementation a decade ago, the WhereScape’s Data Warehouse Automation solution has formed a framework for data management and decision making – and its flexibility has kept up with the business’s great growth and change.

Learn More

First Data

Case Studies

The results of the first project with MIP and WhereScape RED were so good that First Data has since commissioned another two data warehouse projects for other parts of the business. “We used to take two weeks to create end-of-month reports using macros and manual processing,” Richard says. “Now the information is available in real time, directly to the users.”

Learn More

Mark Budzinski on the BBBT

Podcasts

President of WhereScape, Mark Budzinski, joins Dr. Claudia Imhoff, President of Intelligent Solutions at the Boulder BI Brain Trust.

Learn More

BBBT Podcast / the landscape of data warehouse automation

Podcasts

Michael Whitehead joins Claudia Imhoff on the Boulder BI Brain Trust podcast to analyze the landscape of data warehouse automation and how to adapt as the technology evolves.

Learn More

BISUM Podcast / ROI, TCO & the extended data warehouse

Podcasts

Financial justification is critical in any project, and data warehouses are no different. Following on from an ROI presentation at the Pacific Northwest BI Summit, WhereScape CEO Michael Whitehead talks with Claudia Imhoff, President of Intelligent Solutions, Inc. and Founder of the Boulder BI Brain Trust.

Learn More

Podcast: TDWI Las Vegas Podcast / WhereScape 3D & the data warehouse landscape

Podcasts

Eric Kavanagh of DM Radio talks with WhereScape CEO Michael Whitehead at the TDWI Las Vegas show, about WhereScape 3D, the data warehouse landscape, and looking to the future.

Learn More

White Paper: WhereScape - Automated DW Development

Useful data sources are on the rise and business users are continuously demanding faster access to data due to the increased pace of change in data warehouse design. Data warehouses are no longer static or simplistic in design, but with automation the building and maintenance of a new data warehouse becomes easier than ever before.

Learn More

The Case for Data Warehouse Automation

White Papers

This whitepaper takes a deep dive into the historical processes that have long positioned data demand and data delivery–and thus, IT and business–against one another. 

Learn More

White Paper: Delivering Data warehouses on Microsoft SQL server

White Papers

Understanding the differences in architecture, approach and benefits between Microsoft SQL Server Integration Services (SSIS) and WhereScape® RED automation software is integral to choosing the right toolset for your data infrastructure project. This white paper provides an overview of both offerings to help you gain a clear grasp of the functionality each offers and which approach is best suited to the development methodologies and vision within your IT organization.

Learn More

Wherescape RED Technical Architecture

White Papers

WhereScape RED is an integrated development environment (IDE) for developing and managing data warehouses. It can be used to build SQL Server, Teradata, Oracle or DB2 data warehouses. The output from a WhereScape RED project is a data warehouse built in a supported database platform – the Target Data Warehouse.

Learn More

The Revolution Will Not Be Visualized

White Papers

Business people use information to inform and, increasingly, to drive the decisions they make. They don't just want more data and more analytic functionality, they want accurate data, valid facts, and qualified analytic insights. They want to make better decisions faster. But how?

We’ve made a mess of analytics almost from the beginning.

For too long, BI practitioners exerted too much control over data and sources; recently, the pendulum has swung in the other direction. The trend du jour is to open up the data connectivity fire hose, give users unfiltered access to information, equip them with data visualization frontend tools, and let them have at it.

Problem solved. We can all go home now.

This completely misses the point. At the very least, it’s bad framing. The problem isn’t one of control—e.g., of IT groups that exert too much control, of self-service tools that put more control into the hands of users. The core issue is improving and accelerating decision making.

To read more please download the full White Paper below.

Learn More

Let's Not Screw This Up

White Papers

If you're at all familiar with whom I am and what I do, you’d probably identify me as a big data skeptic. In the present instance, however, I’ve come to praise big data.

Big data matters because it has cachet. Just about everybody – from the person in the street to the C-level executive on high – has heard of it. The executives are alert to DM and to DM-related issues in ways they haven’t been for almost two decades. They’re interested in what’s going on. The practical effect of this is that IT and DM are relevant again. 

I see this as a critical second chance.

Fifteen years ago, we in DM botched the decision support revolution. In an atmosphere of excitement, optimism, and critical C-level buy-in, we set the bar too high, neglected to manage expectations, and categorically failed to follow through. We delivered inflexible data warehouse systems. We developed unusable business intelligence (BI) tools. We forced organizations to change their business processes to suit our own product agendas. And in the nascent Age of Big Data, we’re gearing up to do it all over again.

Big data matters because it has cachet. Just ABOUT EVERYBODY – from the person in the street to the C-level executive on high – has heard of it.

To read more please download the full White Paper below.

Learn More

Data Driven Design for Data Warehousing

Though data warehousing is now seen as a de facto foundation of most businesses, organizations continue to struggle with maximizing success when it comes to warehousing data. In this research report, William McKnight lays out the need for better communication and cooperation between business decision makers and warehouse developers to prevent gaps in success.

You’ll learn…

  • How the data warehouse development team can build scalable warehouses and deliver timely data
  • What the data model method is and why it should be the foundation for warehousing development
  • The key principles of data driven design that developers need to know

SUCCESS THROUGH SPEED AND MINIMIZING COST

INTRODUCTION

Data warehousing has long been a staple of organizations of all sizes. Early systems ran the business, but as data became moderately important to access for company gain, the architecture limitations of the systems were soon exposed and copies of the data were made for reporting. As it turned out, copying that data was not enough, nor was data warehousing as simple as it sounded. Some best practices emerged, books were written and some science and homogenous approaches were adopted to accommodate the growing data volumes, user communities and data access requirements.

To read more please download the full White Paper below.

Learn More

What’s your story?

White Papers

Turn User Stories into Working Data Warehouses with WhereScape RED

AGILE REQUIREMENTS

Feature-led or story-led development is a proven Agile method for efficient data warehouse delivery. With this method, developers rely less on an exhaustive specification of requirements, and more on close collaboration with actual users to get a flexible, intuitive understanding of how to create business value through the data warehouse project.

WhereScape RED is ideally suited for story-led development. Among the most valuable features are:

  • Automation: Coding of the routine components of the data warehouse is automated by WhereScape RED, so developers can spend more time working with users and refining the final product. If less time is spent on error-handling code, documentation, and the operational framework, then more time can be spent working with users to refine business logic and presentation.
  • Speed: DW development with WhereScape is so quick that the database design and transformation logic can be refined through rapid iterations and user input rather than detailed specifications. Tables can be redefined and reloaded in minutes so that a variety of approaches can be tried out quickly.
  • Quality: Agile methods emphasize quality and supportability throughout the development process. WhereScape RED helps deliver quality product by automating documentation, source data tracking, coding and naming standards, and many other important features as the data warehouse is developed.

The core of agile development is the user story. Rather than calling out each specific data element and report options for a data warehouse, the user story describes a user solving a real-world business problem with the perfect software ready at hand. The user story then serves as a guide as developers plan the project and develop the system. The project team breaks down the user stories to determine the development tasks that will guide the project.

To read more please download the full White Paper below.

Learn More

Understanding the Data warehouse life cycle

White Papers

UNDERSTANDING THE DATA WAREHOUSE LIFE CYCLE

ABSTRACT

Despite warnings made by W.H. Inmon and others at the outset of the data warehousing movement in the early 1990s, data warehousing practice for the past decade at least has been prefaced on the assumption that, once in production, data warehouses and data marts were essentially static, from a design perspective, and that data warehouse change management practices were fundamentally no different than those of other kinds of production systems.

The pace of business change, combined with the ongoing search for competitive advantage through better decision-making in a climate characterized by commodity transactional systems and (increasingly) commodity decision support infrastructure, underscores the extent to which an organization’s understanding of, and control over, the entirety of the data warehousing lifecycle model can mean the difference between competitive differentiation on the one hand, and millions of dollars in cost sunk in brittle dead-end data warehousing infrastructure on the other.

OVERVIEW

In Building The Data Warehouse, published in 1991, W.H. Inmon made the observation that: The classical system development lifecycle (SDLC) does not work in the world of the DSS analyst. The SDLC assumes that requirements are known at the start of the design (or at least can be discovered). However, in the world of the DSS analyst, requirements are usually the last thing to be discovered in the DSS development lifecycle (p. 23).

At that time, Inmon advocated a data-driven approach to designing data warehouses, pointing out that (a) data warehouse analysts frequently understood their requirements, and the data available to them, only after they had the opportunity to perform various kinds of analysis on that data, and (b) the traditional waterfall oriented models of software development (particularly those enforced by high-end computer-aided software engineering, or CASE, tools) were unlikely to produce workable data warehousing environments.

Learn More

The dimensions of fast

White Papers

THE DIMENSIONS OF FAST

WhereScape RED enables developers to build, prototype and enhance data warehouses 10 to 100 faster than with traditional products. Since WhereScape RED enables this kind of massive productivity boost, why are some projects 100 times faster, some only 10 times faster, and some projects take the same amount of time?

Having a product that enables rapid development is critical to the increased productivity, but clearly there are other factors that influence the amount of time a project takes.

The critical factors that impact speed of delivery are:

  • Rapid development product
  • Approach
  • Data availability
  • Key user availability
  • Governance framework
  • Team size
  • Team experience
  • Technology

FACTORS IMPACTING SPEED DELIVERY

RAPID DEVELOPMENT PRODUCT

A rapid development product is critical to achieving orders of magnitude increases in productivity. WhereScape RED has been designed from the ground up to speed delivery. It has been designed and tested by data warehouse practitioners, and is built on real world experience not academic notions. Projects have been analyzed and dissected to see where the timeis spent, and input has been sought on how to reduce elapsed time and as well as effort.

To read more please download the full White Paper below.

Learn More

Technical Paper: SQL Server Data Compression

Data Sheets

Data compression has been around a while in SQL Server, being first introduced in SQL Server 2008, prior to this SQL Server 2005 supported a form of compression using a data type called Vardecimal. Vardecimal is a deprecated feature in SQL Server 2012 enabling this feature in new installations should be carefully considered. Data Compression is an Enterprise only feature.

Learn More

RED and SSIS integration

White Papers

The purpose of this document is to demonstrate how quick and easy it is to integrate external Microsoft SQL Server Integration Services (SSIS) packages developed using Microsoft tools like Visual Studio into a RED data warehouse environment.

Learn More

The Case for Big Data Automation

White Papers

Review this white paper to understand how automation answers big data integration needs.  

Learn More

Man Group Plc

Case Studies

Man went through nearly a year of what was characterised as a “painful development process,” until they discovered WhereScape RED, an integrated development environment that builds, documents and maintains the entire data warehouse lifecycle.

Learn More

Jersey Electricity

Case Studies

Smart Metering has enabled JE to improve their engagement with customers. Accurate time of day usage information enables customers to adapt their energy usage, taking advantage of off-peak tariffs offered by JE in order to reduce their electricity bills. At a time when some global energy suppliers are perceived to be making large profits at the expense of their customers, JE have a true competitive advantage.

Learn More

Auckland Council

Case Studies

After Auckland Council was formed in 2010, they asked WhereScape to help with data integration for an Enterprise Data Warehouse. Each council came with its own systems, data and processes, so it was a big challenge. WhereScape developed a Data Warehouse solution and reporting platform using WhereScape RED as the foundation.

Learn More

Abano Healthcare Group

Case Studies

The WhereScape RED and 3D solution lets the Abano team create a report that shows ROI on marketing in 15 minutes – which was impossible before the WhereScape Data Warehouse was created. This level of detail helps the team make informed decisions about marketing spend and value to the company and proves that the marketing efforts have a positive ROI.

Learn More

A Leading Automotive Company

Case Studies

A leading automotive company needed to combine sensor data with operational data to deliver compelling offers, provide greater customer service and improve profitability - an integrated Enterprise Data Warehouse with a single global modelling standard; automated and managed by WhereScape, now allows the company to get value from their sensor data, shortening times to market and delivering BI solutions faster than ever before.

Learn More

WhereScape RED

Data Sheets

WhereScape RED is the best software for designing, loading, building, rebuilding and managing enterprise data warehouses and data marts. It sets the standard for the speed with which data warehouses and data marts can be developed and deployed.

Learn More

WhereScape 3D

Data Sheets

WhereScape 3D (data driven design) is data warehouse planning software designed to help you easily explore and understand your data warehousing project at the time you need it most – the beginning. WhereScape 3D is a comprehensive data warehouse design tool that incorporates data into the design process leading to better designs, less surprises and lower risk.

Learn More

Wherescape RED for Teradata

Data Sheets

WhereScape RED is an Integrated Development Environment for designing, loading, building, rebuilding and managing Teradata enterprise data warehouses and data marts. It sets new standards for the speed with which data warehouses and data marts can be developed and deployed.

Learn More

WhereScape RED for Big Data

Data Sheets

Automating the integration of enterprise and big data, WhereScape RED is data warehouse and big data automation software for building, deploying and renovating your analytic solutions whatever the size of your data.

Learn More

Wherescape RED and Tableau

Data Sheets

With WhereScape RED’s Tableau Integration Suite, you can automatically find the impact to your Tableau workbooks of any Data Warehouse change.

Learn More

Extracting Data From SAP Using WhereScape RED

Data Sheets

The WhereScape RED SAP extract solution gives you access to every type of object in SAP with a standard drag and drop interface.

Learn More

WhereScape Product Overview

Brochures

WhereScape is the pioneer and a world leader in data warehouse automation software. This brochure offers an overview of our software products: WhereScape RED and 3D.

Learn More

Doing Much More With Much Less: The Case for Data Warehouse Automation (eBrief)

White Papers

Understanding the data conundrums that IT teams face today is critical to finding a solution to business needs. This two-page eBrief offers a case for the modern-day automation solution and the necessary steps to get there.

Learn More

Teradata and WhereScape

Brochures

Teradata – the world leader in data warehouse technology – has teamed with WhereScape to create an integrated development environment for designing, loading, building and managing your Teradata data warehouses.

Learn More

Teradata and WhereScape 3D - Alliance

Brochures

The overriding goal of the Teradata and WhereScape partnership is to deliver demonstrable value to your business as quickly as possible and to maximize the return on your Teradata investment.

Learn More

WhereScape RED for Microsoft SQL Server

Brochures

Experience agile data warehouse development for Microsoft® SQL ServerTM with WhereScape’s data warehouse automation solution. WhereScape RED is an end-to-end, data warehouse development environment optimized for Microsoft SQL Server, including support for SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).

Learn More

Wherescape RED for Pivotal Greenplum

Brochures

WhereScape RED is an agile data warehouse development and management solution that automates much of the data warehouse life cycle—from initial scoping, prototyping, loading and populating to ongoing management and optimization. In addition, WhereScape RED automates the creation and management of documentation, diagrams and lineage information.

Learn More

WhereScape Quick Start

Brochures

WhereScape Quick Start will get your data warehouse off to a rapid and efficient start. Using industry best practice, leading data warehouse automation software and skilled data warehouse and business intelligence consultants, WhereScape will deliver a fully operational data warehouse in weeks.

Learn More

Insight-Accelerator

Brochures

With the Insight Accelerator you get a single global view of the business that arms business user s with all the information they need to make data-driven decisions. For IT, the Insight Accelerator dramatically simplifies the process of managing data, enabling them to respond to changing business needs fast.

Learn More

RED Clouds

White Papers

At WhereScape we have started to be asked about data warehousing in the cloud. Currently the questions we are fielding are primarily relating to the cloud as infrastructure, rather than on models for enterprise data warehousing in the cloud.

Learn More

Big data analytics: it’s big but is it clever?

Data Sheets

Everyone is talking about the opportunities in, and the possibilities of Big Data. With new and more accessible technology, there is now an opportunity to analyze exciting data which was previously impossible (or uneconomic) to do.

Learn More

WhereScape RED Tabular Models How-To

Videos

This video is a very simple walk-through of the support for SQL Server Analysis Services Tabular Models delivered in WhereScape RED 6.8.6.0.

Learn More

How Zeppelin Unified Their Data Infrastructure with WhereScape

Videos

This video explains how Zeppelin, a company with a EUR 2.36bn turnover operating in 35 different countries, use WhereScape to centralize their disparate data infrastructure.

Learn More

The Right Data Warehouse: Automation Now, Business Value Thereafter

Webinars

In the Big Data shuffle, everyone is looking at Hadoop as the answer to collect interesting data from a new set of sources. While Hadoop has given organizations the power to gather more information, the question remains: which data, regardless of source, structure, are significant for affecting business value – and how do we harness it?

Learn More

Q&A: Save Time and Money with Automated Data Warehouse Development

Data Sheets

TDWI defines data warehouse automation as "using technology to gain efficiencies and improve effectiveness in data warehousing processes. Data warehouse automation is much more than simply automating the development process. It encompasses all of the core processes of data warehousing including design, development, testing, deployment, operations, impact analysis, and change management.

Learn More