This course prepares a student to take the IIBA – Certification in Business Data Analytics national certification exam.
Students will:
- Techniques for data cleaning and preparation (handling missing values, outliers, and more)
- Summarize and understand data characteristics for Exploratory Data Analysis (EDA)
- Conversion of raw data into a suitable format for analysis
- Using statistical methods to analyze data, including descriptive statistics, hypothesis testing, and correlation analysis
- Using visualization techniques to create various types of charts and graphs to communicate data insights
- Using different visualization methods to create stories that convey complex information in a clear and understandable manner
- Create conceptual, logical, and physical data models to represent the structure and relationships of data elements
- Ability to apply analytical techniques such as decision trees and regression analysis
- Find optimal solutions to complex problems, such as resource allocation or scheduling with mathematical techniques
- Implement policies and procedures to ensure data quality, security, and compliance with regulations
- Awareness of data warehousing and data marts to perform centralized data storage and analysis
- Execute ETL (Extract, Transfer, Load) process for extracting data from various sources, transforming it into a suitable format, and loading it
- Apply data mining techniques and algorithms to find patterns and trends in large datasets
- Using Machine Learning (ML) Algorithms to build predictive learning models
Course Outline:
Lesson 1: Introduction to Business Data Analytics
- What is Business Data Analytics?
- The Business Data Analytics Cycle
- Business Data Analytics Objectives
- Business Analysis and Business Data Analytics
- Applications of Data Analytics
Lesson 2: Identify the Research Questions
- Define Business Problem or Opportunity
- Identify and Understand the Stakeholders
- Assess Current State
- Define Future State
- Formulate Research Questions
- Plan Business Data Analytics Approach
- Techniques
Lesson 3: Source Data
- Plan Data Collection
- Determine the Data Sets
- Collect Data
- Validate Data
- Techniques
- A Case Study for Source Data
Lesson 4: Analyze Data
- Develop Data Analysis Plan
- Prepare Data
- Explore Data
- Perform Data Analysis
- Assess the Analytics and System Approach Taken
- Techniques
- A Case Study for Analyze Data
Lesson 5: Interpret and Report Results
- Validate Understanding of Stakeholders
- Plan Stakeholder Communication
- Determine Communication Needs of Stakeholders
- Derive Insights from Data
- Document and Communicate Findings from Completed Analysis
- Techniques
- A Case Study for Interpret and Report Results
Lesson 6: Use Results to Influence Business Decision-Making
- Recommend Actions
- Develop Implementation Plan
- Manage Change
- Techniques
- A Case Study for Use Results to Influence Business Decision-Making
Lesson 7: Guide Organizational-Level Strategy for Business Data Analytics
- Organizational Strategy
- Talent Strategy
- Data Strategy
- Techniques
- Competencies
- A Case Study for Guide Organization-Level Strategy for Business Data Analytics
Lesson 8: Appendix A: Techniques
- Business Simulation
- Business Visualizations
- Concept Modelling
- Data Dictionary
- Data Flow Diagrams
- Data Mapping
- Data Storytelling
- Decision Modelling and Analysis
- Descriptive and Inferential Statistics
- Extract, Transform, and Load (ETL)
- Exploratory Data Analysis
- Hypothesis Formulation and Testing
- Interface Analysis
- Optimization
- Problem Shaping and Reframing
- Stakeholder List, Map, or Personas
- Survey and Questionnaire
- Technical Visualizations
- The Big Idea
- 3-Minute Story
All necessary course materials are included.
Certification(s):
This course prepares a student to take the IIBA – Certification in Business Data Analytics national certification exam.
