White NRA Horizontal logo


The Digital Business Kit for Retailers

Learning Outcomes

Retailers will identify the type of Business Intelligence that can be accessed to inform their business plan. [printfriendly]

mod-arrow BI Reporting Tools

Reporting Tools

In the words of John W. Tuckey, “The greatest value of a picture is when it forces us to notice what we never expected to see.”

Seeing the trends of your sales, website visits, inventory levels, staff/till performance in graphic reports, demonstrates the data easily. Business-intelligence users are increasingly business users, not IT staff who need quick, easy-to-understand displays of information. To meet these needs, software vendors have been working on making it easy to understand the data.

Visualisations helps users create graphical representations of data via simple user interfaces. The ability to visualise information in a graphical format, as opposed to words or numbers, can help users understand data in a more insightful way. In addition, new interactive tools can provide teams with the ability to both analyse and manipulate reports in real time.

Dashboards typically highlight key performance indicators (KPIs), which help managers focus on the metrics that are most important to them. Dashboards are often browser-based, making them easily accessible to anyone with permissions.

Report writers
Report writers allow users to design and generate customised reports. Many customer relationship management (CRM) and enterprise resource planning (ERP) systems include built-in report writing tools; however users can also purchase stand-alone applications, such as Crystal Reports, to create ad hoc reports based on complex queries. This is especially helpful for organisations that continually modify analyses and need to generate new reports, quickly.

Customisable to your business
Business intelligence dashboard tools can be created with excel using free templates found online or your company can use 3rd party applications. Either way, you decide the data you want collected and displayed; and you can create dashboards/reports that will be valuable to you and your staff.

What does a dashboard look like?

You can download most dashboards / reports in a variety of formats

And as an excel sheet capture the data from the dashboard such as website visits per day (image below).

Google Analytics Dashboard
Facebook Insights Dashboard
Sample Facebook insights: All social media have analytic programs to support your use of the system and improve reach, content and audience engagement. Watch for posts that are more commonly liked and shared; replicate this type of post and analyse if increased engagement continues. This content can then be re-used for other marketing activities where applicable.