DEV Community: Joseous Ng'ash

Python and How Python Is Used In The Data Analytics Space. A Beginner's Guide.

Joseous Ng'ash — Fri, 15 May 2026 02:05:22 +0000

Introduction

In today's digital world, data is everywhere, every time people stream movies, socialize on social media, shop online, or make online payments amongst others, data is generated. Institutions collect this type of data to be able to analyze and understands customer behavior to be able to improve services, make better decisions and come up with future predictions depending on the trend.

The collected data is raw and has little value unless it is processed and analyzed. This brings about Data Analytics which involves collecting, cleaning, transforming and interpreting data to uncover useful insights.

To be able to perform data analytics processes, the analysts rely on programming tools and one of the most used programming language in data analytics is Python. It has become a favorite among beginners and professionals because it is simple to learn, powerful and supported by rich ecosystem of libraries designed for data analysis.

This article will cover what is python, why it is widely used in data analytics, the key libraries every beginner should learn, how it helps in cleaning and analyzing data and why python is the best choice for professions in data analytics.

What Is Python
Python is a programming language created by Guido Van Rossum and was first released in 1991.

Unlike some programming languages that require complex syntax, python uses clean and straightforward commands that resemble plain English.

Example of python command

print("Hello, World!")

The simple command line displays text on the screen.

Python is known for:

Large Community support
Versatility
Simplicity

Why Python Is Popular in Data Analytics
Python has become one of mostly used tools in data analytics for several reasons.

Easy to Learn and Use
Data analysis involves solving business and technical problems. Analyst should focus on understanding data rather than struggling with difficult programming syntax.

Python's simple structure allows beginners to write meaningful programs easily.

Example:
Calculating average using python

nums = [10, 20, 30, 40]
avg = sum(nums) / len(nums)
print(avg)

The simple structure of python makes it ideal for people transitioning into analytics.

Libraries Ecosystem
Python provides specialized libraries that simplify data-related task.

Strong Data Handling Capabilities

Python can process:

Unstructured data (text, images)
Semi_structured data (JSON,XML)
Structured data (tables, spreadsheets)

This flexibility makes it useful across many industries.

Integration with Other Tools

Python works well with:

Jupyter Notebook
MS Excel
MS Power BI
MySQL
PostgreSQL

This allows analyst to build complete workflows

High Industry Demand
Many companies actively seek python skilled analysts because it helps automate repetitive tasks and process large dataset efficiently.

Industries using python includes:

Finance
E-commerce
Healthcare
Marketing
Education
Telecommunications

Python Libraries Used in Data Analytics.

One of python's greatest strength is its libraries

A library is a collection of pre-written code that performs specific tasks. Some of most important libraries for beginners include:

Pandas
Pandas is the most widely used library for data manipulation and analysis.
It helps analysts:

Read dataset
Clean data
filter rows
Handle missing values
Group and summarize data

Example:

import pandas as pd

data = pd.read_csv("sales.csv")
print(data.head())

This loads a CSV file and displays the first five rows.
Pandas is essential for any data analyst.

NumPy
NumPy is used for numerical operations.
It is useful for:

Mathematical calculations
Working with arrays
Statistical analysis

Example:

import numpy as np

nums = np.array([10, 20, 30])
print(np.mean(nums))

Matplotlib
This library is used for creating graphs and charts.

Example:

import matplotlib.pyplot as plt

plt.plot([1,2,3],[4,5,6])
plt.show()

It helps analysts visualize trends

Seaborn
Seaborn build on Matplotlib and creates more attractive visualizations
It is commonly used for:

Heatmaps
Bar charts
Distribution

Scikit_learn
Although mainly used in machine learning, beginners can use it for predictive analytics.
It support:

Regression
Classification
Clustering

Jupyter Notebook
Jupyter notebook allows analysts to write code, visualize results and document analysis in one place.
It is widely used for learning and experimentation.

How Python Is Used to Clean, Analyze and Visualize Data.

Data Cleaning
Raw data is usually messy, common problems include:

