In this first chapter, you'll be introduced to the business case you need to answer and you will plan your KNIME workflow. You will then start building your workflow, beginning with importing the data.

Financial analysis in KNIME

Planning your project

Creating the workflow and importing excel

Importing multiple csv

Importing database data

Planning steps

Answering a business case with KNIME

Chapter 2 is where you'll be applying your data cleaning and transformation skills to the London Fire Brigade data. You'll be getting it clean, useful and consistent to make sure that it is suitable for answering the business case. You'll also be practicing the use of metanodes to make the workflow easy to use.


Data cleaning and transformation

Options

Cleaning

Transforming

Documenting

Cleaning, transforming, or documenting?

Cleaning Excel data

Transforming Excel data

Cleaning and transforming CSV data

Cleaning and transforming database data

Manipulating the data into shape

Chapter 3 gives you the opportunity to practice your KNIME merging and aggregation skills to the London Fire Brigade data. You will extract the results that answer the business case.  You will be practicing grouping and pivoting to achieve the desired results.

Merging and aggregating data

Which node does what?

Merge the data

Grouping

Simple pivoting

Complex pivoting

Bringing it all together

Our final chapter practices KNIME data visualization and exporting.  You will be creating useful charts and other visualizations to explore the data and sending the data to spreadsheets and databases. The business case will be answered and your first financial analysis project with KNIME will be complete.


Visualizing and exporting

Reviewing the process

Visualization - bar and line charts

Visualization - scatter plot and table

Exporting data

Wrap up!

Seeing the results

Exercises and Datasets

Metadata sheet

This course uses real-world data to guide the student in applying knowledge and techniques learned in KNIME courses to create a financial analysis workflow on purchase data. The course starts with a business case and guides the student through creating a workflow that will perform the necessary analysis, specific visualizations, and data export to fulfill the case's requirements. The student will import, clean, transform, and aggregate the data and create bar charts, line charts, and table displays, as well as export the data in different formats.

<h2>Financial Analysis in KNIME</h2>
<p>This case study dives deep into the practical use of KNIME for financial analysis, utilizing real-world purchase data to demonstrate this tool's power. Participants will start with a typical business case that requires detailed financial scrutiny. The course meticulously guides students through the initial steps of importing Excel, CSV, and SQL data into KNIME, highlighting how to effectively clean and preprocess the data for analysis. This foundational knowledge is crucial for leveraging KNIME for business intelligence and data analysis projects.</p>

<h2>Creating Effective Workflows in KNIME</h2>
<p>As the case study progresses, participants will learn to construct and refine workflows that automate the analysis process, focusing on transforming raw data into actionable insights. Learners will learn how to aggregate data to suit specific analytical needs and how to utilize KNIME's vast array of nodes to perform complex calculations. </p>

<h2>Visualization and Data Export Techniques</h2>
<p>The final part concentrates on visualizing and exporting financial data, which are critical skills in any data-driven decision-making process. Learners will explore how to create compelling charts and tables. This not only helps in understanding the data better but also in presenting it effectively to stakeholders. Additionally, the course covers various methods of exporting analyzed data, ensuring that students are well-equipped to share their findings in formats that best suit professional needs.</p>

Data Visualization in KNIME

Apply financial analysis in KNIME with real-world data, enhancing data preparation and workflow skills.

Case Study: Financial Analysis in KNIME

KNIME Fundamentals

Transforming Excel data

Case Study: Financial Analysis in KNIME

Hands-on interactive exercise