Advanced Data Analytics & Geospatial Intelligence for Oil Trading: SQL, Python, and Power BI Masterclass

Module 1: SQL Foundations for Energy Data Management

ü  Introduction to relational databases in the oil sector

ü  Writing complex joins for trade and cargo data

ü  Aggregating historical price series (Platts, Argus, ICE)

ü  Data cleaning and normalization for physical contracts

ü  Practical Session: Building a trade database schema from raw CSV cargo logs

Module 2: Spatial Data Engineering: SQL and GIS Integration

ü  Introduction to spatial data types (Points, Polygons, Multipolygons)

ü  Mapping oil refineries, pipelines, and storage terminals

ü  Coordinate Reference Systems (CRS) for global shipping

ü  Importing AIS vessel data into SQL environments

ü  Practical Session: Querying the nearest terminal infrastructure using spatial SQL

Module 3: Advanced Geospatial Querying (SQL for GIS دورات)

ü  Utilizing ST_Distance and ST_Contains for market catchment analysis

ü  Geofencing around key straits (Suez, Hormuz, Malacca)

ü  Calculating pipeline throughput and bottleneck analysis via SQL

ü  Advanced SQL for GIS دورات techniques for resource localization

ü  Practical Session: Identifying all tankers currently within a specific geofenced port zone

Module 4: Python Essentials for Oil Market Analysis

ü  Introduction to the Python "Energy" stack (Pandas, NumPy)

ü  Connecting Python to SQL Server and PostGIS

ü  Time-series analysis for price volatility

ü  Handling missing data in erratic market feeds

ü  Practical Session: Scripting a Python tool to calculate rolling 30-day volatility for Brent Crude

Module 5: Automating Physical Trade Workflows with Python

ü  Web scraping for energy news and regulatory updates

ü  Automated PDF parsing for Bills of Lading and Invoices

ü  Scripting automated email alerts for price threshold breaches

ü  API integration for real-time AIS vessel tracking

ü  Practical Session: Building an automated Python bot to fetch and log daily bunker prices

Module 6: Data Modeling for Downstream Supply Chains

ü  Star Schema vs. Snowflake Schema for downstream retail data

ü  Modeling fuel inventory levels across multiple terminals

ü  Fact tables for sales, loGIStics, and secondary distribution

ü  Managing dimensions for products (ULSD, Mogas, Jet A1)

ü  Practical Session: Designing a dimensional model for a downstream retail network

Module 7: Power BI for Real-time Market Visualization

ü  Connecting Power BI to live SQL and Python data streams

ü  Designing high-impact visualizations for the trading floor

ü  Using DAX for complex oil-specific measures (Netbacks, Crack Spreads)

ü  Implementing "What-if" parameters for market stress testing

ü  Practical Session: Developing a "Market Heatmap" to visualize global supply-demand imbalances

Module 8: Integrating SQL python and Power BI for physical oil trading

ü  Using Python scripts inside Power BI for advanced analytics

ü  Transforming data with Power Query and SQL views

ü  Optimizing data refresh rates for physical operations

ü  Security and row-level access for sensitive trade data

ü  Practical Session: Creating a Power BI visual that runs a Python script to forecast storage drawdown

Module 9: Netback, Arbitrage, and Storage Analytics

ü  Calculating Netback prices for different discharge ports

ü  Building an arbitrage calculator: Freight + Insurance + Tax

ü  Storage "contango" and "backwardation" visualization

ü  Optimizing blending operations via linear programming concepts

ü  Practical Session: Developing a tool to identify the most profitable destination for a specific cargo

Module 10: Capstone: Building the Integrated Trading Intelligence System

ü  Consolidating SQL python and Power BI for physical oil trading into one system

ü  Developing a "Command Center" dashboard

ü  Best practices in data governance and documentation

ü  Future trends: AI and Machine Learning in oil trading

ü  Practical Session: Presenting a completed integrated dashboard featuring GIS tracking and price forecasting

About Our Trainers

Our trainers are industry-leading Data Scientists and Senior Oil Traders with over 20 years of combined experience in the London, Geneva, and Singapore markets. They have successfully implemented SQL python and Power BI for downstream oil trading, SQL and GIS, SQL for GIS دورات, SQL python and Power BI for physical oil trading frameworks for major IOCs and national oil companies. Our GIS leads are certified experts in spatial SQL and remote sensing, specifically within the energy supply chain.

Quality Statement

Phoenix Center for Policy, Research and Training is committed to excellence. Our curriculum is updated quarterly to reflect the latest shifts in the energy markets and technological advancements in the SQL python and Power BI for physical oil trading stack. We ensure every participant receives personalized attention through small class sizes and high-quality course materials.

Tailor-Made Courses

We understand that every organization has unique challenges and opportunities as well as unique training needs. Phoenix Training Center offers tailor-made courses designed to address specific requirements and challenges faced by your team or organization. Whether you need a customized curriculum focused on specific geographical regions, a specific duration, or on-site delivery, we can adapt our expertise to provide a training solution that perfectly aligns with your objectives.

We can customize this Course to focus on your industry, specific risk profile, or internal stakeholder dynamics. Contact us to discuss how we can create a bespoke training program that maximizes value and impact for your team. For further inquiries, please contact us on Tel: +254720272325 / +254737296202 or Email training@phoenixtrainingcenter.com

Admission Criteria

ü  Participants should be reasonably proficient in English. 

ü  Applicants must live up to Phoenix Center for Policy, Research and Training admission criteria.

Terms and Conditions

ü  Discounts: Organizations sponsoring Four Participants will have the 5th attend Free

ü  What is catered for by the Course Fees: Fees cater for all requirements for the training – Learning materials, Lunches, Teas, Snacks and Certification. All participants will additionally cater for their travel and accommodation expenses, visa application, insurance, and other personal expenses.

ü  Certificate Awarded: Participants are awarded Certificates of Participation at the end of the training.

ü  The program content shown here is for guidance purposes only. Our continuous course improvement process may lead to changes in topics and course structure.

ü  Approval of Course: Our Programs are NITA Approved. Participating organizations can therefore claim reimbursement on fees paid in accordance with NITA Rules.

Booking for Training

Simply send an email to the Training Officer on training@phoenixtrainingcenter.com and we will send you a registration form. We advise you to book early to avoid missing a seat to this training. Or call us on +254720272325 / +254737296202

Payment Options

We provide 3 payment options, choose one for your convenience, and kindly make payments at least 5 days before the Training start date to reserve your seat:

ü  Groups of 5 People and Above – Cheque Payments to: Phoenix Center for Policy, Research and Training Limited should be paid in advance, 5 days to the training.

ü  Invoice: We can send a bill directly to you or your company.

ü  Deposit directly into Bank Account (Account details provided upon request)

Cancellation Policy

ü  Payment for all courses includes a registration fee, which is non-refundable, and equals 15% of the total sum of the course fee.

ü  Participants may cancel attendance 14 days or more prior to the training commencement date.

ü  No refunds will be made 14 days or less before the training commencement date. However, participants who are unable to attend may opt to attend a similar training course at a later date or send a substitute participant provided the participation criteria have been met.

Accommodation and Airport Transfer

For physical training attendees, we can assist with recommendations for accommodation near the training venue. Airport pick-up services can also be arranged upon request to ensure a smooth arrival. Please inform us of your travel details in advance if you require these services. For reservations contact the Training Officer on Email: training@phoenixtrainingcenter.com or on Tel: +254720272325 / +254737296202