Course Code: dminingexcel
Duration: 14 hours
Prerequisites:
  • A basic understanding of Excel

Audience

  • Data Scientists
Overview:

Data mining is the process of identifying patterns in big data with data science methods such as machine learning. Using Excel as a data analytical suite, users can perform data mining and analysis.

This instructor-led, live training (online or onsite) is aimed at data scientists who wish to use Excel for data mining.

By the end of this training, participants will be able to:

  • Explore data with Excel to perform data mining and analysis.
  • Use Microsoft algorithms for data mining.
  • Understand concepts in Excel data mining.

Format of the Course

  • Interactive lecture and discussion.
  • Lots of exercises and practice.
  • Hands-on implementation in a live-lab environment.

Course Customization Options

  • To request a customized training for this course, please contact us to arrange.
Course Outline:

Introduction

Data Mining Overview

  • Crisp-DM
  • Algorithms for data mining
  • Data mining structures and models

Preparing the Development Environment

  • Installing and configuring Excel

Data Mining Algorithms and Excel to SQL Server Analysis Services

  • Using Microsoft algorithms
  • Working with data mining structures and models

Data Mining Add-Ins

  • Working with data modeling
  • Identifying influencers and categories
  • Predicting with a model

Summary and Conclusion

Sites Published:

United Arab Emirates - Data Mining with Excel

Qatar - Data Mining with Excel

Egypt - Data Mining with Excel

Saudi Arabia - Data Mining with Excel

South Africa - Data Mining with Excel

Brasil - Data Mining with Excel

Canada - Data Mining with Excel

中国 - Data Mining with Excel

香港 - Data Mining with Excel

澳門 - Data Mining with Excel

台灣 - Data Mining with Excel

USA - Data Mining with Excel

Österreich - Data Mining with Excel

Schweiz - Data Mining with Excel

Deutschland - Data Mining with Excel

Czech Republic - Data Mining with Excel

Denmark - Data Mining with Excel

Estonia - Data Mining with Excel

Finland - Data Mining with Excel

Greece - Data Mining with Excel

Magyarország - Data Mining with Excel

Ireland - Data Mining with Excel

Luxembourg - Data Mining with Excel

Latvia - Data Mining with Excel

España - Data Mining with Excel

Italia - Data Mining with Excel

Lithuania - Data Mining with Excel

Nederland - Data Mining with Excel

Norway - Data Mining with Excel

Portugal - Data Mining with Excel

România - Data Mining with Excel

Sverige - Data Mining with Excel

Türkiye - Data Mining with Excel

Malta - Data Mining with Excel

Belgique - Data Mining with Excel

France - Data Mining with Excel

日本 - Data Mining with Excel

Australia - Data Mining with Excel

Malaysia - Data Mining with Excel

New Zealand - Data Mining with Excel

Philippines - Data Mining with Excel

Singapore - Data Mining with Excel

Thailand - Data Mining with Excel

Vietnam - Data Mining with Excel

India - Data Mining with Excel

Argentina - Data Mining with Excel

Chile - Data Mining with Excel

Costa Rica - Data Mining with Excel

Ecuador - Data Mining with Excel

Guatemala - Data Mining with Excel

Colombia - Data Mining with Excel

México - Data Mining with Excel

Panama - Data Mining with Excel

Peru - Data Mining with Excel

Uruguay - Data Mining with Excel

Venezuela - Data Mining with Excel

Polska - Data Mining with Excel

United Kingdom - Data Mining with Excel

South Korea - Data Mining with Excel

Pakistan - Data Mining with Excel

Sri Lanka - Data Mining with Excel

Bulgaria - Data Mining with Excel

Bolivia - Data Mining with Excel

Indonesia - Data Mining with Excel

Kazakhstan - Data Mining with Excel

Moldova - Data Mining with Excel

Morocco - Data Mining with Excel

Tunisia - Data Mining with Excel

Kuwait - Data Mining with Excel

Oman - Data Mining with Excel

Slovakia - Data Mining with Excel

Kenya - Data Mining with Excel

Nigeria - Data Mining with Excel

Botswana - Data Mining with Excel

Slovenia - Data Mining with Excel

Croatia - Data Mining with Excel

Serbia - Data Mining with Excel

Bhutan - Data Mining with Excel

Nepal - Data Mining with Excel

Uzbekistan - Data Mining with Excel