The Data Group - Blog on all things data

Combined real time and monthly KPIs with coloured indicators, provide thorough end-to-end logistics visibility. Managers are empowered to act on information to meet budgets, whilst increasing customer satisfaction through greater reliability. More accurate / predictable inventory levels allow for reduced holdings and cycle times, and thus improve your company’s return on assets. The dashboard can […]

Real time tracking of these 12 key sales/calls indicators result in improved customer satisfaction, improved service adherence and increased productivity by empowering managers to act on instantaneous information. Problems can be addressed as they occur and managers can reallocate staff to functions that improve efficiency and in response to areas of demand. The dashboard can […]

Displays 16 key sales performance indicators which empower sales managers to better meet their targets by quickly identifying issues through graphical and coloured indicators. Other reporting benefits include: Monitoring the discounts levels used to achieve sales (which have a direct impact on profitability) Clarity into which products are performing and thus what to push Your […]

Key company profit & loss, cash flow, project, servicing, production, Health & Safety and HR metrics provide a thorough overview of company performance for the month. Actual data is compared to budget / trend data where applicable. This report is updated monthly and forms the basis for the monthly management performance meeting. Consider including: Ability […]

The Flashboard provides a fast overview of company key performance indicators. Coloured indicator icons reflect performance and results are written in simple sentences that make it simple for both executive and non-executive staff to quickly understand. When building a flashboard, consider including: Filters for company hierarchy, date and budget comparison version. Drill down to detailed […]

Recently needed to import 4,000 plus text files into SQL. This was an easy job as: All files were in the same directory All files had the same csv structure. All files had the same file name except for a changing date suffix (eg: 20140131.txt) For the following code to work, you need to have […]

A date (or calendar) table is a SQL table containing a variety of date-related parameters. By joining to this table, one can rapidly access the pre-calculated values, thus significantly simplifying & speeding up your queries. Using 18 December 2013 as an example, the following parameters would be available: Parameter Value Date value 2013-12-18 Combined year, […]

In our previous article we looked at the CRM decay rate for Organisations (eg Contact = ABC Company Pty Ltd). This article considers the extra factors that affect the decay rates for contacts within organisations. (eg Contact = Ms Jane Smith @ ABC Company Pty Ltd) Please click on the following for decay rates of […]

CRM data for organisations becomes out-dated (decays) over time primarily due to organisations: Going out of business, Relocating, and/or Changing their name. The following article provides indicative decay rates based on a series of assumptions, which may, or may not be applicable to your unique circumstances. However, when compared to the results from our actual […]

What data should a BI system track to gain (or maintain) a competitive advantage? Well, that all depends on your organisation’s unique circumstances. The following management frameworks provide insight to the internal and external parameters to be considered. Internal Organisational Data: The Value Chain Framework created by Harvard Business School professor Michael Porter, examines the […]