Home >
Microsoft BI >
Data Mining using Microsoft Excel
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% |
Detailed Outline |
|