BRIAN CIAMPA
Enabling excellent decision making through data warehousing and business intelligence

Grow - Practice Using Your Data Warehouse Skills

As with anything, the only way to develop a skillset is to practice. The same is true with data warehousing. Because data warehousing involves taking a large amount of data and restructuring it in order to make it optimal for analysis, it can sometimes be difficult to come up with large amounts of practice data. This area of the site is designed to help with that. Fictitious source systems have been created specifically for your practice. Business process descriptions, ERDs, scripts to create the systems (with data) in Oracle, and suggested exercises are included with each one.

Restaurant Industry

General Information:
This enterprise system is used by a restaurant with multiple locations in various regions in the US. The system stores data related to the store location, seating of customers, menu items, and billing. The two main business processes that use this system heavily are described below.

More Information

Human Resources System

General Information:
This HR system is used by an organization to run payroll, track leave, store employee evaluation data, and store basic job appointment data. The three main business processes and an explanation of employee appointments are described below.

More Information

Images courtesy of FreeDigitalPhotos.net