Salary Management Project in SQL
Salary management project, from creating a database to creating the final DWH and loading it with all necessary data.
Salary Management Project in SQL
GDP Time Series Analysis
Data preprocessing, EDA (in Python) include relevant dataset for 197 countries for 200 years time horizon.
Car Accidents in USA
This is a countrywide car accident dataset, which covers 49 states of the United States. The data is collected from February 2016 to December 2019, using several data providers.
Design Database, tables and load preparation
Design database, then DataWareHouse for the database. The main purpose of the DW is to keep the accounts balance on monthly level.
Full Initial Load in SQL Server
Full Initial Load using functions and stored procedures in SQL Server.
Incremental Load in SQL Server
Incremental load in SQL Server using functions and stored procedures in SQL.
Extend the ETL workflow
Extend the ETL workflow, from WorldWideWeb to WorldWideWeb DataWarehouse, with the help of newly created stored procedure which will synchronize the given dimension.
Air pollution prediction
Regression learning data preprocessing with algorithms, using the given dataset. The goal is to predict the PM10 concentration using the weather-meteorological data.
Credit History and Evaluation
A classification problem, using prediction and decide wheather or not the credit should be approved for a client.
Diabetes metrics and evaluation
Diabetes metrics and evaluations using different classifiers, where the accuracy has to be compared using each of it.
Heart Blood Pressure
EDA, evaluation, metrics. Given dataset, all features explained in the link below.
Predicting PM concentration using meteorological data
Regression learning, data preprocessing, algorithms feature selection, hyperparameter optimization. The goal is to predict the PM10 concentration using the weather-meteorological data.
Telecommunication Providers
EDA, evaluation, metrics. Predicting whether a customer will change telecommunications provider, something known as "churning".
Predicting stroke
EDA, General analysis.
Functions in Python
Some useful python functions and solutions.
Cats vs Dogs Identification-
Training the model using the unsupervised learning.
Credit evaluation with Scikit-Learn
Training models and basic preprocessing in Scikit-Learn. If successful, the model has to identify applicants that are at high risk to default, allowing the bank to refuse credit requests.
Earthquakes
Pyplot, Pyfile, PlyData
Calculus
Calculus in Python.
Descriptive Statistics & Intro to Probability
Descriptive Statistics & Intro to Probability in Python.
Hypothesis Tests
Hypothesis Tests in Python.
Linear Algebra
Linear algebra in Python.
Multivariable Calculus
Multivariable Calculus in Python.
Probability Distribution
Probability distribution in Python.
Regression Analysis
Regression Analysis in Python.
Activities for Young People Survey
Project prepared for an NGO client, using their survey data (chaotic excel file that had to be cleaned first) and prepared Power BI dashboard.
Adventure Works Report
Adventure Works Report, cleaned with Power Query and created Power BI dashboard.
Picture classification Spark ML.
Picture classification Spark ML.
Spark RDD
Spark RDD.
Spark SQL
Spark SQL.
Address
Callao Salvaje 38
Adeje, Tenerife, Spain 38678
Phone
Social
- © Untitled
- Design: HTML5 UP