BENERATOR is a leading software solution to generate, obfuscate, pseudonymize and migrate data for development, testing, and training purposes with a model-driven approach.

This repository contains the project materials for optimising e-commerce conversion rates through comprehensive data analysis. Leveraging SQL, MySQL, Power BI, and other tools, explore key factors influencing website performance. From data collection to actionable insights and recommendations,

Optimus is an easy-to-use, reliable, and performant workflow orchestrator for data transformation, data modeling, pipelines, and data quality management.

Contains example ALFA (www.alfa-lang.io) projects.

dbt + Metabase integration

Extensible Object Model Data Abstraction

Contains end to end Data Analysis portfolio project made using Excel, SQL, Tableau & Power BI

Koldy Model ensures strict data types in JS runtime.

Data model for the Participatory Knowledge Practices in Analogue and Digital Image Archives (PIA) project

Modelling business data. Going from business rules to ERD to database schema.

Coffee Shop Sales Analysis using Advanced Excel.

This repository comprises the design, implementation, and analysis of a near real-time data warehouse prototype for an electronics business chain, utilising a multi-threaded Extract, Transform, Load (ETL) pipeline leveraging the efficient HYBRIDJOIN algorithm implemented with Java and MySQL on customer sales data.

An end to end data engineering project aiming to build an ELT data pipeline that generate insights into ads campaign.

Developed an interactive dashboard utilizing Google Looker Studio to analyze Uber usage patterns in NYC. Designed a robust data model and implemented an efficient data pipeline using Mage AI on GCP's VM infrastructure. Utilized Google BigQuery for in-depth analytics and leveraged Google Cloud Platform for data processing.

Power BI Projects

A high-level business summary tailored for C-suite executives, giving insights into their highest value customers segmented by sales region, providing a detailed analysis of top-performing products categorised by type against their sales targets, and a visually appealing map visual that spotlights the performance metrics of their retail outlets.

Content: Import & Direct query, Data Modelling (Power Pivot), Star & Snowflake Schema, Normalisation & Cardinalities, Cross-filter direction and Sync Slicers

VAST Challenge 2021 - The Kronos Incident: Mini-Challenge 2 solution featuring nested visualizations, employing Python for data transformation and analysis, and utilizing D3.js for interactive visualizations, with Git for version control and VS Code and Google Colab as integrated development environments.