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

Requirements

  • A basic understanding of Excel

Audience

  • Data Scientists
  14 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

I liked the examples and the way he explained.

Sandeep Parashar

The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions.

Daria Rudin

Tamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.

Christine Weiler

I mostly enjoyed the exercises.

Anna Szumniak

Training agenda was well thought out.

Przemek Zalasinski

I genuinely enjoyed the short exercises.

Mateusz Podsiadlo

The pace was the perfect fact that we had a group specially selected. We went through all the functionalities of Excel, which I wanted to discover such things that I did not know.

Ewa Czerwińska

a lot of exercise

Małgorzata Jasniecka

Possibilities to practice all the knowledge gained during the training in additional tasks.

Wioleta Kubczak

a large range of information

Piotr Janicki

problem solving on a regular basis. searching for the most useful elements for trainees.

Dominik Gardo

Trainer's help in solving problems

Tomasz Czornak

Doing live exercises in Excel, and trainer knowledge.

Perceval Pradelle

the way of providing information, simple readability, the ability to make contact

Pirelli

adjusting the scope of training to the actual needs at my workplace

Marcin Ostrówka

The training contained a lot of interesting and well-chosen examples for practical use.

Piotr Walewski

The atmosphere, the knowledge of the trainer, skills of the manager

Beata Perzanowska

The way of conducting classes, clear transfer of issues

Anna Kremens

Creating and PivotTable capabilities. Providing / looking for answers to current questions / problems.

Bartosz Muńko

Content and the way it was provided.

Marcin Samborski

temperament, knowledge, efficiency

Henryk Kubiak

It was really nice of the trainer that he took a lot of time to answer our questions and helped us improve or gave us hints on how to improve some macros we were already using without fully understanding the code.

David Trieu - CD Projekt SA

I generally enjoyed the practical examples.

Marika Agius

I liked the step by step and hands on realistic data examples.

CARL MIFSUD

I mostly liked the hands-on practice and exercises.

Godwin Spiteri

Tamil has an excellent way of explaining things. He speaks clearly and will take the time to explain things individually when necessary.

Theresa Fenech

The trainer was very well prepared and encouraged interaction with the group. The exercises were very interesting and enabled us to utilize the knowledge on the subject in a practical context.

Tomasz Kolbuszewski

Trainer was calm and very patient to explain in a way that everyone understands, even those with basic knowledge of excel.

Sera Farrugia

I appreciated its applicability to work related issues.

Ranier Buhagiar

I appreciate that the training was customized to our company's needs.

Rosanne Tanti

I liked the fact that we were a small group and therefore the trainer was able to offer individual attention to each trainee.

Claire Pace

clear, readable messages, very well prepared materials for work. It is a pity that screenshots of descriptive materials in English

Renata Kurek

A lot of practical issues

innogy Polska S.A.

Practical exercises, discovering new excel possibilities

Małgorzata Kiedykl

Gaining new skills in Excel and learning the VBA language which I hope will help me in my future work.

Sylwia Śliwka

A lot of exercise. Trainer doesn't need to have support for his course. He has really great knowledge for his subject.

Quentin Demeyere

interesting and at the same time easy, absorbed way of presentation

Justyna Gutowska-Błaszyk

solving live problems (problems that participants had).

Dominik Gardo

tips

Kamil Kowalski

a large variety of examples, transparent creation of forms step by step, efficiently conducted workshops despite the diversity of knowledge and skills of participants

Bogusia Kafel

The trainer prepared for training, specifically and on the subject

P4 Sp. z o.o.

Work on computers

P4 Sp. z o.o.

specific examples and adjusting the exercises to our needs

Marcin Gołdyn

practical examples

P4 Sp. z o.o.

tempo and help adapted to the participants' needs

Dariusz Leszczak-Phong

Broad knowledge of the lecturer

Michał Jąkalski

I generally enjoyed the instructors knowledge.

US Bank

Leader's enthusiasm and commitment :)

Credit Agricole Bank Polska S.A

exercises

Credit Agricole Bank Polska S.A

In case of problems, an individual approach; patience.

Credit Agricole Bank Polska S.A

Contact, no barriers to making contact. exercises

Credit Agricole Bank Polska S.A

commitment and direct contact and practical knowledge

Credit Agricole Bank Polska S.A

I generally was benefit from the examples.

Ewelina Palacz

The training was really useful. I liked the most the parts related to the pivot tables, filtering, lockup options and data consolidation. I appreciated trainer's excellent knowledge on the subject. His attitude was very good as well. He built open and 'not so formal' atmosphere which helped participants to ask the questions or speak about their daily excel issues. He was fully understandable during the whole training and his way of explaining the topics was direct and adequate.

Katarzyna Chalinska - UBS Business Solutions Poland Sp. z o.o.

Training was well prepared from the beginning. Enthusiasm and great attitude of the trainer helped us successfully deliver the training. Positive feelings! Highly recommended!.

Łukasz

I was benefit from the possibility to ask various questions and real life solutions to them.

Magdalena Wojtas

A synthetic and efficient course of training. A small group, a lot of exercises

Anna Bazel

Practical use of content provided during training in the exercises. Translation on examples.

SECO/WARWICK S.A. ; ; TRW Steering Systems Poland Sp. z o.o.

Very helpful, made me feel more comfortable using Excel.

TruGreen

I appreciated the amount of effort and energy that Roman put into this. Hours and hours and hours of Excel training will inevitably get boring, but Roman's attention to detail, energy, and thoroughness made me want to keep learning--even at 5 PM on the second, of two, eight hour learning days.

Christian Labenberg - TruGreen

I generally enjoyed the relevant examples and interesting curriculum.

Alex Gubanov

