DEV Community: Alice Muthoni Ngure

Beyond Instructions: The Journey into Machine Learning

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:51:49 +0000

Not too long ago, computers were obedient but limited machines. They could only do exactly what they were told—nothing more, nothing less. Every function, every response, every possibility had to be programmed manually by a developer. If you wanted a computer to play chess, you had to write code that accounted for every possible move, strategy, and outcome. These machines were smart—but only as smart as the people who coded them.

But then, something remarkable happened.

Machine Learning came into the picture.

It was a paradigm shift. Instead of programming a computer to follow instructions, what if we could teach it to learn from experience—just like humans do?

Learning Like Humans

Imagine a curious student, eager to learn not by memorizing rules, but by observing examples. You don’t have to explain everything in detail—just show enough patterns, and they begin to understand, make predictions, and even catch their own mistakes. That’s what Machine Learning is: a way of training computers to learn from data instead of rigid instructions.

Let’s meet Mary, a self-taught tech enthusiast working on a new app. She wants the app to automatically tell whether a picture contains a cat or a dog. But she doesn’t write out rules like, “if it has whiskers and pointy ears, it’s probably a cat.” Instead, Mary uploads thousands of labeled images—each marked “cat” or “dog.” Over time, the algorithm starts picking up on patterns: the shape of ears, the texture of fur, the spacing of eyes.

And just like that, the app begins to make accurate predictions on its own.

That’s the magic of supervised learning—teaching machines using labeled data, where the outcome is already known.

When You Don’t Have the Answers

Now let’s imagine a different challenge. Mary wants to understand how customers behave on her e-commerce site—but she doesn’t have any labels. She just has tons of user data: what they clicked, how long they stayed, what they bought.

So, she turns to unsupervised learning. Instead of guiding the computer with correct answers, she lets it explore and find structure in the chaos. The algorithm begins grouping customers based on hidden patterns—one group loves discounts, another prefers luxury items, and another rarely buys but browses often.

No labels. No clear answers. Just the computer uncovering patterns on its own.

Learning by Trial and Error

But what if Mary wants to build something truly interactive, like an AI that plays a game, drives a car, or makes stock trading decisions?

This is where reinforcement learning comes in. It’s not about feeding the machine data upfront. Instead, it learns by trial and error. It tries different actions, gets feedback in the form of rewards or penalties, and gradually figures out the best strategy.

It’s like raising a digital child—sometimes clumsy, often curious, always learning.

Machine Learning Is Already All Around Us

Whether you notice it or not, machine learning is woven into your everyday life. When Netflix recommends a movie, Gmail filters out spam, your bank flags a suspicious transaction, or your phone understands your voice—machine learning is at work.

Even things that feel like magic, like auto-generating music playlists, predicting traffic jams, or detecting diseases from X-rays, are now powered by learning algorithms.

The Catch? Data is the Fuel

Of course, machine learning isn’t a silver bullet. It requires:

Lots of data (the more, the better)
Clean, well-structured data (garbage in = garbage out)
Computing power (some models need serious hardware)
Time and tuning (good models are rarely built overnight)

But once trained, these systems can spot patterns no human could ever see—and scale decisions faster than any team ever could.

The Real Breakthrough

The real revolution isn’t that computers can follow instructions. It’s that they can learn, adapt, and grow smarter over time. We’re no longer just writing code—we’re building machines that evolve through experience.

And that changes everything.

GitHub for Data Analysts and Scientists: More Than Just Code Storage

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:15:20 +0000

Introduction

You’ve probably heard of GitHub as the place where developers store their code—but if you’re learning data analytics or science, GitHub can become one of your most powerful career tools. From version control and collaboration to portfolio building and workflow automation, GitHub is a must-have in your data toolkit.

In this article, you'll discover what GitHub is, why it’s valuable for non-developers too, and how to start using it effectively as a data professional.

What Is GitHub?

GitHub is a platform built on Git, a version control system. It helps you:

Track changes in your code or data notebooks
Collaborate with others without overwriting work
Back up your projects on the cloud
Showcase your portfolio to recruiters and collaborators

Think of GitHub as Google Drive for coders—but with built-in tools for collaboration, history tracking, and more.

Why Data Professionals Should Use GitHub

Whether you're a data analyst, aspiring data scientist, or building dashboards, GitHub offers serious benefits:

Portfolio Building
Upload your Python notebooks, Excel dashboards, SQL queries, or data projects. Recruiters love to see your real work!
Version Control
Track every edit in your code, notebook, or dataset. Revert if something breaks—no more “final_final_v2_real” filenames.
Team Collaboration
Work on projects with others without confusion. Merge changes using branches and pull requests.
Learning from Others
Explore thousands of public repositories with open-source data projects. Reading other people's code is a great way to learn.
Deploying Projects
GitHub can host your data visualizations, Python apps, or documentation—like using GitHub Pages to host a portfolio site.

Real-World Use Case

You're analyzing customer data in a Jupyter Notebook and cleaning it with Pandas. With GitHub, you can:

Save your project notebook in a private or public repo
Track every edit you make over time
Collaborate with a peer reviewer using a pull request
Show your notebook to potential employers in your portfolio repo

It’s organization + backup + presentation, all in one place.

What Can You Store on GitHub?

You can store and version-control:

.ipynb (Jupyter Notebooks)
.py (Python scripts)
.sql (SQL queries)
.csv, .xlsx (small datasets)
.md (Markdown documentation files)
Project READMEs and dashboards

