Course Offerings

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

Contact Hours

8

CEUs

1

Industry Standard, State or National Certification

Certification

None

Website

None

Certification Learning Outcomes/Requirements

CE or CU Articulation

No

Prerequisites

Elementary-Intermediate Understanding of Excel

Learning Supplies Needed

Laptop with Internet Access & Microsoft Excel

Clinical Site/Special Facilities

None

Requirements for Successful Completion

attendance

Accreditation/Special Approval Requirements

N/A

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

N/A

Wake County Need for Industry Positions

N/A

Industry or Job Titles Related to Training Outcomes for Employment

Related Courses

SEF-8196CL

SEF-3001MS2

Course Contact Information

Community & Career Education Staff
919-532-5700
[email protected]