Watch this short video overview
Set SMART Targets to Motivate and Change Behaviours
How you define your Sales Targets is critical to your organisation as it will be a key factor to motivate and drive your sales team. Key Objectives should also be SMART:
- S - Specific
- M - Measurable
- A - Assignable
- R - Relevant
- T - Time based
Using BI4Cloud - Business Intelligence Cool Stuff (Enterprise 5) version, all businesses no matter how small, can now set flexible Monthly sales budgets and easily measure against them, based on all or any of the following key business drivers. Note each Organisation can choose what dimensions/levels to set their Sales Budgets at:
- Who is Selling - Salesperson/Territory
- Who is Buying - Customer/Customer Group/Channel
- What is Sold - Item/Item Group/Brand
How to Setup and Enter Sales Budgets in BI4Cloud - Click Here.
How to start creating Sales Budget Favourite reports in BI4Cloud - Click Here.
Get help from a BI Expert to setup Budgets in BI - Book a BI Consulting Appointment
Before you get too deep into setting up your Budgets you should determine exactly what level of detail you wish to track in your Budgets. Please take a look at the following report examples to see the many ways you can report and measure Actual Sales results against Budgeted Sales.
This example has been set up to budget all three of the above dimensions.
-
Salesperson
-
Brand- e.g. 3M, Kreepy Krawley, Onga
- Customer Group - e.g. Agent, Hotels Residential
-
Brand- e.g. 3M, Kreepy Krawley, Onga
Dashboards
A Dashboard showing overall performance then broken down by each Salesperson or Customer Sales Rep.
Simply add a Filter for a Salesperson or Customer Sales Rep to each Widget Element to customise. Customer Sales Rep v Salesperson - What is the difference?
Salesperson Dashboard
Run the Salesperson Dashboard, initially it will include data for ALL Sales reps. Simply add a Filter for one Salesperson and the whole Dashboard will show data just for that one person.
Build your own Dashboards by adding Widgets, reports and charts together.
Analyse Type Reports - Simple List
Analyse by Customer Sales Rep or Salesperson - Actual v Budget
Analyse by Customer Group - Actual v Budget
Change the Analyse by field e.g. Customer Group to change the dimension used in the rows.
Analyse by Item Group - Actual v Budget
Change the Analyse by field e.g. Brand or Item Group to change the dimension used in the rows.
Pivot - To see Multiple Dimensions at Once
To learn how to setup and change Pivot reports - Click Here
Pivot Reports are a great way to break out YTD data into Months to see trends.
Monthly by Customer Rep - Showing Metrics in Row
This report Analyses by Customer Rep in the Rows and Pivots on Invoice date by Month across the columns. It also shows the Metrics (Sales/Budget/Variance/Achieve %) on separate rows. This keeps the number of columns to a minimum.
Monthly by Customer Rep V2- Showing Metrics in Columns
This report flips the dimensions and instead Analyses by Invoice date by Month in the Rows and Pivots on Customer Rep across the columns. It also shows the Metrics (Sales/Budget/Variance/Achieve %) as columns. This results in more columns but is a great design to review data and variances up and down a column.
Brand by Customer Rep V2- Showing Metrics in Columns
Use the prebuilt reports, copy the tab and create your own reports.
Pivot Brand v Customer Rep to compare Salesperson performance across Brands
Quarterly Sales Actual V Budget
Pivot Customer Group v Sales by Quarter to compare Sales performance across Quarters showing Metrics in columns.
Visualise - To Really See the Results!
Sales v Budget Chart