Data Warehouse & BI

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:BigDataCube

  • 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:

LocationProject / ModuleToolSector
BC, CAMMR (Materials Management Reporting), DW, BI, Star SchemaVP SDEPublic
BC, CABusiness Objects / Crystal Reports for numerous BC and AB clients BOPrivate
BC, CAOracle Business Intelligence Enterprise Edition workshopOBIEEPublic

Should you have any questions, please let us know. Start saving on your IT costs today.contactus4