DEV Community: Josephine Mackylah

Just These 10 Python Concepts Will Get You Started

Josephine Mackylah — Tue, 01 Sep 2026 13:32:11 +0000

Introduction

Learning Python is a lot like building with blocks. You don't start with the roof you start with one block, set it down properly, then place the next one on top of it. Skip a step, or rush past something you didn't fully understand, and everything you try to stack on top of it starts to wobble.

That's exactly how these ten concepts work. You can't really understand a loop until you understand a list. You can't understand a function until you've written a few conditional statements by hand. Even something as simple as print() sets you up for f-strings a few sections later. Nothing here exists on its own each concept quietly leans on the one before it, and sets up the one that comes next.

So take your time with this one. Don't skim ahead looking for the "advanced" part there isn't one yet. Understand each block before you place the next, and by the end, you won't just have memorized ten separate ideas. You'll have built a foundation sturdy enough to hold whatever you decide to learn next.

Let's lay the first block.

What Is Python?

Python is a programming language known for reading almost like plain English. Where some languages demand semicolons, brackets, and rigid formatting just to print a sentence, Python lets you write print("Hello") and move on with your day. That simplicity is exactly why it's one of the most widely used languages in the world.

Here's what that looks like in practice. Instagram uses Python behind the scenes to help run parts of its app. Spotify uses it to help decide what song to play next. Netflix uses it to help figure out what show to recommend you. Even simple, everyday things like a script that renames a hundred files at once, or a program that checks the weather and texts you if it's going to rain are the kind of small, practical tasks Python is great at.

You don't need to build anything as big as Netflix to benefit from Python. Even the smallest script that saves you five minutes of repetitive work is Python doing exactly what it's meant to do.

Variables: Giving Your Data a Name

A variable is a labeled container for a value. Instead of retyping someone's age every time you need it, you store it once and refer to it by name:

name = "Josephine Mackylah"
age = 25
city = "Nairobi"

Think of variables the way you'd think of cell references in a spreadsheet. You don't retype the number in B2 everywhere you need it you just reference B2. Variables are Python's version of that same convenience, except the name is whatever you choose, which makes code far easier to read six months later than a spreadsheet full of B2 and D17.

Data Types: Python Needs to Know What Kind of Value It's Holding

Every variable holds a value, and every value has a type. As a beginner, you'll mostly work with four of them:

name = "Josephine Mackylah"    # str (string) — text
age = 25                        # int (integer) — whole numbers
salary = 14100000.50            # float — decimal numbers
is_active = True                 # bool (boolean) — True or False

This matters more than it sounds like it should. Python won't let you add a number to a piece of text "Salary: " + 14100000.50 throws an error, because one side is a string and the other is a number. You'd have to convert it first: "Salary: " + str(14100000.50). This single rule that Python cares deeply about type explains more beginner error messages than anything else in the language, so it's worth internalizing early rather than treating it as an annoyance.

`print()`: Making Python Talk Back to You

print() is how Python shows you something on screen. It's the very first tool you'll reach for, and you'll never stop using it even experienced programmers sprinkle print() statements everywhere while checking their work.

print("Python is","great")

Output:

Python is great

Every time you want to check whether something did what you expected, print() is how you look.

`input()`: Letting a Human Talk Back to Python

input() does the reverse it pauses your program and waits for someone to type something in:

age = int(input("How old are you? "))
print("You are", age, "years old")

Output (if age = 25)

How old are you? 25
You are 25 years old

You won't use input() in every single program, but it's what makes your code feel interactive instead of static. It's the difference between a script that just runs the same way every time, and one that actually responds to the person using it like a simple quiz, a to-do list that asks what you want to add, or a small calculator that asks for two numbers before doing the math.

F-Strings: The Cleanest Way to Combine Text and Data

Early on, combining text and variables looks clumsy:

print("Hello " + name + "! You are " + str(age) + " years old.")

Output (using name = "Josephine Mackylah" and age = 25 from earlier):

Hello Josephine Mackylah! You are 25 years old.

F-strings fix that. Put an f before the quotation marks, and drop your variables straight into the sentence using curly braces:

name = input("Enter your name: ")
age = int(input("Enter your age: "))

print(f"Hello {name}! You are {age} years old.")

Output (if the person enters "Josephine" and 25):

Enter your name: Josephine
Enter your age: 25
Hello Josephine! You are 25 years old.

No +, no str() conversions, no broken sentences from missing spaces. F-strings are the standard way modern Python code combines text and values, and once you start using them, going back to the old way feels genuinely painful.

Conditional Statements: Teaching Python to Make Decisions

A conditional statement lets your code branch based on a condition the Python equivalent of an Excel IF formula.

score = int(input("Enter score: "))

if score >= 80:
    print("Grade A - Excellent")
elif score >= 70:
    print("Grade B - Good")
elif score >= 60:
    print("Grade C - Average")
elif score >= 50:
    print("Grade D - Below Average")
else:
    print("Grade F - Failed")

Output (if score = 85):

Enter score: 85
Grade A - Excellent

This is the logic behind almost every decision your code will ever need to make checking a score, deciding whether someone qualifies for something, choosing what message to show based on a condition. Once conditionals click, you'll start noticing them everywhere: a rule you'd normally explain out loud in a sentence is really just a conditional statement, waiting to be written in code.

Loops: Doing Something Once, Then Doing It Again and Again

A loop repeats an action across a collection of items, so you never have to write the same line 50 times:

foods = ["chapati", "ugali", "pilau", "githeri", "mandazi"]
for food in foods:
    print(food)

Output:

chapati
ugali
pilau
githeri
mandazi

i = 1
while i <= 10:
    print(i)
    i += 1

Output:

correct_password = "kenya2024"
attempts = 0
while True:
    password = input("Enter password: ")
    attempts += 1
    if password == correct_password:
        break
print(f"Correct! It took {attempts} attempts.")

Output (if the person types "jojo" first, then "kenya2024"):

Enter password: jojo
Enter password: kenya2024
Correct! It took 2 attempts.

Notice the three different shapes a loop can take here: a for loop stepping through a known list, a while loop counting up to a number, and a while True loop that keeps going until something specific happens (break). As you keep coding, you'll come across tools that quietly do looping for you behind the scenes but understanding what a loop actually does is what makes those tools make sense later on.

Lists: Python's Way of Holding More Than One Thing

A list is an ordered collection of values, written inside square brackets:

transactions = [1500, 3000, 800, 12000, 450, 2700]
total = 0
for amount in transactions:
    total += amount   # add each amount to the running total
    print(f"Added Ksh{amount} — Running total: Ksh{total}")

Output:

Added Ksh1500 — Running total: Ksh1500
Added Ksh3000 — Running total: Ksh4500
Added Ksh800 — Running total: Ksh5300
Added Ksh12000 — Running total: Ksh17300
Added Ksh450 — Running total: Ksh17750
Added Ksh2700 — Running total: Ksh20450

You can also grab items by position (Python starts counting at 0):

passengers = ["Amina", "Brian", "Cynthia", "David", "Esther"]

print(passengers[0])    # Amina — the first passenger
print(passengers[2])    # Cynthia — the third passenger (position 2)
print(passengers[-1])   # Esther — the last passenger

Output:

Amina
Cynthia
Esther

Position 0 is always the first item not the second which trips up almost every beginner at least once. And -1 is a shortcut for "the last one," so you never have to count how long a list is just to grab its final item.

Functions: Package Your Logic So You Never Rewrite It

