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
Open discussion with trainer
Tomek Danowski - GE Medical Systems Polska Sp. Z O.O.
Course - Process Mining
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
Upcoming Courses (Minimal 5 peserta)
Related Courses
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 & 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
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.
Process Mining
21 HoursPenambangan proses, atau Automated Business Process Discovery (ABPD), adalah teknik yang menerapkan algoritma pada log peristiwa untuk tujuan menganalisis proses bisnis. Penambangan proses melampaui penyimpanan data dan analisis data; ia menjembatani data dengan proses dan memberikan wawasan tentang tren dan pola yang memengaruhi efisiensi proses.
Format Kursus
- Kursus ini dimulai dengan tinjauan umum mengenai teknik yang paling umum digunakan untuk penambangan proses. Kami membahas berbagai algoritme dan alat penemuan proses yang digunakan untuk menemukan dan memodelkan proses berdasarkan data kejadian mentah. Studi kasus nyata diperiksa dan kumpulan data dianalisis menggunakan kerangka kerja sumber terbuka ProM.
Introductory R for Biologists
28 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 also found followers among statisticians, engineers and scientists without computer programming skills who find it easy to use. Its popularity is due to the increasing use of data mining for various goals such as set ad prices, find new drugs more quickly or fine-tune financial models. R has a wide variety of packages for data mining.
Statistics with SPSS Predictive Analytics Software
14 HoursGohal:
Belajar bekerja dengan SPSS pada tingkat independensi
Para penerima:
Analis, peneliti, ilmuwan, mahasiswa dan semua orang yang ingin memperoleh kemampuan untuk menggunakan paket SPSS dan mempelajari teknik penambangan data yang populer.