Register Now
Classroom Login
Call Now
Call Now 855-300-1473

Advanced Data Architecture and Intelligence


Take Your Business Intelligence Knowledge to the Next Level!

Advanced Data Architecture and Intelligence

Master the skills you need to lead and manage business intelligence initiatives! This 12-week, 100% online course is designed to provide you with advanced data analytics and modeling skills, along with the best ETL and MDX practices to make sophisticated and effective business decisions. You’ll also complete a comprehensive project and final exam to apply your knowledge to real-world situations, and achieve exclusive Villanova certification as a Certified Professional in Business Intelligence (CPBI).

$2,495
Advanced Data Architecture and Intelligence


This course is part of a Master Certificate Program

SAVE UP TO $890

Packages starting at $5,995

Register Now!

What You’ll Study


Report Design

  • Types of Reports and Scenarios
  • Gathering Requirements
  • Building Use Cases
  • Converting Requirements to Design
  • Prototyping and Iteration
  • Documenting

Dashboard Design

  • Types of Dashboards and Scenarios
  • Best Practices in Dashboard Design
  • KPI's/Metrics
  • Understanding Interactivity
  • Gathering Requirements
  • Prototyping and Iteration

ETL Best Practices

  • ETL Processes
  • Source to Target Mappings
  • Re-Usable Components
  • Testing Procedures 
  • Transformation Logic 
  • Impact Analysis and Data Lineage

Production Support

  • Development/Testing/Production Environments
  • Change Management Procedures
  • Help Desk and SME Networks
  • Deployment and Leveraging the ADKAR Model
  • Training Approaches
  • Capacity Planning
  • Service Level Agreements

Visualization and Design Best Practices

  • Information Overload
  • Visual Perception
  • Common Mistakes
  • Basic Display Types and Uses
  • Sparklines and When to Use
  • GeoSpacial
  • Diagnose Design Improvements in Report and Dashboard

Predictive Analytics and Decisioning

  • Predictive Analytics
  • Modeling Overview
  • Classify Modeling
  • Regression
  • Forecast Model

SQL and MDX for Business Intelligence

  • SQL Intro and Dialects
  • Basic Select Statement Syntax
  • Where Clauses and Joins
  • Subqueries, Decode and Rank
  • Analytical SQL, Reporting and Ration
  • MDX Introduction, Cube Concepts, OLAP 
  • Members and Calculated Members
  • Hierarchical Navigation
  • Time Series, Filtering, Sorting and Ranking

Performance Management

  • Performance Management Introduction
  • Financial Planning - Top-Down and Bottom-Up
  • Planning Beyond Finances
  • Rolling Forecasts
  • Balanced Scorecard

Credit & Tuition


ACE credit recommendation 3 semester hours. Register today and earn 45 PDUs, 4.5 CEUs for $2,495.

Who Should Register?


Professionals and business leaders looking to strengthen their strategic, tactical and operational decision-making skills will benefit from this advanced course. Taught by experts in the BI industry, students will delve deep into topics such as data modeling, technical architecture, predictive analytics and best practices.