A function is a named, reusable block of code. You define it once, then call it as many times as you need. Remember the grading logic from the conditionals section? Here's that exact idea, packaged into a function so you never have to retype it:

def get_grade(score):
    if score >= 80:
        return "Grade A - Excellent"
    elif score >= 70:
        return "Grade B - Good"
    elif score >= 60:
        return "Grade C - Average"
    elif score >= 50:
        return "Grade D - Below Average"
    else:
        return "Grade F - Failed"

print(get_grade(85))   # Grade A - Excellent
print(get_grade(42))   # Grade F - Failed

Output:

Grade A - Excellent
Grade F - Failed

The moment you find yourself copy-pasting the same five lines of grading logic into a second place, that's the signal to wrap it in a function instead. Now, no matter how many scores you need to grade, you call get_grade() once instead of retyping the same if/elif chain over and over.

The Modulus Operator: The Most Underrated Symbol in Python

The modulus operator, written as %, gives you the remainder after division not the answer itself:

print(10 % 3)   # 1  (10 divided by 3 leaves a remainder of 1)
print(15 % 5)   # 0  (15 divides evenly by 5)

Output:

1
0

It looks like a small, obscure trick, but it solves a very common problem: figuring out whether a number is even or odd, or whether it divides evenly into groups.

numbers = [12, 7, 18, 5, 30, 9]
count = 0
for number in numbers:
    if number % 2 == 0:
        count = count + 1
print(count)   # 3 — there are three even numbers in the list

Output:

booking_id = 47
if booking_id % 2 == 0:
    print("Even-numbered booking")
else:
    print("Odd-numbered booking")

Output:

Odd-numbered booking

It also shows up when batching work for example, processing a big list of items in groups of 10 and needing to know exactly when you've hit the boundary of a new batch. It's a small tool, but it's one of those things you don't appreciate until the exact moment you need it and realize nothing else does the job as cleanly.

Putting It All Together: A Simple Ticket Receipt

Let's take some of the earliest blocks you laid down variables, input(), print(), f-strings, and basic arithmetic and use them to build something real: a mini program that prints out a bus ticket receipt.

print("=" * 40)
print("             BUS TICKET BOOKING")
print("=" * 40)

passenger_name = input("Enter passenger name: ")
route = input("Enter route: ")
fare = int(input("Enter fare (ksh): "))

booking_fee = 10
total = fare + booking_fee

print()
print("=" * 40)
print("            TICKET")
print("=" * 40)

print(f"Passenger   : {passenger_name}")
print(f"Route       : {route}")
print(f"Fare        : Ksh{fare}")
print(f"Booking Fee : Ksh{booking_fee}")
print("-" * 40)
print(f"TOTAL       : Ksh{total}")
print("=" * 40)
print("             THANK YOU FOR BOOKING")
print("=" * 40)

Output (if the person enters "Josephine Mackylah", "Nairobi - Mombasa", and 1200)

========================================
             BUS TICKET BOOKING
========================================
Enter passenger name: Josephine Mackylah
Enter route: Nairobi - Mombasa
Enter fare (ksh): 1200

========================================
            TICKET
========================================
Passenger   : Josephine Mackylah
Route       : Nairobi - Mombasa
Fare        : Ksh1200
Booking Fee : Ksh10
----------------------------------------
TOTAL       : Ksh1210
========================================
             THANK YOU FOR BOOKING
========================================

There's more going on here than it looks like at first glance. Notice "=" * 40 that's Python repeating a character 40 times to draw a clean divider line, instead of you typing out forty equals signs by hand. It's a small trick, but it's the kind of shortcut that makes your output look intentional instead of thrown together.

The program then uses input() three times to collect the passenger's name, route, and fare turning a static script into something that actually responds to whoever's using it. Notice that the fare is wrapped in int(): that's because input() always hands back text, even if someone types a number, so we have to explicitly convert it before we can do math with it. Skip that step, and Python will refuse to add it to booking_fee a perfect real-world example of the "Python cares about data types" rule from earlier.

From there, it's just a variable holding a fixed fee, one line of arithmetic to calculate the total, and a series of f-strings to lay everything out neatly lining up the labels with spacing so the receipt actually looks like a receipt.

Run it, and you get a clean, ticket-style printout from about a dozen lines of code. That's variables, data types, input(), print(), and f-strings five of the ten blocks you just learned all working together to produce something that genuinely feels useful.

You don't have to master everything at once. Learn one block well, set it down properly, and place the next one on top. By the time you reach the last line of that receipt, you'll notice you're already using half the concepts you just learned without even having to think about it.

SQL Taught Me That There Is Always an Easier Way to Do Things

Josephine Mackylah — Wed, 26 Aug 2026 09:10:01 +0000

There is a particular kind of fatigue that only a data analyst knows. It is not simply the result of long hours, but the mental exhaustion of manually reviewing thousands of rows to find a single error, such as a misspelled category or inconsistent entry. This is where inefficient processes can become more draining than the work itself.

If you have experienced this, you already know where this is heading. If you have not, keep reading it may help you avoid hundreds of hours of unnecessary manual work.

The Manual Times

For a long time, my approach to data was largely based on trial and error. I collected the data, reviewed it manually, and spent significant time restructuring it. Filtering meant working through dropdowns one column at a time, cleaning involved manually scanning thousands of rows for errors and duplicates, and aggregation often depended on complex formulas that could easily break when the dataset changed.

I became proficient at working with messy datasets, to the point where people trusted me with the ones others avoided. However, being good at a manual process does not mean it is the most efficient approach. For years, I knew I was capable of handling the work, but I also knew there had to be a better way.

The truth is, I didn't feel the weight of that manual process until I compared it to what came after. You don't always know you're carrying something heavy until someone hands you a lighter version of the same load.

The Moment SQL Stopped Being Intimidating

I remember the first time I wrote a SQL query that solved a real problem. It was not perfect, but it returned exactly the records I needed, using three conditions that would have taken me nearly an hour to apply manually. The query did it in less than a second.

That was the moment I realized: I had been doing things the hard way.

That moment changed how I approached data. Instead of spending hours clicking through spreadsheets, I began opening the SQL editor and focusing on one question: What do I actually want to know? SQL handled the process of getting me there, allowing me to focus less on the mechanics and more on the insight.

Let Me Show You What I Mean

So let me walk you through a real kind of dataset I work with, a Tembo hotel booking records: booking_id, guest
_name, guest_phone, guest_city, guest_nationality, room_no, room _type, room_rate_per_night, check-in and check-out dates, payment method, staff_name, staff_department, staff_salary, booking_status,total_amount, service_used and guest_rating.
A few thousand rows collected over months and entered by different people will inevitably contain inconsistencies. If you work with operational data, you know that real-world datasets are rarely clean they are messy in ordinary but time consuming ways.

Cleaning thousands of records that used to take a full day now took a few well-written lines: standardizing inconsistent entries, catching nulls, flagging duplicates, all in one pass, all repeatable.
Filtering was no longer a scavenger hunt through dropdown menus. A WHERE clause could isolate exactly the records I needed, out of tens of thousands, instantly, and I could refine it as many times as I wanted without starting over.

--cleaning guest_name
update tembo_hotel.tembo_hotel_staging
set guest_name = initcap(trim(guest_name))
where guest_name is not null;

Aggregating stopped being a fragile web of formulas. GROUP BY and a handful of aggregate functions gave me summaries, totals, and averages that didn't break the moment the dataset grew.

select
    room_type,
    count(*) as total_bookings
