How to evaluate the effectiveness of money spent on advertising campaigns? Obviously, the easiest way to do this is with the help of a comprehensive dashboard.
Good visualization allows you to understand in seconds whether the advertising campaign was successful or not. And in this case, hypothesis really proved to be true.
Of course, visualizations also revealed leaders and outsiders; it also revealed bottlenecks and inefficient spending. But that’s the way it should be. That’s what analytics is all about.
The PowerBI software used to prepare this dashboard is a powerful tool. It can turn boring and lifeless data in Excel into something more lively and illustrative. Unfortunately, the rights to work with this tool in Russia are severely limited. Many functions are disabled, including geographic maps. Therefore, I can share with you here only a link to a PDF presentation of the work I have done.
Links
- StoresUral.pdf: http://stup.pro/wp-content/uploads/2022/08/storesural.pdf
