Tableau for Finance: テーブルの結合、計算の作成、および財務の分析方法

    create table earnings (
Symbol VARCHAR(50),
Quarterend date,
Shares bigint,
Sharessplitadjusted bigint,
Splitfactor bigint,
Assets bigint,
CurrentAssets bigint,
Liabilities bigint,
CurrentLiabilities bigint,
Shareholdersequity bigint,
Noncontrollinginterest bigint,
Preferredequity bigint,
Goodwillintangibles bigint,
Longtermdebt bigint,
Revenue bigint,
Earnings bigint,
Earningsavailableforcommonstockholders bigint,
EPSbasic float,
EPSdiluted float,
Dividendpershare float,
Cashfromoperatingactivities bigint,
Cashfrominvestingactivities bigint,
Cashfromfinancingactivities bigint,
Cashchangeduringperiod bigint,
Cashatendofperiod bigint,
Capitalexpenditures bigint,
Price float,
Pricehigh float,
Pricelow float,
ROE float,
ROA float,
Bookvalueofequitypershare float,
PBratio float,
PEratio float,
Cumulativedividendspershare float,
Dividendpayoutratio float,
Longtermdebttoequityratio float,
Equitytoassetsratio float,
Netmargin float,
Assetturnover float,
Freecashflowpershare float,
Currentratio float
);

    create table dividends (Date date,

    Dividends float,
Symbol VARCHAR(50));

    create table prices ( Date date,Open float,High float,Low float ,Close float,AdjClose float ,Volume bigint ,symbol varchar(50));

    COPY earnings FROM '/home/ubuntu/Documents/tableau/dis.dividends.csv' DELIMITER ',' CSV HEADER;
COPY earnings FROM '/home/ubuntu/Documents/tableau/sbux.dividends.csv' DELIMITER ',' CSV HEADER;
COPY earnings FROM '/home/ubuntu/Documents/tableau/jns.dividends.csv' DELIMITER ',' CSV HEADER;

    COPY dividends FROM '/home/ubuntu/Documents/tableau/sbux.dividends.csv' DELIMITER ',' CSV HEADER;
 
COPY dividends FROM '/home/ubuntu/Documents/tableau/jnj.dividends.csv' DELIMITER ',' CSV HEADER; 
 
COPY dividends FROM '/home/ubuntu/Documents/tableau/dis.dividends.csv' DELIMITER ',' CSV HEADER;

    COPY prices FROM '/home/ubuntu/Documents/tableau/sbux.prices.csv' DELIMITER ',' CSV HEADER;
COPY prices FROM '/home/ubuntu/Documents/tableau/jns.prices.csv' DELIMITER ',' CSV HEADER;
COPY prices FROM '/home/ubuntu/Documents/tableau/dis.prices.csv' DELIMITER ',' CSV HEADER;