from tembo_hotel.tembo_hotel_staging
group by room_type
order by total_bookings desc;

Transforming data, joining tables, reshaping records, building the exact structure a report needed, became a conversation with the data instead of a fight against it.

The work didn't get less important. It got less exhausting. And that distinction matters more than people admit.

Cleaning. The "Status" column should have four tidy values: Checked Out, Cancelled, No Show. Instead, some rows say "Checked Out" and others say "checked out," entered by someone in a hurry who didn't hit Shift. On a spreadsheet, you'd catch some of these with a filter, miss others, and never really be sure you got them all. In SQL, it's one statement:

update tembo_hotel.tembo_hotel_staging
set booking_status = 'Checked Out'
where lower(status) = 'checked out';

Every inconsistent entry, fixed, in one pass, no matter how many thousand rows are hiding behind it.

Filtering. Buried in the same dataset are a couple of bookings where the check-out date is recorded as earlier than the check-in date, a guest who apparently left two days before they arrived. Nobody enters that on purpose. It's a typo, a swapped date field, a rushed front-desk moment. On paper, or in a spreadsheet with a few thousand rows, that kind of error can sit there for months, quietly making your average length-of-stay figures wrong. A single filter surfaces it immediately:

SELECT booking_id, guest_name, check_in_date, check_out_date
FROM tembo_hotel.tembo_hotel_staging
WHERE check_out_date < check_in_date;

That query doesn't just find an error. It hands you a punch list, exactly which bookings to go back and fix, by name.

Transforming. The dataset also has a "Nights" column, filled in by hand, that's supposed to match the gap between check-in and check-out. Most of the time it does. But every so often you'll find a booking where the dates span two months and the nights column still says "2," because someone typed the wrong check-out date and the nights field was never recalculated. Instead of eyeballing every row to catch that, you let SQL do the comparison for you:

select booking_id, guest_name, check_in_date, check_out_date,
       nights as recorded_nights,
       (check_out_date - check_in_date) as actual_nights
from tembo_hotel.tembo_hotel_staging
where nights <> (check_out_date - check_in_date);

One query, and every mismatch between what was recorded and what actually happened is sitting right in front of you.

Aggregating. And then there's the question every manager eventually asks: which room type is actually making the money? Doing that by hand means sorting, subtotaling, and re-checking a pivot table every time new bookings come in, and hoping nobody left an amount field blank, because a blank cell breaks a SUM formula fast. SQL handles the gaps for you and gives you the answer in seconds:

select
    room_type,
    count(*) as total_bookings,
    sum(total_amount) as total_revenue,
    round(avg(total_amount), 2) as avg_booking_value
from tembo_hotel.tembo_hotel_staging
group by room_type
order by total_revenue desc;

What It Actually Changed

Learning SQL after years of doing things manually teaches you that it does more than save time it gives you back your attention. By reducing the mental effort spent on repetitive tasks, you have more capacity to focus on the data, identify meaningful patterns, and uncover insights that manual processes can easily hide.

SQL also changed how I viewed mistakes. Manual errors could easily go unnoticed until they were identified downstream, while queries could be tested, rerun, and corrected quickly. My confidence in my work increased not because I became more careful, but because SQL made accuracy and consistency easier to achieve.

The Bigger Lesson

If I'm honest, this isn't really an article about SQL. Not entirely.

It is about realizing that doing something the hard way is not a badge of honor, it simply means you have not yet discovered a better approach. For me, SQL was that turning point. For anyone doing repetitive, high-volume work, there is likely a more efficient tool, shortcut, or way of approaching the problem waiting to be discovered.

If you are still relying on manual filters and checking rows one by one to find errors, you are not slow or behind you simply have not found the more efficient approach yet. Once you discover it, you will not only work faster but also think more clearly, with less energy spent on repetitive tasks.

That's what SQL taught me. Not just how to write a query. How to keep asking, every time something feels unnecessarily hard: is there an easier way to do this?

There usually is a simpler, more efficient way to approach the problem.

From Local to Cloud: Lessons I Learned Connecting Power BI to SQL Databases

Josephine Mackylah — Tue, 14 Jul 2026 15:38:02 +0000

Introduction.

Data is only as valuable as the insights it provides. Before creating dashboards or writing DAX measures in Power BI, you must first establish a secure connection to your data source. In today's environments, that often means connecting to both on premises SQL Servers and cloud hosted databases, each with its own security requirements. This guide walks you through securely connecting Power BI Desktop to local and cloud SQL databases, including configuring SSL certificates for cloud connections.

Understanding Data Connectivity Modes.

Before building dashboards in Power BI, I learnt that the most important decisions is choosing how Power BI will connect and interact with my SQL database.
Power BI mainly provides two connectivity modes:

Import Mode loads a snapshot of your SQL data into Power BI’s memory. This delivers fast performance and allows you to take full advantage of Power BI’s data modeling and DAX capabilities. However, because the data is stored as a snapshot, regular refreshes are required to keep reports updated.
Direct Query keeps the data within the SQL database and sends live queries whenever users interact with a report. This is useful for very large datasets or situations requiring frequent updates. However, performance depends heavily on the capacity and speed of the underlying database.

Connecting Power BI to a Local SQL Database

When working with a local SQL database, the connection process is usually straightforward because the data environment is within your machine. Before connecting, ensure you have the SQL Server details, database access permissions, and the appropriate authentication credentials.

Gathering Your Database Connection Details

Before connecting Power BI to SQL database, collect the key connection details from the database management tool (such as SSMS or pgAdmin).

You will need:
Server Name: The location or address of your database server (for example, localhost, or an internal network address).
Database Name: The specific database containing the tables you want to analyze.
Authentication Method: The credentials required to access the database, such as Windows/Active Directory authentication or a database username and password.

Initializing the Database Connection

To begin connecting Power BI to a database, open Power BI Desktop and navigate to the Home tab.
Select Get Data, choose More to explore available data sources, then search for a database type (such as SQL Server or PostgreSQL).
Select the appropriate connector and click Connect to start the setup process.
In the database setup window, enter a Server pathway and a Database name.
Select Import and then Click OK.

Authenticate and Load Your Data

A credential prompt will appear. If a database utilizes corporate single sign-on, select Windows -> Use my current credentials. For dedicated SQL logins, select the Database tab and manually type a database user credentials.
Click Connect. If prompted with an unencrypted connection warning, click OK or Run (safe for internal testing environments).
The Navigator window will open. Check the boxes next to the tables you wish to pull, and click Load to commit them to a workspace.

Connecting Power BI to a Cloud SQL Database (Aiven)

Cloud databases such as Aiven PostgreSQL provide scalability and flexibility, but connecting to them requires additional security considerations. Since these databases are accessed over the internet, they rely on encrypted connections to protect data during transmission.
Power BI requires a trusted and secure connection before accessing cloud databases. This means a local machine must recognize and trust the cloud provider’s Certificate Authority (CA) to verify the database server’s identity and establish a secure connection.

Extract Connection Properties from Aiven

Step 1:

Download the CA Certificate, Look near the bottom of your image in the Connection information block. Locate the row labeled CA certificate.
Click the small Download icon (the arrow pointing down into a tray) located on the far-right side of that row.
Save the file to a secure folder on your computer (it will be downloaded as a file typically named ca.pem).

Download and Convert the SSL Certificate

Step 2:

