Projects

Data Engineering project-

• Collect traditional batch pumping parameters from a petroleum product pipeline source station
• Transforms the collected data
• Save the transformed data in a ready to load csv format for Analysis.

HOUSE PRICE PREDICTION LINEAR REGRESSION –

• To identify the variables affecting house prices, e.g. area, number of rooms, bathrooms, etc.
• To create a linear model that quantitatively relates house prices with variables such as number of rooms, area, number of bathrooms, etc.
• To know the accuracy of the model, i.e. how well these variables can predict house prices.

Customer Sales Analysis –

• Utilized SQL to extract data from 8 different related tables from customer sales databases using JOIN and VIEW
• Transformed and filtered data by using aggregating and filtering function to improve reporting process
• Loaded and visualized data with Python to identify key business intelligences that can improve sales performance

Skills