✅ 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 |
Ankit Srivastava is an IT trainer, technology educator, and digital skills mentor with expertise in programming, data analytics, AI, and software development. He has successfully trained thousands of learners, with more than 10,000 student enrollments on Udemy. His practical teaching approach empowers students and professionals to build in-demand technical skills. Colorstech channel where Ankit posts video tutorials has more than 8000 Subscribers.
