Concepts, Fundamentals and Architect

Business Intelligence & Data Warehousing Training: Concepts, Fundamentals and Architect

Working on a business intelligence (BI) or data warehousing (DW) project can be overwhelming if you don't have a solid grounding in the basics. It's difficult to focus on the goals of the project when you're bogged down by unanswered questions - or don't even know what questions to ask. By arming yourself with knowledge of the concepts and fundamentals, you can hit the ground running. This course provides an overview that gives business and information technology professionals the confidence to dive right into their business intelligence and data warehousing activities and contribute to their success.

The course begins by covering the business drivers for business intelligence and the technology drivers for data warehousing, so you'll have a context in which to understand how the project affects your business.

It then provides an overview of the uses and users of business intelligence, along with the type of applications and tools that may be deployed. Next is an introduction to data integration and data warehousing, identifying what lies at the heart of successful business intelligence implementations. Because business value is not derived by merely selecting the right tools, this course will also examine the staffing and planning, as well as best-practice approaches and structures for design, development and implementation. We use practical examples to illustrate technical theories, concepts and techniques, as well as the functions and tasks needed for successful projects. We'll describe, at a high level, how to develop a business intelligence application and its supporting data warehouse, along with an organization structure you could use. We'll talk about the various roles and responsibilities, as well as the associated skills that are needed. We'll identify critical success factors of a project, and cover a checklist of data warehousing considerations.

It's important to understand deliverables that may be produced throughout these projects and discuss the reasons for producing them. We'll talk about the best practices for getting the right deliverables for your users. A lot can go wrong when a data warehouse is built without a solid architecture. For example, the data reported from an organization's warehouse may not be integrated across the organization, so business users get confusing and conflicting results. And that's just the beginning. It's critical that a data warehouse support and reinforce the objectives of the entire enterprise, not just a single group.

The choice of architectures range from the "integration hub data warehouse" to "independent data marts", and different approaches including: top-down, bottom-up, and hybrid methodologies. This course explains the differences and helps you sort through the choices to determine the best fit for your organization.

We'll examine the size and scope of the data warehousing program, expected timing and frequency of deliverables, anticipated return-on-investment, staff size and skill, available tools and technology. You'll learn how to assess your resources and requirements, and then make informed decisions about the best data warehousing architectures and methods for your organization.

Who Should Attend?

This course is intended for business and technical managers who may be involved in the process of designing and implementing a business intelligence application or data warehouse. It is also for those who just need to understand what is involved in managing either a business intelligence or data warehouse project.

What You Will Learn

  • Basic concepts of business intelligence and Data Warehousing

  • Industry terminology

  • Critical success factors & risks

  • Business intelligence applications, uses and users

  • Data Integration Framework (DIF)

  • Data warehousing & business intelligence development processes

  • Culture, politics & organizations

  • Best practices

  • Industry trends

Duration: 2 Days

Enquire about dates or Register

For more information on these courses and course outlines, please contact the ITBusiness training division on (011) 462 7450 or email us at