Missing values
Duplicates records
Incorrect formats
Typographical errors

Python helps to clean such problems in data efficeintly.

Example:

import pandas as pd

data = pd.read_csv("customers.csv")

data.drop_duplicates(inplace=True)
data.fillna(0, inplace=True)

This script removes duplicates and fills missing values.
Cleaning data is important because poor-quality data leads to inaccurate analysis.

Data Analysis
After cleaning the dataset, analysts explore the data to identify patterns

Python can calculate:

Averages
Totals
Trends
Correlations

Example:

sales.groupby("Region")["Revenue"].sum()

This script calculates total revenue by region.
Analysts use such insights to answer business questions.

For Example:

Which product sells the most
Which customer segment is most profitable
Which month generates highest or lowest revenue

Data Visualization
Visualizations makes insights easier to understanda.
Instead of reading large tables, decision-makers can quickly interpret charts.

Example:

import seaborn as sns

sns.barplot(x="Region", y="Revenue", data=sales)

This creates a bar chart showing regional revenue.

Python supports:

Line charts
Pie charts
Scatter plots
Histograms
Heatmaps Visualization is critical because it helps communicate findings clearly

Real-World Examples of Python in Data Analytics

Python is widely used in real-world organizations.

E-Commerce
Online stores analyze customer purchase behaviour

Python helps answer:

Which product sells most
Which products are often bought together
Which customer are likely to return Companies like Alibaba use data analytics extensively.

Finance
Banks and financial institutions use python for:

Customer segmentation
Risk analysis
Fraud detection By analyzing transaction patterns, suspicious activity can be detected quickly.

Healthcare
Hospitals use python to analyze:

Patient records
Disease trends
Treatment outcomes This improves decision-making and patient care

Marketing
Business analyst analyze business performance using python.

Questions include:

Which audience engages most?
Which advertisements perform best?
What is the conversion rate?

Sports Analytics
Sports teams analyze players or club performance and match statistics. Python helps identify strengths and weaknesses. This helps improve team strategies.

Why Beginners Should Learn Python.

If you are new to data analytics, python is one of the best starting points.

Beginner-Friendly
Its syntax is simple and readable.
You can start solving real problems quickly.

Strong Career Opportunities
Python is highly valued in roles such as:

Data Analyst
Data Scientist
Business Analyst
Machine Learning Engineer Learning python increases employability.

Supports Career Growth
Once you master Python for analytics, you can expand into:

Machine Learning
Artificial intelligence
Data Engineering
Automation Python opens many career paths.

Practical and In-Demand
Python is not just theoretical.
You can immediately apply it to real datasets and projects.
This makes learning more engaging and rewarding.

Conclusion

In modern data analytics, python has become one of most important tools.

With python, analyst can:

Clean messy datasets
Analyze trends and patterns
Create meaningful visualizations
Generate actionable business insights

Python powers real world data driven decisions across industries such as E-commerce, Finance, Healthcare and sports.

Learning python as a beginner in data analytics profession provides a strong technical foundation and opens doors to exciting career opportunities in the growing field of data.

As data continues to shape the future, python remains one of the tools to help analysts transform raw information into valuable knowledge.

Understanding SQL Joins and SQL Functions, CTEs and Subqueries.

Joseous Ng'ash — Tue, 05 May 2026 23:29:35 +0000

As my journey in becoming a competent data analytics, my SQL knowledge continues to deepen and as a result, I also publish few things pick up through the process.
couple of weeks back I published about SQL fundamentals, covering that is DDL, DML and Data Manipulation. Read more about SQL fundamentals from this link Click here to visit dev.to.

Building on SQL skills and data analysis, I have come to know you can work on different tables at the same time through the help of SQL joins and SQL Functions.

What is Join?

A JOIN in SQL is used to link or combine rows from two or more tables based on related column between them and it is usually a Primary Key and Foreign Key.
Think of it like, one table has students and another has scores, JOIN will help you see which student took which course.

Types of Joins

LEFT JOIN (LEFT OUTER JOIN) This type of returns all records from Left table and matching records from the right table

