About AimAxis:

AimAxis is a leading e-learning platform providing live instructor-led interactive online training. We cater to professionals and students across the globe in categories like Data Science, Artificial Intelligence (AI), R Language, Python, SEO, Digital Marketing, Photoshop, Google Cloud Platform (GCP), Amazon Web Services (AWS), DevOps, SAP-BO-XIR 4.1/R4.2, Data Warehousing, IBM Cognos BI, Informatica Power Center 9.6.1/10.1, OBIEE, MSBI, Power BI, Tableau, Big Data, Hadoop, Business Analytics, Mobile Technologies, System Engineering, Project Management, and Programming. We have an easy and affordable learning solution that is accessible to all of the learners. With our students spread across countries like the US, India, UK, Canada, Singapore, Australia, Middle East, Brazil, and many others, we have built a community of overall learners across the globe.

Data Warehousing Certification Training


  • Need of Data Warehousing
  • Definitions for Data Warehousing
  • Architecture of OLTP Systems
  • Drawbacks of OLTP Systems
  • Introduction to SOA (Service Oriented Architecture)
  • Difference between OLTP Systems and OLAP Systems
  • General Architecture of Data Warehousing
  • Different Approaches for DWH
  • Top Down
  • Bottom Up
  • Components of Data Warehousing
  • Modeling
  • Logical
  • Physical
  • Complete comparison
  • Data Modeling
  • Dimensional Modeling
  • Different Types of Dimensions
  • Normalized
  • De normalized
  • Different Types of Fact Tables
  • Periodic Snapshot
  • Accumulated Snapshot
  • Transactional grain
  • Fact less
  • OLAP system Design
  • Enterprise Data Warehousing
  • Data Marts
  • Independent
  • Dependent
  • ODS (operational Data Store)
  • Difference between OLTP, OLAP, ODS
  • Difference between DWH and Data Marts
  • Schemas:
  • Star Schema
  • Snowflake Star Schema
  • Galaxy Schema
  • Difference between E-R Model and Dimensional Model.
  • Working with data modeling concepts.
  • Conceptual model
  • Logical model
  • Physical model
  • Introduction to Erwin:
  • Design logical model with entities, attributes and relationships
  • Design Physical model with tables, columns and relationships
  • Working with identifying and non-identifying relationships
  • Explanation on different types of relationships:
  • Unary relationship
  • Binary relationship
  • Ternary relationship
  • Working with 1-m and m-m relationships
  • Working with bridge or associate tables
  • Working with forward engineering process
  • Working with reverse engineering process

Working complete comparison


All Courses

Preview Sample Certificate

Contact Us

We're not around right now. But you can send us an email and we'll get back to you, asap.

Not readable? Change text. captcha txt

Start typing and press Enter to search