How to Get Started on GitHub (Step-by-Step)

1.Create a GitHub Account

Go to github.com and sign up—it’s free.

2.Install Git (Optional)

Install Git on your PC to work from the command line (recommended for advanced use).

3.Set Up a Repository

Click New Repo
Give it a name and description
Choose public (for portfolios) or private

4.Upload Your Work

Use drag-and-drop on the site
Or push from your computer using Git commands

5.Write a README File

Tell people what your project does, what data was used, and how to run it.

6.Keep Updating It

Add new projects, track changes, and build your repo over time.

Bonus Tips

Use GitHub Pages to turn your repo into a personal website
Use Jupyter Notebooks + Markdown for project storytelling
Follow other data analysts and scientists for learning and inspiration
Add Licenses and GitHub Topics to make your repos professional and searchable

GitHub = Your Digital Resume

In today’s data-driven job market, GitHub acts as a public record of your work. While resumes tell what you can do, GitHub shows it. Hiring managers love to see how you solve problems, organize code, and collaborate.

Conclusion

GitHub is more than just a code repo—it's a platform for learning, showcasing, and collaborating. As a data analyst or scientist, adopting GitHub early helps you stay organized, get noticed, and grow your career faster.

You don’t need to be a developer to benefit from it. Start simple: upload your first project, write a README, and keep building.

Python for Data Analytics: Why It's the #1 Tool for Data Enthusiasts

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:13:36 +0000

Introduction

If you're diving into data analytics or data science, one language comes up again and again: Python. It’s simple to learn, yet powerful enough to analyze massive datasets, build machine learning models, and automate repetitive tasks. In fact, Python has become the go-to language for anyone working with data.

So what makes Python so essential—and how can you start using it as a data analyst or aspiring data scientist?

Why Python?

Here’s why Python stands out in the data world:

Beginner-Friendly Syntax
Python reads like plain English. Even if you're new to coding, you’ll find it easy to pick up.
Huge Data Ecosystem
With libraries like Pandas, NumPy, Matplotlib, and Scikit-learn, Python lets you clean, analyze, visualize, and model data with just a few lines of code.
Open Source and Free
No licenses, no fees. You can install Python and its libraries on any machine, completely free.
Community Support
Python has one of the largest programming communities in the world. If you get stuck, there’s always a solution on Stack Overflow, GitHub, or Reddit.

Key Python Libraries for Data Analytics

Library	Purpose
Pandas	Data manipulation and analysis
NumPy	Numerical operations and arrays
Matplotlib / Seaborn	Data visualization
Scikit-learn	Machine learning and predictive analytics
Plotly	Interactive graphs and dashboards
Jupyter Notebook	Interactive coding environment, perfect for EDA

What You Can Do with Python in Data Analytics

Read and clean messy datasets (e.g., removing duplicates, fixing missing values)
Perform descriptive and inferential statistics
Visualize patterns using plots, graphs, and dashboards
Create automated data reports
Build machine learning models to predict trends or outcomes

Whether you're working with CSV files or querying databases, Python gives you the flexibility to scale your analytics from small tasks to big projects.

Getting Started with Python

Here’s how to begin:

Install Python and Jupyter Notebook

Download from python.org
Or install Anaconda, which includes Python, Jupyter, and essential libraries.

2.Learn the Basics

Data types (strings, integers, floats)
Variables and control flow (if/else, loops)
Functions and modules

3.Practice with Real Datasets

Use free datasets from Kaggle, UCI Machine Learning Repository, or Data.gov

4.Build Mini Projects

Analyze COVID-19 data
Clean and visualize a product sales dataset
Automate a simple report using Pandas

Real-Life Example

Say you’re analyzing customer feedback for an online store. With Python, you can:

Read reviews from a CSV file (using Pandas)
Count positive and negative words (using text analysis)
Visualize satisfaction trends (using Seaborn)
Predict future customer churn (using Scikit-learn)

And you can do all this without leaving your Jupyter Notebook!

Bonus Tip: Combine Python with Power BI

Did you know Power BI allows Python integration? You can run Python scripts to clean your data or generate custom visuals—giving you the best of both worlds: code-based flexibility + no-code dashboards.

Conclusion

Python is not just a programming language—it’s a data toolkit. If you're serious about data analytics or science, learning Python will open up opportunities to explore data deeper, automate boring tasks, and build intelligent solutions.

Start small, practice often, and don’t be afraid to experiment. With Python, the possibilities are truly limitless.

Data Visualization: The Language of Data Analytics

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:11:49 +0000

Introduction

You’ve cleaned the data. You’ve analyzed it. Now what? Without a way to communicate insights, even the best analysis can fall flat. That’s where data visualization becomes your superpower.

Whether you're a student, a new analyst, or a data science enthusiast, learning to visualize data is one of the most essential skills you can develop.

What Is Data Visualization?

Data visualization is the art and science of representing data through charts, graphs, maps, and other visuals. It allows you to spot patterns, uncover trends, and present your findings in a way that’s quick and easy to understand.
Imagine reading a spreadsheet with thousands of rows—hard to make sense of, right? But with a simple bar chart or heatmap, the same data can tell a compelling story in seconds.

Why Data Visualization Matters

Simplifies Complex Data-
Makes it easier to interpret large datasets.
Improves Decision-Making-
Trends and insights become immediately obvious.
Enhances Communication-
Stakeholders can grasp findings without reading a full report.
Boosts Retention-
People remember visuals more than raw numbers.

