Data and Analytics - from the ground up

There are no specific requirements needed to attend this course.

Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions: 

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

The course itself can be delivered either as a 6 day classroom course or remotely over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.

Basic Excel

• Navigation
• Manipulating data
• Working with formulas and addresses
• Charts

Advanced Excel 

• Logical functions
• Scenario analysis
• Solver
• Macros
• First glimpse of code: VBA

VBA

• Data types
• Writing a function
• Controlling a program: conditional evaluation and loops
• Debugging techniques

Data Analytics with R

• Introducing R
• Variables and types
• Data manipulation in R
• Writing functions
• Data visualization using ggplot
• Data wrangling with Dplyr

Introduction to Machine Learning with R

• Linear Regression
• Classification and regression trees
• Classification using Support Vector Machines and Random Forests
• Clustering techniques