Data Mining with Excel Training Course

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 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.

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 results.

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

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 mining.

In this instructor-led, live training in Poland, participants will learn how to build a Data Vault.

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

• Understand the architecture and design concepts behind Data Vault 2.0, and its interaction with Big Data, NoSQL and AI.
• Use data vaulting techniques to enable auditing, tracing, and inspection of historical data in a data warehouse.
• Develop a consistent and repeatable ETL (Extract, Transform, Load) process.
• Build and deploy highly scalable and repeatable warehouses.

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 and help them to understand hidden information.

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 mining.

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, visualization, querying, updating and information privacy.

This instructor-led, live training in Poland (online or onsite) is aimed at beginner-level professionals who wish to gain a mastery of the fundamentals of R and how to work with data.

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

• Understand the R programming environment and RStudio interface.
• Import, manipulate, and explore datasets using R commands and packages.
• Perform basic statistical analysis and data summarization.
• Generate visualizations using both base R and ggplot2.
• Manage workspaces, scripts, and packages effectively.

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.

The "Pentaho Business Intelligence (PBI) - reporting modules" training allows you to gain knowledge in the field of Business Intelligence, focusing on the reporting modules of the Pentaho platform. Participants will learn to use Report Designer to create reports from basic to advanced levels, including advanced data formatting, using parameters, PDI transformations and JavaScript queries. Additionally, the training covers the use of Business Intelligence Server, scheduling, sharing reports and the basics of creating transformations in Pentaho Data Integration.

The "Pentaho Data Integration (PDI) - ETL data processing module" training offers advanced knowledge of the Pentaho platform, covering the area of Business Intelligence, reporting, data analysis and data integration. It is aimed at programmers, architects and application administrators, enabling learning how to design, implement, monitor and optimize ETL processes using Pentaho Data Integration (PDI). Participants will gain skills in working with various types of data, filtering, grouping and combining data, as well as scheduling tasks, running transformations and creating clusters. The training also covers advanced topics such as data versioning, database transactions, the use of JavaScript, mapping transformations, data type conversion and remote startup.

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 processes and provides insights into the trends and patterns that affect process efficiency. 

Format of the Course

• The course starts with an overview of the most commonly used techniques for process mining. We discuss the various process discovery algorithms and tools used for discovering and modeling processes based on raw event data. Real-life case studies are examined and data sets are analyzed using the ProM open-source framework.

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 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.

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 techniques.