Building Data Models In PostgreSQL
This creates PostgreSQL tables, inserts data using Python, constructs a simpler star schema from a complex 3 NF schema, and analyses query time complexity.
Data Modelling Analyst
Data Engineer
Database Specialist
PostgreSQL
Python
Data Acquisition from an MQTT Broker
Connects to remote IoT devices on oil & gas vessels, extracts variables like level, flow, pressure, temperature in real-time, and transforms data for analysis.
Data Scraper
Data Engineer
AWS
AWS Lambda
Python
Food Delivery Analytics
Food delivery insights using Microsoft PowerBI; includes data cleansing, analysis, visualization, AI, predictive analytics, and Pareto principle application.
Data Visualizer
Business Analyst
Data Analyst
Microsoft Power BI
Python