Course Offerings

Big Data and Business Analytics

Course ID: SEF-3001MR2
Overview
Course Outline
Requirements
Intended Audience
More Details

Data analytics has become a critical topic across the business world. Whether you work with a major corporation, small business, or non-profit entity, understanding big data and business analytics is an increasingly important and desired skill. This course will cover the basics of data analytics and how to special use tools built into Microsoft Excel (a common application for most work environments) to analyze data in a productive and meaningful way.

Course Objectives

understand the basics of the data analytics environment.

learn how to use Microsoft Excel to manage, visualize, and analyze large data sets at an high level.

Outline of Instruction

Day 1- Introduction to Big Data and Business Analytics
a. What is Business Analytics?
b. How Data Analytics Can Help Business

Gathering the Correct Information
a. Data Structure and Environment
b. Obtaining and Connecting Data Sources
c. Asking the Right Questions
d. Avoiding Data Overflow
e. Ensuring Data Integrity

Statistics Primer
a. Review of Basic Statistics
b. Correlation and Causation

Analyzing the Data- High Level
a. Descriptive Analytics
b. Predictive Analytics
c. Prescriptive Analytics
d. Avoiding Pitfalls

Day 2 - Analyzing the Data- Deep Dive
a. Reporting and Dashboarding
b. Decision Trees
c. Segment Analysis
d. Regression
e. Optimization and A/B Testing

Communicating Findings and Turning Data into Actionable Insights
a. Understanding Your Objectives
b. Effective Communication of Findings
c. Communicating Uncertainty and Preparing for Pushback

Looking to the Future
a. Future Evolution of Data: Smarter and Bigger
b. Questions of Ethics and Privacy