Unhide and Copy the Database Credentials. You will also need the correct login credentials shown on this screen to fix the password error from your earlier.
Click the Eye icon next to the asterisks in the Password row to reveal your actual password. Copy it.
Note the User listed right above it is avnadmin (not postgres like you had earlier).Note the custom Port is 14306 (not 5432).

As a prerequisite, confirm that the PostgreSQL database is available by connecting to it through DBeaver before attempting to connect with Power BI.

Select the dataset you want to import. If your data has already been loaded into the PostgreSQL database, click Load to import the data into Power BI Desktop, and then proceed with data cleaning, data modeling, and dashboarding.

Use the troubleshooting below to identify common connection errors, understand their causes, and implement the appropriate solution.

1. Error Message / Symptom The remote certificate is invalid according to the validation procedure." Root Cause Analysis The Aiven SSL certificate was installed under the Current User certificate store, or it was not registered correctly with the system Corrective Action Re-run Phase 2, Step 2.3. Ensure you install the certificate under Local Machine and place it in the Trusted Root Certification Authorities store.

2.Error Message / Symptom Connection Timeout or "Unable to connect to the remote server" Root Cause Analysis A local or corporate firewall is blocking outbound network traffic on Aiven's assigned port. Corrective Action Contact your network administrator or IT department to whitelist the outbound traffic for your specific Aiven port, as cloud databases typically use non-standard ports.

3. Error Message / Symptom An error occurred while reading data from the provider: 'Invalid password Root Cause Analysis Incorrect login credentials or cached credentials stored in Power BI's credential manager. Corrective Action In Power BI Desktop, go to File →Options and settings → Data source settings. Select your database connection, click Clear Permissions, and reconnect using your correct cloud database credentials.

Final Thoughts and Key Takeaways

-It is easy to get frustrated when a connection gets blocked, but cloud environments like Aiven enforce strict SSL encryption for a reason to keep your data safe. Once you know how to navigate the handshake, it becomes a routine setup rather than a roadblock.

-Remember that Power BI doesn't validate certificates on its own it relies entirely on your local Windows operating system. If you take the extra ten seconds to correctly drop your certificate into the Local Machine's Trusted Root folder, Windows handles the trust automatically behind the scenes.

-The best part about this configuration is that it is a one-time task. Once that secure pipeline is locked in place, you can completely forget about ports and protocols and put 100% of your focus where it belongs: writing clean DAX and designing impactful dashboards.

The First Thing Power BI Taught Me Had Nothing to Do with Dashboards

Josephine Mackylah — Sun, 28 Jun 2026 22:22:11 +0000

When I decided to learn Power BI, I had one picture in my mind, beautiful dashboards.
I imagined creating interactive reports with colorful charts, KPIs, and slicers that would impress anyone who looked at them. Like many beginners, I thought the magic of Power BI started with visualization.
I couldn't have been more wrong.
The first thing Power BI taught me had nothing to do with dashboards.
It taught me that before you can tell a story with data, you must first clean the data.

My First Surprise

On my very first day, I expected to import data and immediately start building charts. I imagined dashboards coming together within minutes.
Instead, I found myself spending most of my time in Power Query, cleaning and preparing the data before I could do anything visual.
At first, I was confused. I kept asking myself: "Why am I spending so much time cleaning data? I thought Power BI was about building dashboards."
But when I looked more closely at the dataset, everything started to make sense.
I noticed something simple, yet very important.
Some names that were meant to represent the same person were written in different ways:

- Josephine
- josephine
- JOSEPHINE

To a person, these are clearly the same name.
But to Power BI, they are treated as three completely different values.

I also discovered several data quality issues that I hadn’t expected.
There were empty cells where important information was missing, and some text columns had things like errors, null and N/A, which I had to standardize by replacing them with consistent values such as Unknown, Not Provided, depending on the context and data type. For example, I used Unknown or Not Provided for text fields, and handled numeric fields differently by replacing error cells with null since Power BI recognizes null as a special value that represents missing or undefined datas to ensure they remained valid for calculations.

I also encountered duplicate records, which inflated totals and could easily lead to misleading results if not corrected.
Again, some dates 01/02/2026 were stored as text instead of proper date formats, making it impossible to perform time-based analysis until they were converted correctly and also IDs were treated as numbers when they should be text.

I found extra spaces and inconsistent formatting, which made identical values appear different and affected grouping and filtering. For example, "Uganda" vs "Uganda " You can say Some values looked identical but weren’t—hidden spaces made Power BI treat them as different entries.
I also realized that the dataset had incorrect data types, where text, numeric, and date fields were not properly assigned. This meant some columns that should have supported calculations were treated as plain text, while others that should have been categorical or date-based were misinterpreted, affecting accuracy and performance.

Then Came My Next Challenge: DAX

After spending time cleaning and preparing the data, I thought I was finally ready to build visuals.
But Power BI had another lesson waiting for me. This is where I met something called DAX (Data Analysis Expressions).
At first, it looked simple just formulas, right? I quickly realized it was not that simple.
DAX wasn’t just about writing calculations. It was about thinking in logic and asking the right questions of my data.

Instead of just “adding numbers,” I had to start thinking like an analyst:

- What is the total cost of production?
- What is the total profit value?
- What is the total revenue?
- What is the total planted area?

Suddenly, I wasn’t just clicking around Power BI anymore, I was reasoning with data.

My First DAX Moments

My first simple functions felt like a breakthrough:
SUM() to calculate totals
AVERAGE() to find mean values
COUNT() and DISTINCTCOUNT() to understand records
Even though they looked basic, they opened a new way of thinking.
I remember realizing something important:
Cleaning data prepares it.
DAX gives it meaning.

My First Encounter with Logical Functions in DAX

This is where Power BI started to feel less like a tool and more like a way of thinking.
Logical functions are what allow Power BI to make decisions based on conditions. Instead of just calculating values, I could now tell Power BI:

- “If this condition is true, do this…”
- “If not, do something else…”
The first logical function I used was IF().
It helped me answer simple questions like:
If a value is above 50, return “Pass”
Otherwise, return “Fail”
Result = IF([Score] >= 50, "Pass", "Fail")

