Training Dates - please open the booking form by clicking the listed date.

training duration icon Data Mining - Using MS Excel

Duration: 3 Days
Delivery Type: Classroom
Target Audience: Information workers, IT Professional
Course Number: 2020597
Method: Lecture with examples and exercises.
  • Topics
  • Summary
  • Trainer
  • Download
  • Conditions

Tab 1

Topicsss

A. Data Mining and MS SQL Server - Introduction

[Duration: 0.5 Days] Business Intelligence and Data Mining - Usage Scenarios for Data Mining - Data Mining Techniques in Microsoft SQL Server and MS Excel - Server and Client Components: MS SQL Server Analysis Services and Data Mining Add-Ins for MS Excel and MS Visio - Data Mining Life Cycle and Tasks - Data Mining Techniques in MS SQL Server - Project Cycle (Data Collection, Processing and Cleaning of Data, Modeling, Model Evaluation, Reporting, Forecasting, Integration into Applications, Model Management and Maintenance)

B. Classification using Microsoft Decision Trees

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model - DMX Queries - Classification Model, Regression Model, Relationship Model

C. Classification using Microsoft Naive Bayes

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model - DMX Queries - Dependency Network, Attribute Profiles, Attribute Characteristics, Attribute Discrimination

D. Microsoft Time Series

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Auto Regression, Multiple Time Series, Seasonality, Historic Predictions, Caching Predictions - DMX Queries

E. Microsoft Clustering

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Clustering Types, Scalable Clustering, Predictions and Cluster Assignment - DMX Queries: Cluster, Probability, Histograms, CaseLikelihood

F. Microsoft Sequence Clustering

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Markov Chains, Transition Matrix, Clustering and Markov Chains, Decomposition - DMX Queries

G. Microsoft Association Rules

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Itemset, Support, Probability and Confidence, Interestingness and Importance - DMX Queries

H. Microsoft Neural Network

[Duration: 0.25 Days] Introduction to the Algorithm - Parameters - Building a Model and Using the Model: Combination and Activation, Normalization and Mapping, Topology of a Neural Network , Model Training - DMX Queries

I. Table Analysis Tools for Excel

[Duration: 0.25 Days] Data Cleaning and Sampling - Prediction Calculator - Shopping Basket Analysis

J. Data Mining Client for Excel

[Duration: 0.25 Days] Adding and Processing Structures and Models - Testing Models - Data Mining Queries - Using Data Mining-Models in Integration Services – Using Data Mining Results in Reporting Services

Tab 3

Tab 4

Tab 5

Tab 6

Description
For trainings with hands-on labs you are kindly requested to bring your own laptop with the required software. Alternatively, you can use our virtual machines (VMWare) for the MS Windows OS.
Description
These course dates don´t fit in your calendar?
We also offer individual appointments or on-site trainings for your team and charge a per-day fee depending on the size of the group.
Description
In order to enroll for a training or for general inquiries regarding our training and consulting services please use the contact form, send us an email or phone. Kontaktformular oder die folgenden Möglichkeiten:
  • Phone : +1.305.395.7962
  • Fax : +1.305.395.7964