Business Intelligence and Data Modelling


Business intelligence (BI) is a technology-driven process for analysing data and presenting actionable information to help executives, managers and other corporate end users make informed business decisions. Business intelligence can be used by enterprises to support a wide range of business decisions ranging from operational to strategic. Basic operating decisions include product positioning or pricing.

Data Modelling in software engineering is the process of creating a data model for an information system by applying certain formal techniques. Data modelling techniques and methodologies are used to model data in a standard, consistent, predictable manner in order to manage it as a resource. The use of data modelling standards is strongly recommended for all projects requiring a standard means of defining and analysing data within an organization, e.g., using data modelling

4 Days

  • Basics of Entity-Relationship (ER) and dimensional modelling
  • Benefits and applicability of Dimensional Data Modelling
  • how to create Dimensional Data Models for BI and DW applications
  • how to learn more about Data Modelling

  • Beginning Data Modelers
  • Business Analysts and Architects
  • Database Administrators and Analysts
  • Information Technology Managers, Project Managers
  • Application Development Project Team Members
  • People involved in design and maintenance of Data Warehousing and Business Intelligence applications
  • People involved in data quality or data governance processes

  • Basic familiarity with Windows Environment
  • Knowledge of RDBMS is helpful

Topics:  Day 1

Module: BI overview

Module: BI Architecture


Day 2

Module: DW-Data Modelling

Module: ETL concept


Day 3

Module: Case Study using ErWin


Day 4

Module: Case Study using ErWin