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.
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
8
1
None
None
No
Elementary-Intermediate Understanding of Excel
Laptop with Internet Access & Microsoft Excel
None
attendance
N/A
Anyone interested in learning the basics of business analytics and how to use tools such as Excel to perform data analyses.
N/A
N/A
SEF-8196CL
SEF-3001MS2
Community & Career Education Staff
919-532-5700
[email protected]
To be notified when this course becomes available, please use
Wake Tech's Notify Me service.
Requisites: None
To view information on this course and additional non-degree course offerings, visit the Workforce Continuing Education Catalog