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