Please enable JavaScript.
Coggle requires JavaScript to display documents.
Advanced Business Analytics Specialization (COURSE 1 Introduction to Data…
Advanced Business Analytics Specialization
COURSE 1
Introduction to Data Analytics for Business
WEEK 1 Data and Analysis in the Real World
Video · 0. Introduction to Data & Analysis in Real World
Video · 1. Thinking about Analytical Problems
Video · 2. Conceptual Business Models
Video · 3. The information-Action Value Chain (Part 1)
Video · 4. The information-Action Value Chain (Part 2)
Video · 5. Real World Events and Characteristics
Video · 6. Data Capture by Source Systems
Other · What is more important for a data analyst to understand, the business or analytical methods?
Other · What are some of the challenges you might find in communicating the results of your analysis?
WEEK 2 Analytical Tools
Video · 0. Introduction - Analytical Technologies
Video · 1. Data Storage and Databases
Video · 2. Big Data & the Cloud
Video · 3. Virtualization, Federation, and In-Memory Computing
Video · 4. The Relational Database
Video · 5. Data Tools Landscape
Video · 6. The Tools of the Data Analyst
Other · Information tools used at different organizations
Other · Different approaches to building a relational database
WEEK 3 Data Extraction Using SQL
Video · 0. Introduction - Data Extraction Using SQL
Video · 1. Introduction to SQL
Video · 2. Aggregating and Sorting Data in SQL
Video · 3. Extracting Data from Multiple Tables
Video · 4. Stacking Data with UNION Command
Video · 5. Extending SQL Queries Using Operators
Video · 6. Using SQL Subqueries
Reading · You can now start part 3 of the final assignment!
Other · Advantages and shortcomings of accessing data using SQL
WEEK 4 Real World Analytical Organizations
Video · 0. Introduction to Real World Analytical Orgs
Video · 1. Analytical Organizations – Roles
Video · 2. Analytical Organizations – Structures
Video · 3. Data Governance
Video · 4. Data Privacy
Video · 5. Data Quality
Other · Issues with roles and organizational structures around analytics
Other · Data privacy issues
COURSE 2
Predictive Modeling and Analytics
WEEK 1 Exploratory Data Analysis and Visualizations
Video · 0. Introduction to the Module. Why Exploratory Data Analysis is Important
Video · 1. Data Cleanup and Transformation
Video · 2. Dealing With Missing Values
Video · 3. Dealing with Outliers
Video · 4. Adding and Removing Variables
Video · 5. Common Graphs
Video · 6. What is Good Data Visualization?
Practice Quiz · Week 1 Application Assignment 1 (optional): Data Cleanup
Peer Review · Week 1 Application Assignment 2: Data Visualization
WEEK 2 Predicting a Continuous Variable
Video · 0. Introduction to Predictive Modeling
Video · 1. Introduction to Linear Regression
Video · 2. Assessing Predictive Accuracy Using Cross-Validation
Video · 3. Multiple Regression
Video · 4. Improving Model Fit
Video · 5. Model Selection
Video · 6. Challenges of Predictive Modeling
Video · 7. How to Build a Model using XLMiner
WEEK 3 Predicting a Binary Outcome
Video · 0. Introduction to classification
Video · 1. Introduction to Logistic Regression
Video · 2. Building Logistic Regression Model
Video · 3. Multiple Logistic Regression
Video · 4. Cross Validation and Confusion Matrix
Video · 5. Cost Sensitive Classification
Video · 6. Comparing Models Independent of Costs and Cutoffs
Video · 7. Building Logistic Regression Models using XLMiner
Reading · Data File for Application Assignment
WEEK 4 Trees and Other Predictive Models
Video · 0.Introduction to Advanced Predictive Modeling Techniques
Video · 1. Introduction to Trees
Video · 2. Classification Trees
Video · 3. Regression Trees
Video · 4. Bagging, Boosting, Random Forest
Video · 5. Neural Networks
Video · 6. Building Trees with XLMiner
Video · 7. Building Neural Networks using XLMiner
COURSE 3
Business Analytics for Decision Making
WEEK 1 Data Exploration and Reduction — Cluster Analysis
Video · 0. What is Cluster Analysis
Video · 1. Data Reduction and Unsupervised Learning
Video · 2. Preparing Data and Measuring Dissimilarities
Video · 3. Hierarchical and k-Means Clustering
Reading · Getting Started with Analytic Solver Platform (XLMiner)
Video · 4. Cluster Analysis with Excel
Video · 5. Cluster Analysis with XLMiner
Quiz · Week 1 Application Assignment - Clustering
Other · Week 1 Discussion: Cluster Analysis in Nilsen Analytics Tools
WEEK 2 Dealing with Uncertainty and Analyzing Risk
Video · 0. Risk Analysis and Monte Carlo Simulation
Video · 1. Adding Uncertainty to a Spreadsheet Model
Video · 2. Defining Output Variables and Analyzing the Results
Video · 3. Using Historical Data to Model Uncertainty
Video · 4. Models with Correlated Uncertain Variables
Video · 5. Creating and Interpreting Charts
Video · 6. Using Average Values versus Simulation
Other · Week 2 Discussion: How Betterment Holdings Inc. Used Monte Carlo Simulation
WEEK 3 Identifying the Best Options — Optimization
Video · 0. Optimization and Decision Making
Video · 1. Formulating an Optimization Problem
Video · 2. Developing a Spreadsheet Model
Video · 3. Adding Optimization to a Spreadsheet Model
Video · 4. What-if Analysis and the Sensitivity Report
Video · 5. Evaluating Scenarios and Visualizing Results to Gain Practical Insights
Video · 6. Digital Marketing Application of Optimization
Quiz · Week 3 Application Assignment - Linear Optimization
Other · Week 3 Discussion: How Amazon Uses Optimization for Its Supply Chain
WEEK 4 Decision Analytics
Video · 0. Advanced Models for Better Decisions
Video · 1. Business Problems with Yes/No Decisions
Video · 2. Formulation and Solution of Binary Optimization Problems
Video · 3. Metaheuristic Optimization
Video · 4. Chance Constraints and Value At Risk
Video · 5. Simulation Optimization
Quiz · Week 4 Application Assignment - Simulation Optimization
Other · Week 4 Discussion: How Uber Optimized Its Dispatch System
COURSE 4
Communicating Business Analytics Results
WEEK 1 Introduction to the Course
Video · 0. Introduction to the Course
Video · 1. Information Action Value Chain Redux
Video · 2. Analytics in Classic Business Problems
Video · 3. Analytics in Emergent Business Problems
Other · Types of Analytical Problems
Other · Is This a New Type of Analysis?
WEEK 2 Best Practices in Data Visualization
Video · Module Introduction
Video · Vehicles to Present Quantitative Information
Video · Data Visualization Examples
Video · Graphs in Excel and ASP
Video · Graphical Excellence
Video · Techniques to Display Multiple Variables
Video · Excel Charts to Avoid
Other · Share an Example of Effective or Ineffective Visualization
Other · Annual Energy Review Graph
WEEK 3 Interpreting, Telling, and Selling
Video · Correlation vs Causation
Video · Common Cognitive Biases
Video · Misleading With Data
Video · Market Experiments: When the action is the question
Video · Know thy Audience
Video · Telling compelling stories
Video · Making It Real
Other · What Examples of Correlation vs. Causation Have You Recently Encountered?
Other · CNN Article about Four-Day Work Week. Is This a Good Data-Based Argument?
WEEK 4 Acting on Data
Video · Case Study 1: Experiment Driven Analytics and Customer Churn
Video · Case Study 2: Multidimensional Analysis for Customer Acquisition - Part 1
Video · Case Study 2: Multidimensional Analysis for Customer Acquisition - Part 2
Video · Case Study 2: Multidimensional Analysis for Customer Acquisition - Part 3
Other · Communicating Control Group Results
Other · The "Science and Art" of Analytics
COURSE 5
Advanced Business Analytics Capstone
Module 1 - Understand the data and prepare your data for analysis
Video · Data Cleanup and Transformation
Video · Dealing with Missing Values
Video · Dealing with Outliers
Video · What is Good Data Visualization
Video · Graphical Excellence
Reading · Introduction to the Project
Peer Review · Understand the data and prepare your data for analysis
Module 2 - Perform predictive analytics tasks
Video · Cross Validation and Confusion Matrix
Video · Assessing Predictive Accuracy Using Cross-Validation
Video · Building Logistic Regression Models using XLMiner
Video · How to Build a Model using XLMiner
Peer Review · Perform predictive analytics tasks
Module 3 - Provide suggestions on how to allocate investment funds using prescriptive analytics tools
Module 4 - Present your analytics results to your clients