This is my personal development space where I build integrated approaches for environmental and agricultural purposes
-
Updated
Jan 6, 2023 - Jupyter Notebook
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:
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 project showcases an end-to-end ELT (Extract, Load, Transform) pipeline leveraging the TPCH orders table from Snowflake's sample database. The primary goal is to demonstrate modern data engineering practices using Snowflake, dbt (Data Build Tool), and Apache Airflow.
Designing MongoDB database for Zen class programme, covering users, codekata, attendance, topics, tasks, company drives, and mentors as part of a Day-36 task from GUVI Zen class.
This project focuses on enhancing direct marketing strategies for a Portuguese banking institution, specifically targeting term deposit subscriptions. Utilizing advanced data analytics, predictive modeling, and customer segmentation, we developed a robust database system to improve marketing precision and effectiveness.
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.
This project involves creating comprehensive Sales and Finance Reports using data provided by AtliQ Hardware. The objective is to empower businesses to monitor and evaluate their sales activities and financial performance, supporting informed decision-making and stakeholder communication.
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.
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.
Airplane Boarding Simulation: Visually display hundreds of passengers boarding
Extensible Object Model Data Abstraction
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.
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."