Example:

SELECT s.name, c.course_name
FROM students s
LEFT JOIN courses c
ON s.course_id = c.id;

All students appear, even if they are not assigned a course.

INNER JOIN
This type of JOIN returns only matching records from both tables.

Example:

SELECT s.name, c.course_name
FROM students s
INNER JOIN courses c
ON s.course_id = c.id;

RIGHT JOIN (RIGHT OUTER JOIN)
The JOIN returns all records from the right table and matching ones from the left.

Example

SELECT s.name, c.course_name
FROM students s
RIGHT JOIN courses c
ON s.course_id = c.id;

All courses appear, even if no student is enrolled.

FULL JOIN(FULL OUTER JOIN)
This type of JOIN returns all records when there is a match in either table.

Example:

SELECT s.name, c.course_name
FROM students s
FULL JOIN courses c
ON s.course_id = c.id;

JOINs are about relationships between tables
Without JOINs, databases would be much less powerful

SQL Window Functions

What are Window Functions?
Window functions are used to calculate across rows without collapsing them.

Example:

SELECT name, department, salary,
       AVG(salary) OVER (PARTITION BY department) AS avg_salary
FROM employees;

The output from this query, every employee still appears, which also includes department average.

SQL functions Every Beginner Should Know

COUNT():

The function counts rows present in a given table.

Example:

SELECT COUNT(*) FROM students;

Counts total number of students

SUM():

This function is used to add numeric values.

Example:

SELECT SUM(salary) FROM employees;

This will get the total salary.

AVERAGE():

The function is used to get Average values like school exam result performance.

Example:

SELECT AVG(marks) FROM exams;

The output will give the average marks.

UPPER()/LOWER():

The function is used to get or change text case,
UPPER() is used to change text into upper case while
LOWER() is used to change text into lower case.

Example:

SELECT 
   UPPER(first_name),
   LOWER(last_name) 
FROM students;

The student's first name will be in upper case and second name will be in lower case.

NOW()/CURRENT_DATE():
This function is used to get current date or time. It is useful when filtering recent records.

Example:

SELECT CURRENT_DATE;

In SQL functions are many, the highlighted functions are most common and every beginner should know and understand how they work in order to ease the work as data analysts, data engineer or scientist.

SQL Subqueries

What is Subquery in SQL:
A Subquery is a query written inside another SQL Query, It executes first and its result is used by the outer query.

Example:

SELECT name, salary
FROM employees
WHERE salary > (
    SELECT AVG(salary)
    FROM employees
);

The inner query calculates average salary and the outer query compares the employee's salary against average

Types of Subquery
We have different types of subqueries, they include;

Scalar Subquery: It is used to return single value.

Example:

SELECT *
FROM products
WHERE price > (
    SELECT AVG(price)
    FROM products
);

Multiple-row Subquery: This subquery returns multiple rows as its name suggests.

Example:

SELECT name
FROM employees
WHERE department_id IN (
    SELECT id
    FROM departments
);

Correlated Subquery: This query references one or more columns from the outer(main) query, it depends on the outer query.

Example:

SELECT e1.name, e1.salary
FROM employees e1
WHERE salary > (
    SELECT AVG(e2.salary)
    FROM employees e2
    WHERE e1.department = e2.department
);

The query compares each employee to the average salary in their department.

Common Table Expression (CTE)

What is CTE?
A CTE (Common Table expression) is a temporary named result set created using the With clause.
CTE makes query easier to organize and read.

Example: same query using a CTE

WITH avg_salary AS (
    SELECT AVG(salary) AS avg_sal
    FROM employees
)

SELECT name, salary
FROM employees
WHERE salary > (
    SELECT avg_sal
    FROM avg_salary
);

Reasons for using CTEs

The need for better readability
Simply complex queries
The need for organized structure
If you need to reuse intermediate results

CTE with Multiple Steps
One advantage of CTEs is chaining logic

Example: Monthly sales analysis

