Data Analytics Training

Answers to Popular Questions:

Yes, this class can be tailored to meet your specific training needs.
Yes, we provide Business Analysis consulting services.
Yes, group discounts are provided.

Course Description

Data Analytics is the practice of using data for gaining insights, for forecasting and for decision-making. This training workshop will introduce techniques and tools that knowledge workers can use for analyzing data using popular software tools. At the end of the workshop, the participant will be able to (a) manage and prepare data for analysis, (ii) summarize data across multiple dimensions, (iii) interpret distributions of the data, (iv) identify and interpret relationships among data elements, (v) compare data summaries and (vi) forecast based on historical data.
Course Length: 3 Days
Course Tuition: $1200 (US)


Basic math and some Excel skills.

Course Outline

Session 1: Introduction to data
Data can be categorical or numeric.
Scales of measurement
Transforming data
Session 2: Summarizing the data
Pivot table, pivot chart, and dashboards
Distributions, box and whisker plot, and interpretations
Session 3: Discovering relationships among data
Scatter-plots and interpretations of relationships
Create linear relationships between variables
Predictions and determine confidence intervals.
Session 4: Comparing sets of data for similarity.
Use of t-tests and ANOVA
Interpretation of results
Session 5: Time-series data
Analysis of time-series to forecast future values
Comparing forecasting models.
Session 6: Data mining
Identifying data mining projects
Data mining techniques
Interpretation of results
Each session will include (a) presentation, summary of literature with references for further
information, (ii) hands-on lab exercises with real data sets and (iii) quizzes to assess
Tools used: Excel and Rapidminer

Course Directory [training on all levels]

Upcoming Classes