Description

BIAM 500 Lab Week 1

Learning Outcome Step 1: Importing, Cleaning, and Converting Data

Learning-Outcome Step 2: Table Analysis

Learning Outcome Step 3: Pivot Tables

Learning-Outcome Step 4: /What If Analysis

Learning Outcome Step 5: Opinion Paper

BIAM 500 Lab Week 2

Learning Outcome Step 1: Creation of Formulas with Constraints

Learning-Outcome Step 2: Use Solver to find an optimal solution

Learning Outcome Step 3: Perform Sensitivity Analysis

Learning-Outcome Step 4: Create Monte Carlo Simulation

Learning Outcome Step 5: Opinion Paper

BIAM 500 Lab Week 3

Learning Outcome Step 1: Analysis of Simple Six-vertex Network

Learning-Outcome Step 2: Capture and Analyze Twitter Feed

Learning Outcome Step 3: Opinion Paper

BIAM 500 Lab Week 4

Learning Outcome Step 1: Create Dashboard with Summary of Key Metrics

Learning-Outcome Step 2: Create Calls Handled by Auto Response Chart

Learning Outcome Step 3: Create Additional KPI Displays

Learning-Outcome Step 4: Finalize Workbook

Learning Outcome Step 5: Write Opinion Paper and Submit

BIAM 500 Lab Week 5, Star Schema

Learning Outcome Step 1: Create Simplified Star Schema in Student Data Warehouse

Learning-Outcome Step 2: View Data from Related Tables in the Data Warehouse

Learning Outcome Step 3: Create and Deploy a Data Cube

Learning-Outcome Step 4: Browse the Cube

Learning Outcome Step 4(d): Browse the Cube (d: on your own)

Learning-Outcome Write Opinion Paper and Submit

BIAM 500 iLab Week 6

Learning Outcome Step 1: Load and Prepare Data

Learning-Outcome Step 2: Define the Training/Testing and Prediction Data Sets

Learning Outcome Step 3: Train and Test Neural Network

Learning-Outcome Step 4: Predict Classifications for New Customers

Learning Outcome Step 5: Write Opinion Paper and Submit