Skip to content

Latest commit

 

History

History
41 lines (19 loc) · 1.08 KB

README.md

File metadata and controls

41 lines (19 loc) · 1.08 KB
Raw

Database-Project-Lab

Hello :)

You may also check video short description:click down arrow on the right upper corner (download raw file).

Or follow YoutTube link below:

Go to GitHub Readme project short description.mp4 file in this repository and click down arrow on the right upper corner (download raw file).

Or follow YoutTube link below:

https://youtu.be/fWnZMhNyLS4

In this repository you will find files representing the whole "path" I went through while participating in Database Project Lab This project was a simulation of "real-life" process in SeftServe company.

  1. Database design:

Graph of our database - together with my 5 collegues I've designed a transactional database in MS SQL Server.

  1. Data insertion and scripting:

SQL objects(view, trigger, stored procedure and function) that I've created.

  1. ETL process:

SSIS packages of data flow examples - migration of the data to data warehouse.

  1. Visualization in Power BI and Tableau:

Choosen reports regarding sales in our shop that I've created in Power BI and Tableau.

Feel free to contact me for more details.