Data Mining using Microsoft Excel

Course Code: BIMEDM
Currency: Excel 2007/2010
Duration: 1 day
Audience: Excel Power Users, Data Analysts and BI Consultants/BI Developers.
Prerequisites: Completion of our course MS Excel Level 3: Advanced or equivalent knowledge.
Summary: This hands-on course demonstrates how to use the Data Mining Add-in for Microsoft Excel to:
  • Analyse how values in one column are influenced by values in other columns
  • Detect groups with similar characteristics
  • Perform time series forecasting
  • Perform scenario-based analysis
  • Perform shopping basket analysis and identify cross-selling opportunities
  • Etc.
Objectives: Upon completion of this course, the delegate should be able to perform predictive analytics using Excel’s Table Analysis Tools.
Format: Hands-on 65%, lecture 35%
View full outline in PDF formatDetailed Outline Bookmark and Share

print  |  top of page