Project Overview

Nexus Learning Lab Project was planned for multiple services: Database Solutions, Data Analytics and ETL Processes. This was an unpaid internship. The price that was quoted was for reference purposes only.

This project involved the creation of a suite of database and data analytics solutions at Nexus Learning Lab. These solutions were designed to enhance the data management, reporting, and decision-making capabilities. The project encompassed the development of 1 normalized database, 1 snowflake-type database, the implementation of ETL (Extract, Transform, Load) processes, and the creation of 5 dashboards in Power BI.

Technical Details

The normalized database was created from several non-normalized Excel tables that exceeded the limit of 1,048,576 rows. After designing the normalized architecture, I deployed constraints (PK, FK, Defaults, Identity, Checks) to ensure data accuracy, as I needed to start the ETL process (using an SSIS package in Visual Studio) to load data into this SQL Server database. Once the database was populated, I implemented security measures (TDE and SQL Symmetric Key for private data), longevity solutions (jobs for shrinking, updating statistics, and daily backups), and usability enhancements for HR and Sales personnel. This included creating user accounts, granting appropriate permissions, providing documentation, and creating views and procedures to simplify their work.

This normalized database was specifically built for efficient querying. From this database, I created another ETL process to transfer the data to a Snowflake-type database, designed for real-time and fast Power BI analysis. The Snowflake-type database followed its base architecture with fact and dimension tables, which help Power BI's filter and row contexts. Using this database, I built five dashboards for business insights related to Sales by Category & Year, Product Sales & Quantities Sold, revenue, and the number of products sold for each product category.

Results and Pricing

The implementation of these database and data analytics solutions has significantly improved my experience in databases and data analysis. The normalized and snowflake-type databases provide a robust foundation for data integrity and complex queries. The automated ETL processes and SQL constraints ensure that the data is always current and accurate, while the Power BI dashboards offer powerful tools for real-time reporting and decision-making. As a result, this project provides a great system to save time and leverage data for strategic business growth. There was no payment for this project; it was completed only for learning purposes. The price that was quoted was for reference purposes only.

The Monthly Maintenance is 300€.

The Total Payment is 1,530€, and it is split per services as follows:
800€ for development of 2 database models, including constraints
100€ for data cleaning before first ETL process
300€ for implementation of 2 ETL processes
200€ for adding security measures
100€ for setting up automatic backups and longevity solutions
100€ for creation of procedures, views and functions
200€ for dashboards creation
-270€ (15%) discount for Multiple Services