Then things got more interesting with nestedIFs.
Instead of just two outcomes, I could handle multiple categories and also take care of the blanks:
Excellent Good Average Poor
Forexample;
Grade =IF([Score] >= 80, "Excellent",IF([Score] >= 60, "Good",IF([Score] >= 50, "Average", "Poor") At this point, I realized

Data analysis is often about classification, not just numbers.

One of the biggest challenges I faced was missing data.
That’s where ISBLANK() came in handy.
Example:
Revenue Category Nested IF =IF(ISBLANK('Kenya_Crops_Dataset'[Revenue (KES)]),"Not Provided",IF('Kenya_Crops_Dataset'[Revenue (KES)] > 500000,"High Revenue",IF('Kenya_Crops_Dataset'[Revenue (KES)] > 100000, "Medium Revenue",IF('Kenya_Crops_Dataset'[Revenue (KES)] > 0,"Low Revenue","Not Provided"))))
This helped me handle empty values instead of ignoring them.
I learned that missing data is still data you just need to label it properly.

Sometimes one condition was not enough. So I learned how to combine conditions: AND/OR Example:
High Revenue and Profitable =IF(AND('Kenya_Crops_Dataset'[Revenue (KES)] > 100000,'Kenya_Crops_Dataset'[Profit (KES)] > 0),"High Revenu Profitable Farm","Other Farm")

Maize or Rice = IF(OR('Kenya_Crops_Dataset'[Crop Type]"Maize",'Kenya_Crops_Dataset'[Crop Type] = "Rice"),"Priority Crop","Other Crop")
I realized something that Logical functions don’t just process data they simulate thinking and they made me think like an analyst, not just a tool user.

This is just the begining

As I look back at my first steps in Power BI, I realize something important.
I didn’t start by building dashboards. I started by cleaning messy data, fixing inconsistencies, and learning how to think logically about information.
Then came DAX where numbers stopped being just numbers and started becoming decisions. And finally, logical functions taught me that data is not just something you display, but something you interpret.
What I thought would be a journey about visuals turned out to be a journey about thinking.
And I am still at the beginning. Every dataset I touch now reminds me of one thing, before insights, there is understanding. Before understanding, there is preparation.
Power BI is not just teaching me how to analyze data it is teaching me how to see it differently.

How Excel is Used in Real-World Data Analysis.

Josephine Mackylah — Sun, 28 Jun 2026 19:12:51 +0000

Before dashboards light up with insights, before SQL queries pull records from databases, and before machine learning models make predictions, most data begins its journey in a spreadsheet. For decades, Microsoft Excel has been the tool that professionals rely on to collect, organize, clean, and analyze information. From tracking hospital records and managing business sales to monitoring project performance and preparing reports, Excel remains one of the most widely used tools in the world of data analysis.
As I began my journey in Data Science and Analytics, I quickly realized that Excel is far more than a simple spreadsheet application. It is often the first place where raw data is transformed into meaningful information. In this article, I explore how Excel is used in real-world data analysis and what I have learnt this week.

What is Excel?

Microsoft Excel is a spreadsheet application that organises data into rows and columns inside a grid called a worksheet. Each cell in that grid can hold text, numbers, dates, or crucially, formulas that compute values dynamically based on other cells.

Understanding Excel's Building Blocks

A workbook is the entire Excel file that contains one or more worksheets. Think of it as a digital binder used to store related data and analyses in a single file.
A worksheet, commonly called a sheet, is an individual page within a workbook where data is entered and managed. A workbook can contain multiple worksheets for organizing different sets of information.
A row is a horizontal line of cells identified by numbers (1, 2, 3, and so on). Rows are typically used to store individual records or observations.
A column is a vertical line of cells identified by letters (A, B, C, and so on). Columns are usually used to store specific categories or variables of data.
A cell is the intersection of a row and a column. It is the smallest unit in a worksheet and serves as the location where data is entered. Each cell has a unique reference, such as A1 or B5.
A range is a group of two or more cells selected together. Ranges are commonly used when performing calculations, formatting data, or applying formulas. For example, A1 represents a range containing multiple rows and columns.

A Critical Step in Analysis that i learnt is Data cleaning.

One of the most valuable lessons I learned during my first week with Excel is that the quality of an analysis depends heavily on the quality of the data being analyzed. Even the most advanced analytical techniques can produce misleading results if the underlying data is inaccurate or incomplete.

In real-world scenarios, datasets often contain duplicate records, missing values, inconsistent formatting, extra spaces, and incorrect entries. These issues can lead to errors in calculations, inaccurate reports, and poor decision-making.

Excel provides several tools that help address these challenges, including Remove Duplicates, text functions such as TRIM() and PROPER(), and data validation features that improve data accuracy and consistency. By cleaning and preparing data before analysis, analysts can ensure that their findings are reliable and meaningful.

Function Purpose Examples I learnt.

UPPER() Converts text to uppercase =UPPER("jose") → JOSE
LOWER() Converts text to lowercase =LOWER("JOSE") → jose
PROPER() Capitalizes first letter of each
word =PROPER("jose macky") → Jose Macky
TRIM() Removes extra spaces from
text =TRIM(" Jose Macky ") → Jose Macky
LEFT() Extracts leftmost characters =LEFT("Jose", 2) → Jo
RIGHT() Extracts rightmost characters =RIGHT("Jose", 2) → hn
MID() Extracts characters from the
middle =MID("Jose", 2, 2) → oh
LEN() Returns length of text =LEN("Jose") → 4
FIND() Finds position of a substring
(case-sensitive) =FIND("o", "Jose") → 3
SUBSTITUTE() Replaces text within a string
=SUBSTITUTE("Jose Macky", "Macky",
"Smith") → Jose Smith

I also learnt Why Excel Matters in Data Analysis

Data analysis is about turning raw data into meaningful insights that support better decision-making. However, before any patterns can be identified or trends discovered, data must first be collected, organized, and prepared. This is where Excel plays a crucial role.

Excel serves as the foundation for many data analysis workflows because it provides a simple yet powerful environment for managing data. It enables users to organize information into structured tables, perform calculations automatically, clean and validate datasets, and quickly sort or filter records to focus on relevant information. These capabilities allow analysts to transform raw data into accurate, reliable, and actionable insights.

Whether tracking sales performance, managing patient records, analyzing survey responses, or monitoring project indicators, Excel remains one of the most widely used tools for preparing data for analysis and informed decision-making.

Organizing Data for Better Insights

A key takeaway from my first week of learning Excel is that effective data analysis begins with proper data organization. Excel structures information into rows and columns, creating datasets that are easy to understand, manage, and analyze.
For example, a retail company might use Excel to record and organize sales transactions as shown below:

Product     Quantity Sold   Unit Price   Sales Date
Laptop             10           $500          01/06/2026
Mouse              25           $15        02/06/2026

With data organized in this format, it becomes much easier to calculate revenue, identify best selling products, track sales trends over time, and generate reports that support business decision-making. This demonstrates how Excel's structured layout transforms raw data into information that can be analyzed effectively.

Sorting and Filtering for Better Insights

As datasets grow larger, finding specific information manually becomes increasingly difficult and time consuming. This is where Excel's sorting and filtering features become valuable tools for data analysis.

Sorting allows users to arrange data in a meaningful order, such as ranking student scores from highest to lowest or organizing products by price. Filtering, on the other hand, enables users to display only the records that meet specific criteria while temporarily hiding the rest.

For example, a school administrator can sort examination scores to quickly identify top-performing students, while a sales manager can filter transactions to view sales from a particular region or month. These features make it easier to explore data, identify trends, and focus on relevant information without modifying the original dataset.

Using Formulas and Functions to Automate Analysis

One of Excel’s most powerful capabilities is its ability to automate calculations using formulas. Instead of relying on manual calculations or external tools, Excel allows users to build dynamic formulas that automatically update whenever the underlying data changes.

This makes it especially useful in real-world scenarios such as calculating monthly expenses, determining employee salaries, computing student performance averages, or estimating project costs. For example, a simple formula like:

=A1+B1
adds the values in two cells and instantly updates the result whenever either value changes. This dynamic behavior reduces manual effort and minimizes the risk of errors.

Beyond basic formulas, Excel also provides built-in functions that simplify and speed up data analysis.

Some of the most commonly used functions include:

SUM() – Adds a range of values
Example: =SUM(B2)
AVERAGE() – Calculates the mean of a dataset
Example: =AVERAGE(B2)
MAX() – Returns the highest value in a range
Example: =MAX(B2)
MIN() – Returns the lowest value in a range
Example: =MIN(B2)
COUNT() – Counts the number of numeric entries in a range
Example: =COUNT(B2)

These functions are widely used in data analysis to quickly summarize large datasets and uncover key trends. They help analysts move from raw numbers to meaningful insights in a matter of seconds.

Real-World Applications of Excel in Different Industries

In the business and sales sector, companies use Excel to track sales performance, monitor inventory levels, analyze customer trends, and prepare financial reports. These activities help organizations understand their performance and make informed decisions that improve efficiency and profitability.
In healthcare, Excel plays an important role in managing and analyzing data. Hospitals and health programs use it to track patient information, monitor disease trends, generate monthly reports, and support monitoring and evaluation activities. This helps health professionals maintain accurate records and improve service delivery.
In education, schools and academic institutions rely on Excel to record student performance, calculate grades, track attendance, and generate academic reports. This simplifies administrative work and ensures that student data is well-organized and easy to access.
In the agriculture sector, Excel is used to monitor crop yields, analyze farmer productivity, track training attendance, and manage project performance indicators. These insights help agricultural organizations improve planning and support farmers more effectively.
In monitoring and evaluation, Excel is a key tool for data management and reporting. It is used to clean survey datasets, calculate indicators, track project progress, and produce donor reports. This ensures that program data is accurate, consistent, and useful for decision making.

Personal Reflection.

Before learning Excel, I viewed data as something abstract—hidden inside systems and far removed from everyday understanding. After working with Excel, that perception changed. Data became something tangible, something I could explore, manipulate, and question directly.

As I began to use Excel more deeply, I realized that data is not just passive information sitting in a system. It is something that can be explored and interrogated. Even simple analyses, such as using a SUMIFS formula to answer a question like how many projects in Berlin, handled by employees above 30 years, were completed, helped me see data in a new light. It became clear that data carries patterns, tells stories, and can respond when the right questions are asked.

What also stood out to me was how much of data work is actually about preparation rather than analysis. Before this learning experience, I assumed data analysts spent most of their time discovering insights and producing visualizations. However, I have come to understand that a large part of the process involves cleaning and preparing data—removing duplicates, correcting inconsistencies, standardizing formats, and ensuring accuracy using tools like TRIM and SUBSTITUTE.

Another powerful feature that stood out to me in Excel is Conditional Formatting. This tool allows data to visually communicate its meaning by automatically highlighting values based on specific rules. For example, high-performing values can be marked in green, while low or concerning values can appear in red. This makes it much easier to quickly interpret patterns, detect outliers, and understand performance trends without going through every single value manually. It showed me how Excel is not just about calculations, but also about turning data into something visually meaningful and easier to interpret.

Conclusion

My first week of learning Excel has shown me that data analysis starts with strong data foundations. Before advanced tools and complex models come into play, it is Excel that provides the essential skills for organizing, cleaning, validating, and analyzing data.
Through this learning journey, I have gained practical skills in formatting, sorting, filtering, data validation, formulas, and functionstools that are widely used across industries every day. More importantly, I have learned that the quality of any analysis depends on how well the data is managed from the start.
Excel is not just a spreadsheet tool, it is the foundation of effective data analysis. As I continue my journey in Data Science and Analytics, I now understand how powerful Excel is in transforming raw data into meaningful insights that support better decision making.

Understanding Excel in Real-World Data Analysis: My First Week of Learning.

Josephine Mackylah — Sun, 07 Jun 2026 12:16:49 +0000

What is Excel?

Understanding Excel’s Structure

I have learnt that Excel is built on a simple but powerful structure that makes it easy to organize and analyze data effectively.

A workbook is the entire Excel file. It acts like a digital binder that can contain one or more worksheets, allowing users to store related datasets and analyses in a single place.

A worksheet, often called a sheet, is an individual page within a workbook where data is entered, organized, and analyzed. A single workbook can contain multiple worksheets, each used for different types of information.

Data in a worksheet is arranged in rows and columns. Rows are horizontal lines identified by numbers and are typically used to represent individual records or observations. Columns are vertical lines identified by letters and are used to store specific categories or variables.

A cell is the smallest unit in a worksheet, formed by the intersection of a row and a column. It is where data is entered, and each cell has a unique address such as A1 or B5. The Name Box in Excel displays this cell address, helping users quickly identify locations within a dataset.

A range refers to a selection of two or more cells, often used for calculations, formatting, or analysis. For example, A1 represents a range of cells spanning multiple rows within a single column, allowing users to perform operations on grouped data efficiently.

Different types of data in excel.

One of the important lessons I learned while working with Excel is that data comes in different types, and understanding these types is essential for proper analysis. Each type of data behaves differently and determines how it can be used in calculations, sorting, and reporting.

Text data, also known as labels, includes words, names, and categories. This type of data is mainly used for identification and description rather than calculations. Examples include product names such as Laptop or Mouse, employee names, or locations like Kampala or Berlin.
Numeric data represents values that can be used in mathematical operations. This includes numbers such as sales amounts, quantities, and prices. Because numeric data supports calculations, it is the foundation for formulas like sums, averages, and totals in Excel.
Date and time data represent specific points or periods in time. Examples include dates like 01/06/2026 or timestamps such as 10:30 AM. This type of data is particularly useful for analyzing trends over time, such as monthly sales performance or project timelines.
Currency data is a special type of numeric data used to represent money values. It is commonly used in business and financial analysis to track sales, expenses, profits, and budgets. For example, values like $500 or UGX 1,200,000 are treated as currency to ensure clarity and consistency in financial reporting.
Percentage data represents values out of 100 and is often used to show proportions, rates, or changes. Examples include discount rates, growth percentages, and performance indicators such as 15% increase in sales. This type of data is especially useful for comparing performance across categories.

Basic Arithmetic Operations in Excel.

One of the most interesting things I discovered in Excel is that behind every calculation is a simple set of operations that behave almost like building blocks of analysis. At first glance, they may look basic, but together they power almost every financial report, sales summary, and analytical insight.

It starts with addition, where Excel quietly does the work of bringing numbers together. Instead of manually calculating totals, a formula like =A1+B1 instantly combines values, whether it is daily sales, expenses, or quantities.
Then comes subtraction, which helps uncover differences. With something as simple as =A1-B1, Excel can show profit after expenses, remaining stock, or performance gaps—turning raw numbers into meaningful comparisons.
Multiplication takes things a step further. It allows Excel to scale values, such as calculating total cost by multiplying price and quantity using =A1*B1. This is where simple data begins to feel like real-world business analysis.
With division, Excel helps break things down into understandable units. A formula like =A1/B1 can show averages per item, cost per unit, or ratios that reveal deeper insights hidden within the data.
Finally, there is exponentiation, represented by the ^ symbol. Something like =A1^2 may seem simple, but it plays an important role in more advanced analysis such as growth trends, projections, and statistical calculations.

Excel Shortcuts That Make Work Feel Effortless.

Instead of manually copying and pasting data, a quick Ctrl + C followed by Ctrl + V feels like second nature once you get used to it. And when mistakes happen as they always do in data work Ctrl + Z becomes a lifesaver, allowing you to instantly undo an action and recover your work.

As datasets grow larger, navigation becomes important. That is where Ctrl + Arrow Keys comes in, allowing you to jump across thousands of rows or columns in seconds instead of scrolling endlessly.

When working with structured data, turning on filters is a common task. With just Ctrl + Shift + L, you can instantly activate filtering and start slicing through data to focus only on what matters.

Formatting also becomes much easier with Ctrl + 1, which opens the formatting menu where you can adjust number formats, alignment, and borders to make data clearer and more professional.

Ctrl + A, which allows you to instantly select all the data in a worksheet or a specific data range. Instead of manually dragging your mouse across rows and columns, this shortcut highlights everything with a single action.

A Critical Step in Analysis that I learnt is Data cleaning.

Function Purpose Examples I learnt.

UPPER() Converts text to uppercase =UPPER("jose") → JOSE
LOWER() Converts text to lowercase =LOWER("JOSE") → jose
PROPER() Capitalizes first letter of each
word =PROPER("jose macky") → Jose Macky
TRIM() Removes extra spaces from
text =TRIM(" Jose Macky ") → Jose Macky
LEFT() Extracts leftmost characters =LEFT("Jose", 2) → Jo
RIGHT() Extracts rightmost characters =RIGHT("Jose", 2) → hn
MID() Extracts characters from the
middle =MID("Jose", 2, 2) → oh
LEN() Returns length of text =LEN("Jose") → 4
FIND() Finds position of a substring
(case-sensitive) =FIND("o", "Jose") → 3
SUBSTITUTE() Replaces text within a string
=SUBSTITUTE("Jose Macky", "Macky",
"Smith") → Jose Smith

I also learnt Why Excel Matters in Data Analysis

Organizing Data for Better Insights

Product     Quantity Sold   Unit Price   Sales Date
Laptop             10           $500          01/06/2026
Mouse              25           $15        02/06/2026

Sorting and Filtering for Better Insights

Using Formulas and Functions to Automate Analysis

=A1+B1
adds the values in two cells and instantly updates the result whenever either value changes. This dynamic behavior reduces manual effort and minimizes the risk of errors.

Beyond basic formulas, Excel also provides built-in functions that simplify and speed up data analysis.

Some of the most commonly used functions include:

SUM() – Adds a range of values
Example: =SUM(B2)
AVERAGE() – Calculates the mean of a dataset
Example: =AVERAGE(B2)
MAX() – Returns the highest value in a range
Example: =MAX(B2)
MIN() – Returns the lowest value in a range
Example: =MIN(B2)
COUNT() – Counts the number of numeric entries in a range
Example: =COUNT(B2)
SUMIFS() – A function that adds values based on multiple conditions.
AVERAGEIFS() – A function that calculates the average of values based on multiple conditions.

These functions are widely used in data analysis to quickly summarize large datasets and uncover key trends. They help analysts move from raw numbers to meaningful insights in a matter of seconds.

Date and Time Functions in Excel

TODAY() → =TODAY() → returns: 07/06/2026 NOW() → =NOW() → returns: 07/06/2026 14:35 DATE() → =DATE(2026,6,7) → returns: 07/06/2026 TIME() → =TIME(14,30,0) → returns: 14:30:00 DAY() → =DAY("07/06/2026") → returns: 7 MONTH() → =MONTH("07/06/2026") → returns: 6 YEAR() → =YEAR("07/06/2026") → returns: 2026 HOUR() → =HOUR("14:45:00") → returns: 14 MINUTE() → =MINUTE("14:45:00") → returns: 45 SECOND() → =SECOND("14:45:30") → returns: 30 DAYS() → =DAYS("10/06/2026","01/06/2026") → returns: 9 NETWORKDAYS() → =NETWORKDAYS("01/06/2026","10/06/2026") → returns: 8 EDATE() → =EDATE("01/06/2026",2) → returns: 01/08/2026

Real-World Applications of Excel in Different Industries

In the business and sales sector, companies use Excel to track sales performance, monitor inventory levels, analyze customer trends, and prepare financial reports. These activities help organizations understand their performance and make informed decisions that improve efficiency and profitability.
In healthcare, Excel plays an important role in managing and analyzing data. Hospitals and health programs use it to track patient information, monitor disease trends, generate monthly reports, and support monitoring and evaluation activities. This helps health professionals maintain accurate records and improve service delivery.
In education, schools and academic institutions rely on Excel to record student performance, calculate grades, track attendance, and generate academic reports. This simplifies administrative work and ensures that student data is well-organized and easy to access.
In the agriculture sector, Excel is used to monitor crop yields, analyze farmer productivity, track training attendance, and manage project performance indicators. These insights help agricultural organizations improve planning and support farmers more effectively.
In monitoring and evaluation, Excel is a key tool for data management and reporting. It is used to clean survey datasets, calculate indicators, track project progress, and produce donor reports. This ensures that program data is accurate, consistent, and useful for decision making.

Personal Reflection.

Before learning Excel, I viewed data as something abstract hidden inside systems and far removed from everyday understanding. After working with Excel, that perception changed. Data became something tangible, something I could explore, manipulate, and question directly.

What also stood out to me was how much of data work is actually about preparation rather than analysis. Before this learning experience, I assumed data analysts spent most of their time discovering insights and producing visualizations. However, I have come to understand that a large part of the process involves cleaning and preparing data removing duplicates, correcting inconsistencies, standardizing formats, and ensuring accuracy using tools like TRIM and SUBSTITUTE.

And lastly, Data Validation in Excel is one of those features that controls what data can be entered into a cell to ensure accuracy and consistency. It helps prevent errors by setting rules such as allowing only numbers within a range, specific dates, or predefined list values. A common use is dropdown lists, which reduce typing mistakes and maintain uniform data entry, thus improving data quality by ensuring that only valid and reliable information is captured from the start.

Conclusion

Understanding Excel in Real-World Data Analysis: My First Week of Learning.

Josephine Mackylah — Sun, 07 Jun 2026 12:16:49 +0000

What is Excel?

Understanding Excel’s Structure

I have learnt that Excel is built on a simple but powerful structure that makes it easy to organize and analyze data effectively.

A workbook is the entire Excel file. It acts like a digital binder that can contain one or more worksheets, allowing users to store related datasets and analyses in a single place.

Different types of data in excel.

Text data, also known as labels, includes words, names, and categories. This type of data is mainly used for identification and description rather than calculations. Examples include product names such as Laptop or Mouse, employee names, or locations like Kampala or Berlin.
Numeric data represents values that can be used in mathematical operations. This includes numbers such as sales amounts, quantities, and prices. Because numeric data supports calculations, it is the foundation for formulas like sums, averages, and totals in Excel.
Date and time data represent specific points or periods in time. Examples include dates like 01/06/2026 or timestamps such as 10:30 AM. This type of data is particularly useful for analyzing trends over time, such as monthly sales performance or project timelines.
Currency data is a special type of numeric data used to represent money values. It is commonly used in business and financial analysis to track sales, expenses, profits, and budgets. For example, values like $500 or UGX 1,200,000 are treated as currency to ensure clarity and consistency in financial reporting.
Percentage data represents values out of 100 and is often used to show proportions, rates, or changes. Examples include discount rates, growth percentages, and performance indicators such as 15% increase in sales. This type of data is especially useful for comparing performance across categories.

Basic Arithmetic Operations in Excel.

It starts with addition, where Excel quietly does the work of bringing numbers together. Instead of manually calculating totals, a formula like =A1+B1 instantly combines values, whether it is daily sales, expenses, or quantities.
Then comes subtraction, which helps uncover differences. With something as simple as =A1-B1, Excel can show profit after expenses, remaining stock, or performance gaps—turning raw numbers into meaningful comparisons.
Multiplication takes things a step further. It allows Excel to scale values, such as calculating total cost by multiplying price and quantity using =A1*B1. This is where simple data begins to feel like real-world business analysis.
With division, Excel helps break things down into understandable units. A formula like =A1/B1 can show averages per item, cost per unit, or ratios that reveal deeper insights hidden within the data.
Finally, there is exponentiation, represented by the ^ symbol. Something like =A1^2 may seem simple, but it plays an important role in more advanced analysis such as growth trends, projections, and statistical calculations.

Excel Shortcuts That Make Work Feel Effortless.

As datasets grow larger, navigation becomes important. That is where Ctrl + Arrow Keys comes in, allowing you to jump across thousands of rows or columns in seconds instead of scrolling endlessly.

Formatting also becomes much easier with Ctrl + 1, which opens the formatting menu where you can adjust number formats, alignment, and borders to make data clearer and more professional.

A Critical Step in Analysis that I learnt is Data cleaning.

Function Purpose Examples I learnt.

UPPER() Converts text to uppercase =UPPER("jose") → JOSE
LOWER() Converts text to lowercase =LOWER("JOSE") → jose
PROPER() Capitalizes first letter of each
word =PROPER("jose macky") → Jose Macky
TRIM() Removes extra spaces from
text =TRIM(" Jose Macky ") → Jose Macky
LEFT() Extracts leftmost characters =LEFT("Jose", 2) → Jo
RIGHT() Extracts rightmost characters =RIGHT("Jose", 2) → hn
MID() Extracts characters from the
middle =MID("Jose", 2, 2) → oh
LEN() Returns length of text =LEN("Jose") → 4
FIND() Finds position of a substring
(case-sensitive) =FIND("o", "Jose") → 3
SUBSTITUTE() Replaces text within a string
=SUBSTITUTE("Jose Macky", "Macky",
"Smith") → Jose Smith

I also learnt Why Excel Matters in Data Analysis

Organizing Data for Better Insights

Product     Quantity Sold   Unit Price   Sales Date
Laptop             10           $500          01/06/2026
Mouse              25           $15        02/06/2026

Sorting and Filtering for Better Insights

Using Formulas and Functions to Automate Analysis

=A1+B1
adds the values in two cells and instantly updates the result whenever either value changes. This dynamic behavior reduces manual effort and minimizes the risk of errors.

Beyond basic formulas, Excel also provides built-in functions that simplify and speed up data analysis.

Some of the most commonly used functions include:

SUM() – Adds a range of values
Example: =SUM(B2)
AVERAGE() – Calculates the mean of a dataset
Example: =AVERAGE(B2)
MAX() – Returns the highest value in a range
Example: =MAX(B2)
MIN() – Returns the lowest value in a range
Example: =MIN(B2)
COUNT() – Counts the number of numeric entries in a range
Example: =COUNT(B2)
SUMIFS() – A function that adds values based on multiple conditions.
AVERAGEIFS() – A function that calculates the average of values based on multiple conditions.

These functions are widely used in data analysis to quickly summarize large datasets and uncover key trends. They help analysts move from raw numbers to meaningful insights in a matter of seconds.

Date and Time Functions in Excel

Real-World Applications of Excel in Different Industries

In the business and sales sector, companies use Excel to track sales performance, monitor inventory levels, analyze customer trends, and prepare financial reports. These activities help organizations understand their performance and make informed decisions that improve efficiency and profitability.
In healthcare, Excel plays an important role in managing and analyzing data. Hospitals and health programs use it to track patient information, monitor disease trends, generate monthly reports, and support monitoring and evaluation activities. This helps health professionals maintain accurate records and improve service delivery.
In education, schools and academic institutions rely on Excel to record student performance, calculate grades, track attendance, and generate academic reports. This simplifies administrative work and ensures that student data is well-organized and easy to access.
In the agriculture sector, Excel is used to monitor crop yields, analyze farmer productivity, track training attendance, and manage project performance indicators. These insights help agricultural organizations improve planning and support farmers more effectively.
In monitoring and evaluation, Excel is a key tool for data management and reporting. It is used to clean survey datasets, calculate indicators, track project progress, and produce donor reports. This ensures that program data is accurate, consistent, and useful for decision making.

Personal Reflection.

What also stood out to me was how much of data work is actually about preparation rather than analysis. Before this learning experience, I assumed data analysts spent most of their time discovering insights and producing visualizations. However, I have come to understand that a large part of the process involves cleaning and preparing data removing duplicates, correcting inconsistencies, standardizing formats, and ensuring accuracy using tools like TRIM and SUBSTITUTE.

DEV Community: Josephine Mackylah

Just These 10 Python Concepts Will Get You Started

Introduction

What Is Python?

Variables: Giving Your Data a Name

Data Types: Python Needs to Know What Kind of Value It's Holding

print(): Making Python Talk Back to You

input(): Letting a Human Talk Back to Python

F-Strings: The Cleanest Way to Combine Text and Data

Conditional Statements: Teaching Python to Make Decisions

Loops: Doing Something Once, Then Doing It Again and Again

Lists: Python's Way of Holding More Than One Thing

Functions: Package Your Logic So You Never Rewrite It

The Modulus Operator: The Most Underrated Symbol in Python

Putting It All Together: A Simple Ticket Receipt

SQL Taught Me That There Is Always an Easier Way to Do Things

The Manual Times

The Moment SQL Stopped Being Intimidating

Let Me Show You What I Mean

What It Actually Changed

The Bigger Lesson

From Local to Cloud: Lessons I Learned Connecting Power BI to SQL Databases

Introduction.

Understanding Data Connectivity Modes.

Connecting Power BI to a Local SQL Database

Gathering Your Database Connection Details

Initializing the Database Connection

Authenticate and Load Your Data

Connecting Power BI to a Cloud SQL Database (Aiven)

Extract Connection Properties from Aiven

Download and Convert the SSL Certificate

Use the troubleshooting below to identify common connection errors, understand their causes, and implement the appropriate solution.

Final Thoughts and Key Takeaways

The First Thing Power BI Taught Me Had Nothing to Do with Dashboards

My First Surprise

Then Came My Next Challenge: DAX

My First DAX Moments

My First Encounter with Logical Functions in DAX

This is just the begining

How Excel is Used in Real-World Data Analysis.

What is Excel?

Understanding Excel's Building Blocks

A Critical Step in Analysis that i learnt is Data cleaning.

Function Purpose Examples I learnt.

I also learnt Why Excel Matters in Data Analysis

Organizing Data for Better Insights

Sorting and Filtering for Better Insights

Real-World Applications of Excel in Different Industries

Personal Reflection.

Conclusion

Understanding Excel in Real-World Data Analysis: My First Week of Learning.

What is Excel?

Understanding Excel’s Structure

Different types of data in excel.

Basic Arithmetic Operations in Excel.

Excel Shortcuts That Make Work Feel Effortless.

A Critical Step in Analysis that I learnt is Data cleaning.

Function Purpose Examples I learnt.

I also learnt Why Excel Matters in Data Analysis

Organizing Data for Better Insights

Sorting and Filtering for Better Insights

Using Formulas and Functions to Automate Analysis

Date and Time Functions in Excel

Real-World Applications of Excel in Different Industries

Personal Reflection.

Conclusion

Understanding Excel in Real-World Data Analysis: My First Week of Learning.

What is Excel?

Understanding Excel’s Structure

Different types of data in excel.

Basic Arithmetic Operations in Excel.

Excel Shortcuts That Make Work Feel Effortless.

A Critical Step in Analysis that I learnt is Data cleaning.

Function Purpose Examples I learnt.

I also learnt Why Excel Matters in Data Analysis

Organizing Data for Better Insights

Sorting and Filtering for Better Insights

Using Formulas and Functions to Automate Analysis

Date and Time Functions in Excel

Real-World Applications of Excel in Different Industries

`print()`: Making Python Talk Back to You

`input()`: Letting a Human Talk Back to Python