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

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.

Data Preprocessing

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.

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.

Open source dataset projects using various R studio And Jupyter notebook Environment

Visualizing and extracting insights from several different sets of related data

The project "Sales Reporting with Microsoft Power BI" involved leveraging the capabilities of Microsoft Power BI to analyze and visualize sales data using DAX (Data Analysis Expressions). The main objective was to generate meaningful insights and present them in an effectively.

Proyecto final SQL Server Intermedio WE Educación Ejecutiva

Perform Extract-Transform-Load on datasets scraping from NHL website using Pandas, PostgreSQL ,SQLAlchemy, and cloud database for public access.