Popular Data Visualization Tools

Power BI – Great for interactive dashboards and business reporting.

Tableau – Known for beautiful and complex visualizations.

Excel – Basic but still powerful for quick charts.

Python (Matplotlib, Seaborn, Plotly) – Flexible and ideal for coding custom visualizations.

R (ggplot2) – Excellent for statistical visuals and academic analysis.

Types of Data Visualizations

Visualization Type	Best For
Bar Chart	Comparing categories
Line Graph	Showing trends over time
Pie Chart	Showing proportions or percentages
Scatter Plot	Identifying relationships between variables
Heatmap	Highlighting intensity or concentration
Histogram	Displaying frequency distributions

Best Practices for Great Visuals

Know Your Audience
Design visuals that match the level of technical understanding of your viewers.
Tell a Story
Guide the viewer through a narrative using headings, annotations, and visual cues.
Keep It Simple
Avoid clutter. Use minimal colors, fonts, and chart types to prevent confusion.
Label Clearly
Always label axes, data points, and legends—assume nothing is obvious.
Use Color Wisely
Use color to highlight key data, not to decorate. Be mindful of colorblind accessibility.

Real-Life Example

Imagine you’re working for an e-commerce company analyzing sales data. Instead of sharing a raw CSV file with thousands of transactions, you can build a dashboard that shows:

Total sales by month (line chart)
Top 5 selling products (bar chart)
Sales by region (map)
Customer satisfaction scores (gauge)

In seconds, you’ve told a clear story—visually.

Conclusion

In the field of data analytics and science, data visualization is not just a supporting skill—it’s a core competency. It turns data into decisions, numbers into narratives, and confusion into clarity.
Whether you're just starting out or aiming to become a data expert, mastering the art of data visualization will make your work more impactful and your insights more influential.
Start with simple charts. Experiment with tools like Power BI or Python libraries. With practice, you’ll become fluent in one of the most powerful languages in data.

Why Every Aspiring Data Scientist Should Learn Power BI

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:09:01 +0000

Introduction

Data scientists often work with complex models and big data, but one skill that's sometimes overlooked is data storytelling—communicating insights clearly to non-technical stakeholders. This is where Power BI shines. While tools like Python and R are essential for analysis, Power BI bridges the gap between data science and decision-making.

Power BI vs. Programming Tools

Python/R: Great for in-depth statistical modeling, machine learning, and automation.
Power BI: Best for visualization, summarization, and sharing insights with business teams.

Using Power BI alongside your programming skills can make you a more well-rounded data professional hence use python to analyze data and Power BI to present it

Top Features Data Scientists Love in Power BI

Power Query Editor-
Helps you transform and clean data efficiently without writing code—ideal for preprocessing before analysis.
DAX (Data Analysis Expressions)-
A formula language used in Power BI to create calculated columns, measures, and custom aggregations.
Custom Visualizations-
Build advanced visuals with R or Python scripts within Power BI for high-level storytelling.
Real-Time Dashboards-
Monitor live data streams and detect anomalies quickly—especially useful in IoT and finance.

When Should a Data Scientist Use Power BI?

Exploratory Data Analysis (EDA): Quickly visualize patterns before modeling.
Sharing Results: Present machine learning outcomes in a clean, interactive dashboard.
Reporting: Automate recurring reports for business teams and stakeholders.

The Data Science Lifecycle with Power BI

New Visual Workflow:

Discovery Phase: Power BI for initial data exploration
Model Development: Switch to Python/R for ML
Validation: Power BI for model performance dashboards
Deployment: Embedded dashboards with model outputs
Monitoring: Real-time performance tracking

Conclusion

Power BI isn’t just a reporting tool—it's a communication powerhouse. As an aspiring data scientist, combining analytical skills with tools like Power BI will make your insights understandable, impactful, and actionable. In short: your models will not only be smart, but useful too.

Power BI for Beginners: Turning Raw Data Into Actionable Insights Through Data Analysis

Alice Muthoni Ngure — Sun, 20 Jul 2025 13:05:32 +0000

Introduction

In the world of data analytics, the ability to translate raw data into understandable visuals and insights is a game-changer. This is where Power BI comes in—a powerful business intelligence tool developed by Microsoft that helps users create interactive dashboards and reports with ease. If you're new to data analytics, Power BI is one of the best tools to start your journey with.

What Is Power BI?

Power BI is a data visualization and business intelligence tool that allows users to connect to various data sources, clean and transform data, and build visual dashboards that tell compelling data stories.

Bonus: It’s FREE to start (Power BI Desktop).

Why Power BI Is Perfect for Beginners

User-Friendly Interface: With its drag-and-drop functionality and easy-to-understand menus, Power BI feels more like Excel than complex programming tools.
Wide Range of Data Connectors: From Excel files and SQL databases to web APIs and cloud services, Power BI makes it simple to pull in data.
Pre-built Visuals: Charts, graphs, maps, and gauges are available and customizable to help convey insights clearly.
Integration with Excel: If you already know Excel, especially PivotTables and Power Query, you’ll find Power BI’s environment familiar and even more powerful.

Try This: Import an Excel file → Click “Get Data” → Select your file → See Power BI auto-detect tables!

The Role of Power BI in Data Analysis

Data analysis involves a series of steps: collecting, cleaning, exploring, visualizing, and interpreting data. Power BI supports each of these steps:

