Contact Us
Call Now Email Us Start a Chat
Request Info Classroom Login Support Enroll Now

Enroll by December 1, 2024

Essentials of Business Intelligence

Learn to apply the tools used for BI program creation, data warehouse management and business analytics.

Enroll Now Download Guide
image
8-Week Course
image
8 Continuing Education Units
image
80 Military Clock Hours

About the Course

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

Earn a Digital Badge
Villanova students will earn a digital badge when they successfully complete an individual course or full certificate program. These badges help to emphasize their skills and commitment to professional development and enables them to easily share and display the badge on a resume and/or social media.
Curriculum
8 Week Course
Week 1
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
Week 2
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
Week 3
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
Week 4
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
Week 5
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
Week 6
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
Week 7
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
Week 8
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
Learning Objectives
Skills Learned
Change Management Communication Program Management Business Intelligence Data Modeling Technology
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
Related Certificate Programs

Business Intelligence Certificate

24 Weeks
3 Courses
$6,059

Learn how to turn data into actionable insights.

Certification Available
Skills Learned
Data Analysis, Program Management, Data Management, Agile, Predictive Analytics
Program Details

Certificate in Business Analysis

20+ Weeks
3 Courses
$5,883

Develop analytical and problem-solving skills while preparing for industry-recognized Business Analysis certification.

Certification Prep
Skills Learned
Leadership, Change Management, Process Management, Risk Analysis, Strategic Communication, Facilitation and Negotiation
Program Details

Cybersecurity Certificate

20+ Weeks
3 Courses
$5,883+

Learn to assess risks and protect critical data from cyber threats.

Certification Prep
Skills Learned
Information Technology, Risk Management, Threat Assessment, Incident Response, Network Security, Communication Security, Cloud Computing, Security Policy, Firewall Systems, Security Maintenance
Program Details

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 useful tools and skills. There is no prerequisite for IT/data analytics expertise or business management experience.

Tuition & Payment

Total Course Cost

$2,095

Enroll Now Request Information

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.

 

Payment Options

There are multiple ways to pay for your certificate program. Just let your enrollment representative know the choice that works best for you.

icon Pay in Full
icon Flexible Payments
icon Tuition Assistance
icon Military Benefits