WhereScape is a data warehousing software company with offices in Portland

Portland, Oregon

Portland is a city located in the Pacific Northwest, near the confluence of the Willamette and Columbia rivers in the U.S. state of Oregon. As of the 2010 Census, it had a population of 583,776, making it the 29th most populous city in the United States...

 Oregon

Oregon

Oregon is a state in the Pacific Northwest region of the United States. It is located on the Pacific coast, with Washington to the north, California to the south, Nevada on the southeast and Idaho to the east. The Columbia and Snake rivers delineate much of Oregon's northern and eastern...

, Auckland

Auckland

The Auckland metropolitan area , in the North Island of New Zealand, is the largest and most populous urban area in the country with residents, percent of the country's population. Auckland also has the largest Polynesian population of any city in the world...

 New Zealand

New Zealand

New Zealand is an island country in the south-western Pacific Ocean comprising two main landmasses and numerous smaller islands. The country is situated some east of Australia across the Tasman Sea, and roughly south of the Pacific island nations of New Caledonia, Fiji, and Tonga...

 and Wokingham

Wokingham

Wokingham is a market town and civil parish in Berkshire in South East England about west of central London. It is about east-southeast of Reading and west of Bracknell. It spans an area of and, according to the 2001 census, has a population of 30,403...

 UK.

History

WhereScape was originally founded in Auckland, New Zealand during 1999 by co-founders Michael Whitehead (CEO) and Wayne Richmond (CTO). The company was formerly named Profit Management Systems, but due to expansion to America during 2002 the company was required to undertake a new image and officially changed their name to WhereScape.

WhereScape now operate out of regional headquarters in Portland – Oregon, Auckland – New Zealand, and Wokingham – England. Today, nearly 500 organizations worldwide use WhereScape software products.

WhereScape Products

WhereScape are an independent software vendor who plan, build and develop data warehouses

Data warehouse

In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.A data warehouse...

 and data marts

Data mart

A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse which is usually oriented to a specific business line or team.- Terminology :...

. WhereScape’s products are used in business intelligence

Business intelligence

Business intelligence mainly refers to computer-based techniques used in identifying, extracting, and analyzing business data, such as sales revenue by products and/or departments, or by associated costs and incomes....

 project in commercial environments: from normal-form

Fifth normal form

Fifth normal form , also known as Project-join normal form is a level of database normalization designed to reduce redundancy in relational databases recording multi-valued facts by isolating semantically related multiple relationships...

 enterprise data warehouses and data vaults

Data Vault Modeling

Data Vault Modeling is a database modeling method that is designed to provide historical storage of data coming in from multiple operational systems. It is also a method of looking at historical data that, apart from the modeling aspect, deals with issues such as auditing, tracing of data, loading...

, through user access layers and tiers of dependent data marts, to standalone data marts and reporting systems.

WhereScape 3D

This data driven design tool is WhereScape’s newest product (released May 2011). It is claimed to be the industry’s first planning and reality testing tool for data warehousing and business intelligence projects. The product produces project design documentation and an implementation-ready design through the process of source and target exploration and modelling, usability and data legibility, and scoping, sizing and costing activities. WhereScape 3D is compatible with WhereScape RED for automated build-out, or can be used for input to a manual build or a third party tool set.

WhereScape RED

This integrated development environment

Integrated development environment

An integrated development environment is a software application that provides comprehensive facilities to computer programmers for software development...

 (IDE) is claimed to transform traditional approaches to building, deploying, managing and renovating data warehouses and data marts. WhereScape RED unites source system exploration, ELT

Extract, transform, load

Extract, transform and load is a process in database usage and especially in data warehousing that involves:* Extracting data from outside sources* Transforming it to fit operational needs...

, dimensional

Dimensional modeling

Dimensional modeling is the name of a set of techniques and concepts used in data warehouse design. It is considered to be different from entity-relationship modeling . Dimensional Modeling does not necessarily involve a relational database. The same modeling approach, at the logical level, can be...

 and normal-form target schema design, and dependent cube

OLAP cube

An OLAP cube is a data structure that allows fast analysis of data. It can also be defined as the capability of manipulating and analyzing data from multiple perspectives...

-building construction with an integrated operations and management environment and a metadata repository

Metadata registry

A metadata registry is a central location in an organization where metadata definitions are stored and maintained in a controlled method.-Use of Metadata Registries:...

, allowing small teams of data warehousing professionals to implement data warehouses using agile

Agile software development

Agile software development is a group of software development methodologies based on iterative and incremental development, where requirements and solutions evolve through collaboration between self-organizing, cross-functional teams...

 methodologies, practising iterative-build-and-test disciplines and involving key end-users in the build process. All build-and-operate metadata is customizable, rewritable and stored in a central, managed and versioned repository, bringing application programming discipline, tool integration and automated documentation generation to data warehouse build projects.

Customers and Partnerships

Today, nearly 500 organizations worldwide — in every vertical market segment, and in the public and private sectors — use WhereScape software products. (CIO NZ Staff, 2010)
WhereScape customers include Fonterra

Fonterra

Fonterra Co-operative Group Limited is a New Zealand multinational dairy co-operative owned by almost 10,500 New Zealand farmers. The company is responsible for approximately 30% of the world's dairy exports and with revenue exceeding NZ$19.87 billion, is New Zealand's largest company.- History :In...

, SkyCity

SKYCITY Entertainment Group

Skycity Entertainment Group is a New Zealand corporation whose core business is owning and operating casinos in Australasia. It is the smallest of four major players operating in the market....

, ASB

ASB Bank

ASB is a New Zealand bank owned by the Commonwealth Bank of Australia, which is listed on the Australian Stock Exchange. It is one of the largest New Zealand banks, with branches throughout the country. It operates BankDirect, a branchless banking service that provides service via phone, Internet,...

, Vero, Vodafone

Vodafone

Vodafone Group Plc is a global telecommunications company headquartered in London, United Kingdom. It is the world's largest mobile telecommunications company measured by revenues and the world's second-largest measured by subscribers , with around 341 million proportionate subscribers as of...

 and the fast food chain Subway

Subway (restaurant)

Subway is an American restaurant franchise that primarily sells submarine sandwiches and salads. It is owned and operated by Doctor's Associates, Inc. . Subway is one of the fastest growing franchises in the world with 35,519 restaurants in 98 countries and territories as of October 25th, 2011...

.