Essentials of Business Intelligence
Overview
This 100% online certificate course serves as an introduction to the value and structure of the key concepts in enterprise business intelligence and the related field of business analytics. You will learn about Business Intelligence/Business Analytics Competency Centers (BICC or BACC) and study the core skills of data management, warehousing, business intelligence requirements, business intelligence program management and data quality management, while learning to make more effective and efficient business analytics decisions.
45 PDUs | 8 Continuing Education Units
80 Military Clock Hours | 10 Military Clock Hours Per Week
Who Should Register?
If your business uses data to make business decisions, or if launching a business analytics program is on the corporate roadmap, this course is for you. From IT professionals working in or transitioning into BI program creation or data warehouse management, to members of upper management interested in learning more about business analytics, this course provides the tools and skills you need. There is no prerequisite for IT/data analytics expertise or business management experience.
Course offerings and associated prices are subject to change without prior notice. Pricing for multi-course certificate programs varies depending on course selection. View the Professional Education Catalog for more information on the courses and programs.
What You’ll Study
Introduction to Business Intelligence
- History of Business Intelligence
- Business Intelligence Business Value and ROI
- Introduction to Data Warehousing
- Business Intelligence Lifecycle and Architecture
- Business Case for Business Intelligence
Organizing for Business Intelligence
- Business Intelligence Program vs. Business Intelligence Project
- Business Intelligence Sponsorship
- Enterprise Level vs. Departmental Level Business Intelligence
- BI Team Roles and Responsibilities
- Business Analytics Competency Centers/Centers of Excellence
- Data Governance and Change Management
- Communication and Promoting Business Intelligence
BI Development Phases and Methods Approaches
- The Major Phases of BI Program Delivery
- The Waterfall Approach to BI Program Management
- Agile Approaches to Business Intelligence Program Management
- BI Planning Phase Best Practices
- BI Implementation and Configuration Phase Best Practices
- BI Deployment Phase Best Practices
Data Warehousing
- Introduction and History of Data Warehousing
- Inmom Approach
- Kimball Approach
- Data Modeling Basics
- Metadata
- Big Data and Big Data Analytics Cloud-based BI and Data Warehousing
Data Quality and Architecture
- Data Quality Introduction
- Measuring Data Quality
- Poor Data Quality
- Improving Data Quality
- Disparate Data Sources
- Data Governance
- Master Data Management (MDM)
Business Intelligence Requirements Gathering
- Requirements Gathering Introduction
- Top-Down Requirements Gathering
- Bottom-Up Requirements Gathering
- Capture and Prioritize Requirements
- Agile Requirements Gathering Best Practices
- The Top 5 Categories of BI Requirements
Readiness for Business Intelligence and Maturity Models
- Business Intelligence Readiness Assessments
- Assessing Technology and Data
- Organizational Readiness Assessments
- Process and Procedures Readiness Assessments
- BA Competency Center/Center of Excellence and Readiness
- BI Maturity Models
Technology and Capability Review
- Modern BI Capabilities
- Selecting and Evaluating BI Technologies
- Selecting and Evaluating Data Warehouse Technologies Selecting and Evaluating Master Data Management Technologies
- BI Technology Disruptive Change
- BI Visualization Tools
Curriculum
8 Week Course
Introduction to Business Intelligence
- State what Business Intelligence is and what it is not
- Apply BI to real-world marketplace examples
- Describe the history and evolution of BI, from ledgers to databases to web-based reporting and beyond
- Identify Business Intelligence industry trends, including its usage, its adoption, its market growth, and the impact of technological developments on BI
- Understand how Business Analytics applies BI results to the enterprise
Organizing for BI
- Distinguish between a Business Intelligence program and a Business Intelligence project
- Explain Business Analytics Competency Center, Center of Excellence, and BI Competency Center, and name critical success factors for effective use of these concepts
- State the positives and negatives of enterprise and departmental BI solutions
- Describe the definition of data governance, along with its components, impact, and importance
- Identify keys to planning for change, overcoming challenges, and legacy sunsetting
BI Development Phases, Methods, & Approaches
- Identify key deliverables of the planning, design, and deployment phases
- Describe the different approaches to developing a BI solution, and explain the advantages and disadvantages of each approach
- Understand best practices for BI implementation from a management, planning, and development lifecycle perspective
Data Warehousing
- Differentiate the data warehousing theories from Inmon to Kimball, and describe the characteristics of each
- Explain data modeling fundamentals in a data warehouse
- Define the term metadata, and identify the different types and benefits of metadata
- Define Big Data and Big Data Analytics
- Discuss Big Data analytics’ impacts on data warehousing and BI
- Introduce Cloud-based BI and DW
Data Quality and Architecture
- Define the concept of data quality
- Explain how the quality of the data affects the quality of the BI solutions
- State various ways to improve the quality of different types of data
- Define Master Data Management
BI Requirements Gathering
- Name the different ways requirements are captured
- Explain the differences between top-down requirements gathering and bottom-up requirements gathering
- Describe how to gather requirements using agile-based methods
- Outline why BI works well with agile-based approaches to requirements management
Readiness for BI and Maturity Models
- Explain different readiness assessment methods
- List the nine levels of technology readiness
- Name the key facets of data readiness
- Describe maturity models, including Gartner’s BI Maturity Model
- Explain what the terms Business Analytics Competency Center (BACC) and BI Center of Excellence (CoE) mean and how they apply to enterprise BI
Technology and Capability Review
- Identify modern BI capability sets.
- Identify questions that should be asked when trying to choose between various types of BI implementations.
- Identify questions that should be asked when trying to choose between various BI vendors.
- List the key selection criteria for choosing between various data warehouse/MDM implementation styles and vendors
If you’re going to pay by credit card, you can either get started with installment payments or pay in full. Just let your enrollment representative know the option that works best for you.
Corporate Tuition Assistance
-
Corporate TA
Corporate tuition assistance is paid by your employer. You will need to provide appropriate forms for processing, prior to enrollment. Subject to employer benefit policies.
-
Deferred Corporate TA
Pay tuition now and have your employer reimburse you. Additional documentation will be needed to process this payment. Subject to employer benefit policies.
Military Benefits
Active Duty
Villanova offers a 15% savings, per certificate course, to active-duty servicemembers, Guardsmen and Reservists (upon verification of military status).
Veterans
Villanova offers a 15% savings, per certificate course to veterans (upon verification of military status). You may also use your Department of Veterans Affairs (VA) education benefits for many of Villanova’s 100% online non-credit programs, based upon your individual eligibility.
Spouses and Dependents
Villanova offers a 15% savings, per certificate course, to active-duty servicemembers, veterans, Guardsmen, Reservists and their spouses and dependents (upon verification of military status).
This reduction is valid off the standard tuition fee rate of the listed courses offered by Villanova University with online administration by Bisk. This reduction is not stackable with other reductions, and you may not use this reduction in conjunction with other reductions.
