Budget vs Expense

Budget vs Expense insights analyze the allocation and utilization of financial resources. They provide an overview of planned budgets versus actual expenses, helping users understand financial performance and budget compliance. These combinations allow you to assess the financial performance of different dimensions by analyzing the variance between actual expenses and budgeted amounts, helping you gain insights into areas of growth or decline in spending.

Input Combinations

You can leverage this input combination to bring out the different types of insights we offer for the Budget analysis.

Sr No	Combination
1	Date, Metric 1, Metric 2 and Dimension

All the above mentioned input combinations are to be set using set_column_meta method.

Topics

Topic	Description
growth_expense	Provides insights on value/entity within the dimension that have experienced an increase in their actual expenses compared to the budgeted amounts based on the given metrics.
decline_expense	Provides insights on value/entity within the dimension that have experienced a decrease in their actual expenses compared to the budgeted amounts based on the given metrics.

Examples

Generate Insights by Analysis

Generate insights for analyzing which Department has increase or Decrease in their Expense.

# Set column meta according to the input combination.
phrzr.set_column_meta(
    date_column={"name": "Date", "period": "month"},
    metric_column=["Budget","Expense"],
    dimension_column="Department"
)

insights = phrzr.get_insights('budget')

print(insights)

Generate Insights by Topics

Let's gather insights regarding the Department(s) that have a growth in their expense.

# Set column meta according to the topic input combination.
phrzr.set_column_meta(
    date_column={"name": "Date", "period": "month"},
    metric_column=["Budget","Expense"],
    dimension_column="Department"
)

insights = phrzr.get_insights(["growth_expense"])

print(insights)