Excellent trainer. Very adept at modifying the course to fit our time line.

TruGreen

I liked learning new ways to process data in Excel, in an engaging and fun learning environment.

Hunter Smith

I mostly was benefit from the interaction with the class.

TruGreen

Roman was great! He was really entertaining and helpful. He is very knowledgeable and passionate about the subject. He made the class enjoyable, and made you want to learn and ask questions.

TruGreen

A lot of shortcuts and such flavors that improve work.

DNV GL Business Assurance Poland Sp. z o.o.

work on our real files

Katarzyna Grodecka

Very good introduction to VBA, numerous examples, getting to know many previously unknown functionalities

Przemysław Naskręt

What I liked most was the very practical approach, the ability to work on files on which we actually work every day and to adapt the training to our needs, our internal work specifics.

Anna Jarocka

the scope of training to stick to topics; a lot of examples

DNV GL Business Assurance Poland Sp. z o.o.

The coach had time for all participants and made sure that no one was left with mistakes / unresolved task, and yet there was not enough time to implement the planned material

Anna Niestępska

The flexibility of the trainer and the ability to adjust the exercises to the questions raised during the training. The training did not have a rigid plan, the plan evolved during the training under the influence of my needs.

Paweł Imbir

Tricks and Tips and also structural items.

Ritesh Gupta

Learned many new tricks and lots of eye-openers. Tamil kept it interesting and was always able to surprise with new things and insights.

APM Terminals B.V.

The trainer was a knowledgeable and approachable person it was good to refresh & extend my excel knowledge.

laura kooijman

The smart tips that are not too complicated but helpful.

APM Terminals B.V.

Tamil was great at handling our idiosyncrasies and responding to specific needs from people at various skill levels.

Brian Pishko

Flexibility in conducting training, matching the scope of training to participants.

Marcin Doleżyk

I was benefit from the examples from different area of VBA programming.

UBS Business Solutions Poland Sp. z o.o.

The whole topic is interesting - everything was OK.

Bartosz Wierzewski - UBS B

Good knowledge of the lecturer

Marcin Doleżyk

I was benefit from a lot of exercises.

UBS Business Solutions Poland Sp. z o.o.

I was benefit from the well prepared examples, plenty of opportunity to practice.

Piotr Ogar - UBS Business Solutions Poland Sp. z o.

Well adjusted to the level of trainees.

Ewelina - UBS Business Solutions Poland Sp. z o.o.

I generally enjoyed the exercises.

UBS Business Solutions Poland Sp. z o.o.

The training was complex and with many useful examples.

Anna Mycka - UBS Business Solutions Poland Sp. z o.o.

Everything was shown very well but as I said too fast.

Damian Szuflada - UBS Business Solutions Poland Sp. z o.o.

I generally was benefit from the quality of the material, exercises.

UBS Business Solutions Poland Sp. z o.o.

I mostly was benefit from the fitted training to people needs.

Robert Solek - UBS Business Solutions Poland Sp. z o.o.

matching the examples given by the participants

NBP

practical knowledge

Oskar Krzesicki - NBP

reaction to the participants' questions

NBP

Good contact with listeners and willingness to explain until the end of ambiguity

Katarzyna Zięba - NBP

I enjoyed the flexibility of the trainer, many practical examples, good atmosphere during the training.

Aleksandra Bauer - UBS Business Solutions Poland Sp. z o.o.

I really enjoyed the many practice.

Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.

A lot of examples ..

ADM CONSULTING GROUP SPÓŁKA AKCYJNA

The right amount of exercise.

ADM CONSULTING GROUP SPÓŁKA AKCYJNA

That the trainer walked around and devoted time to virtually everyone.

ADM CONSULTING GROUP SPÓŁKA AKCYJNA

Checking exercises by the lecturer on each computer on a regular basis.

ADM CONSULTING GROUP SPÓŁKA AKCYJNA

Related Courses

From Data to Decision with Big Data and Predictive Analytics

 21 hours

Audience If you try to make sense out of the data you have access to or want to analyse unstructured data available on the net (like Twitter, Linked in, etc...) this course is for you. It is mostly aimed at decision makers and people who need to

Data Mining and Analysis

 28 hours

Objective: Delegates be able to analyse big data sets, extract patterns, choose the right variable impacting the results so that a new model is forecasted with predictive

Data Mining

 21 hours

Course can be provided with any tools, including free open-source data mining software and applications

Data Mining with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

MonetDB

 28 hours

MonetDB is an open-source database that pioneered the column-store technology approach. In this instructor-led, live training, participants will learn how to use MonetDB and how to get the most value out of it. By the end of this training,

Oracle SQL Intermediate - Data Extraction

 14 hours

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

Introductory R for Biologists

 28 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among

Statistics with SPSS Predictive Analytics Software

 14 hours

Goal: Learning to work with SPSS at the level of independence The addressees: Analysts, researchers, scientists, students and all those who want to acquire the ability to use SPSS package and learn popular data mining

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Data Visualization

 28 hours

This course is intended for engineers and decision makers working in data mining and knoweldge discovery. You will learn how to create effective plots and ways to present and represent your data in a way that will appeal to the decision makers

Foundation R

 7 hours

The objective of the course is to enable participants to gain a mastery of the fundamentals of R and how to work with data.

Data Mining & Machine Learning with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

Data Science for Big Data Analytics

 35 hours

Big data is data sets that are so voluminous and complex that traditional data processing application software are inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer,

Knowledge Discovery in Databases (KDD)

 21 hours

Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing. In

Process Mining

 21 hours

Process mining, or Automated Business Process Discovery (ABPD), is a technique that applies algorithms to event logs for the purpose of analyzing business processes. Process mining goes beyond data storage and data analysis; it bridges data with