Icon

MSA 580 Project 1

Concatenate company and industry average rows
Concatenate
Visualize company metrics vs industry average as bar chart
Bar Chart
Sorter
Filter rows for Income Statement
Nominal Value Row Filter
Column Filter
5 Pharm balance sheet
CSV Reader
Column Filter
5 Pharm cash flow
CSV Reader
Filter rows for Balance Sheet
Nominal Value Row Filter
Column Filter
Filter rows for Cash Flow
Nominal Value Row Filter
5 Pharm income statement
CSV Reader
Gross Margin
Math Formula
Current Ratio
Math Formula
Column Filter
Column Filter
Bar Chart
Bar Chart
Operating Margin
Math Formula
Operating Margin
Math Formula
Net Margin
Math Formula
Net Margin
Math Formula
Bar Chart
Free Cash Flow
Math Formula
Gross Margin
Math Formula
Quick Ratio
Math Formula
Bar Chart
Debt to Equity
Math Formula
ROA
Math Formula
ROA
Math Formula
ROE
Math Formula
ROE
Math Formula
Column Filter
Metric Table
Column Filter
Income Statement
CSV Reader
Balance Sheet
CSV Reader
Cash Flow
CSV Reader
Debt to Equity
Math Formula
Bar Chart
Current Ratio
Math Formula
Quick Ratio
Math Formula
(Benchmark Table)
GroupBy
Free Cash Flow
Math Formula
Filter rows whereYear is between 2021and 2025 for metricstable
Expression
Bar Chart
Metric Tableand Benchmark Tableby industry and year
Cross Joiner
5pharmaceuticalcompanies
CSV Reader
Compute industry averages for all metrics (mean aggregation)
GroupBy
Companies Metadata
CSV Reader
Compute industry averages for all metrics
GroupBy
Joiner
Label industry average row
Constant Value Column Appender
Pharmaceutical Preparations
Row Filter
Concatenate original company data with industry average row
Concatenate
Joiner
Label company rows
Constant Value Column Appender
Joiner

Nodes

Extensions

Links