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

Metadata sheet

Exercises and Datasets

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>KNIME中的财务分析</h2>
<p>本案例研究深入探讨了 KNIME 在财务分析中的实际应用，利用真实的采购数据展示了这一工具的强大能力。 参与者将从一个典型的商业案例开始，该案例需要进行细致的财务审查。 这门课程将细致地引导学员完成将 Excel、CSV 和 SQL 数据导入 KNIME 的初始步骤，并重点讲解如何高效地清洗和预处理数据，以便进行分析。 这项基础知识对于在商业智能和数据分析项目中充分利用 KNIME 至关重要。</p>

<h2>在 KNIME 中创建高效工作流</h2>
<p>随着案例研究的推进，参与者将学习构建和优化工作流，以自动化分析流程，重点是将原始数据转化为可执行的洞察。 学习者将学习如何汇总数据以满足特定的分析需求，以及如何利用 KNIME 的丰富节点阵列执行复杂计算。 </p>

<h2>可视化与数据导出技术</h2>
<p>最后一部分重点讲解金融数据的可视化和导出，这些都是任何数据驱动决策过程中至关重要的技能。 学习者将探索如何创建引人注目的图表和表格。 这不仅有助于更好地理解数据，还能更有效地向利益相关者展示数据。 此外，课程还涵盖多种导出已分析数据的方法，确保学生能够充分掌握以最适合专业需求的格式分享研究结果的技能。</p>

Data Visualization in KNIME

在KNIME中应用财务分析，使用真实数据，提高数据准备和工作流程技能。

Case Study: Financial Analysis in KNIME

在 KNIME 中运用财务分析，结合真实数据，提升数据准备和工作流技能。

KNIME 基础知识

Transforming Excel data

Case Study: Financial Analysis in KNIME

动手互动练习