Advanced Data Architecture and Intelligence

Overview

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 Exact Transform Load (ETL) and Multidimensional Expressions (MDX) practices to make sophisticated and effective business decisions. By successfully completing all three courses, the comprehensive project and certification exam, you can achieve exclusive Villanova certification as a Certified Professional in Business Intelligence (CPBI).

45 Professional Development Units | 4.5 Continuing Education Units

Military Clock Hours: 135.6

 

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.

 

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
  • KPIs/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

Payment Options

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.

Pay in Full: $2495 or

Flexible payment options available

Corporate Tuition Assistance

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

  2. 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 can also use your Department of Veterans Affairs (VA) education benefits for Villanova’s 100% online non-credit certificate 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 and program fee rate of the certificates 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.

Have Questions?

Our representatives are here to assist you.

Curriculum

12 Week Course

Visualization and Design Best Practices
  • Provide examples of visual distinction
  • Present data using the Rule of Thirds and Fifths
  • Describe the uses and benefits of various visual charts and graphs
Report Design
  • Discuss information-oriented, analysis-oriented, static, parameterized, and formatted reports
  • Identify requirement focus areas
  • Analyze and document requirements
  • Discuss the documentation of typical workflows
  • Describe the need for prototyping and iteration
Dashboard Design
  • Discuss the significance of dashboards and how they are created
  • Identify variables which lead to bad dashboard design
  • Describe the common attributes of KPIs that are useful for dashboards
  • Discuss the tools used to design and manage iterations
Performance Management
  • Discuss the symbiosis between BI and performance management
  • Explain the significance of strategy creation
  • Identify common issues with budgeting
  • Discuss the need for rolling forecasts
  • Describe the design process of balanced scorecards and common implementation pitfalls
Predictive Analytics
  • Discuss the significance of predictive analytics and offer a brief history
  • Compare predictive, descriptive, and decision models
  • Identify working examples of predictive models
  • Discuss the significance of analytic tools
SQL and MDX for BI
  • Discuss the capabilities and syntax of SQL
  • Discuss the applications of GROUP BY and HAVING clauses
  • Contrast CASE and DECODE
  • Provide examples of subqueries
ETL Best Practices
  • Explain the process of extraction, transformation, and loading (ETL) and describe its benefits
  • Describe how mappings are built and provide some best practices
  • Identify the components of ETL
  • Discuss the testing and implementation of code
Production Support
  • Discuss the necessity for multiple environments and the role of each one
  • Identify the characteristics of a development, test, and production environment
  • Discuss the development of training curriculums
  • Explain the process of translating needs into growth for data, hardware, and licenses
  • Identify the common components of a service level agreement (SLA)

Have Questions?

Our representatives are here to assist you.

VA Benefit Eligibility: Visit the U.S. Department of Veterans Affairs Web Enabled Approval Management System (WEAMS) to view which programs of study or courses are currently certified. Benefit certification depends upon your VA determined eligibility, enrollment status and certified program of study.

Corporate Tuition Assistance

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

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