Forem: Stephen Omengo

Introduction to SQL: DDL, DML, and Data Querying

Stephen Omengo — Tue, 14 Apr 2026 08:23:46 +0000

Structured Query Language (SQL) is used to manage and manipulate databases. In this assignment, I learned how to build and interact with a database from scratch.

DDL vs DML

DDL (Data Definition Language) is used to define the structure of a database. Commands like CREATE, ALTER, and DROP are used to create tables and modify them.

DML (Data Manipulation Language) is used to work with the data inside the database. Commands such as INSERT, UPDATE, and DELETE help in adding, modifying, and removing data.

Practical Usage

I used CREATE to build tables such as students, subjects, and exam_results. I then used INSERT to populate them with data. UPDATE helped correct mistakes, and DELETE removed unwanted records.

Filtering Data

The WHERE clause is used to filter records. I used operators such as:

= (equals)
> (greater than)
BETWEEN (range filtering)
IN (multiple values)
LIKE (pattern matching)

These made it easy to retrieve specific data from the database.

CASE WHEN

CASE WHEN allows us to transform data into meaningful categories. For example, I used it to classify student performance into Distinction, Merit, Pass, and Fail.

Reflection

This assignment was both challenging and interesting. Understanding relationships between tables and writing correct queries required attention to detail. However, it improved my confidence in working with databases and SQL queries.

IOS 26.4 Beta : WHAT USERS NEED TO KNOW

Stephen Omengo — Sun, 12 Apr 2026 18:51:57 +0000

Key Features

New emojis
New Accessibility options
CarPlay AI Integration
Performance and stability improvements

New Emojis

. The new iOS 26.4 beta expands the user's library by adding new characters for messaging and social media, such as the Distorted face, a fan favourite.

New Accessibility options

. To users who have a strong visual effect, there is a new feature for them called "Reduce Bright Effects." This reduces intense flashing when interacting with the keyboard.

Carplay AI Integration

. With Apple CarPlay, users can now use third-party apps such as ChatGPT and Gemini through voice command.

Performance and Stability Improvements

. Like all the previous updates, this is a general improvement that fixes bugs, provides smoother performance, "Not laggy anymore."

Compatibility

. IOS 26.4 is available on iPhone 11 series and later, plus iPhone SE (2nd generation).

Summary

. Although iOS 26.4 may appear to be a minor update, it delivers meaningful improvements in performance, accessibility, and AI integration. For both everyday users and developers, it represents another step toward a more intelligent and optimized Apple ecosystem.

Understanding Data Modeling in Power BI: Joins, Relationships, and Schemas Explained.

Stephen Omengo — Tue, 07 Apr 2026 07:14:51 +0000

Data modeling is a critical step in building effective Power BI reports. It shows how data is structured, connected, and used to generate understanding. A well-designed model improves performance and ensures accuracy, while a poor one can lead to slow dashboards and incorrect results.
This article explains data modeling in Power BI, covering SQL joins, relationships, schemas, and how to implement each step in practice.

Data Modeling

Data modeling is the process of organizing data into tables and showing how those tables relate to one another. This happens after data is imported and transformed.
Purpose of data modelling:

Efficient calculations
Structure of data
improve efficiency and clarity

SQL joins

What are joins? They are used to combine rows from two or more tables based on a related column.

1.Inner join

Returns only matching rows from both tables.

2.LEFT JOIN (LEFT OUTER)

Returns all rows from the left table and matching rows from the right.

3.RIGHT JOIN (RIGHT OUTER)

Returns all rows from the right table and matching rows from the left.

4.FULL OUTER JOIN

Returns all rows from both tables.

6. LEFT ANTI JOIN

Returns rows from the left table with no match in the right.

7.RIGHT ANTI JOIN

Returns rows from the right table with no match in the left.

How to Create Joins in Power BI
.Open Power BI Desktop
.Click Transform Data
.Select a table
.Click Merge Queries
.Select the second table
.Choose a matching column
Select join type:
.Inner
.Left Outer
.Right Outer
.Full Outer
.Left Anti
.Right Anti
Click OK
.Expand merged columns

Relationships in Power BI

Type of relationships:
1.One-to-Many (1) -Most common type.
2.Many-to-Many (M) -Both tables contain duplicate values.
3.One-to-One (1:1) -Each record matches exactly one record in another table.

Creating relationships in Power BI

.Go to Home → Manage Relationships
.Click New
.Select tables and columns
.Set cardinality and filter direction
.Click OK

Conclusion

Data modeling in Power BI is the foundation of effective reporting. Understanding joins, relationships, and schemas allows you to build models that are both efficient and reliable.

Guide to Publishing and Embedding Power BI Reports on the Web with IFrames

Stephen Omengo — Tue, 07 Apr 2026 07:13:36 +0000

Introduction

In today’s data-driven world, organizations rely heavily on tools that transform raw data into valuable insights. One of the most powerful solutions for this purpose is Microsoft Power BI. It enables analysts and businesses to create interactive dashboards and reports that support informed decision-making. One of the most powerful tools for this purpose is Microsoft Power BI. It allows analysts and businesses to create interactive dashboards and reports to support decision-making.

This article provides a step-by-step guide on how to :

Create a Power BI workspace
Upload and publish a report
Generate an Embed code
Embed the report into a website using an iframe

What is Power BI? This is a business analytics tool developed by Microsoft that enables users to transform, clean data, build interactive visualizations, and connect to multiple data sources*Excel*.

What is Power BI Publishing? Publishing a Power BI report involves moving your report from Power BI Desktop to the Power BI Service cloud platform.

Prerequisites

Key things to consider before you start:

Power BI Desktop installed
A Power BI account
A complete report

Step 1: Create a Workspace in Power BI Service

A workspace is a shared environment where you store datasets, reports, and dashboards.

Tutorial

Go to Power BI Service: https://app.powerbi.com
Log in using your account
On the left sidebar, click Workspaces
Click + New workspace
Enter: .Workspace name .Description
Click Save

Step 2: Prepare Your Report

You should make sure that your report is: Clean and well-structured, has meaningful visuals, uses proper relationships, and DAX measures.

Step 3: Publish the Report to Power BI Service

Tutorial

Open your report in Power BI

Click File → Publish → Publish to Power BI
Sign in if prompted
Select your workspace created earlier
Click Select

Once uploaded, you’ll see a confirmation message.

Step 4: Verify the Report in Power BI Service

Head back to Power BI Service
Open your workspace
Locate your report under Reports
Click to open and confirm everything is working

Step 5: Generate the Embed Code

Power BI allows you to embed reports using Publish to Web or secure embedding.
Note: Publishing to the web makes it easily accessible, and anyone with the link can view it.

Tutorial

Open your report in Power BI Service
Click File → Embed report → Publish to web

Click Create embed code

Confirm the warning
Copy the generated iframe code

Step 6: Understanding the IFrame Code

The embed code will look like this:
<iframe width="800" height="600" src="https://app.powerbi.com/view?r=..." frameborder="0" allowFullScreen="true"></iframe>

Key Attributes:
.Width & height: Control size
.Src: Contains report URL
.Frameborder: Removes border
.AllowFullScreen: Enables full-screen mode

Step 7: Embed the Report into a Website

.You can embed this iframe into:

HTML websites
Blogs (Dev.to, Medium)
Web apps

Step 8: Test Your Embedded Report

After embedding:
.Open your website in a browser
. Check: Report loads correctly, Filters and visuals work, and Responsiveness.

conclusion

Publishing and embedding Power BI reports is an essential skill for any data analyst. It allows you to transform your work into a shareable and interactive experience accessible from anywhere.