Data Analysis Step -- How Power BI Helps

Collecting Data -- Connects to Excel, SQL, web data, APIs, etc.
Cleaning & Transforming -- Built-in Power Query Editor for shaping data
Exploring Patterns -- Interactive visuals help spot trends easily
Visualizing Insights -- Charts, maps, KPIs, tables, and more
Reporting & Sharing -- Dashboards are shareable via the cloud

For example, if you’re analyzing sales data from Excel, Power BI helps you clean messy records, combine multiple files, and then create visuals like sales by region, product trends, and customer segments—all without using advanced programming.

How to Get Started with Power BI

Download Power BI Desktop: It's free and ideal for learning and development.
Load Your Data: Connect to Excel, CSV, or any other data source.
Clean Your Data: Use Power Query to remove duplicates, fill missing values, and create calculated columns.
Visualize It: Drag and drop data fields to create charts and graphs.
Publish & Share: Upload your reports to the Power BI Service to share with others or access them on your phone.

Simple Project Idea to Try

Analyze student performance data across different subjects and visualize the results by gender, school, and year. This hands-on experience will build your confidence.

Tip

Already use Excel? Power BI integrates seamlessly with Excel data models and pivot tables.

Learning Python? You can even run Python scripts within Power BI to clean data or generate advanced visuals. This makes it an amazing hybrid tool for both beginner analysts and growing data scientists.

Conclusion

Power BI is a powerful yet approachable tool for anyone stepping into the data world. Mastering it not only improves your analytical skills but also gives you a competitive edge in today’s data-driven job market.And the best part? You don’t need to be a programmer or a data scientist to get started.

Introduction to SQL Functions and Joins: Essential Techniques for Data Manipulation

Alice Muthoni Ngure — Sun, 27 Apr 2025 17:24:02 +0000

SQL is a powerful language for managing and manipulating databases. In this guide, we’ll explore essential SQL functions and different types of joins that allow you to work efficiently with your data.

SQL String Functions

SQL String Functions help in manipulating text data and offer operations like concatenating strings, extracting parts of a string, and modifying text.

1. CONCAT()-Combines two or more strings into one

--combine first and last name 
select concat(first_name ,' ',last_name) as full_name
from luxdevteaching.customers;

2. SUBSTRING()-Extracts part of a string

--get the first 3 letters of the first name 
select substring(first_name, 1 ,3) as short_name
from  luxdevteaching.customers;

3. LENGTH()-Returns the number of characters in a string.

--find the length of customer first name 
select first_name, length(first_name)as name_length
from  luxdevteaching.customers;

4. UPPER(),LOWER()-Converts text to uppercase or lowercase

--convert the first names to uppercase
select upper(first_name) as uppercase_names
from  luxdevteaching.customers;

--convert the book title to lowercase
select lower(title) as lowercase_titles
from  luxdevteaching.books;

5. TRIM ()-removes extra spaces from the beginning or the end of a text string

select trim(  title  ) as book_title
from  luxdevteaching.books;

6. REPLACE()-Replaces occurrences of a substring within a string

--relace nairobi with NRB
select replace (city,'Nairobi','NRB') as short_name
from  luxdevteaching.customers;

SQL Date Functions

SQL also allows us to perform operations on date values. Date functions help in extracting parts of a date or performing calculations involving dates.

1. NOW()-Returns the current date and time

select NOW() as CURRENT_DATE;

2. YEAR()-extracts the year

--extract the year from order date 
select order_id,extract (year from order_date) as order_year
from  luxdevteaching.orders;

3. MONTH()-extracts the month

--extract the month from the order date 
select order_id,extract(month from order_date) as order_month
from  luxdevteaching.orders;

4. DAY()-extracts the day

--extract the day from the order day
select order_id,extract(day from order_date) as order_day
from  luxdevteaching.orders;

5. DATEDIFF()-Returns the difference in days between two dates.

-- find the difference between today and published date
select date '2025-04-16'-published_date as diff
from luxdevteaching.books;

SQL Mathematical Functions

Mathematical functions are used for performing calculations and rounding operations.

1. ROUND()-Rounds a numeric value to the specified number of decimal places.

--round the price to 2 decimal places
select title ,price,round(price,1) as rounded_price
from luxdevteaching.books;

2. CEIL()-returns the smallest integer greater than or equal to the number

select title,price ,ceil(price) as cell_price
from luxdevteaching.books;

3. FLOOR()-returns the largest integer less than or equal to the number

select title,price,floor(price) as floor_price
from luxdevteaching.books;

4. MOD()-Returns the remainder of division between two numbers.

--check if the order quantity is odd or even
select order_id, quantities,mod(quantities,2)
as remainder
from luxdevteaching.orders;

5. POWER()-Raises a number to the power of another number

--raise the quantity to the power 2 
select order_id,power(quantities,2) as squared_quantity
from luxdevteaching.orders;

6. ABS()-Returns the absolute (non-negative) value of a number.

--find  the absolute value of  the price difference
select title,price,abs(price-2000) as price_diff
from luxdevteaching.books;

SQL JOINS

SQL Joins allow you to combine related data from different tables into one result set.Let’s look at different types of SQL joins:

1. INNER JOIN -N returns only the rows that have matching values in both tables

--employees and the projects they have been assigned to 
select employees.name ,projects.project_name
from employees
inner join projects on employees.employee_id= projects.employee_id;

2. LEFT JOIN(LEFT OUTER JOIN)-returns all the rows from the left table, and the matched rows from the right table.If there’s no match, it fills in NULL.

--list all employees and their departments
select employees.name,departments.department_name
from employees
left join departments  on employees. department_id =departments.department_id;

3. RIGHT JOIN(RIGHT OUTER JOIN)- shows all the entries from the right side, whether there’s a match on the left or not.

--list all projects and employees (even unassigned projects)
select projects.project_name,employees.name
from employees
right join projects on projects.employee_id =employees.employee_id;

4. FULL OUTER JOIN-It shows all rows from both tables. If there’s no match, it uses NULLs

--show all employees and all departments
select employees.name,departments.department_name
from employees 
full outer join departments on employees.department_id = departments.department_id;

5. CROSS JOIN-returns every combination of rows from both table

--cross departments and employees
select employees.name,departments.department_name
from departments
cross join employees;

6.SELF JOIN-It is when a table joins with itself

--find employee manager relationships
select A.name as employee, B.name as manager
from employees A 
join employees B on B.manager_id = A.employee_id;

These SQL functions and joins are crucial for working with relational databases, enabling you to perform a variety of operations, from simple string manipulations to complex data retrieval from multiple tables. Understanding how to use these functions and joins effectively will enhance your ability to work with data in SQL databases.

SQL Fundamentals: A Deep Dive Into Aggregate Functions and Operators for Data Analysis

Alice Muthoni Ngure — Sun, 27 Apr 2025 17:23:49 +0000

SQL (Structured Query Language) is the primary language for managing and manipulating databases. Whether you're analyzing data or performing database operations, understanding SQL functions and operators is crucial. In this article, we will explore some of the essential SQL functions and operators, including aggregate functions, comparison operators, logical operators, arithmetic operators, and set operators. These tools will help you manage and query databases efficiently, especially when handling large datasets.

AGGREGATE FUNCTIONS

Aggregate functions in SQL are used to perform calculations on a set of values and return a single value. They are commonly used in conjunction with the GROUP BY clause to group rows based on certain attributes.

1. COUNT()-It returns the number of rows that match a specific condition. It’s often used to find the total number of entries in a table or based on specific criteria.

--count the total customers;
select count(*) as total_customers
from luxdevteaching.customers;

2. SUM()-It adds up the values in a numeric column. It’s particularly useful when calculating totals

--total quantity of all orders
select sum (quantities) as total_orders
from luxdevteaching.orders;

3. AVG()-It calculates the average (mean) value of a numeric column. It can be useful for finding average prices or other metrics.

--average price of books
select avg(price) as avg_price
from luxdevteaching.books;

4. MAX()-It finds the largest value in a column. It is often used to find the highest value in a dataset, such as the most expensive book.

--find the most expensive book
select max(price) as most_expensive_book
from luxdevteaching.books;

5. MIN()-It finds the smallest value in a column. It’s useful for identifying the least expensive item or the lowest quantity.

--find the least expensive book
select min(price) as cheapest_book
from luxdevteaching.books;

SQL OPERATORS

SQL Comparison Operators

These operators compare values in your data and return true or false. They are mostly used inside the WHERE clause to filter results.

1. =(Equals)-shows where a column matches an exact value

--find customers in kisumu
select * from luxdevteaching.customers 
where city = 'Kisumu';

2. != or <> (Not Equals)-Selects rows where a column value does not match the specified value.

--find customer not in Nairobi
select first_name,last_name,city 
from luxdevteaching.customers 
where city <>'Nairobi';

3. > (Greater Than)-Selects rows where column value is greater than the given value

--find books priced above 2500
select * from luxdevteaching.books 
where price > 2500;

4. < (Less Than)-Selects rows where column value is less than the given value.

--find books priced below 2500
select * from luxdevteaching.books 
where price < 2500;

5. >= (Greater Than or Equal To)-Selects rows where column value is greater than or equal to the given value

--find orders with quantity >=2
select * from luxdevteaching.orders 
where quantities >= 2;

6. <= (Less Than or Equal To)-Selects rows where column value is less than or equal to the given value.

--find orders with quantity <=2
select * from luxdevteaching.orders 
where quantities <=2;

7. BETWEEN (Range) -Selects rows with column values between two values (inclusive).

--find books priced between 2000 and 3000
select * from luxdevteaching.books 
where price between 2000 and 3000;

8. LIKE(Pattern Matching)-Use LIKE to search for patterns in text data

--find customers with first name starting with'J'
select * from luxdevteaching.customers 
where first_name like 'J%';

--find books with title containing SQL 
select * from luxdevteaching.books 
where title like '%SQL%';

--show customer emails ending with 'gmail.com'
select * from luxdevteaching.customers 
where email like '%gmail.com';

9. IN (Multiple Values)-Use IN to filter records by matching any value in a list

--find customers in kisumu or nairobi
select * from luxdevteaching.customers 
where city in ('Kisumu','Nairobi');

SQL Logical Operators

Logical operators allow us to combine multiple conditions inside the WHERE clause.

1. AND-All conditions must be true

--find customers form kisumu and first name containing paul
select * from luxdevteaching.customers 
where city ='Kisumu'
and first_name ='Paul';

2. OR-one condition has to be true

--find customers from nairobi or kisumu
select * from luxdevteaching.customers 
where city ='Nairobi' or city = 'Kisumu';

