Mastering Data Management and Technology
Overview
Building upon the foundation concepts of Essentials of Business Intelligence, this 100% online certificate course explores more advanced topics including data modeling, securing business intelligence content, reporting and performance management. With case studies and exercises, you’ll gain real-world insight into all facets of business intelligence.
50.75 PDUs | 8 Continuing Education Units
80 Military Clock Hours | 10 Military Clock Hours Per Week
Who Should Register?
Whether you’re a strategic decision maker, project manager, business analyst, market researcher, or IT professional, this course can provide you with a solid understanding of critical business intelligence topics. With subjects including best practices in data modeling, data architecture and performance management, you’ll gain the skills needed for success in today’s highly competitive global data analytics market.
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
Data Architecture and Quality
- Business Case for Improving Data Quality
- Data Quality Assessment
- Process Improvements, Source System Validation
- Attribute Constraints, Profiling and Precision
- Historical Data
- Real Time vs. Right Time
- Granularity for Analysis
Data Modeling
- Dimension Types
- Snowflake vs. Star
- Fact Types
- Aggregates
- Process for Designing
CDM and MDM
- Master Data Management (MDM)
- Customer Master Data
- Product Master Data
- Other Types of Master Data
- MDM Best Practices and Benefits
- MDM Team Creation and Scope
BI Front-End Tool Segments
- User Interfaces
- Waterfall Development
- Agile Methodology
- The Different Types of Online Analytics Processing
- Network Architecture
- Maintaining Your BI Application
Industry Standards
- Middleware (ODBC, ODBO, XMLA)
- MDX
- ETL
- SQL Introduction
- Common Warehouse Meta Model (CWM)
- HTML
Creating a Business Analytics Competency Center (BACC)
- BACC Review
- Initialization
- Define
- Establish
- Organize
- Operate
Technical Architecture
- Cloud-based BI and MDM
- Virtualization
- Load Balancing
- Performance Tuning
- On-line Analytical Processing (OLAP)
Success Factors and Constraints
- Leadership
- Business/IT Partnership
- Business Alignment Incentives
- Company Culture
- Change Management
Curriculum
8 Week Course
Success Factors and Constraints
- Describe the significance of leadership buy-in
- Name the three key characteristics of a strong and active sponsor
- Summarize ways to bridge the gap between Business and IT
- Discuss how to get people onboard and involved with your BI project, ways to build and maintain momentum, and how to align and design the right incentives
- Name and explain the five structured phases of change
BI Front End Tool Segments
- Describe scorecards, dashboards, and key performance indicators (KPI)
- Review waterfall methodologies as applied to BI programs and compare/contrast waterfall vs. Agile for BI program management.
- Discuss Agile program management methodologies and how they apply to Business Intelligence initiatives
- Outline the three types of Online Analytical Processing (OLAP)
- Discuss modern BI reporting capabilities
Data Architecture and Quality
- Provide data quality issues and ways data quality can be improved
- Explain the differences between the top-down approach and the bottom-up approach to data quality
- Discuss the definitions of data quality assessment and explain how to effectively perform data quality assessments
- Illustrate how data flows through from sources to reporting
- Differentiate real-time from right-time data
Data Modeling
- Illustrate star schema and snowflake schema design basics
- Identify fact types and dimension types
- Outline the data modeling process, including defining requirements back-to-front and front-to-back
- Summarize when to create aggregate tables and why they appear in the data warehouse
Customer Data Management (CDM) and Master Data Management (MDM)
- Define Master Data Management (MDM), customer master data, and product master data
- Explain how customer master data and product master data are used, and provide the best practices for integrating each
- Discuss why an MDM team is necessary as well as their roles and responsibilities
- Analyze case studies in Master Data Management
Industry Standards
- Define middleware, identify the three forms, and explain the uses of each
- Summarize the meaning of ETL, explain how it works, and when to use it
- Discuss best practices in ETL processing.
Creating a Business Analytics Competency Center (BACC)
- Define what a BACC is, why it is needed, its role, and how to place it in an organization
- Identify best practices for creating and managing a BACC
- Analyze BACC case studies to investigate real-world competency center application.
Technical Architecture
- Name the three tiers that support technical architecture, and explain each tier’s purpose
- Discuss best practices in cloud-based BI and MDM
- Distinguish the differences between virtualization and traditional architecture
- Explain what scalability is, and how to use load balancing to achieve scalability
- Summarize when and why performance testing is done
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.
