Knowledge sharing made easy for lifelong learners, understanding the complexities of promotion cost modeling
At Model Citizn, we’re committed to empowering businesses and individuals with cutting-edge tools to transform data into actionable insights and Power BI embedded.
One of the exciting features now available on our Knowledge Hub is the ability to embed interactive Power BI reports directly into our platform.
This innovation allows you to explore financial models, dashboards, and analytics in real-time, all from the comfort of our newly enhanced and improved website.
Dashboard Overview: “Promotion Costing Model”
The “Promotion Costing Model” is a suite of Power BI dashboards designed to help a luxury goods company manage and analyse the costs associated with its promotional activities. The tool is divided into six main views, each providing a different perspective on promotion data, including geographical distribution, temporal trends, comparative analysis, and a detailed breakdown of costs and warnings.
The Model Selection panel on the right of each dashboard allows users to filter the data by product type (3W, SKI, ATV, SSV, PWC), platform, model group, and specific model. The Geographic Selection panel further refines the data by region, state, or snowbelt designation.
Dashboard Analysis
1. State Promotion Cost Map View
The State Promotion Cost Map View provides a high-level summary of promotion costs across different states and regions. The US and Canadian maps are colour-coded to visually represent the average promotion cost, with deeper shades of red indicating higher costs. This dashboard presents a clear, instant visual of where promotional spending is most concentrated. Key metrics are prominently displayed, including the Average Promotion Cost, and the average costs for specific promotion types like Rebate Cost, Sales Incentives, and Standard Fin. Cost, and Promotional Fin. Cost. The dashboard also provides insights into the Average Sales Revenue of units promoted and Total Units Promoted, linking promotion spending directly to sales outcomes.
2. State Promotion Cost Graph View
This dashboard is a dynamic tool for analyzing promotional costs over time. The State Promotion Cost Graph View displays cost trends, with the ability to filter by different promotion types (e.g., Rebate, Sales Person Incentives). The graph visually represents how a chosen promotion cost changes over a specified period. This helps managers identify peak spending periods, assess the effectiveness of promotions over time, and make adjustments to future strategies. It complements the map view by adding a temporal dimension to the cost analysis.
3. State Promotion Cost Output Comparison
The State Promotion Cost Output Comparison is a powerful analytical tool that allows for a side-by-side comparison of two scenarios. Users can compare different promotion types, such as Approved, Budget, and Forecast, or even a specific scenario (e.g., Scenario 15). This is invaluable for evaluating performance against planned budgets or forecasting the impact of a new promotion. It provides a detailed breakdown of Total Units Promoted, Total Promotion Cost, and the breakdown of various cost components for each scenario, enabling data-driven decisions on promotional effectiveness.
4. State Promotion Table View
The State Promotion Table View provides the most granular detail on promotion costs. This table lists each Model Group and the corresponding Promotion Combination in a chosen state. For each model, the table spells out the specific promotional deal, including values for rebates ($R), sales incentives ($S), financing terms ($C, $F1, $F2), and coverage details. This detailed view is crucial for configuring specific promotions, validating data, and understanding the exact terms offered for each model, ensuring accuracy and consistency across the dealer network.
5. State Promotion Warning Matrix
The State Promotion Warning Matrix serves as a vital tool for performance monitoring and risk management. It compares the Approved/Forecast promotion costs against the Budget and uses a simple, visual matrix to flag discrepancies. Checkmarks (✔) indicate alignment, while exclamation marks (❗) and arrows (⬇️⬆️) signal variances. The Visualisation Filters on the left panel allow users to filter for specific variance ranges, from minor deviations to significant overspending. This dashboard helps managers quickly identify models or regions that are not adhering to the budget, enabling proactive intervention.
6. State Promotion Small Multiples Line Graph
This dashboard provides a detailed, regional-level analysis of promotion costs over time. The State Promotion Small Multiples Line Graph displays separate line graphs for different geographic regions (e.g., Canada, US Central, US East, US West). Each graph shows the cost trends for a selected promotion type (e.g., Additional Coverage, Rebate). The use of “small multiples” allows for a direct comparison of trends across regions, highlighting regional differences in promotional spending and effectiveness. This is a powerful tool for localised strategy development and identifying regional anomalies.
Learn and Interact with Power BI Embedded for Free
The best part?
You can access and interact with these embedded Power BI reports for free on our Knowledge Hub.
Here’s how you can get started:
Explore the Collection: Visit the Knowledge Hub and navigate to the Blogs section to find articles accompanied by embedded Power BI dashboards. These include tools like the 3-way Financial Model with Power BI and the Simple Property Valuation Model, designed to help you practice and learn.
Hands-On Learning: Click through the interactive elements to adjust variables, view different scenarios, and see how data shifts in real-time. This hands-on experience is ideal for both beginners and advanced users, aligning with our tailored Power BI training programs.
Free Resources: Alongside the embeds, we offer downloadable Excel models and guides to complement your learning. From financial forecasting to budgeting tools, these resources are crafted to boost your career prospects and decision-making skills. You can find these in our Shop.
As we look back on the excitement of 2024 and move forward into 2025 and beyond, our goal remains to transfer expert coding knowledge to those with a basic awareness, empowering you to build your own tools. The embedded Power BI reports are a stepping stone to mastering these skills, available at no cost.
Join the Journey
We’re continually updating the Knowledge Hub with new content and interactive features.
Whether you’re inspired by the latest trends in financial modelling or eager to learn from our comprehensive programs, there’s something for everyone.
Start exploring today in the Knowledge Hub and unlock your potential with Model Citizn’s free, interactive learning tools.
Below you will find the first of many to be embedded soon to be released.
Model Citizn is a digitally savvy company that enables better decision-making and value creation using technology and bespoke models, dashboards and business intelligence.
We help simplify complexity by helping you make relevant, informed and purposeful decisions with insight.
Model Citizn is an Australian-based company that has been providing financial modelling and data analytics services and training since 2016.
We support clients in many different countries and industries that are looking to gain more value from the accounting and finance function
Model Citizn uses some of the latest cutting-edge technologies to provide comprehensive outsourced CFO services.
We have built cash flow, valuation and business performance models, including scenarios.
To find out more, follow us on social media