Advanced Data Architecture and Intelligence
Overview
Master the skills you need to lead and manage business intelligence initiatives. This 100% online course is designed to provide you with advanced data analytics and modeling skills, along with the best Extraction, Transformation and Loading (ETL) general BI program management skills needed to make sophisticated and effective business decisions. By successfully completing all three courses and the certification exam, you can achieve the exclusive Villanova certification as a Certified Professional in Business Intelligence (CPBI).
8 Continuing Education Units
80 Military Clock Hours | 10 Military Clock Hours Per Week
Who Should Register?
Professionals and business leaders looking to strengthen their strategic, tactical and operational knowledge of BI program management and architecture 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.
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
Report Design
- Types of Reports and Scenarios
- Gathering Agile Requirements
- Prototyping and Iteration
- Data Visualization Best Practices
Dashboard Design
- Types of Dashboards and Scenarios
- Best Practices in Dashboard Design
- KPIs/Metrics
- Understanding Interactivity
- Gathering Agile Requirements
- Prototyping and Iteration
ETL Best Practices
- ETL Best Practices
- Re-Usable Components
- Testing Procedures
- Transformation Management
- Impact Analysis and Data Lineage
Production Support
- Development/Testing/Production Environments
- Change Management Procedures
- Training Approaches
- Deployment Best Practices
Predictive Analytics
- Predictive Analytics
- Modeling Overview
- AI and Machine Learning-based Approaches
- Regression Models
SQL and MDX for Business Intelligence
- Understanding the relationship between MDX and SQL
- MDX Introduction, Cube Concepts, OLAP
- Best Practices in MDX vs. SQL Usage
Performance Management
- Performance Management Introduction
- Financial Planning – Top-Down and Bottom-Up
- Planning Beyond Finances
- Balanced Scorecard
- Scorecards vs. Dashboards for Business Performance Management
Curriculum
8 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
- 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
- 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
- Compare and Contrast MDX and SQL applications
- Discuss Best Practices for MDX usage
ETL Best Practices
- Explain the process of extraction, transformation and loading (ETL) and describe its benefits
- Discuss ETL implementation and management best practices
- Identify the components of ETL
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
- Discuss BI capability deployment best practices.
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.
