This course runs for a duration of .
The class will run daily from 8:30 am EST to 4:30 pm EST.
Class Location: Cary - Cary, NC.
Space is limited. Enroll today.Enroll Now
Make informed, data-driven decisions applicable to real-world situations using hands-on data analysis exercises with Excel and R.
This three-day course leverages straightforward business examples to explain practical techniques for understanding and reviewing data quality.
This course starts with an overview of data quality and data management, followed by foundational analysis and statistical techniques. Throughout the course, you learn to communicate about data and insights to stakeholders who need to make quick business decisions to drive your organization forward.
This data analysis training class is a lively blend of expert instruction combined with hands-on exercises so you can practice new skills and leave prepared to start performing practical analysis techniques. Every Data Analysis Boot Camp instructor is a veteran consultant and data guru who guides you through effective best practices and technologies for working with your data.
Labs for this course are primarily in Microsoft Excel, however, students will get an opportunity to practice using R during some labs. Labs for this course can also be taught using the Python programming language for private team deliveries.
Professionals who benefit from this course include:
In this class you will learn how to:
Part 1: The Value and Challenges of Data-Driven Disruption
Part 2: Tying Data to Business Value
CLASS EXERCISE: Data-driven project checklist
LAB: Data analysis techniques: Aggregations
Part 3: Understanding Your Data
LAB: Prioritizing data quality
Part 4: Analyzing Data
LAB: Central Tendency
LAB: Feature Engineering
LAB: Univariate Linear Regression
LAB: Multivariate Linear Regression
LAB: Monte Carlo Simulation
Part 5: Thinking Critically About Your Analysis
Part 6: Data Analysis in the Real World
Part 7: Data Visualization & Reporting
Part 8: Hands-On Introduction to R and R Studio
LAB: Intro to R Studio
LAB: Univariate Linear Regression in R
LAB: Multivariate Linear Regression in R
Students attending this class should have a basic understanding of how data is currently used in their organization. They should also have strong Excel aptitude.
If you have basic familiarity with Excel, this three-day course can teach you practical applied analysis techniques to leverage data for relatively common decision making methods.