• ITB

    Training & Eduction

    ITBusiness and our partners have 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: Business Overview of Data Warehousing
    What is a data warehouse? Do we need one? What's so great about it? How does it affect my business, my department, and my job? Assuming no prior experience in data warehousing, this course will help attendees understand data warehouse basics and benefits, and how a data warehouse can affect their jobs. It provides a functional understanding of the ROI of a data warehouse, data warehouse basics, project management, architecture, critical success factors, risk factors, design, process, and tools. It also explains how a business intelligence system can use a data warehouse to deliver a competitive advantage in the marketplace. Using real-world experience, the instructor provides recommendations for getting started, including how to make sure that your objectives and needs are met. It provides an overview of the process that IT will go through on the data warehouse project so business users will know what to expect.

    Who Should Attend?
    Business users, sponsors, non-technical project managers, anyone who needs to learn the basics of data warehousing.

    What You Will Learn:

    • Concepts
    • Terminology
    • Processes of data warehousing and business intelligence
    • How a data warehouse fits in with other sources of information you're already using
    • Architecture overview - how a data warehouse is built
    • Challenges, success and risk factors of data warehousing
    • How to get a positive ROI on your data warehouse

    • Duration: 1 Day
      Enquire about dates or Register


      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 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


      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 latter part of the training will focus on some advance challenges we face, example are many to many relationships.

      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
      Enquire about dates or Register


      BI & DW Training: Project Management
      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.

      The data warehouse project manager must embrace new tasks and deliverables, develop a different working relationship with the users, and work in an environment that is far less defined than with traditional operational systems.

      The project management course helps managers develop the skills they need to usher their projects through all phases of planning and implementation. It provides a solid basis on: test data, metadata planning, data stewardship, governance, backup planning, ROI measurement, documentation, support preparation, user training, communications planning, and other elements of a successful data warehouse.

      Who Should Attend?
      This course is for business and technical managers who may be planning or managing a business intelligence application or data warehouse project, but is also suitable for anyone who wants to understand what is involved in managing either a business intelligence or data warehouse project.

      What You Will Learn:
      • How to identify business and technical drivers for the project
      • How to gather and prioritize business and technical requirements
      • How to scope out current and future project phases
      • The organizational and cultural issues, including staffing, roles, and responsibilities
      • How to manage user expectations for function, schedules, performance, and availability
      • How to identify critical success factors and mitigate risk
      • Data warehouse methodology, project planning, and project control

      Duration: 1 Day
      Enquire about dates or Register


      BI & DW Training: Master Data Management
      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: 3 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 itbusiness-training@itbusiness.co.za

    Our Courses

    For more information on these courses and course outlines, please contact the ITBusiness
    training division on (011) 462 7450 or email us at itbusiness-training@itbusiness.co.za
    Enquire about dates or Register


    Our Services

    Login form