Skip to content

3 months lasting group project for SoftServe Accademy to show full database project lifecycle from DB design through scripting, ETL with SISS till reports visualization in PowerBI and Tableau

Notifications You must be signed in to change notification settings

MargotMoi/Database-Project-Lab

Repository files navigation

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.

About

3 months lasting group project for SoftServe Accademy to show full database project lifecycle from DB design through scripting, ETL with SISS till reports visualization in PowerBI and Tableau

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages