CF Forecast Project Overview
Explore the source-to-dashboard architecture and attach a formatted PMO note to any stage.
CF Forecast · Project Overview
Source landscape → Fabric preparation → governed Gold facts → Power BI dashboard
Raw DataOperational and manual sources
System
- PVE
- Salesforce
SAP
- ACDOCA
- ACDOCA (additional fields)
- CAPEX (lists)
Sharepoint - flow n8n
- Alcoa Note
- Prime
- Mining Plan
- Ocean freight
- NG Forecast
Sharepoint - Manual Input
- CAPEX Pending IO
- Expense Rate
- Dividend
- Payroll
- Bonus
- Settle FWD/FCD
- Gloabal Expansion
- Interco Transaction
- Prime Discount
- Sell to Prime
- Sell USD
- ST Loan (edit/revise/check)
- LT Loan (edit/revise/check)
- Leasing (edit/revise/check)
- Master Vendor & Customer
Bronze / Silver
Ingest · standardize · validate
Gold ViewConsumption-ready fact contracts
1. Fact_Forecast
- Cash Received - Alcoa
- Cash Received - Others
- Cash Received - Ocean Freight
- Opex - Bag & Pallet
- Opex - Coal
- Opex - Mining (4 type)
- Opex - Transportation
- Opex - Ocean Freight
- Opex - NG
- Opex - Oil
- Opex - PEA (MEA)
- Opex - Tax (กง011)
- Opex - Provident Fund
- Opex - ประกันสังคม
- Opex - AIA
- Opex - Other Taxes
- Opex - Other Operating Expenses
- Opex - Rebate/ Repair/ Rental
- Special Items - Tax (กง050,51)
2. Fact_Manual
- ทุกข้อมูลใน sharepoint manual input ยกเว้น
- CAPEX Pending IO
- ST Loan
- LT Loan
- Leasing
- Expense rate
3. Fact_Actual
- Cash Received - Alcoa
- Cash Received - Others
- Cash Received - Ocean Freight
- Opex - เหมือน forecast
- Special Items - เหมือน forecast
4. Fact_LoanLease
- Sharepoint Manual Input - ST Loan
- Sharepoint Manual Input - LT Loan
- Sharepoint Manual Input - Leasing
5. Fact_CAPEX
- SAP CAPEX
- Sharepoint Manual Input - Pending IO
Sharepoint - Manual Input
- Manual Adjustment
Sharepoint - Set Up
- Dim_Cashflow_Report - Overview
- Dim_Cashflow_Report - Detailed
- Dim_CAPEX
DashboardPower BI consumption layer
Power BI
- Design
- Data Model
- DAX
- Dim_Date => Master Date Table
- Dim_Date => as_of_date Table