Basic Python and Power BI Trainer

ONLY TRAINERS MUST APPLY / FREELANCE TRAINERS ONLY

Basic Power BI Training Outline

Module 1: Power BI Basics

• What is Power BI?
• Power BI Desktop vs. Power BI Service
• Interface walkthrough: ribbon, visuals pane, fields pane
• Types of Power BI components: datasets, reports, dashboards

Module 2: Getting & Importing Data

• Connecting to Excel, CSV, Web data
• Understanding import vs. DirectQuery
• Exploring datasets and tables
• Hands-on: Import sample dataset

Module 3: Power Query Editor (Data Preparation)

• Cleaning and shaping data
• Removing duplicates
• Splitting & merging columns
• Changing data types
• Hands-on: Basic transformations

Module 4: Data Modeling Basics

• Understanding relationships
• Primary/foreign keys
• Cardinality & cross-filter direction
• Star schema basics
• Hands-on: Creating relationships

Module 5: Introduction to DAX

• Measures vs. calculated columns
• Basic functions:
• SUM
• COUNT
• IF
• AVERAGE
• Hands-on: Creating simple measures

Module 6: Visualizations & Dashboard Building

• Creating charts: bar, pie, line
• Cards, tables, KPIs
• Adding slicers
• Formatting visuals for clarity
• Hands-on: Build a mini dashboard

Module 7: Publishing & Sharing

• Publishing to Power BI Service
• Creating workspaces
• Sharing dashboards
• Overview of permissions
• Q&A

***********************************************************************************

Basic Python Training Program

Module 1: Introduction to Python

• What is Python?
• Why Python is popular
• Installing Python & using IDEs (IDLE, VS Code, Jupyter)
• First Python script: print("Hello, World!")

Module 2: Python Basics

• Variables & naming rules
• Data types (int, float, string, boolean)
• Input & output functions
• Basic operators (+, -, *, /, %, //, **)
• Hands-on mini exercises

Module 3: Conditional Statements

• if, elif, else
• Nested conditions
• Comparison & logical operators
• Hands-on: Simple decision-making programs

Module 4: Loops

• for loops
• while loops
• Loop control: break, continue, pass
• Hands-on: Repetition & iteration tasks

Module 5: Data Structures

• Lists
• Tuples
• Dictionaries
• Sets
• Hands-on: Accessing, modifying, looping through data

Module 6: Functions

• Defining functions
• Parameters & return values
• Built-in vs. user-defined functions
• Hands-on: Writing reusable code

Module 7: Working with Files

• Reading files
• Writing files
• Simple automation tasks
• Hands-on: Create & save a text file

Module 8: Intro to Libraries

• Using the math library
• Intro to pandas (optional for beginners)
• How to install libraries using pip

Module 9: Mini Project

Examples:

• Simple calculator
• Name/age input program
• Basic data summarizer
• Contact list program

QUALIFIED AND EXPERIENCED IN PREPARING MATERIALS AND USING SOFTWARE AND RELEVANT TOOLS TO TRAIN PARTICIPANTS/LEARNINGS ON BASIC PYTHON AND POWER BI is a MUST

Please apply with CV with picture and list of trainings conducted

Job Types: Part-time, Temporary, Contract
Contract length: 12 months

Pay: AED50.00 per hour

Expected hours: 4 per week