Data Warehouse (DW) is a central repository used for data analysis and reporting. It consists of current and historical integrated data from one or more data sources. The data stored in the warehouse is loaded from the operational systems through ETL procedure. Data Warehouse is mainly for Online Analytical Processing (OLAP) purpose.
Following are a few key concepts:
- Star Schema and Snowflake
- Facts and Dimension tables
- Design methodologies
- Top-down
- Bottom-up
- Hybrid
Lionsgate Software developed ETL tool DataEx and has rich experiences on:
- Data Warehouse Modeling
- Conceptual, logical and physical DW modeling
- ER diagram or UML diagram
- ETL (Extract – Transform – Load)
- Data Management
- Metadata Management
- Master Data Management
- Reporting
- Business Objects / Crystal Reports;
- OBIEE (Oracle Business Intelligence Enterprise Edition)
Here are a few data warehouse projects that were achieved by us, with case study:
| Location | Project / Module | Tool | Sector |
|---|---|---|---|
| BC, CA | MMR (Materials Management Reporting), DW, BI, Star Schema | VP SDE | Public |
| BC, CA | Business Objects / Crystal Reports for numerous BC and AB clients | BO | Private |
| BC, CA | Oracle Business Intelligence Enterprise Edition workshop | OBIEE | Public |
Should you have any questions, please let us know. Start saving on your IT costs today.