WITH monthly_sales AS (
    SELECT
        DATE_TRUNC('month', sale_date) AS month,
        SUM(amount) AS revenue
    FROM sales
    GROUP BY month
),

ranked_sales AS (
    SELECT *,
           RANK() OVER (ORDER BY revenue DESC) AS sales_rank
    FROM monthly_sales
)

SELECT *
FROM ranked_sales;

This will calculate monthly revenue, rank months by revenue and return final results.

SQL Learning Roadmap for a Beginner

SQL Fundamentals

JOINs
Group BY
Window Functions
SQL Functions
Subqueries
CTEs

These will be core concepts needed for:

Preparing for SQL technical interview
Writing quality SQL scripts
Dashboard preparation for tools like Ms Power BI
Data analysis

Conclusion

Since now as a data scientist, data manipulation and analysis is easier now that I have learnt and understood SQL Functions, Window Function and also Joins.

Also the use of CTEs and Subquery makes SQL query to be easier to read and organization.
Note: If a subquery starts to become difficult to read, convert it into a CTE

Understanding SQL Fundamentals: DDL, DML, and Data Manipulation.

Joseous Ng'ash — Mon, 13 Apr 2026 11:27:48 +0000

What is SQL(Structured Query Language):

Structured Query Language (SQL) is a powerful tool used to manage and manipulate data in relational databases.

SQL commands are categorized into different groups, two of the most important being DDL and DML.

What is DDL (Data Definition Language)

This refers to commands used to define and manage the structure of a database. These commands include creating, modifying, or deleting database objects such as tables.

Examples of DDL Commands:

CREATE – used to create new tables and databases
ALTER – used to modify existing database structures
DROP – used to delete tables or databases

What is DML (Data Manipulation Language)

This refers to commands that deal with managing data within those structures. It allows users to insert, update, retrieve, and delete records.
Examples of DML Commands:

INSERT – adds new records to a table
UPDATE – modifies existing data
DELETE – removes records from a table
SELECT – retrieves data

How I Used CREATE, INSERT, UPDATE, and DELETE

In the assignment, I applied several SQL commands to interact with the database.

CREATE

I used the CREATE statement to define tables such as students, subjects, and exam_results. This involved specifying column names, data types, and constraints like primary keys.

CREATE TABLE exam_results (
    result_id INT PRIMARY KEY,
    student_id INT,
    subject_id INT,
    marks INT,
    exam_date DATE,
    grade VARCHAR(2)
);

INSERT

I used the INSERT command to add records into the tables. For example, I inserted student details such as names, city, class, gender, and date of birth into the students table.

insert into students(student_id, first_name, last_name, gender,
date_of_birth, class, city)
values 
(1, 'Amina', 'Wanjiku', 'F', '2008-03-12', 'Form 3', 'Nairobi'),
(2, 'Brian', 'Ochieng', 'M', '2007-07-25', 'Form 4', 'Mombasa'),
(3, 'Cynthia', 'Mutua', 'F', '2008-11-05', 'Form 3', 'Kisumu'),
(4, 'David', 'Kamau', 'M', '2007-02-18', 'Form 4', 'Nairobi'),
(5, 'Esther', 'Akinyi', 'F', '2009-06-30', 'Form 2', 'Nakuru'),
(6, 'Felix', 'Otieno', 'M', '2009-09-14', 'Form 2', 'Eldoret'),
(7, 'Grace', 'Mwangi', 'F', '2008-01-22', 'Form 3', 'Nairobi'),
(8, 'Hassan', 'Abdi', 'M', '2007-04-09', 'Form 4', 'Mombasa'),
(9, 'Ivy', 'Chebet', 'F', '2009-12-01', 'Form 2', 'Nakuru'),
(10, 'James', 'Kariuki', 'M', '2008-08-17', 'Form 3', 'Nairobi');

UPDATE

I used UPDATE to modify existing records. For example, updating student_id = 5 city from Nakuru to Nairobi.

UPDATE students
SET city = 'Nairobi'
WHERE student_id = 5;

DELETE

The DELETE statement was used to remove result_id = 9, which was cancelled, ensuring data accuracy and consistency.