3. NOT-Reverses the result of a condition. If condition is true, NOT makes it false.

--find customers not from Kisumu
select * from luxdevteaching.customers 
where not city ='Kisumu';

SQL Arithmetic Operators

1. Addition (+)-Adds two numbers together

-- Add book price with 500
select title,price, price +500
from luxdevteaching.books;

2. Subtraction (-)- gets the difference between 2 values

-- Discount each book with 200kes
select title, price, price- 200 as discountedprice_
from luxdevteaching.books;

3. Multiplication (*)-finds the product

-- Double the price of books
select title, price, price * 5 as newprice_
from luxdevteaching.books;

4. Division (/)

select title, price, price/2 as discountedprice_
from luxdevteaching.books;

5.Modulus(%)

-- Find the remainder when quantity is divided by 2
select quantities, quantities % 2
from luxdevteaching.orders;

SQL Set Operators

Set operators allow you to combine the results of two or more SELECT queries.

1. UNION-Combines two result sets and removes duplicates.

-- Combine the customers first name and authors names
Select first_name as name from luxdevteaching.customers
union
select author as name from luxdevteaching.books;

2. UNION ALL-Combines two result sets and keeps duplicates.

--combine customer frist name and authors 
select first_name as name from luxdevteaching.customers 
union all 
select author as name from luxdevteaching.books;

3. INTERSECT-Returns common records from both queries

--find common id in between customer_id and order_id from orders
select customer_id as id from luxdevteaching.customers 
intersect
select order_id as id from luxdevteaching.orders;

4. EXCEPT-Returns records from the first query that are not in the second query

--find book id  not on orders
select book_id as books from luxdevteaching.books 
except 
select book_id as books from luxdevteaching.orders;

OTHER USEFUL SQL OPERATORS

1. IS NULL-Used to find records where a column has no value

--check for customers without a city
select * from luxdevteaching.customers 
where city is null;

2. IS NOT NULL-Used to find records where the column has a value.

--check for customers with cities
select * from  luxdevteaching.customers 
where city is not null;

3. DISTINCT-Removes duplicate values from the results

--list unique authors 
select distinct author from luxdevteaching.books;

SQL Fundamentals for Aspiring Data Analysts

Alice Muthoni Ngure — Sun, 27 Apr 2025 17:23:34 +0000

WHAT IS A DATABASE ?

A database is an organized collection of data stored electronically.

WHAT IS DBMS?

DBMS stands for Database Management System which is a software used to create,manage and maintain databases.

Types of DBMS:

WHAT IS SQL?

SQL (Structured Query Language)is a domain-specific language designed for managing and manipulating relational databases. It allows users to:

Retrieve data from databases
Insert new data
Update existing records
Delete unwanted data
Create and modify database structures

SQL works with database management systems like MySQL, PostgreSQL, SQLite, Microsoft SQL Server, and Oracle.

WHY LEARN SQL?

Universality: SQL is supported by almost every relational database system.
In-demand skill: SQL is among the most sought-after skills in data analytics, software development, and database administration.
Data interaction: It empowers you to explore, filter, and summarize vast datasets.

MAIN DATA TYPES IN SQL(POSTGRESQL)

TABLE CREATION

A table is like a spreadsheet as it stores data in rows and columns.

Basic syntax for table creation

CREATE TABLE — command to create a new table.
table_name — the name you want to give to your table.
column_name — name of each field (column).
data_type — type of data the column will store (e.g., text, numbers, dates).
constraints (optional) — rules like NOT NULL, PRIMARY KEY, etc.

--creating tables
create table customers(
customer_id SERIAL primary key,
first_name VARCHAR(50) not null,
last_name VARCHAR(50) not null,
email VARCHAR(100) unique not null,
phone_number CHAR (13)
);

Constraint & meaning

CREATE TABLE- Create a new table
PRIMARY KEY- Uniquely identifies each row
FOREIGN KEY -Links tables together
NOT NULL -Ensures column cannot be empty
VARCHAR(n)- Variable length string
DECIMAL(p, s) -Precise numbers with decimals
DATE- Date values
UNIQUE -all values in the column must be unique
DEFAULT -Provides a default value if none is given

COMMON SQL KEY WORDS

SELECT-used to retrieve data from a table

--list book titles and authors
select book_id,title,author
from luxdevteaching.books;

WHERE-filters data to show only the rows that meet certain conditons.

--find orders placed by customer with customer_id 1
select * from luxdevteaching.orders 
where customer_id= 1;

ORDER BY -used to sort data .ASC (default) sorts in ascending order while DESC sorts in descending order.

--list(title and price) books by price from lowest to highest
select title,price
from luxdevteaching.books 
order by price asc;

GROUP BY-groups and summarizes data.

--count how many books each author has
select author,
count(*)
as total_books 
from luxdevteaching.books 
group by author;

HAVING-filters after grouping

--show authors with more than 1 book
select author,
count(*)
as total_books
from luxdevteaching.books 
group by author 
having count(*) > 1;

LIMIT-show only a few records

--show the top 2 most expensive books 
select title,price 
from luxdevteaching.books 
order by price desc 
limit 2 ;

How Data Science & Analytics Are Transforming Industries Today

Alice Muthoni Ngure — Sun, 27 Apr 2025 17:23:04 +0000

