Price: Check with seller



Data Warehousing Class Chennai provides real-time and placement focused Data Warehousing training in chennai with real-time project scenarios. We can guarantee classes that makes you as a Data Warehousing Expert. A Best Data Warehousing Training course that is exclusively designed with Basics through Advanced Data Warehousing Concepts. Data Warehousing Certification and Interview Guidance are provided during the course. All our training sessions are Completely Practical and Real Time.


Dimensional modeling is the proven technique for designing comprehensive, high-performance Business Intelligence/Data Warehouse (BI/DW) systems. Agile dimensional modeling is dimensional modeling done iteratively, incrementally and collaboratively.

This course provides in depth coverage of agile dimensional modeling techniques for improving communication between BI/DW teams and business stakeholders as well as responding to changing DW requirements. Specifically the course covers BEAM*, the powerful, yet simple method for ModelStorming directly with BI stakeholders described in the book Agile Data Warehouse Design: collaborative dimensional modeling, from whiteboard to star schema


In this agile data warehouse training, you will learn to:

    • Model data requirements directly with stakeholders

    • Translate common cross-industry data analysis requirements into efficient, flexible dimensional models

    • Maximize the usability and performance of your data warehouse or data mart designs

    • Plan, design and incrementally develop agile data warehouse solutions




This course is for anyone interested in learning the latest agile techniques for designing and managing dimensional data warehouses and ETL processes. Beginner, intermediate and experienced data warehouse practitioners, data architects, DBA’s and ETL designers & developers will all benefit from this course.

Agile Data Warehousing

  • What the Agile manifesto means for business intelligence/data warehousing

  • The challenge of proactive data warehouse development: the need for agile data modeling techniques

  • Becoming agile: supporting iterative and incremental data warehouse development


Dimensional Modeling Fundamentals

  • Data warehousing requirements, challenges and opportunities

  • Modeling for measurement: the case for dimensional modeling

  • Star schema, snowflake schema, facts and dimensions

  • Modeling with BI stakeholders: the case for Agile dimensional modeling


Dimensional ModelStorming

  • Business Event Analysis and Modeling (BEAM*): an agile dimensional modeling method

  • Creating inclusive data models using the BEAM* notation

  • ModelStorming: practical techniques for facilitating interactive modeling

  • Using the 7Ws framework (who, what, when, where, how many, why and how) to discover and document BI data requirements

  • Telling business event stories: modeling by example

  • Drawing hierarchy charts: modeling dimensional attributes and hierarchical relationships

  • Sketching timelines: modeling events sequences and business processes

  • Identifying Key Performance Indicators (KPIs) and Metrics: aggregation level, comparisons and query by exception

  • Test-driven design: using data profiling results to validate requirements models

  • Designing high performance star schemas

  • Refactoring stars: welcoming change and responding to it

More Details

Total Views:12
Reference Id:#464152
Phone Number:8939915577
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]