Data Warehousing

The Data Warehouse provides the foundation for the Business Intelligence by providing the appropriate data in accessible and understandable form. The animation below represents a typical Data Warehouse Logical Architecture and highlights key elements of the architecture.

The two most important activities in the development of Data Warehouse are the design of a sound data model and development of effective ETL processes.

The data model translates business concepts into a logical format that is efficient and maintainable. All Altis consultants are formally trained in dimensional modeling an our approach includes milestone reviews where solutions are critiqued by fellow team members.

In addition, the Altis team are trained in multiple ETL tools and leverage their internal knowledge-base for support. The three typical engagements that we participate in are:

  • Data Warehouse implementation
  • Data Mart development
  • Health Checks

 

News


» Staff News
» Melbourne Comedy Club - October 2009
» Planet Ark National Tree Day - August 2009
» Read More


» Altis in the Press

» Business Intelligence: Maximising data collation for end users - July 2010
» Organisations fail to measure the costs of information and system defects - July 2010
» Altis Consulting Recognised in BRW's Annual Best Places to Work in Australia - June 2010
» Finding your car made easier - June 2010
» Survey Shows Data Visualisation a Growing Priority for BI Deployments - March 2010
» Lack of data clarity possibly spurred GFC - March 2010
» Read More

 

Education

 

» Dimensional Modeling in Depth (DMD) Course
Ralph Kimball and Margy Ross (co-authors of the best selling Data Warehouse Toolkit) are coming back to Sydney in Sep 2010 to present this popular course. Take advantage of this opportunity and register quickly as it will sell out.

Early bird pricing ends 31 May 2010
See registration page for 2 course rate deal
Kimball University LogoSydney 7-10 Sep 2010

» Registration Now Open
» Course Brochure

 

» ETL Architecture in Depth (ETLD) Course
Learn about the 34 ETL subsystems from the co-authors of the best selling Data Warehouse ETL Toolkit: Ralph Kimball and Bob Becker. A must attend course for those involved in the backend of the data warehouse.

Early bird pricing ends 31 May 2010
See registration page for 2 course rate deal
Kimball University LogoSydney 13-16 Sep 2010

» Registration Now Open
» Course Brochure

 

» Visual Business Intelligence Workshop
After 2 sold-out workshops in Sydney in Feb 2010, Stephen Few is returning to Australia AND New Zealand in Nov 2010. Stephen Few is a leading educator and author in data visualisation techniques.
Early bird pricing ends 30 June 2010
Kimball University LogoSydney 23-25 Nov 2010
Auckland 29 Nov-1 Dec 2010

» Registration Now Open
» Course Brochure (Sydney)
» Course Brochure (Auckland)

 

 

Altis Advantage

Read more about the advantages of working for Altis Consulting

» Employee Benefits
» Career Framework
» Altis Values
» Altis Environment Policy
» Job Postings in Australia & New Zealand