... Databases |

Databases

Automated Report Generation

In this project, our team developed an automated report generation system using Python and Django, which extracts data from the OLAP datastore Apache Pinot. The goal was to create a user-friendly web application that streamlines the reporting process, providing real-time insights and analytics.

Detection of illicit activities

It was used machine learning and Data transformation to detect ilicit activities in a marketing, transportation and selling of certain kind of products.

London Energy Consumption (SmartEnerx Dashboard)

An entire Data Science project was developed, generating a visualization dashboard built with Dash-Python for the forecast of energy in London for the coming months.

Shortage of a product

Identify through statistical methods whether next period of time there will be any shortage of a product

Extraction, Transformation and Load (ETL) project

Using SSIS to transform data into business context reference.