We live in a world where data is everywhere—from the apps we use on our phones, to the purchases we make online, to the healthcare services we receive. Data science and analytics are tools that help companies and organizations make sense of all this data. These tools are changing the way many industries work by helping organizations make smarter decisions, reduce costs, and better serve their customers .This essay explores how data science and analytics are revolutionizing key sectors, including healthcare, finance, retail, manufacturing, and transportation. It also highlights the real-world applications of these technologies and their growing importance in shaping the future of global industries.

1.UNDERSTANDING DATA SCIENCE AND ANALYTICS

What is data analysis?
Data analytics refers to the process of examining, transforming, and modeling data to identify meaningful patterns, trends, and relationships. It is used to support better decision-making and operational efficiency. The four key types of data analytics are:

Descriptive Analytics – What happened?
Diagnostic Analytics – Why did it happen?
Predictive Analytics – What is likely to happen?
Prescriptive Analytics – What should be done about it?

What is data science?
Data science is an interdisciplinary field that combines mathematics, statistics, computer science, and domain-specific knowledge to extract actionable insights from large volumes of data. It involves advanced techniques such as machine learning, artificial intelligence (AI), and predictive modeling. Together, data science and analytics provide the foundation for data-driven innovation across various sectors.

2. KEY INDUSTRIES TRANSFORMED BY DATA SCIENCE AND ANALYTICS

2.1 Healthcare

Data science is making a significant impact on healthcare systems around the world:

Predictive Health Monitoring: Hospitals analyze patients’ medical records and historical data to predict potential health issues. This allows for early intervention and preventive treatment, improving patient outcomes.
Personalized Treatment Plans: By examining genetic information and medical histories, healthcare providers can tailor treatments to each patient, increasing the effectiveness of therapies and minimizing adverse effects.
Hospital Operations Management: Data is used to optimize staffing, identify high-demand departments, and reduce patient waiting times. These improvements not only enhance patient satisfaction but also reduce operational costs.

2.2 Finance

Financial institutions use data science to manage money, protect customers, and grow their businesses:

Loan Risk Assessment: Banks use credit history, transaction behavior, and other financial indicators to assess whether a customer is eligible for a loan and to determine appropriate interest rates.
Fraud Detection: Machine learning models are trained to recognize abnormal patterns in financial transactions. This enables institutions to detect and prevent fraudulent activities in real time.
Algorithmic Trading: Investment firms use data-driven algorithms to analyze market trends and make informed trading decisions. These systems can execute trades at speeds and accuracy levels far beyond human capabilities.

2.3 Retail

Retail companies are leveraging data to better understand customer behavior and streamline operations:

Product Recommendations: Online platforms such as Amazon and Netflix use machine learning to analyze users’ preferences and purchasing history, offering personalized recommendations that boost customer engagement and sales.
Inventory Management: Retailers use predictive analytics to forecast demand, ensuring that popular items are restocked in time while reducing overstock of less popular products.

2.4 Manufacturing

The manufacturing sector is undergoing a digital transformation powered by smart technologies and data analytics:

Predictive Maintenance: Machines equipped with sensors transmit real-time data to centralized systems, which analyze the data to predict potential breakdowns. This proactive approach minimizes costly downtimes.
Supply Chain Optimization: Manufacturers use data to monitor material availability, delivery schedules, and production timelines, helping them operate more efficiently and meet customer demand.
Quality Assurance: Automated systems analyze product data to detect defects before products leave the factory, ensuring consistent quality standards.

2.5 Transportation

From traffic control to delivery services, the transportation industry is using data science to make travel and shipping better.

Traffic Management and Route Optimization: Cities use data from sensors and cameras to control traffic lights and reduce congestion. Navigation apps like Google Maps use real-time data to guide drivers through the quickest routes.
Autonomous Vehicles: Self-driving cars rely on a combination of cameras, GPS, radar, and machine learning algorithms to interpret surroundings and make safe driving decisions.
Smart Delivery Services: Logistics companies like FedEx and delivery platforms such as Uber Eats use analytics to plan efficient delivery routes, reduce fuel consumption, and track driver performance in real-time.

3.CHALLENGES AND ETHICAL CONSIDERATIONS

Despite its transformative potential, data science and analytics comes with challenges that must be addressed:

Data Privacy: With vast amounts of personal data being collected, protecting user privacy has become a major concern. Regulations like the General Data Protection Regulation aim to safeguard individuals' rights.
Algorithmic Bias: AI systems can reflect or amplify existing biases present in training data. Ensuring fairness and inclusivity requires transparency, diverse datasets, and ethical oversight.
Skills Gap: Many organizations face difficulty in finding qualified data scientists and analysts. Bridging this skills gap is essential for businesses to fully leverage data-driven insights.
Implementation Costs: Advanced analytics infrastructure can be expensive, particularly for small and medium-sized enterprises. Cloud-based solutions are increasingly offering affordable alternatives.

CONCLUSION

The impact of data science and analytics across industries is both profound and far-reaching. In healthcare, data-driven tools help save lives and streamline operations. In finance, they enhance fraud prevention and intelligent investing. In retail, they personalize customer experiences and improve inventory decisions. In manufacturing, they reduce downtime and maintain quality control. And in transportation, they optimize logistics and enable the development of autonomous vehicles as well as making travel easier and greener.

As technology advances and data becomes increasingly abundant, the need for skilled data professionals will continue to grow. Ultimately, data science and analytics will continue to change the way we live and work. No matter what industry you're in—or want to work in—understanding data can help you be part of the future.

Excel For Data Analysis: A Comprehensive Guide To Mastering Data Insights

