Nebim - Data Warehouse

The Data Warehouse has been designed to allow for effortless reporting of data held on ERP and is optimized to perform searches that produce analyses. Data Warehouse includes an operational database and analysis cubes with a different design than in the ERP.

The cubes that provide ease of functionality to the Data Warehouse and which allow you to perform multi-dimensional searches on the data are V3, Payables and Receivables, Cost Centers, Human Resources, Payments, Accounting and Instalment Sales.

By use of the ‘Perspective’ feature built into the Data Warehouse Scanner, you can design simplified reports by selecting the area which contains the values and the parameters that you need to analyze a particular set of data; for instance, inventory values, location, product and a date range can be selected for a report. You can grasp whether the rows and columns attached to the fields have been filtered or not and view the details of the filters in the report you have prepared. By double-clicking on any cell of the report, you have focus on this cell’s row and column values.

You can add new values to the perspective menus you have previously created. Values and parameters can be moved around in the menu and you can format the menu to suit your needs. The Data Warehouse scanner includes “before” and “after” buttons which will permit you to undo or redo actions step by step.

The reporting feature can be used without affecting the ERP’s operational database performance and without slowing your working operations. The Data Warehouse Reporting Services is accessible to a numerous range of varied reporting software such as Excel or other platforms.

As well as Turkish, your reports can be prepared in two other languages featuring products, product specifications and hierarchies, retail and wholesale customers, supplies and store features.

Using Delta Updating, the Data Warehouse will only update those ERP entries which have changed since the previous update and only upon request. For example, in case your company has data spanning the previous 3 years and the data has only been changed in the past 5 months, using Delta Updating will allow you to transfer only the past 5 months’ worth of data. By means of this, you will obtain a much shorter cubing time.

Accessing the Data Warehouse:There are two ways to query data: you can use the Data Warehouse Scanner option or the Microsoft Excel Pivot Table Area List option when operating within Nebim V3 ERP.

Select, Drag and Drop method allows you to generate customized reports very rapidly. You can save the prepared reports in order to view them later on.

You can create reports and Dashboards using Data Warehouse and Nebim V3 Business Intelligence, which enable you to produce numerous reports where you can perform very rapid analyses. Users can access these reports over the web to perform fast analyses that lead to quick decisions.

V3 General Analyses

You can perform detailed analyses using many Key Performance Indicators by defining values and parameters in the Data Warehouse including orders received/given, turnover targets, stock level information, inventory, stores space/rent, store footfall information, invoices, discounts etc.

You can make hierarchically structured queries such as product, location, customer, supplier, date etc., for example Company-Area-Office-Store-Warehouse.

Using invoice and returns analysis measurements, you can analyze the average invoice amount, the number of invoices, invoice line numbers, model numbers and basket depth as well as the ratio of returns to actual sales. You can also perform specific analyses that you need such as measuring stores or products, etc. according to on-the-spot discounting, loyalty points, discount vouchers, payment types, discounts metrics. Purchase order tracking can be carried out according to metrics on orders given and received, purchase amounts, delivered amounts and remaining stock values.

Using the calculations in the Data Warehouse,

Values which are not part of the Nebim V3 operational system can also be used in your reports and your analyses. Examples of these are: Gross Margin Return On Inventory or product profitability, Gross Margin Return on Footage or profitability per square meter, Gross Margin Return on Labor or staff productivity and Markup.

You can view store size information, analyze the sales area history and the turnover per meter square. You can further analyze the number of customers entering your store, the percentage of those who actually shop and focus on which days of the week or hours of the day purchasing trends tend to increase. You can view the stock situation of your store or warehouse at the start of a given period, as well as the average and current inventory levels and amounts. Furthermore, you can analyze inventory on a daily basis. Calculated irrespective of date, available inventory which has been reduced by reserved items, transfer orders and products already packed – can be analyzed very rapidly to provide the most up-to-date stock situation.

Accounting Analyses

You can track your clients’ payables, receivables, total receivables and total debts. Details of accounts receipts and cost center related monthly expense items can be swiftly analyzed via the account plan and its breakdown; a trial balance and income statement reports can be prepared.

Cost Center Analyses

When you run the allocation program in Nebim V3, you can see the sales amount, sales units, cost of goods sold as well as the cost amounts by category allocations to the cost center. At the same time, you can view cost allocations according to expense periods based on cost center hierarchy and can analyze according to the accounts plan.

Payables and Receivables Analyses

Payables, receivables and balance analyses can be carried out based on retail customers, wholesale customers, staff or supplier; customer statements can be accessed quickly and future cashflow from cash items such as checks and invoices are analyzed with ease.

Retail Instalment Sales Analyses

Information relating to payments made as a consequence of instalment purchases by your customers, their remaining payables broken down by month, as well as outstanding payments can be analyzed in detail.

Human Resources Analyses

You can analyze your staff’s length of service, gender breakdown, age levels and education segments; and can prepare demographic and graph reports based on departments or by store.

Payment Analyses

You can analyze the payments made in store by grouping them into different hierarchical categories.

For example, for payments made by credit card you can analyze based on the hierarchy: bank name-> credit card type -> number of instalments. For payments by bank transfer you can analyze based on the hierarchy: bank name -> bank branch name -> bank account type -> bank account name. For payments made via gift cards, you can analyze according to the explanation field of the gift card.

Data Warehouse