DELETE FROM exam_results
WHERE result_id = 9;

These commands helped simulate real-world database operations, where data is constantly being created, updated, and maintained.

Using WHERE to Filter Data

The WHERE clause is used to filter records based on specific conditions. It ensures that queries return only relevant data instead of the entire dataset.

Some Commonly Used Operators Include:

= (equals): used to match exact values Example:

DELETE FROM exam_results
WHERE result_id = 9;

sql

> (greater than): used for numeric comparisons Example:

SELECT *
FROM exam_results
WHERE marks > 70;

BETWEEN: used to filter values within a range Example:

SELECT *
FROM exam_results
WHERE exam_date BETWEEN '2024-03-15' AND '2024-03-18';

IN: used to match multiple values Example:

SELECT *
FROM students
WHERE city IN ('Nairobi', 'Mombasa', 'Kisumu');

LIKE: used for pattern matching Example:

SELECT *
FROM students
WHERE first_name LIKE 'A%' OR first_name LIKE 'E%';

Using the WHERE clause makes queries more efficient and meaningful by narrowing down results.

Using CASE WHEN to Transform Data

The CASE WHEN statement is used to apply conditional logic within SQL queries. It allows transformation of data into more meaningful categories.

For example, I used CASE WHEN to categorize students' grades:

Question:

Write a query using CASE WHEN to label each exam result with a grade description:

'Distinction' if marks >= 80
'Merit' if marks >= 60
'Pass' if marks >= 40
'Fail' if marks below 40

SELECT *,
CASE
    WHEN marks >= 80 THEN 'Distinction'
    WHEN marks >= 60 THEN 'Merit'
    WHEN marks >= 40 THEN 'Pass'
    ELSE 'Fail'
END AS performance
FROM exam_results;

This approach helps in creating readable insights from raw data, making it easier to analyze and present findings.

Reflection

Learning SQL has been both challenging and rewarding.

One of the main challenges was understanding how different SQL commands interact, especially when updating or filtering data. Small syntax errors, such as missing quotes or incorrect data types, often led to errors.

However, I found it very interesting how SQL allows you to manipulate and transform data efficiently. The CASE WHEN clause, in particular, stood out as a powerful tool for turning raw data into meaningful insights. Additionally, learning how to filter data using different operators improved my ability to write more precise and clear queries.

In the end, this experience strengthened my understanding of database operations and improved my confidence in using SQL for data analysis.

A comprehensive guide to Publishing And Embedding Power BI Reports on Website with iFrames.

Joseous Ng'ash — Mon, 06 Apr 2026 17:11:50 +0000

What exactly is Microsoft Power BI?

In simple and understandable terms, it refers to business analytic tool by Microsoft that helps you visualize data, create reports and share insights.

Key components

Power BI Desktop – Build reports on your computer.
Power BI Mobile – View reports on phones/tablets.
Power BI Service – Cloud platform for sharing and collaboration.

Why Use Power BI?

It provides real time analytics
It is easy to share and embed
It can connect to multiple data sources
Drag and Drop dashboards

Power BI Publishing

Power BI publishing means moving your report from Power BI Desktop to Power BI Service(cloud) so others on the same team can access it.

Power BI Report Publishing Overview

Highlight Of Steps Involved In Power BI Report Publishing

Create report in Power BI Desktop
Save your report
Click publish on Power BI desktop
Sign in to publish
Choose workspace
Upload to Power BI Service
Access via browser

Detailed Power BI Publishing steps

STEP ONE

Create Report In Power BI Desktop
To create Power BI reports, you have to import data, clean and transform the data then build visuals.
Importing Data; Data can be imported from different sources, eg excel as flat file or excel workbook, different database, SQL server.
One way to import data, open Power BI desktop and it will open to home page where you have different options to select from to get data.
Home Panel with different data sources

Another way to import data to create Power BI reports, click on Get Data on the far left on navigation panel/home panel and click on your preferred data source or depending on where the data you are working with is saved.

Get Data Option to import data to power BI desktop

