Send your request Join Sii
Send your request Join Sii

About the client

The Ministry of Justice is the auxiliary office of the Minister of Justice, the chief body of state administration responsible for the Justice government administration department. As part of its activities, the Ministry is responsible for the maintenance of many key state registers, including the National Court Register (KRS), the National Criminal Register (KRK), the Sex Offenders Register (RSPTS), the Register of Pledges, the Real Estate Register and others.

The challenge

The main goal of the project was to create a reporting environment based on Power BI technology and a tabular model as a data source. The implementation of the order also included the creation of several dozen defined reports.

What we did

The architecture of the solution was based on the construction of the in-memory analytic layer (analytical model) and data layer – Data Mart. The process of extraction, transformation and data loading (ETL) was built through programmatically generated Microsoft SQL Server Integration Services (SSIS) packages and scheduled using SQL Server Agent tasks. The source of data is the KRK database. Reporting is provided by the Power BI Report Server service. The scope of work included:

  • Implementation of the Power BI reporting tool along with the creation of defined reports
  • Building an analytical model
  • Implementation of the database constituting the Mart Data System of the KRK
  • Starting the power supply process
  • Execution of 102 dedicated reports
  • Users’ training in building reports in Power BI

Effects

Prepared reports have improved reporting and provide export capabilities to selected formats. The users were also trained both from the operation of the PowerBI tool itself, as well as from the use of the prepared analytical model. This gives the opportunity to build analyzes by the KRK employees themselves.

Learn more
See more

We are constantly searching for talents

Join Sii and get a chance to work on similar projects for prestigious customers.

Python Developer

Stockholm, Gothenburg, Uppsala

Embedded Developer

Stockholm, Gothenburg, Uppsala

Data Engineer

Kyiv, Lviv, Odesa, Remote work

SailPoint Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

IAM Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

.NET Developer

Kyiv, Lviv, Odesa, Remote work

Golang Developer – fintech project

Kyiv, Odesa, Lviv, Remote work

ServiceNow Developer with German

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

3D Animation Artist

Lodz, Bialystok, Bydgoszcz, Czestochowa + 14 locations

Security Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Power Platform Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

L1 Support Specialist – CMS systems

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

L2 Support Specialist – e-Commerce systems

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Teams Unified Communications Architect

Armenia, Bulgaria, Croatia, Estonia + 13 locations

UX Designer – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Tax Accountant

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Senior Business Analyst – Supply Chain Systems

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

DevOps Administrator

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Oracle Administrator

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Linux Administrator

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Engagement Manager

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Python Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

SAP Consultant

Wroclaw, Remote work

Golang Developer – fintech project

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Scala Developer

Lodz, Warsaw, Gdansk

Teams Unified Communications Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Senior Java Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Internal Communications Specialist

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Performance Tester – 5G Core/Mediation Performance

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

Solution Architect – Online Charging Systems

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

Business Analyst – banking

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Certification Specialist – aviation industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Business Analyst – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

UX/UI Designer – digital projects

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

Senior Consultant D365 FnO

Bialystok, Bydgoszcz, Gdansk, Katowice + 9 locations

Data Scientist

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

AEM Back-end Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Mulesoft Technical Leader

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Security Business Analyst – cybersecurity sector

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Project Manager – automation industry

Bydgoszcz, Gdansk, Katowice, Cracow + 14 locations

Optical Engineer

Wroclaw, Bialystok, Bydgoszcz, Czestochowa + 14 locations

GL Accountant with German

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

AP Accountant with German

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

.NET Developer – ePayment FinTech

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

Salesforce Test Automation Engineer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Project Engineer – automation industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Data Architect – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Scientific Business Analyst – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Solution Architect with Java – eCommerce

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

DevSecOps Engineer

Bialystok, Bydgoszcz, Gdansk, Katowice + 9 locations

IT Support with English, French and Spanish

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Penetration Tester – retail industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Capability Architect

Wroclaw, Warsaw, Remote work

Android Architect – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

ETL Developer with Talend – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Senior SAP PLM Consultant

Armenia, Azerbaijan, Bulgaria, Croatia + 14 locations

BI Developer

Kyiv, Odesa, Lviv, Remote work

Golang Developer

Kyiv, Odesa, Lviv, Remote work

Business Development Manager – Salesforce

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

