A national marketer combines details from four different regional ERP systems (Dynamics, Oracle, Salesforce, and SAP). Controls select regions and date range. What-if sales analysis test impacts of changes to close rate and average deal size. A cohort analysis shows customer retention. Expected sales impact of upcoming events is displayed. Brand cross-selling is analyzed with a profit growth analysis by market.
The Leads Pipeline model integrates marketing and sales data and clever controls to let the CMO forecast leads and sales, and also adjust allocation of marketing dollars to maximize sales and reduce customer acquisition cost. A visible leads funnel updates instantly with drill downs on lead source, product, region, and industry. Deal size and close rate by industry update with drill downs.
The Industry 4.0 dashboard gives insights into top customers, products, shipping locations, and overall equipment effectiveness with controls to select from each of four production sites and by date range. Factory insights show machines, machine age, hourly operating cost, and machine OEE, with drilldowns by site, cell, machine, operator and date range. The same drilldowns track each sales order shipped.
The Inventory Management dashboard combines data from warehouses in seven international cities, showing inventory quantity, value, and restocking cost by warehouse. Sales and profits by warehouse, customer, and SKU are shown. Best and worst performing products are called out, and sales turns by SKU are plotted with an intuitive bubble plot. Controls enable drilldown by product, customer, vendor, warehouse, and date range.
The Multi Year Performance Analysis serves the CFO and CSO with a revealing 30 Day Moving Average and cumulative sales comparisons for current year versus each of last two years of data. Current and previous years’ sales by channel are called out. Rankings show sales by US city, and this year versus last year sales are plotted so that outliers stand out. Controls allow selection of channel, individual customer, product, and date range.
This intensely-graphical dashboard shows marketing costs and resulting sales by region, campaign, and strategy with a selectable date range. Marketing spend by date and cumulative marketing costs year to date are shown. An amazing graphic shows marketing costs by strategy and by campaign across a selected timeline.
This information-packed dashboard gives an overview of sales and manufacturing including a detailed book-to-build report, book to build details, a summary of holds by warehouse, sales status, and hold status, and overdue details by department and cause. A breakdown of sales amount by overdue duration highlights outliers. An Annual tab plots order book volume by month and production by product line by month.
This product sales dashboard offers deep insights into product sales, with quarter over quarter comparisons, margin comparison, sales and margin by customer, and breakdowns by region, city, and channel. Sales and margin change by city are plotted. Controls allow direct selection of product and date range. Multiple simultaneous drill downs offer selection by region, city, customer, and channel.
A compendium of employee data with controls and drilldowns to select and cross-select by employment type, age range, gender, ethnicity, region, department, role, age. Total salary costs, tenure, average salary, number of employees are shown. Report tabs provide insight by the individual, department, and gender and ethnicity. A forecast report reveals head count and salary cost changes by region, department, role, and employment type.
This intensely analytical dashboard offers 8 tabs populated with frequently-refreshed Covid-19 CDC data. Daily cases by state and locality are tracked within the US. New cases are shown by selectable date range. Employee health status is tracked, including use of public transportation. Dashboards for facility readiness, cleaning frequency, risk factors, and a cash flow analysis prototype are shown.
By Bruce Brownlee A real-time live-data supply chain dashboard with actionable analytics can be a powerful tool for optimizing inventory, supplier, and fulfillment performance. The tools
By George Fandos Samuel Rutherford, a Scottish pastor in the 17th century, said when he was cast into the cellars of affliction, he remembered that
By Bruce Brownlee Companies may seem completely compatible at the beginning of the merger or acquisition process. The legal and financial process moves forward and the
Since 1989, we have assisted the world’s leading companies gain a sustained competitive advantage in their respective markets through the integration of business intelligence (BI) consulting, data analytics, business process, people and technology.