KID : data warehousing courses

KID has developed and licensed the very best business intelligence training courses to ensure that its training delegates are equipped with practical knowledge and skills that can be used immediately in the work place. Business intelligence, data warehousing and data integration are our areas of expertise. Your company will benefit from our collective experience and specialised training methods - we are committed to transferring our knowledge to our delegates.
The courses we offer are:

BI & DW 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 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 ranges 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 include 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
Training Calendar
Course Enquiry/Registration

BI & DW Training: Basic Modeling
We'll be looking at the different methods of modeling used today and how to apply them. Our focus will change later to focus on the Ralph Kimball methodology of Multidimensional schema design. We will look at the various normal forms, keys, tables and relationships. This knowledge will be applied in a practical exercise. The later part of the training will focus on some advance challenges we face, example are many to many relationships. Project management is especially critical for a data warehouse project. Without good management, projects are prone to being short on required resources. They are late, over budget, low quality and, most importantly, they don't meet expectations.

Who Should Attend?
This course is intended for Business Intelligence or Data warehousing program managers, project managers and Data architects. Anyone who participates in making architecture and methodology decisions for data warehousing and business intelligence.

What You Will Learn:
  • Different schemas, Conceptual, Logical and Physical
  • Fact tables, Aggregate tables
  • Dimensions tables and type of dimension tables
  • Business intelligence applications, uses and users
  • Different keys, surrogate keys etc.
  • Relationships, including many to many relationships
  • How to identify business and technical drivers for the project

Duration: 1 Day
Training Calendar
Course Enquiry/Registration

BI & DW Training: Introduction to Master Data Management and Data Quality
Master data is a collection of key objects, around which the business processes of an enterprise can be modeled and analyzed. Master data can include structured data elements, such as commonly used entities, attributes, hierarchy definitions, and some unstructured data elements such as business rules.
Sharing data and relating it to other data is also a challenge when the organization does not know its master data and the meta data associated with master data, and does not understand the relationship between meta data and information intelligence.
This course will provide you with concepts, techniques and approaches to building a master data management program for your organization, and will provide a plan for implementing master data management throughout your enterprise. The workshop is built around actual case studies of an organization interested in developing and implementing a master data management program.

Who Should Attend?
- Data architects
- Enterprise architects
- Data administrators
- Database administrators
- Database designers
- Systems analysts
- Business analysts
- Project managers
- IT professionals

What You Will Learn:
  • The importance of master data management to the improvement of business information sharing and process alignment
  • The concepts and principles of master data management
  • How to scope out current and future project phases
  • The process of creating a master data management program
  • The key roles in a master data management organization, including data and meta data stewardship
  • Principles and practices in meta data and data governance through master data management
  • Issues, concerns and solutions to master data management and its implementation

Duration: 1/2 Day
Training Calendar
Course Enquiry/Registration

For more information on these courses and course outlines, please do not hesitate to contact the KID training division on (011) 462 1277 or email