Aralco's reporting capabilities are extensive and designed not to produce volumes of paper, but to prevent just that. Reports are selected for the purpose for which they are required and contain only the information requested.
It comes with over 100 standard reports that can be further modified to user specifications and takes only a few minutes to learn how to create a basic new report. There is also no limit to the SQL database size, so you can keep as many years of history you want without purging, therefore you can report on year-on-year performances of your business.
Aralco Reporting Engine is the perfect data analytics tool for retailers and it will save you countless man-hours when preparing reports every day, periodically, for boardroom presentation and even at the last minute.
BUILD YOUR OWN REPORT
You can design a new report on your own easily without the need for costly customization by programmers. Simply use the following tab options to create one quickly or whenever you need to make changes to any existing reports:
- FILTERING TAB option is where you define the date range, include and exclude location, brand, department, season, customer type, supplier, etc.
- GROUPING TAB option is where you specify the grouping for summarizing data by groups such as location, customer, department, supplier, brands season or any categories
- COLUMN TAB option is where you can define to insert any fields/values in the columns of the report such as Product Code/Name, Cost of Sales, GP%, Margins, Stock Quantity At Hand, etc and frequently used formulas like "Sell Through Rate", "Stock Valuation", "Commission Calculations", "Average Spending".
Real-time reporting is one of the key features of Aralco offering comprehensive report formats for you to choose from for your precise reporting requirements:
|REPORT FORMATS||REPORT USAGE||FORMULAS||
|TABULAR REPORTS||Basic report listing rows of data in relation to a column||Yes||Yes||Yes||Yes|
|SUMMARY REPORTS||Group and summarize rows of data in relation to each column||Yes||Yes||Yes||Yes|
|Group and summarize data by columns and rows||Yes||Yes||Yes||Yes|
|CUBE REPORTS||Drag & drop data to a column, row for a multidimensional view||Yes||Not applicable||Not applicable||Not applicable|
|CHART REPORTS||Chart type in Area, Bar, Bubble, Column, Doughnut, Line & Pie||Yes||Not applicable||Yes||Yes|
TABULAR VS MATRIX REPORT FORMAT
Tabular Report is the most basic type of report you can build and the report output is organized with a single column header with multirow of data.
Matrix Report is very similar to a table, but it is configured to show data grouped by columns and rows, with aggregate data at the intersections. Some of the data you might expect to see in a row can actually become a column header. This format is similar to a crosstab or pivot table in a spreadsheet.
SUMMARY REPORT FORMAT
Summary Report is similar to Tabular Reports and you can configure these reports to group by rows of data but with the same column header - below is an example with images included in the report.
CHART REPORT FORMAT
Chart Report shows data in the form of areas, bars, columns, lines, and other shapes.
REPORTING INTERFACE TO MICROSOFT OUTLOOK, EXCEL, WORD, PDF :
All Aralco reports are prepared as HTML (or ASCII) files and readily convertible with a click of a button to Microsoft (MS) Excel, MS Word or PDF format, wherein any MS documents, you can make a modification such as your own presentation or applications of formulas and other calculations.
For mass price updates or markdowns, Aralco exports the selected product range (by Supplier, Department, Group etc.) into Excel where you can easily manipulate the data at your convenience, then simply re-import your changes back into Aralco with a simple click. The product price information residing on the Aralco system will then be replaced by your Excel's entries.
ARALCO VIDEOS | POWERFUL REPORTING SYSTEMS
Read about more Reporting Feature - Cube Analytics