Services

A glimpse of the services we offer.

Data integration and transformation

Evaluation of the various systems and software to determine the best approach to access and consolidate the data.

Modeling new entities when needed, from a simple staging table to a complete data warehouse.

Writing the routines needed to extract and transform the data in keeping with the business rules.

Creation of Power BI reports for different types of users and audiences.

Re-usable datasets for Power BI or Excel users.

Reducing the load time and memory usage of existing Power BI reports.

Creation of an analysis report on the health of a SQL Server instance and improvement recommendations.

Includes verification of the backup and recovery strategy, the instance configuration, the most expensive queries, etc.

Modification of the indexing strategy and/or modification of SQL queries to improve performance.

Modeling of databases of any kind, from a standard third normal form to a star schema.