We’ve been implementing data warehouses on Microsoft SQL Server for 15 years

We’ll help you design a data model and develop ETL procedures, and we’ll provide our own ETL framework

acterys, Data science a AI, microsoft fabric

Microsoft SQL Server

We’ve been developing data warehouses in on-premise SQL Server environments for 15 years. We provide our own methodologies and framework for development of ETL procedures. We’re happy to involve and train your own team in development, too. We have a number of reference studies and personal references.

Dolphins in numbers

14

years on the market

3000+

number of participants in the BI Academy

140 mil.+

annual turnover

178+

number of certifications achieved

Data warehouse in Microsoft SQL Server

We’ll set up regular uploading of data from your information systems to a data warehouse in Microsoft SQL Server and ensure it is linked, cleaned, historicized, understandable and optimized for reporting. 

Data warehouse in Microsoft SQL Server

DWH implementation in SQL Server

We’ll design an optimal DWH architecture in Microsoft SQL Server to ensure maximum efficiency and performance. We’ll set up the environment to minimize costs.

We’ll create a data model for self-service on which users can easily and quickly create optimized reports.

We’ll develop ETL procedures by scripting, in SSIS or other tools, making maximum use of automation and AI to minimize development costs.

We’ll migrate your existing data warehouse to Microsoft SQL Server. We’ll ensure a smooth transition, optimize performance and minimize costs.

We’ll provide comprehensive data warehouse operations support. We’ll monitor performance, resolve incidents and regularly optimize the system to keep it running at its best.

dolphin ETL framework

On top of Microsoft Azure tools, we’ll provide you with our dolphin ETL framework - a set of methodologies and technologies that together create a platform for automating your data warehouse development and administration according to the latest DevOps rules.

dolphin ETL framework

Benefits of the ETL framework

We’ll set up templates for automated generation of ETL procedures from metadata, including various historization methods. This will result in time savings of at least 50% compared to manual development. 

The framework generates ETL script envelopes, including audit procedures, for you. You can focus solely on implementing the transformation logic. 

The framework includes support for versioning ETL procedures in GIT and easy transfer of procedures between development, test and production environments. 

ETL development using our framework is based on the latest DevOps principles - collaboration, automation, continuous integration, monitoring and logging. 

The entire environment is completely open - it consists of methodologies, standard database and PowerShell scripts, templates, GIT and a development and management cockpit. You can customize anything you want.

It's easy with us

We know how to do it.

1.

Non-binding consultation

We will identify your needs and evaluate how Microsoft SQL Server can help you work with data more efficiently. Free of charge and without obligation.

2.

Solution proposal

We will design the optimal solution tailored to your requirements, including architecture, integration and specific tools.

3.

Implementation

We will ensure fast and smooth deployment of Microsoft SQL Server into your environment, including configuration and team training.

4.

Support

We provide long-term technical support and regular optimization so that your solution always works at 100%.

How we’ve helped our clients

Zautomatizovali jsme nahrávání dat pro řízení výkonnosti distribuční sítě, vyvinuli reporty a dashboardy pro představenstvo společnosti a zajistili jejich distribuci na mobilní zařízení.

We implemented a datamart for data collection and cleaning and calculation of key performance indicators (KPIs) for the development of the distribution network. We designed management dashboards and reports for the KPIs.

We integrated data from the company’s accounting systems and built a financial data mart optimized for reporting. We developed reporting focused on various types of financial statements in the Power BI environment.

Case study

For KB, we created a Microsoft Power BI solution for digital transformation and enhanced self-service reporting. Through report migration, we simplified management and increased data analysis efficiency.

Case study

Provedli jsme analýzu požadavků uživatelů a spolupracovali při návrhu architektury BI a datového skladu. Vytvořili jsme reporty pro obchodní síť a další uživatele a zajistili jejich podporu a rozvoj.

Certifikace MS Analyzing and

Analyzing and Visualizing Data with Microsoft Power BI

Microsoft Certified Solutions Associate (MCSA) Certification

Microsoft Certified Solutions Associate (MCSA) Certification

Microsoft Certified Trainer 2019 - 2020

Microsoft Certified Trainer

Microsoft certified solution expert

Microsoft certified solution expert 2019

DP-200 Implementing an Azure Data Solution

DP-200 Implementing an Azure Data Solution

DP-201 Designing an Azure Data Solution

DP-201 Designing an Azure Data Solution

Microsoft Certified Azure AI Engeneer Associate

Microsoft Certified Azure AI Engeneer Associate

Microsoft Certified Solutions Expert

Microsoft Certified Solutions Expert

Azure AI Engineer Associatechitect

Azure AI Engineer Associatechitect

Azure Data Engineer Associate

Azure Data Engineer Associate

Microsoft Office Specialist Master Instructor

Microsoft Office Specialist Master Instructor

Microsoft Certified Technology Specialist (MCTS)

Microsoft Certified Technology Specialist (MCTS)

Petr Kolář, dashboardy a reporty, Microsoft SQL, Skupina Power BI

Need help implementing Microsoft BI tools?

We’d be happy to advise you. Send us a message with your contact information and we’ll get back to you as soon as possible.

Drop files here or
Max. file size: 100 MB.
    This site is registered on wpml.org as a development site. Switch to a production site key to remove this banner.