After selecting your preferred data source, click connect located on the bottom right of Get Data navigation panel and wait for the data to be connected from source then click the connected table to select and preview the data.
In this demo I used an Excel Workbook as my data source.

What to expect after connecting to your preferred data source, my table is called Sheet1 containing detailed imported data

Data Cleaning And Transformation(Power Query)
Raw data is often messy -- Missing Values, Inconsistent format, Duplicates. This process of data cleaning and transforming ensures the report is accurate and reliable. In simple terms data cleaning and transforming in Microsoft power BI is the process of preparing raw data so it becomes accurate, consistent, and ready for analysis.

Data Cleaning Involves

Removing Duplicates: This ensures each record is unique and avoid double counting during analysis. To start data cleaning, on the navigator on the bottom right click on Transform option which will take you direct to Power Query What is Power Query: It is a tool used to connect, clean, transform, and load data into Power BI for analysis.

Transform Option On Navigator

Power Query Interface

Main sections in Power Query
1️⃣ Ribbon(Top Menu): It gives access to all transformation tools and commands, key tabs includes;

Home → load data, close and apply
Transform → Change data types, pivot/unpivot
View → Toggle panels (like formula bar)
Add Column → Create calculated columns

2️⃣ Queries Pane (Left Side): it contains a list of all tables which help in navigating between different datasets and organize queries(rename, group or duplicates)

3️⃣ Data Preview (Center Table View): it serve the purpose of viewing and interacting with your dataset and applying transformation directly on columns.

4️⃣ Applied Steps Pane (Right Side): it shows all applied steps during data cleaning and transformation like removed columns, filter row or change type.

5️⃣ Query Settings Panel (Right Side – Top): it is located on top of applied steps, which is used to rename query and add description.

6️⃣ Formula Bar: it is used to display formulas and uses M Language

7️⃣ Column Headers: this is the top row of every column which offers quick transformation through dropdown menus.

Handling Missing Data: This helps in replacing missing values with Nulls, Not Provided, Missing, N/A or remove incomplete rows.
Fixing Data Types: Convert columns into correct formats eg number to text or text to date.
Select on the column you want to change data type and right click then select Change type and select to the type you want to change your data into(decimal, data, text, number amongst others) as part of data cleaning.

Renaming Columns: make a column make sense or meanifull.

Data Transformation
This involves reshaping data for analysis and visualization. The process involves different tasks which includes:

Data filtering
Creating new columns
Grouping and aggregating
Pivoting and unpivoting
Splitting and merging columns
Data sorting

After the data is imported, cleaned and transformed. The data is ready to be used to Build Visual.
Reports visuals are prepared in Power BI. To make sure the cleaned data is loaded to Power BI, in the Power Query to save changes, click on Home Tab and then click Close and Apply button to save data and load to Power BI directly

Close and Apply Button In Power Query Editor

After Power Query is closed and changes saved, the data is loaded to Power BI to build visual reports.

Report View In Power BI Home Page

It displays table contain our data, panel where visuals appear, filter panel, visualization panel with different charts, a ribbon for different commands and functionality.

Building Visuals In Power BI
After closing Power Query and the cleaned and transformed data is loaded to Power BI, the next step is to use DAX (Data Analysis Expressions) to create necessary measure to help in data analysis.

What Is DAX (Data Analysis Expressions): is a formula language used in Power BI and Analysis Services to perform data calculations and analysis.
Example Of DAX

Profit margin = DIVIDE(SUM(Electronics_sales[Profit]), SUM(Electronics_sales[SalesAmount])) * 100

After we have done the necessary calculations, the next step is choosing the right charts to represent the analysis visually.
Some of the available charts in Power BI include;

Bar Charts
Column charts
Pie charts
Line charts

Charts panel in Power BI

After creating required KPIs and visualizing the report, the next step is publishing to Power BI service.

Complete Power BI Report Looks like demonstrated below.

STEP TWO

Saving Power BI Report(.pbix format)
After you have completed the Power BI Report, the next step is saving the report in the appropriate format.
Always save your Power BI report with extension **.pbix format.
Power BI file save in local machine

