Advanced Data Architecture and Intelligence

Villanova University

Villanova University

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

Business Analytics courses will introduce you to a popular and diverse profession. A business analyst is a specialist in many IT fields as well as in ...

Read more about Digital Transformation

Digital transformation is the process of adopting and utilizing state-of-the-art technologies in order to boost business activity, improve safety, and...

Read more about Operations

Operations management has recently become a crucial part of any company's framework. This complex process focuses on reducing organizational expenses ...

Reviews

Comprehensive course analysis

Unbiased reviews from past participants
Global companies alumni of this course worked for
Positions of participants who took this course
Countries where most past participants are from
FREE
Individual needs analysis

Who should attend

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.

About the course

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

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

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.

Advanced Data Architecture and Intelligence at Villanova University

From  $2,495
Add coaching to your course booking

Coaching can personalize and deepen learning for you and your organization.


Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Read more about Business Analytics

What will you learn from Business Analytics courses? First of all, you will learn about the profession of a business analyst, his duties, and what such a specialist does. You will get various soft skills, such as organizing teamwork, for example, acc...

Read more about Digital Transformation

When it comes to imposing digital frameworks and technologies, whether you’re trying to optimize particular units or the entire organization, you need to minimize the collateral damage in order to have a greater effect. However, it's not always that ...

Read more about Operations

When it comes to operations control, whether you’re trying to optimize workflow or marketing and sales operations, you need to impact as many variables at once as possible in order to have a greater effect. However, it's not always that easy. How sho...

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.