ASPE-IT offers a full line of hands-on SharePoint training for complete implementation, management and usability for all key functions in your enterprise.

 

ASPE-IT's proprietary Microsoft training gives you a real world, hands-on approach to address the implementation, maintenance & challenges of these products.

 

ASPE-IT offers real-world, independent training on Windows technologies giving you unbiased hands-on knowledge of the products.

 

Implemented correctly, virtualization technologies have the potential to create vast improvements in the utilization of IT resources.

 

ASPE-IT offers networking courses that focus on skills and knowledge development. The course you take will dissect the technology, and teaching you the protocols that drive them.

 

ASPE-IT provides premier hands-on Linux skills and certification training through its partnership with Red Hat.

 

Organizing and managing a company's vital information is one of the most extreme challenges in the IT sector today. We'll give you the knowledge and skills to find actionable data.

 

The Java programming language has become the foundation of many of today's programming languages. We have training courses for people of all levels.

 
 

Fees starting at


Individual: $1295
Group (3+): $1095
GSA Individual: $971.25
GSA 3+: $821.25

Latest Blog Post from ASPE-IT

Upcoming FREE Online Events

Connect with ASPE-IT

  • ASPE RSS Feeds
  • ASPE Blog
  • ASPE on Twitter
  • ASPE on LinkedIn

   

COURSE 9160 | 2-DAY SESSION | 14 PDUs
Introduction to Business Intelligence



Build the right mix of project management and requirements gathering skills to make your data warehouse project stick.

Course Outline


Section 1: What is Introduction to Business Intelligence
Gain a solid understanding of Introduction to Business Intelligence 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