How to Calculate Year-Over-Year Sales Growth with Bold BI

Published:

Calculating year-over-year growth is a common requirement for businesses that need to analyze their performance over time. This article will guide you through the process of calculating year-over-year growth percentage for sales data using Bold BI.

Establishing the Data Source

First, you need to establish a connection with your data connector where your sales data is stored. Consider the following MSSQL database table that includes columns such as WeekNumber, Month, Year, SalesDetails, and StoreName.

Calculating Year-Over-Year Growth

To calculate the year-over-year growth percentage, you will need to create calculated fields using the following expressions:

PreviousYear: This expression calculates the sales amount for the previous year.
```
SUM(CASE WHEN [Year] = YEAR(GETDATE()) - 1 THEN [SalesDetails] ELSE 0 END)
```
CurrentYear: This expression calculates the sales amount for the current year.
```
SUM(CASE WHEN [Year] = YEAR(GETDATE()) THEN [SalesDetails] ELSE 0 END)
```
Year Over Year Growth: This expression calculates the year-over-year growth percentage.
```
(([CurrentYear]-[PreviousYear])/[PreviousYear])*100
```

Please note that the expressions provided are specific to the database columns in this particular case, and may need to be adjusted based on how the data is stored in your own use case.

Visualizing the Data

After creating the calculated fields, you can visualize the data using a bar chart widget in Bold BI:

Drag and drop the bar chart widget into the Designer.
Navigate to the Assign Data panel to configure the widget.
Enable the Value Label option in the properties panel to display the data values on the chart.
Append the suffix (e.g., ‘%’) to the Primary axis to indicate the percentage values.

By following these steps, you can create a visualization that clearly shows the year-over-year growth percentage for each store.

Conclusion

Year-over-year growth is a vital metric for businesses to understand their sales trends. By using Bold BI and the expressions provided, you can effectively calculate and visualize this metric to make informed decisions.

Additional References

Was this article useful?

Dislike

Written by Venkataprasad Subramani

Updated

Comments (0)