STEP THREE

Click Publish
In Power BI desktop home tab Click Publish on the top right of the application.

STEP FOUR

Sign In
After clicking publish button, you will be prompted to Sign In. Use your Microsoft Account to sign in or school email for students and organization account for the organization you are working for for collaborations.
Sign In Window from Power BI Desktop

STEP FIVE

Choose Workspace
After you have provided the Sign In credentials, next you choose the workspace already created from Power BI Service.
Window to choose your workspace from

STEP SIX

Upload to Power BI Service
After choosing workspace, click select to upload to Power BI Srvice.
Select Option

🌐 Embedding Power BI Reports on the Web (iFrame)

After publishing the Power BI report from Desktop, this are the step involved in Embedding report on the web

Go to Power BI service and sign in with your account information.
Go to Workspace where you published power bi file and open your report. Published Power BI report on Power BI service

Click: File → Embed report → Website or Portal

Confirm and generate embed code

Copy the generated iFrame code to code editor like Vs code Copied code in VS code

Save the embedding code to a folder in your PC and open the index.html using your preferred browser and share the link to your team or organization to access the Power BI report.

Conclusion

Creating visuals in Power BI desktop is just the beginning which equips you with data understanding skills and data analysis to derive business insights. After the report is complete, it is only accessible to you and any other person using your computer because it is only available into local machine. To make sure all involved parties get to see the final report for decision making, you have to go an extra mile into publishing it to Power BI service and share the link to the web to relevant parties. For any individual who aspire to be data analyst, it is important to understand the process of publishing the report and embedding into a website.

Power BI Data Modeling.

Joseous Ng'ash — Tue, 31 Mar 2026 08:02:15 +0000

What is Data Modeling in Power BI

In simple and understandable terms, Data Modeling is simply a way to organize, connect and structure your data in a way it can be easily analyzed and visualized.

Raw data = Messy datasets
Data modeling = organize and arrange the dataset into meaningful structure

Data Modeling in Power BI: Creating relationships between tables and structuring data into a format that enables accurate analysis and reporting.

Data Modeling Involves

Creating relationship
Defining structure(Schema)
Organizing Data into tables
Setting rules(Cardinality & Filters)

Data modeling is important because;

We can derive accurate analysis
We can get better insights
Can create clear and accurate dashboards

Power BI uses some of components to help in data modeling

Main Components of Data Modeling in Power BI.

Joins In Power BI
Joins are used when combining tables into one (This is usually done in Power Query Editor).

Types Of Joins In Power BI

Inner Join: It only returns matching rows in both tables and it is used when you only want related data. How Inner join looks like.

Left Outer Join: This is the most commonly used join. It returns all rows from the left table plus matching rows from the right.

Right Outer Join: This join act opposite of the Left Outer Join. It returns all rows from the right table plus matching rows from the left table.

Full Outer Join: This type of join in power bi, returns all the rows from both table, matched or unmatched.

Anti Join(Left/Right): This type of joins are used to return the unmatched rows, usually help in finding missing data.

Relationships In Power BI
In Relationship tables are connected without merging them. Instead of combining data physically, Power BI links tables logically.

Key Concept

Primary Key → Unique column (e.g., ProductID in Products)
Foreign Key → Repeated column (e.g., ProductID in Sales)

Cardinality: defines how table relate, example;

One-to-many(1:):* commonly used relationship, meaning one product many sales.
Many-to-one(:1):* it is the same as one-to-many but reversed.
One-to-one(1:1): this relationship is rarely used during data modeling.
Many-to-many(:): this type of relationship create ambiguity and should be used carefully.

Cross Filter Direction

Single direction: the filter flow from one direction and its the recommended filter.
Both Direction: the filter flows both ways though it can cause confusion if misused.

Schemas (Data Modeling Structures)
Schemas define how your tables are organized.
Star Schema (best practice)
This is the recommended approach in Power BI.

