Alert: Sadly, I don't have time to maintain this but we have now a new edition 2020 available at https://www.amazon.com/dp/B086ML4PGW/ref=cm_sw_r_sms_awdb_t1_Z6oHEbGMPYFXF. The "Clear and Sane" framework for rapid data modeling, from the book "Clear and Sane engineering" (by Cheikhna Diouf) , a lightweight alternative to UML-like diagrams for en…

Data Modeling, Engineering and Analysis for a company's employee database

This project includes data modeling, engineering and analysis of employee data. Demonstrates use of SQL, creating schemas, queries, joins, aggregate functions, primary keys, and foreign keys.

Introdução a técnicas de modelagem de dados para modelos de Regressão Linear utilizando StatsModels e Scikit Learn.

Data Modeling using CassandraQL for a Music Industry Project (Sparkify). Course Project by Udactiy Data Engineering Nano Degree.

[Data Modeling/ ETL] This project aims to create a star schema optimized for song play analysis queries for the music streaming service Sparkify.

deriving insights from data contained in sql or nosql databases for dashboards

Investigated Lyft riders’ data set, by performing data wrangling, conducting exploratory data analysis, and building statistical machine-learned model, using python packages, to determine KPIs, that guide riders’ cancellation decision

This SQL project is a cumulation of Data modelling, engineering and analysis and aims to organize employee and department data from 1980s to 1990s.

Built a data warehoue with that picks data from AWS s3, transforms and loads the data into AWS redshift.

This project involved Data Engineering and Data Analysis where I designed the tables to hold data from 6 CSV files, imported the CSVs into a SQL database using PostgreSQL and wrote SQL queries to answer the given questions. A bonus analysis included creating some charts to analyze employee salary data.

7. SQL Engineering and Data Analysis

A Server Side Pre-Rendered Company Website build using NextJs

Modeling the data with Postgres and building an ETL pipeline using Python. I will define fact and dimension tables for a star schema for a particular analytic focus, and write an ETL pipeline that transfers data from files in two local directories into these tables in Postgres using Python and SQL.

Data modelling with postgres. First project of udacity data engineering nano degree

ETL and Dimensional Modeling with PostgreSQL

A data science hackathon project to draw top 10 insights from several datasets consisting of 3 lacs of data

ETL (Extract, Transform & Load) Pipline to extract user activity and song data from json files and ingestion into a Postgres Database. This Project is part of the [Udacity Data Engineering nanodegree](https://www.udacity.com/course/data-engineer-nanodegree--nd027).

Exploring, cleaning and wrangling SFM Technologies' water consumption dataset using python and pandas library, in order to obtain clean data. This is data is modeled and visualized in a Power BI dashboard.

Data model to keep track of a collector's extensive retro electronics collection.