Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
Sign in
  • KNIME Hub
  • knime
  • Spaces
  • Finance, Accounting, and Audit
  • Timesheets Aggregation & Analysis
WorkflowWorkflow

Timesheets Aggregation & Analysis

date&time manual table manipulation timesheets p&l finance +5

Last edited: 

Drag Workflow
Workflow preview
This workflow reads timesheets from Google Sheets and additional information about employees and projects from Excel files. The information is joined, aggreagted and grouped to: 1) calculate the expenses for clients and the company itself. The aggregated and transformed data can be sent to P&L and visualized. 2) analyze each project regarding its profitability and discrepancies between real expenses and the price aggreed on with a client (client budget). To execute this workflow, upload the timesheets data provided in the workflow data area to your Google Drive and connect to it using the Google Authentication node pop-up. Specify the working directory to the timesheets data on your Drive in the Google Drive Connector node and select the timesheets data in the Excel Reader node as suggested in the workflow. Alternatively, disconnect the Excel Reader from Google Drive by removing green/blue colored File System Connection port and read the data locally.

External resources

  • From Excel to KNIME
  • Will They Blend
  • Finance Data Analysis with KNIME
  • Blueprints for Finance Analysis

Used extensions & nodes

Created with KNIME Analytics Platform version 4.3.1
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.1

  • KNIME Excel Support Trusted extension

    KNIME AG, Zurich, Switzerland

    Versions 4.3.0, 4.3.1

  • KNIME Google Connectors Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • KNIME JavaScript Views Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • KNIME Math Expression (JEP) Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

Legal

By downloading the workflow, you agree to our terms and conditions.

License (CC-BY-4.0)
Discussion
Discussions are currently not available, please try again later.

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2021 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits