Business Intelligence

From

Big Data

To

One Page Reporting

Business Intelligence

We implement projects in the field of data warehouse as well as analytic systems supporting the operational and financial activities of enterprises. Solet expert solutions are characterized by high flexibility while maintaining the possibility of using standard modules for all areas of the company business activities.

DATA

Market exploration

INFORMATION

Interpretation of facts

DECISIONS

Business acceleration

Portfolio

sbiSALE

sbiLOGISTICS

sbiPRODUCTION

Multi-sectional analysis of sales structure and dynamicsincluding among others the cross-section of assortment items, customers, sales channel with reference to features of sales transactions, warehouse batches and ordering documents
Retail sales daily reports, including average sales per receipt by geographical structure
Analysis of flyer sales and private label sales
Sales trends analysis by goods range
Price index, goods range price benchmarking for particular points of sale with reference to selected points of sale of the competition
Numerical analysis
Performance analysis for marketing activities
Monitoring of promotion costs
Discount analysis by type and with reference to catalogue prices
Analysis of retrospective discounts
Monitoring of customer loyalty indexes, including frequency and volume of purchase in the assortment structure
Analyses of conducted surveys and market research results

Analysis of average margin and economic performance of sales transaction , with reference to the settled costs of the capital involved, logistics costs, transport costs, as well as granted and received retrospective discounts
Performance analysis of salesmen, sales representatives, RSM, ASM, salesmen groups including target performance levels
Profitability analyses for points of sale, assortment groups, products, sales channels and customers
Sales and rotation analysis for display goods
Analysis of coupon sales and producer groups
Performance analysis for display boxesincluding sales indexes and unit margin per a single case of a given assortment occurrence in a box
Share of sales to share in the area
Customer orders performance level, including lost sales analysis with definition of cause and value of the lost margin
Analysis of the structure and dynamics of receivables by customer and sales representative
Estimation of cash inflows in reference to sales transactions

Dynamics and structure of warehouse turnover - including: multi-section quantitative and value analysis of receipts, transfers, releases, returns, inventory documents
Dynamics and structure of inventory - including, among others , level of batch inventory divided into storage locations and age structure
Logistics indicators: turnover, availability, continuity, back orders, stock up frequency, storing costs, % claims ratio, efficiency ratio, reservation value, storage capacity, work analysis
Shortages in released goods - analysis of relations between value of goods ordered by customers and value of goods released from the warehouse
Scanner control reports – the amount of controls, purchasers’ errors, controllers’ errors
Logistics controlling – transport effectiveness and efficiency analysis, structure and dynamics of transport costs, warehouse effectiveness analysis, losses on goods
Transport costs allocation based on the parameters of transport documents and/or the applied engineering model route
Outgoing capacity analysis of the fleet calculated by pallet or carriage including overloading analysis and empty runs rate

Warehouse performance analysis – general performance indicators, compliance of orders, acceptance of delivery, mediator (cash box) and internal operations in the warehouse
Supplier dossier – general information, quantitative share of the supplier’s SKU, back margin, target, marketing budget, share of the supplier’s SKU in the sales structure, indicators – lead time, % of defective deliveries
Ratio analysis for compliance of delivered goods with order, surpluses and deficits in deliveries
Analysis of the Delivery Lead Time indicator - time of supplier order performance in relation to the forecast assumptions for individual items of the product range
Current value of overdue orders
Purchase reports, including: demand analysis against inventory balance, orders, inbound shipments, surplus and shortage parameters, stock up parameters in a cross-section by the place of storage
Assortment categorization in the structure of ABC and XYZ groups
Analysis of the economic order value
Analysis of the introduction process of new links into the supply chain
Comparative analyses of scheduled shipments, deliveries and loading of goods

Developing general principles for particular production plans based on sales forecasts, customer orders and with reference to current inventory levels
Production plan performance analysis
Multi-sectional analysis of production orders, including comparative analysis of the real consumption of manufacturing process components in relation to specified standards
Analysis of machinery idle and working times with accuracy to one working shift and by cross-section of a given production order
Monitoring the parameters of technological operations by particular routes

Quality control reports with reference to the extent and cause of deviations from assumed standards.
Multi-sectional analysis of the technical production cost by time and product price factors, with reference to recurrence relations in multistage production
Support for the calculation of the controlling Technical Production Cost, including allocation profiles for production costs
Calculation of the manufacturing cost and the sales price of finished goods
Ad-hoc calculations of the break-even points for the specified sales price on the basis of the selected option of the finished item price calculation

