Course
Big Data and Business Analytics
Name
SEF-3001MR2
Overall Quality of This Course
★★★★★
Based on 5 student surveys.
Available Classes
Not currently offered.
Description Course Outline Requirements Intended Audience More Details
Intended Audience
Anyone interested in learning the basics of business analytics and how to use tools such as Excel to perform data analyses.
Description
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
  1. understand the basics of the data analytics environment.
  2. learn how to use Microsoft Excel to manage, visualize, and analyze large data sets at an high level.
Outline of Instruction
  1. Day 1- Introduction to Big Data and Business Analytics
    a. What is Business Analytics?
    b. How Data Analytics Can Help Business
  2. 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
  3. Statistics Primer
    a. Review of Basic Statistics
    b. Correlation and Causation
  4. Analyzing the Data- High Level
    a. Descriptive Analytics
    b. Predictive Analytics
    c. Prescriptive Analytics
    d. Avoiding Pitfalls
  5. 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
  6. Communicating Findings and Turning Data into Actionable Insights
    a. Understanding Your Objectives
    b. Effective Communication of Findings
    c. Communicating Uncertainty and Preparing for Pushback
  7. Looking to the Future
    a. Future Evolution of Data: Smarter and Bigger
    b. Questions of Ethics and Privacy
Contact Hours
8
CEU's
0.8
Industry Standard, State, or National Certification
No
CE to CU Articulation
No
Prerequisites
Elementary-Intermediate Understanding of Excel
Text and Supplies Needed
Laptop with Internet Access & Microsoft Excel
Clinical Site/Special Facilities
Requirements for Successful Completion of this Course
  1. Attendance 100%
  2. Participation
Accreditation/Special Approval Requirements
Intended Audience
Anyone interested in learning the basics of business analytics and how to use tools such as Excel to perform data analyses.
Specific Industry or Business Support Needs
Industry or Job Titles Related to training Outcomes for Employment
Related Courses
  • Data Science and Big Data Analytics - SEF-8196CL
  • Big Data and Business Analytics Part 2 - SEF-3001MS2
Course Contact Information
Community & Career Education Staff
cce@waketech.edu
919-532-5700