Data Preparation and Analysis Using Power BI & SQL

• Course Duration: 10 hours

• Instructor: Mr. Nashaat Jumaa

The course covers the fundamentals of handling data, presenting it, preparing it, and analyzing it. No prior programming knowledge is required.

Course Contents

📊 General Introduction

• Introduction to various oil industry operations.

• Understanding how data is generated in oilfields, their types, and classifications.

🗃️ Databases and SQL

• Introduction to relational databases.

• Basics of SQL language.

• Performing basic operations on data: Create, Read, Update, Delete (CRUD).

• Understanding tables and derived elements like views.

🔄 Data Handling and Analysis

• Merging and splitting tables using Power BI.

• Using aggregations and statistics in data analysis.

• Understanding data structures and handling different types of data.

📈 Power BI and Its Applications

• Overview of Power BI interface and features.

• Starting a new project and loading data into Power BI.

• Introduction to data modeling, transformation, and ETL.

• Converting operational and production data into interactive reports.

• Creating dashboards and interactive visuals.