A library for data modeling in Scala.

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

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

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.

This is my personal development space where I build integrated approaches for environmental and agricultural purposes

This project accompanies a Power BI data visualization project focused on analyzing various aspects of a telecom company's operations. It provides guidance and resources for creating three distinct dashboards:

Projeto criado durante as aulas da Formação Modelagem de Dados da Alura.

The E-commerce Sales Dashboard project offers a comprehensive view of e-commerce sales performance using interactive Power BI dashboards. It focuses on key metrics like YTD Sales, YTD Profit, YTD Profit Margin, and Quantity of Products sold, analyzing data by product categories, states, and regions.

Coffee Shop Sales Analysis using Advanced Excel.

Social blogging community build with React, Next.js, and Firebase.

This project carried out as the final capstone project of the Udacity Data Engineering nanodegree program. It involves Extracting, Loading, and Transforming of datasets of different file formats from the web (downloadable,), to the lake (S3), and then the warehouse (Redshift)

Perform data modelling, data engineering and data analysis on fictional employment records using SQL.

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.

An analysis and visualization of google play store apps scraped data for the period of 2010 - 2018 . This project aims at cleaning the dataset, analyzing the given dataset, and mining informational quality insights. This project also involves visualizing the data to better and easily understand trends and different categories.

Airplane Boarding Simulation: Visually display hundreds of passengers boarding

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.

Extensible Object Model Data Abstraction

Built employee database using SQL by applying data modeling, engineering and analysis skills. I prepared an entity relationship diagram (ERD). I used PostgreSQL and pgAdmin to write SQL scripts to build tables, added joins between tables, imported data from CSV files, and wrote custom reports.

This repo covers the processes of designing a database by performing logical, conceptual and physical data modelling processes, creating the designed database using DML and DDL on various database server systems and performing SQL queries on the created database.