ICT SERVICES
The unbearable lightness of data
Database & Data Warehouse: from collection to security and analysis of data.
Nowadays companies have large amounts of data relating to their customers, agents, suppliers, etc… kept in different databases, perhaps used by software applications that are in turn separate and unconnected.
To transform these data into information that can be easy to analyse and use, it is necessary to collect them in a single data warehouse and manage and protect them correctly.
Subsequently, thanks to BUSINESS INTELLIGENCE services, it is possible to use the data organised in the data warehouses or data marts both for the purposes of adopting strategies to grow the business and to protect the company from any risks that can be identified precisely with analysis of these data.
Data Warehousing
THE BENEFITS
- Integration of heterogeneous data sources (databases, .xls files, etc.) into a single data warehouse
- Integration of different functional areas: sales, finance, logistics
- Data analysis, reporting and KPIs always available to key users
- Information on sales always available by volume and amount according to time period, customer, product category and geographical area
- Comparison of historical sales data up to 10 years
- Possibility of drill down and drill through in real time for the different dimensions of analysis
SPECIFICS
Design of the data warehouse, staging areas and data marts with DFMs (Dimensional Fact Models) and implementation of ETL procedures with data quality control at different levels: completeness, accuracy, updating, consistency.
We have developed several data warehouses on multiple platforms. We know all the phases of design, development and maintenance very well, such as the implementation of logical and physical databases, the design of data marts and the adoption of ETL processes based on different ERPs such as SAP and others.
The flow of data is considered at every step and important indicators are extracted for analysis of the data with Business Intelligence tools.
AN EXAMPLE FOR FINANCIAL MANAGEMENT
In the case of finance, we have set the data marts for:
- analysis of variations between the margin on turnover and the budget defined at the level of business unit and commercial product family
- analysis of variations between the margin on turnover and the budget defined at the level of business unit and commercial product family
- annual, quarterly and monthly budgeting, with analysis of variations
- financial forecasts and rolling forecasts
- management reporting and KPI dashboards
AN EXAMPLE FOR SALES MANAGEMENT
In the case of sales, we have configured the data marts for:
- analysis of sales force performance by volume and value according to product category and region/province/municipality
- analysis of delivery performance of the flow of products ordered, shipped, delivered, installed and invoiced
- cross-referencing of sales data with post-sales failure detection data to determine the “Field Failure Rate” per item
Database management and data protection
THE BENEFITS
The management of data and the maintenance of “Big Data” with Database Management platforms is a very important matter for companies.
We offer advice on issues concerning Database Administration / Performance Tuning / Software Development. We provide application support, development of new features, and evolutionary and corrective maintenance.
- Continuous monitoring of data processing
- Checking the logs and therefore the “health status” of the database
- Monitoring of security policies
- Increased processing speed
- Increased security in the processing of personal and sensitive data
- Integration and control of flows to and from other systems
- Periodic analysis reports on specific and systematic activities related to the database
- Check of database vulnerability
SPECIFICS
For years we have been working with an important system integrator in the TELCO sector for two major international companies. We have gained considerable experience in the processes of data collection, credit management & collection, bad debt management, VDSL caring and statistical analysis with internal audit objectives and customer satisfaction.
The use and administration of relational databases and the processing of structured information have led us to gain in-depth knowledge of contexts and needs: from transactional to data warehouse, from embedded to distributed, and from installation to performance monitoring. Oracle Database and Microsoft SQL Server are the databases we use most often with both Unix / Linux and Microsoft Windows operating systems: installation, configuration, backup management, tablespaces, indexes, views, materialised views, control of SQL execution plans.
TECHNICAL SERVICES
- On-site Database Administration tasks
- Remote Database Administration tasks
- Backup & Restore policy
- Disaster Recovery Plan
- Database Audit & Policy Compliance
- Performance & Tuning: query, parallel query, execution plan, index, partition, etc.
- Local and/or remote monitoring of databases and jobs