COURSE 9160 | 2-DAY SESSION
Business Intelligence & Data Warehousing for Project Managers & Business Analysts
Course Outline
Section 1: What is Business Intelligence & Data Warehousing
Gain a solid understanding of business intelligence and data warehousing and the role they play in today’s business world. Learn about the data to information life cycle as well as the different data warehousing philosophies defined by Bill Inman and Ralph Kimball.
- Brief History Of Accessing, Reporting And Analyzing Data
- Data to Information Lifecycle
- Business Intelligence (BI) defined
- Data Warehousing (DW) defined
Section 2: Data Warehousing Methodology
This chapters focuses on the process and approach (methodology) for successfully building integrated DW projects and some of the differences between DW and other IT projects.
- Project methodologies
- DW methodology
- Differences between DW and traditional IT projects
Section 3: Data Warehousing Processes
This section focuses on the importance of sponsorship, governance, and overall management and support. Project sponsorship is key to getting the senior management backing required to make a project successful. Continuing governance is vital to the projects overall success. You must build the appropriate team to build to provide oversight to both business and IT initiatives.
- Sponsorship & Governance
- Program Management
- Project Management
- Change Management
- Data Quality & Data Management
- Ongoing Administration & Support
Section 4: Data Warehousing Roles & Responsibilities
This section examines the roles and responsibilities of the team members on the data warehouse project. The structure of the team will be discusses as well as the critical balance between business and IT and staffing, training, and mentoring.
- Organizations
- IT And Business Interaction
- Context Of Roles & Responsibilities
- IT And Business Roles
- Skills And Training
Section 5: Data Warehousing Project Planning
This chapter thoroughly examines the major data warehouse project phases and the activities tied to them. Developing project scope early is key to the data warehouse project as well as establishing the right team to implement.
- DW Project Phases
- Major Activities and Deliverables
- Developing Scope & Building Business Case
- Assembling Team
- Staffing & Management
Section 6: Data Warehousing Assessment Activities
The chapter will focus on gathering the proper requirements from both the business and IT organizations as well as systems analysis and data quality
- Requirements Gathering
- Source Systems Analysis
- Data Quality & Integrity Metrics
Section 7: Data Warehousing Design Activities
This chapter focuses on the purpose and usefulness of a logical data model and the database design purpose of the physical data model. Both two-dimensional, entity- relationship based and the more popular multidimensional, star schema based database design architectures are discussed.
- Data Architecture
- Data Staging
- Data Modeling
- Database Design
Section 8: Data Warehouse Data Preparation Activities
This chapter will discuss the importance of data quality requirements to prevent data souring. Also the Extract, Transform, and Load (ETL) process of getting data into the data warehouse is discussed thoroughly.
- Data Souring & Quality Requirements
- ETL Architecture
- Designing & Creating ETL Processes
Section 9: Data Warehouse BI Activities
This chapter will focus on the actual reporting done and the business requirements that are tied to that. The major business intelligence tools are discussed as well as how to communicate with the business users.
- BI, Reporting & Analysis Requirements
- BI Architecture
- BI Tool Selection
- Design & Build BI Processes
- Business User Involvement
Section 10: Data Warehouse Testing, Deployment & Roll-out
The chapter discusses the Industry-wide testing, which consists of unit testing, integration testing, system and acceptance testing, and data warehouse testing. The deployment, rollout and ongoing maintenance are also discussed thoroughly.
- Testing
- Deployment
- Roll-out
- Ongoing Administration & Maintenance
Section 11: Conclusions
- Highlights
- References & Resources
