Project: report in Pentaho and BIRT (PostgreSQL)

Using the attached CSV file using Postgres, Pentaho and BIRT, generate a report (in pdf. form) containing:

-Title: "PPK Project Task - currency report:" (+first and last names)

-Table containing (in this order):

average value of the exchange rate (according to the price close);

the average value of the price fluctuation in the candle (high-low);

number of candles

average volume

-Percentage chart of falling/rising candles (so-called circular)

-Chart of average closing price of candles (close) for each month

-Chart of average candlestick price fluctuation (high-low) for each month

-Report covers the period from 01.01.2019 to 01.01.2020.

-On the last page include a description of the determination of data for charts (queries in DataSet or postgres, etc.).

The file is quotes of currency pairs in the form of candles:

date - the date of the quote

time - the time of the quote

open - the opening price of the candle

high - the max price in a given candle

low - min price in a given candle

close - the closing price of a candle

volume - volume