C++ Developer – high-tech industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Business Manager with German

Gdansk, Poznan, Warsaw, Cracow + 3 locations

RPA Developer – Blue Prism

Warsaw, Cracow, Remote work

Consultant SAP CO

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Solution Architect with Azure - automotive sector

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

ServiceNow Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

DevOps Engineer – financial sector

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Functional Safety Engineer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

SAP GRC Consultant

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

AEM Front-End Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 21 locations

Azure Administrator – IoT project

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Data Engineer – pharmaceutical industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Chatbot Developer – Azure AI

Armenia, Azerbaijan, Bosnia and Herzegovina, Bulgaria + 14 locations

Technical System Analyst

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

React Native Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Automotive Cybersecurity Engineer with German

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Java Test Developer – retail industry

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

IAM GCP Technical Lead/Architect

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Test Automation Engineer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Front-end Developer

Bialystok, Gdansk, Kielce, Cracow + 14 locations

C++ Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Java Developer

Bydgoszcz, Czestochowa, Gdansk, Gliwice + 14 locations

.NET Developer

Bydgoszcz, Czestochowa, Gdansk, Gliwice + 14 locations

DevOps Engineer

Bialystok, Bydgoszcz, Gdansk, Kielce + 14 locations

Business Analyst

Bydgoszcz, Czestochowa, Gdansk, Gliwice + 14 locations

Automatyk – Programista PLC

Bialystok, Bydgoszcz, Gdansk, Katowice + 13 locations

Brygadzista/ Elektromonter z językiem niemieckim

Gdansk, Bydgoszcz, Torun, Katowice + 1 location

Konsultant Dynamics 365 CE/CRM

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Analityk systemowy – sektor kredytowy

Katowice, Bialystok, Bydgoszcz, Gdansk + 9 locations

BMC Remedy ARS Developer with Java

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Konsultant Techniczny SAP PLM/MDG

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

SAP ABAP Developer – EWM

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Architekt Dynamics CRM

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Specjalista ds. wsparcia IT z językiem niemieckim

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Specjalista ds. wsparcia IT z językiem hiszpańskim

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Developer RPA – UiPath

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Power BI Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Programista Java – branża bankowa

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Architect Automotive – Adaptive AUTOSAR

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Analityk marketingowy

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Mitsubishi PLC Engineer

Bialystok, Bydgoszcz, Czestochowa, Gliwice + 12 locations

Senior Salesforce Consultant

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Tester Manualny z MES

Bialystok, Bydgoszcz, Gdansk, Katowice + 14 locations

Architekt Dynamics 365 F/SCM

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Power BI Developer – projekty publiczne

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Copywriter

Lublin, Poznan

Automatyk systemów magazynowych

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Java Test Developer

Bialystok, Bydgoszcz, Gdansk, Katowice + 8 locations

Konsultant Power Platform

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Programista Java z językiem niemieckim

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Konsultant SAP PP/DS

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

SAP ABAP Developer - Mobisys

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Konsultant SAP WM

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

SAP Fiori/UI5 Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Konsultant Salesforce CPQ

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

TIBCO Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Tester oprogramowania – branża elektryczna

Katowice, Bialystok, Bydgoszcz, Czestochowa + 14 locations

Inżynier testów manualnych

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Administrator Salesforce

Czestochowa, Gdansk, Gliwice, Katowice + 14 locations

Cloud Data Engineer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Tester Automatyzujący – obszar Business Inteligence

Lublin, Bialystok, Bydgoszcz, Czestochowa + 12 locations

Computerized Software Validation (CSV) Specialist

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Konsultant Dynamics 365 Finance

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Developer BI

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Programista Python

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations

Programista C++

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 13 locations

Java Developer

Bialystok, Bydgoszcz, Czestochowa, Gdansk + 14 locations
See more

Get an offer

If you have any questions or would like to learn more about our offer, feel free to contact us.

Send your request Send your request

Miguel Sii Sweden Managing Director

Get an offer

Join Sii

Find the job that's right for you. Check out open positions and apply.

Join Sii Join Sii

Malwina Sales and Delivery Operation Specialist

Join Sii

SUBMIT

This content is available only in English version.

Are you sure you want to leave this page?

Detta innehåll är endast tillgängligt på engelska.

Är du säker på att du vill lämna sidan?