Programista Business Intelligence i SQL nastawiony na nowoczesne systemy bazodanowe SQL/NoSQL oraz systemy raportowania tj. PowerBI, Qlik Sense, Reporting Services. Zarządzam małym zespołem raportowania i baz danych oraz sprawuję opiekę nad projektami BI. W wolnej chwili szkolący się z dziedzin uczenia maszynowego w języku Python oraz chmury Azure.
Więcej o moich kompetencjach: https://www.linkedin.com/in/bart%C5%82omiej-osak/ Zapraszam na mój profil na LinkedIn.
The work presents a project with the implementation of a data warehouse and individual layers of a multidimensional model, ie data integration, analysis, and reporting and visualization. The presented solution is intended for analyzes for a construction company. Generated analyzes and reports can be the basis for supporting decisions on current and future sales and purchasing processes. To implement the data warehouse with the business analytics layers, the Microsoft SQL Server 2017 database in the Developer version and the data warehouse and data warehouse mechanisms included in it were used. The data used in the work has been imported from the company's accounting files and reflects the actual sales and purchase data.
Technologies and services used:
The work contains implementations in the fields of:
A system design streamlining the work of the dispatch office and all organizational units associated with it.
The project includes an example data warehouse built on the basis of a snowflake scheme. The theme is "Shoe and leathercraft workshop".
The following analytical queries were written in the project:
The project was written based on the Oracle Database 11g Express Edition.
In order to easily create data warehouse tables and delete them, a special client application was written in the recursive version using SQL * Plus.