Structure
Fact Table: contains measurable data eg sales, revenue, quantity.
Dimension Tables Eg customers, dates, products

Benefits of star schema includes;

It is easy to understand
Better performance in Power BI
It is easy and fast

Snowflake Schema
This is a more complex version of star schema

Structure
In this type of schema, dimension tables are split into Sub-Tables though it is slow in performance and harder to manage.

Flat Table (Single Table)
This type, the data is in one table and has poor performance, hard to manage and also data redundancy.

Conclusion

Data modeling in Power BI is the process of organizing data into structured tables and creating relationships between them to enable accurate analysis and reporting. It involves arranging data in an efficient format, such as a star schema, to improve performance and ensure that filters and calculations work correctly. Overall, good data modeling helps transform raw data into meaningful insights for better decision-making.

Excel Real world Applications

Joseous Ng'ash — Fri, 27 Mar 2026 11:44:09 +0000

HOW EXCEL IS USED IN REAL WORLD DATA ANALYSIS

What really is Excel, in simple terms it is just an application from Microsoft to help ordinary people to keep their records either groceries records, building materials records, names of people traveling, basically anything involving records keeping for future references.
But for professionals like Data Analytics it is a software used to organize, analyze and visualize data. It is like a digital notebook comprising of columns and rows where you can:

create charts
perform calculations
store data of different data type eg; text, dates, numbers

Excel worksheet is made of collection of cells.

What you can do with Excel

Data analysis
Data Visualization
Automation
Data Organization
Perform Calculations

How Excel is Used in Real-world:

Track monthly expenses either by an individual or in an industrial set up.
Widely used in finance, engineering, business and data analysis.
Used to clean and prepare data before its used in other tools like SQL and Python.
It is an essential skill for careers like accountant, data engineer and data analyst.
Analyzing products performance and help in decision making in a company.
Create reports to derive clear insights.

Key Features found in Microsoft Excel

Charts And Graphs

Charts and graphs are used for data visualization which help in creating dashboard reports, some examples of charts and graphs includes:

Bar Charts
Line Graphs
Pie Charts

Example of a Pie and Bar Chart

An example of dashboard reports created from different charts and graphs

Sorting And Filtering

It is a feature used to Analyze large datasets quickly, you can either sort data from largest to smallest, smallest to largest or filter specific data.
Filter marks are always located on top of every column but are activated from the tab editing under sort and filter.

Filter Marks on every column to filter specific data

Pivot Tables

It is one of the powerful feature used for analysis in Excel

Example of how pivot table is used in data analysis

Conditional Formatting

The feature automatically changes the color of cell based on highlight rule either;

High/Low values
Duplicates
Trends Example of conditional formatting used to highlight top most performing product, using Top/Bottom Rule

Data Validation

The feature helps to keep data clean and consistent.

Data Organization

Helps make the data readable and manageable by;

Storing data in rows and columns
Format as table
structured referencing

Formulas And Functions

This feature helps excel to perform calculations using formulas
Formulas and functions are excel built-in features which are activated by typing equal sign (=) followed by specific formula or function example (VLOOKUP()) on any excel cell containing data to be filtered, aggregated or edited.

Basic operators in Excel: +,-,*,/
Functions:
- SUM() adds Values
- AVERAGE() finds mean
- IF() logical decisions
- VLOOKUP()/XLOOKUP() search data

Import And Export Data

With this feature will help in importing data from CSV files and Databases, and Export to a different formats

Conclusion
Learning Microsoft excel has transformed how I understand and interpret data, before data felt overwhelming, I would look at dataset without knowing how to extract useful insights.

Features like formulas and functions helped move far from manual calculations and start focusing on what dataset actually represent.

features like filtering, pivot table and sorting showed me data is not just static, it can be explored from different perspectives to reveal hidden insights.

Excel has also made me improve on data handling, the importance of missing values, ensuring data validation. Working with any dataset has made me more careful knowing small errors can lead to incorrect conclusions.

Overall, learning Excel has helped in a way that when I look at the data , I can understand, question and develop analytical reports to the organization for better decision making.