Databases services
Database design, data merging
Design, size and optimization of databases like (Postgres, MS SQL Server, Oracle, MySQL)
Edigram has got a great experience in data reconciliation and has internal tools allowing to supply quality services at slightest cost :
- single database constitution from heterogeneous databases
- heterogeneous data reconciliation (quantitative and qualitative data reconciliation for instance)
- incremental upgrades of reconciliation bases from different source databases
- export databases definition, reconcilied databases exports
Relationnal databases
Modeling of relational databases according to MERISE method
- definition of conceptual data model (entities definition, relations, links, inheritance, data types user)
- definition of physical data model (tables definition, views, columns, index)
- scripts generation for tables physical creation, views, data types user on all types of databases
Multidimensional databases
Multidimensional databases definition with Analysis Services for Microsoft SQL Server 2000
- definition of multidimensional structure of cubes
- mastery of MDX language for:
- the dimension definition, levels, members and measures, cubes, etc.
- query for extracting cube data
- Client-side software development in VB or C++ with ADO MD or OLE DB for OLAP
Data warehouses
Design of data warehouses
- Variables/dimensions definition
- quantitative variables, label variables, grouping variables, shared variables, calculated variables, conversion variables
- variables sorting
- formats (%, budget, etc.)
- Facts tables definition