sbiFINANCE

sbiHR

sbiEXPLORER

Handling of analyses in the multi-level structure of the capital group
Analysis of the structure and dynamics of financial statements in the selected format (statutory format, KPWiG, US GAAP, KNUiFE) as per company and capital group
Mapping of financial statements from general ledger and detailed accounting records
Generating financial statements based on mapping formulas from data from the source system or MS Excel spreadsheets
Loading financial statements from MS Excel spreadsheets, entering data into financial statements using worksheets
Automation of the process of allocation of value of explanatory notes to the financial statements (including, among others: structure of receivables, structure of liabilities, detailed analysis of changes in the group of tangible assets)
Registration of presentation and consolidation adjustments, adjustment of company’s equity and holding of the subsidiaries' capital , calculation of company’s value and minority interest
Automatic process of excluding mutual transactions in the capital group
Handling of intergroup transaction balance register, generating discrepancies reports
Full and proportional method of financial statements consolidation
Presentation by the equity method, handling dimension of segmentation
Analysis of the financial situationincluding dynamics and structure of assets and liabilities with reference to source data (including the structure and dynamics of receivables, liabilities, inventories)
Measuring the degree of operating and financial leverage

Profitability ratio, debt ratio analysis, liquidity ratio
Developing financial data models, including financial results forecasting
Cost analysis structured per particular organizational unit of the company
Cost analyses under real cost income statement, regular, planned and standard, including deviation analyses
Handling cost allocation profiles according to defined distribution keys, including support for the ABC accounting method
Time Driven Activity Based Costs statement
Creating a layout and generating data for multisectional and multi-level controlling accounts,, including e.g. profitability analyses of products, customers, projects and sales channels
Centralised and decentralised budgeting
Budget performance control, including support for flexible budgeting options
Operational analyses of cash flow and balance, generating item value of cash budget
Risk analysis for the receivables portfolio, average payment time and delays by customer, ranking of debtors
Balanced Scorecard

Analysis of employment situation and fluctuation, including a number of employees, a number of lay-offs, a number of job positions by time and organizational units of an enterprise
Analysis of employment form structure
Analysis of absenteeism, including monitoring of current and unused leave use in relation to the holiday schedule, number of sick leaves, ranking of employees by type of absenteeism
Analysis and optimisation of work schedules

Multi-sectional analysis of working time
Analysis of labour costs by wage components, including overheads and bonuses
Preparation and review of the employee card, including the dynamics of salary changes, description of experience, trainings, analysis of the dynamics of KPIs defined in the employee evaluation card
Scheduling and optimisation of resources in service companies and medical personnel

sbi Explorer is data exploring platform, offering a comprehensive and integrated set of analytical tools, developed to provide insight into business analysis results to wide range of users and allowing any user from any organizational unit to access current, self-service, relevant and useful information via the web interface. The platform allows combining data retrieved from many databases, applications, OLAP data sources and unstructured data sources into a single, unified view of corporate information. The solution is based on IBM technology. Appropriate selection of tools is based on pre-implementation analysis.

sbi Explorer implementation enables:

acceleration of business, analytical and data acquisition processes
easy, intuitive access to data
efficient data exploration in the extended and in-depth retail analysis model
over hundredfold faster response to inquiries
compression of physical data
unification of the environment, work space and information exchange
optimization of processes within the organization
introduction of self-service Business Intelligence and ad-hoc analysis in real time
building a solid foundation for the needs of advanced predictive analytics
precision and speed of reaction in changing environment
building sustainable competitive advantage

Products used:

IBM Integrated Analytics System (previously: IBM PDA, Netezza) - an efficient environment for loading, processing and storing large amounts of data for analysis. This accelerator enables exploration of reliable and business-friendly information in seconds.
IBM Cognos - is a tool for intelligent data analysis, enabling reporting, creating analyzes and dashboards for managers, supporting planning, budgeting and forecasting.
IBM SPSS - an intuitive tool for statistical analysis. It enables viewing data from various sources, formulating hypotheses, analyzing relations between variables, identifying trends, developing forecasts, prediction and recommendation.
IBM DB2 - is a relational database that provides huge flexibility, advanced possibilities of stored data compression and IBM BLU Acceleration technology. The column-oriented DBMS, patented compression, caching algorithms of big collections of data in RAM, mechanisms eliminating the need of creating indexes and a set of algorithms enabling parallel transferring of data collections without the necessity of referring to disc.