What is Budget Fact table in data warehousing and business intelligence

---

✅ Definition: Fact Budget

A fact budget is a fact table that stores budgeted (planned or forecasted) values for various business measures such as revenue, expenses, units sold, etc.

---

🔍 Where It’s Used:

• Data Warehouses
• Business Intelligence (BI) Tools
• Financial Reporting Systems

---

📊 Example Fields in a Fact Budget Table:

Date	Department	Product	Budgeted Sales	Budgeted Cost
2025-06-01	Marketing	A	100,000	40,000
2025-06-01	Sales	B	150,000	60,000

---

📌 Key Points:

• It stores planned data (as opposed to actuals, which are stored in a different fact table like fact_sales).
• Can be used to compare budget vs actuals for variance analysis.
• Typically linked to dimension tables like dim_date, dim_product, dim_department, etc.

---

🆚 Fact Budget vs Fact Actual

Aspect	Fact Budget	Fact Actual
Type of Data	Planned/Forecasted	Real/Actual Transactions
Use Case	Forecasting, Planning	Performance Tracking
Example Measure	Budgeted Revenue	Actual Revenue

---