Alice Muthoni Ngure — Sun, 27 Apr 2025 17:22:48 +0000

INTRODUCTION TO EXCEL FOR DATA ANALYSIS

In today’s world, data plays a central role in making decisions, improving processes, and driving innovation. Whether you are a beginner or aspiring data analyst, understanding how to work with data is essential — and Excel remains one of the most accessible and powerful tools for doing so.This article introduces key concepts in data analysis and explains how Excel can be used effectively for analyzing and visualizing data.

What is data?
Data refers to raw elements or unprocessed facts which one can process for reasoning ,calculation and discussion.
What is data analysis?
The process of examining ,transforming and modelling data to discover pattern trends to make insightful decisions and improve operational efficiency
What is data science?
It is an interdisciplinary field involving maths and statistics that uses scientific methods ,processes algorithms and systems to extract knowledge from data.
Tools for data analysis and science?
Spreadsheet tools (e.g., Microsoft Excel)
Programming languages (e.g., Python)
Data visualization tools (e.g., Power BI)
Database management systems (e.g., MySQL, PostgreSQL)

WHY USE EXCEL FOR DATA ANALYSIS?

Excel is one of the easiest tools to start with when learning data analysis. It doesn’t need any coding skills and is available on most computers. Here’s why Excel is a great choice:

Easy to Access: Excel is often already installed or can be used through Microsoft 365.
Simple Visuals: You can create charts and graphs in just a few clicks.
Useful Tools: Features like PivotTables, formulas, and conditional formatting help you quickly analyze data.
Works with Other Programs: You can easily share Excel files or use them in other apps and systems.

BASIC DATA ANALYSIS TASKS IN EXCEL

Microsoft Excel is widely used in both academic and business settings for its powerful yet approachable data analysis features. Here are some of the most important data analysis tasks you can perform in Excel:

1. Sorting and Filtering

Sorting allows you to organize your data in a logical order—for example, alphabetically (A to Z), numerically (smallest to largest), or by date (oldest to newest). This is helpful when trying to identify top performers, latest transactions, or ranked items.
Filtering lets you display only the rows that meet specific conditions, such as showing only sales above a sum of money or customers from a certain region. You can also use Advanced Filters for more complex criteria.

2. Using Formulas and Functions

What are Formulas in Excel?

A formula in Excel is an expression used to perform calculations. All formulas start with an equal sign =, followed by a combination of values, cell references, operators, and functions.

Types of Formulas

Mathematical: =A1 + A2, =B3 - B2, =C1 * C2
Text: =A1 & " " & B1, =UPPER(A1), =LOWER(B1)
Logical: =IF(A1>50, "Pass", "Fail")
Date/Time: =TODAY(), =NOW(), =D2 - C2

Types of Functions in Excel

A function is a predefined formula built into Excel. You simply provide the input (arguments), and Excel does the rest.

Mathematical: =SUM(A1:A10), =PRODUCT(A1:A5), =ROUND(B1, 2)
Statistical: =AVERAGE(A1:A10), =MEDIAN(A1:A10)
Logical: =IF(), =AND(), =OR(), =NOT()
Lookup & Reference: =VLOOKUP(), =HLOOKUP(), =INDEX(), =MATCH()
Text: =LEFT(), =RIGHT(), =MID(), =LEN(), =TRIM()
Date/Time: =TODAY(), =NOW(), =DAY(), =MONTH(), =YEAR()

3. Conditional Formatting

Conditional formatting in Excel is a feature that automatically changes the appearance of cells based on specific conditions or rules you define. It provides visual cues that help identify patterns, trends, and exceptions in your data without altering the actual values. This formatting can include:

Background colors (cell shading)
Font colors and styles (bold, italic, etc.)
Cell borders
Icon sets (such as arrows, flags, or ratings)
Data bars (horizontal bars within cells representing values)
Color scales (gradient colors representing value ranges)

4.PivotTables

A PivotTable is an interactive table that automatically extracts, organizes, and summarizes your data. The name "pivot" comes from the ability to rotate (or pivot) the data fields to view different summaries of the source data.
They're designed to:

Condense large datasets into meaningful summaries
Analyze relationships between data points
Create custom calculations and groupings
Calculate totals
Filter and slice the data using dropdown menus or slicers
Present information in an easily digestible format

5.Data Visualization

Data visualization is the graphical representation of information and data using visual elements such as charts, graphs, maps, and other visual formats. It provides a way to see and understand trends, patterns, and outliers in data that might be difficult to identify in raw numerical or textual format.
Most commonly used chart types for data analysis:

Line charts-great for analyzing trends over time
Column charts-easy to compare values across categories
Bar charts-similar to column charts but better for long labels
Pivotcharts-used to summarize,filter and visualize large datasets
Pie & Donut charts-good for showing proportions but only for a few categories
Scatter plots-shows the relationship or correlation between two variables
Histogram-shows how data is distributed across ranges

6.Conclusion

Excel is one of the most useful tools for learning data analysis. It’s easy to use, available on most computers, and packed with features that help you work with data effectively.From basic tasks such as sorting and filtering to more advanced techniques like PivotTables and data visualization, Excel provides a robust platform for extracting insights and making informed decisions.By mastering its core functionalities, users can efficiently analyze data, identify trends, and communicate findings effectively. As data continues to play a central role across industries, proficiency in Excel serves as a strong foundation for any aspiring data analyst or professional working with data.