Contains end to end Data Analysis portfolio project made using Excel, SQL, Tableau & Power BI
-
Updated
Apr 10, 2024
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.
E-commerce database application for browsing, selling, and buying products online
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.
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.
Data Fellowship 9 Final Project - Bank Marketing Campaign Data Pipeline
An end to end data engineering project aiming to build an ELT data pipeline that generate insights into ads campaign.
Add a description, image, and links to the data-modelling topic page so that developers can more easily learn about it.
To associate your repository with the data-modelling topic, visit your repo's landing page and select "manage topics."