Data Mining with Excel Training Course
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
Requirements
- A basic understanding of Excel
Audience
- Data Scientists
Open Training Courses require 5+ participants.
Data Mining with Excel Training Course - Booking
Data Mining with Excel Training Course - Enquiry
Testimonials (5)
how the trainor shows his knowledge in the subject he's teachign
john ernesto ii fernandez - Philippine AXA Life Insurance Corporation
Course - Data Vault: Building a Scalable Data Warehouse
Very useful in because it helps me understand what we can do with the data in our context. It will also help me
Nicolas NEMORIN - Adecco Groupe France
Course - KNIME Analytics Platform for BI
I genuinely enjoyed the hands passed exercises.
Yunfa Zhu - Environmental and Climate Change Canada
Course - Foundation R
Richard's training style kept it interesting, the real world examples used helped to drive the concepts home.
Jamie Martin-Royle - NBrown Group
Course - From Data to Decision with Big Data and Predictive Analytics
The example and training material were sufficient and made it easy to understand what you are doing.
Teboho Makenete
Course - Data Science for Big Data Analytics
Upcoming Courses (Minimal 5 peserta)
Related Courses
Cluster Analysis with R and SAS
14 HoursThis instructor-led, live training in Indonesia (online or onsite) is aimed at data analysts who wish to program with R in SAS for cluster analysis.
By the end of this training, participants will be able to:
- Use cluster analysis for data mining
- Master R syntax for clustering solutions.
- Implement hierarchical and non-hierarchical clustering.
- Make data-driven decisions to help to improve business operations.
From Data to Decision with Big Data and Predictive Analytics
21 HoursAudience
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 choose what data is worth collecting and what is worth analyzing.
It is not aimed at people configuring the solution, those people will benefit from the big picture though.
Delivery Mode
During the course delegates will be presented with working examples of mostly open source technologies.
Short lectures will be followed by presentation and simple exercises by the participants
Content and Software used
All software used is updated each time the course is run, so we check the newest versions possible.
It covers the process from obtaining, formatting, processing and analysing the data, to explain how to automate decision making process with machine learning.
Data Mining and Analysis
28 HoursObjective:
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 results.
Data Mining
21 HoursCourse can be provided with any tools, including free open-source data mining software and applications
Data Mining with Python
14 HoursPelatihan langsung yang dipandu oleh instruktur ini (online atau onsite) ditujukan bagi analis data dan ilmuwan data yang ingin menerapkan teknik analisis data yang lebih canggih untuk penambangan data menggunakan Python.
Pada akhir pelatihan ini, peserta akan dapat:
- Memahami area-area penting dalam penambangan data, termasuk penambangan aturan asosiasi, analisis sentimen teks, ringkasan teks otomatis, dan deteksi anomali data.
- Membandingkan dan menerapkan berbagai strategi untuk memecahkan masalah penambangan data dunia nyata.
- Memahami dan menginterpretasikan hasilnya.
Format Kursus
- Ceramah dan diskusi interaktif.
- Banyak latihan dan praktik.
- Implementasi langsung di lingkungan lab langsung.
Opsi Kustomisasi Kursus
- Untuk meminta pelatihan yang disesuaikan untuk kursus ini, silakan hubungi kami untuk mengatur.
Data Mining with R
14 HoursR 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 mining.
Data Vault: Building a Scalable Data Warehouse
28 HoursDalam pelatihan langsung yang dipandu instruktur di Indonesia ini, peserta akan mempelajari cara membangun Data Vault.
Pada akhir pelatihan ini, peserta akan dapat:
- Memahami arsitektur dan konsep desain di balik Data Vault 2.0, dan interaksinya dengan Big Data, NoSQL dan AI.
- Gunakan teknik penyimpanan data untuk memungkinkan audit, penelusuran, dan pemeriksaan data historis dalam gudang data.
- Kembangkan proses ETL (Ekstrak, Transformasi, Muat) yang konsisten dan dapat diulang.
- Bangun dan terapkan gudang yang sangat skalabel dan dapat diulang.
Data Visualization
28 HoursThis 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 and help them to understand hidden information.
Data Mining with Weka
14 HoursPelatihan langsung yang dipandu instruktur di Indonesia (online atau di tempat) ini ditujukan untuk analis data dan ilmuwan data tingkat pemula hingga menengah yang ingin menggunakan Weka untuk melakukan tugas penambangan data.
Pada akhir pelatihan ini, peserta akan dapat:
- Instal dan konfigurasikan Weka.
- Memahami lingkungan dan meja kerja Weka.
- Lakukan tugas penambangan data menggunakan Weka.
Data Mining & Machine Learning with R
14 HoursR adalah bahasa pemrograman gratis sumber terbuka untuk komputasi statistik, analisis data, dan grafik. R digunakan oleh semakin banyak manajer dan analis data di dalam perusahaan dan akademisi. R memiliki beragam paket untuk penambangan data.
Data Science for Big Data Analytics
35 HoursBig 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, visualization, querying, updating and information privacy.
Foundation R
7 HoursPelatihan daring atau tatap muka ini di Indonesia, yang dipimpin oleh instruktur, ditujukan bagi profesional tingkat pemula yang ingin menguasai dasar-dasar R dan cara bekerja dengan data.
Selesai pelatihan ini, peserta akan dapat:
- Mengerti lingkungan pengembangan R dan antarmuka RStudio.
- Mengimpor, memanipulasi, dan mengeksplorasi dataset menggunakan perintah dan paket R.
- Menjalankan analisis statistik dasar dan ringkasan data.
- Menghasilkan visualisasi menggunakan baik base R maupun ggplot2.
- Memanage workspace, skrip, dan paket dengan efektif.
KNIME Analytics Platform for BI
21 HoursKNIME Analytics Platform is a leading open source option for data-driven innovation, helping you discover the potential hidden in your data, mine for fresh insights, or predict new futures. With more than 1000 modules, hundreds of ready-to-run examples, a comprehensive range of integrated tools, and the widest choice of advanced algorithms available, KNIME Analytics Platform is the perfect toolbox for any data scientist and business analyst.
This course for KNIME Analytics Platform is an ideal opportunity for beginners, advanced users and KNIME experts to be introduced to KNIME, to learn how to use it more effectively, and how to create clear, comprehensive reports based on KNIME workflows
Platforma analityczna KNIME - szkolenie kompleksowe
35 HoursPelatihan "Platform Analitik KNIME" menawarkan ikhtisar komprehensif tentang platform analisis data gratis ini. Program ini mencakup pengenalan pemrosesan dan analisis data, instalasi dan konfigurasi KNIME, pembuatan alur kerja, metodologi untuk membuat model bisnis, dan pemodelan data. Kursus ini juga mencakup alat analisis data tingkat lanjut, impor dan ekspor alur kerja, integrasi alat, proses ETL, penambangan data, visualisasi, ekstensi dan integrasi dengan alat seperti R, Java, Python, Gephi, Neo4j. Kesimpulannya mencakup gambaran pelaporan, integrasi dengan BIRT dan KNIME WebPortal.
Oracle SQL Intermediate - Data Extraction
14 HoursTujuan dari kursus ini adalah untuk memungkinkan peserta memperoleh penguasaan tentang cara bekerja dengan bahasa SQL di database Oracle untuk ekstraksi data pada tingkat menengah.