Where Data Meets Intelligence: Relationships, Schemas, and Joins

Zenna Akinyi — Sat, 04 Jul 2026 07:23:28 +0000

Imagine Power BI as a city's central transportation hub.
Every table is like a neighborhood. Relationships are the roads connecting neighborhoods. Schemas are the city map showing how everything is organized. Joins are the vehicles that move information from one place to another.
Power BI is the traffic control center, ensuring data flows efficiently so everyone reaches the right destination. Such a powerful concept, right? Lets take a ride on this road

Relationships

Imagine a city where roads connect neighborhoods but there are no traffic lights, road signs, or speed limits. The result would be congestion, wrong turns, and accidents. Similarly, without relationships, Power BI would struggle to understand how different tables are connected, leading to inaccurate analysis. Relationships provide the rules that guide data from one table to another, ensuring reports and dashboards display consistent and reliable results.

Schemas

A schema in Power BI is like a city's road map or blueprint. Before people can travel efficiently, the city needs a well-planned layout showing where neighborhoods, roads, bridges, and intersections belong. Similarly, a schema organizes data tables into a logical structure, defining how they relate to one another. Just as a road map helps drivers navigate the city, a schema helps Power BI understand how data is arranged, ensuring information flows accurately and efficiently.

Joins

Joins are like the roads and bridges that connect different neighborhoods within a city. Without these connections, each neighborhood would remain isolated, making travel difficult. In Power BI, joins combine related information from different tables using common fields, allowing data to move seamlessly across the model. Whether it's an Inner Join, Left Join, Right Join, or Full Outer Join, each join determines which "routes" are available and which data reaches its destination.

Conclusion

Just as a well-planned transportation network keeps a city running efficiently, schemas, relationships, and joins work together to create a strong and reliable data model in Power BI. Understanding these three concepts is essential for building efficient Power BI reports and dashboards that turn raw data into actionable intelligence.

How Excel is Used in Real-World Data Analysis

Zenna Akinyi — Sat, 06 Jun 2026 05:18:25 +0000

Introduction

Excel converts raw data to useful data in rows and columns, allowing you to perform calculations, create charts, analyze data, and automate tasks with formulas and functions. The rows are represented using numbers, while the columns are represented by letters. Cells are where columns and rows intersect. Excel worksheets contain columns and rows, while the workbook has several sheets.

Uses of Excel in the real world

To understand what is happening: A small shop owner can use Excel to track daily sales and could create a pivot table to show sales that are highest on weekends and lowest on Mondays, while a line chart reveals that phone accessory sales spike every December to help them understand which products sell when and plan stock accordingly.
To spot problems: A teacher could use Excel to highlight all student grades below 50% in red, instantly spotting which students need extra help.
To predict the future: A farmer can use Excel, with the last 3 years of rainfall and crop yield data, to predict next season's harvest, while a small business owner can use it to predict next month's sales based on the past 12 months, helping them decide how much inventory to order and when to hire temporary staff.

Uses of Excel functions

Excel has several functions. I have listed a few
ctrl+shift+$ is used to change the currency.
conditional formatingis used to highlight the color.
alt+H+O+Iis used to separate data.
proper functionis used to capitalize the first letter.
lower functionis used to convert to lowercase
upper functionis used to convert to uppercase
alt+H+Bis used to underline the header

Conclusion

Before learning Excel, all I saw was numbers and too much information. I thought it was just a data entry tool and that was it. Excel has taught me problem-solving skills, patience, keenness, and to slow down and listen to my data because behind every piece of data there is a decision to be made or a decision was made. Now I see Excel as a powerhouse for better decisions, and my perspective on data has definitely changed.

DEV Community: Zenna Akinyi

Where Data Meets Intelligence: Relationships, Schemas, and Joins

Relationships

Schemas

Joins

Conclusion

How Excel is Used in Real-World Data Analysis

Introduction

Uses of Excel in the real world

Uses of Excel functions

Conclusion