DEV Community: Noel Mwami

# Python and Data Analytics

Noel Mwami — Mon, 11 May 2026 05:17:23 +0000

I have been spending time exploring the world of data analytics, and came across Python in the recent weeks. I have seen it on job listings, online courses and YouTube tutorial. But what is it about this programming language — originally created in 1991 by Guido van Rossum — that has made it the go-to tool for data analysts, data scientists, and business intelligence professionals around the world?
This article is for anyone who is curious about Python and wants to understand why it matters in the data space — no prior coding experience required as i don't have any myself.

What Is Python?

Python is a general-purpose programming language. "General-purpose" means it wasn't built for just one thing. You can use it to build websites, automate boring tasks on your computer, control robots, and yes — analyze data.

What sets Python apart from many other languages is how readable it is. Its syntax (that is the rules of how you write code) is designed to look almost like plain English. Here's a small example:

sales = [1200,1500, 900, 2000, 1000]
total_sales = sum(sales)
print("total_sales:", total_sales)

Even if you've never written a line of code, you can probably guess what this does: it calculates the total sales of a list of sales figures and prints the result. This accessibility is one of the core reasons Python has taken over the data world.

The Core Tools: Python's Data Analytics Ecosystem

One of the most important things to understand is that "Python for data analytics" is not really just Python. It's Python plus a handful of incredibly powerful libraries. Think of Python as the hospital, and these libraries as the professional surgeons , nurses and everything inside it.

Key Features of Python

Easy to Learn: Python uses simple English-like syntax.
Versatile: It can be used for web development, automation, machine learning, and data analytics.
Large Community: There are millions of Python users worldwide, making it easy to find help.
Rich Libraries: Python has many libraries specifically built for data analytics.

What is Data Analytics?

Data analytics is the process of examining data to extract useful insights. It involves collecting, cleaning, analyzing, and interpreting data to support decision-making.

Data analytics typically involves the following steps:

Data Collection
Data Cleaning
Data Exploration
Data Analysis
Data Visualization
Decision Making

Python supports all these steps, making it a complete solution for data analytics.

Why Python is Popular in Data Analytics

Python has become the go-to language for data analytics for several reasons we will explore some of them below

1. Simplicity and Readability

Python code is easy to read and write. This allows analysts to focus more on solving problems rather than struggling with complex syntax.

2. Powerful Libraries

Python has a wide range of libraries that make data analysis easier and faster. Some of the most commonly used ones include:

Pandas – Used for data manipulation and analysis
NumPy – Used for numerical computations
Matplotlib – Used for data visualization
Seaborn – Used for advanced data visualization
Scikit-learn – Used for machine learning These libraries reduce the need to write complex code from scratch.

3. Integration with Other Tools

Python can easily integrate with databases, Excel, web applications, and big data platforms. This makes it very flexible in different working environments.

4. Open Source

Python is free to use, which makes it accessible to individuals and organizations of all sizes.

5. Strong Community Support

If you encounter a problem, chances are someone else has already solved it. There are countless tutorials, forums, and documentation available online.

How Python is Used in Data Analytics

Let’s explore how Python is applied at different stages of the data analytics process.

1. Data Collection

Data can come from many sources such as:

Excel files
Databases
APIs (Application Programming Interfaces)
Web scraping Python makes it easy to collect data from these sources.

Example:

Using Python, you can read an Excel file in just a few lines of code:

import pandas as pd
data = pd.read_excel("sales_data.xlsx")
print(data.head())

2. Data Cleaning

Raw data is often messy. It may contain missing values, duplicates, or errors. Data cleaning is an important step before analysis.

Python, especially the Pandas library, is very powerful for cleaning data.

Common Cleaning Tasks:

Removing duplicates
Filling missing values
Renaming columns
Converting data types

Example:

data = data.drop_duplicates()
data = data.fillna(0)

3. Data Exploration

Data exploration helps you understand the structure and patterns in your data.
With Python, you can quickly summarize and inspect your dataset.

Example:

print(data.describe())
print(data.info())

These commands provide useful information such as:

Mean
Standard deviation
Data types
Missing values

4. Data Analysis

This is where you start extracting insights from the data.
You can perform calculations, group data, and identify trends.

Example:

total_sales = data["sales"].sum()
sales_by_region = data.groupby("region")["sales"].sum()

print(total_sales)
print(sales_by_region)

5. Data Visualization

Data visualization helps present insights in a clear and understandable way.
Python provides several libraries for creating charts and graphs.

Example:

import matplotlib.pyplot as plt
data.groupby("region")["sales"].sum().plot(kind="bar")
plt.show()

This creates a bar chart showing sales by region.

6. Reporting and Decision Making

Once analysis is complete, results are shared with stakeholders.
Python can generate reports, dashboards, or export results to Excel.

Real-World Applications of Python in Data Analytics

Python is used across many industries. Here are some examples:

1. Finance

In finance, Python is used for:

Risk analysis
Fraud detection
Financial forecasting

2. Healthcare

In healthcare, Python helps with:

Patient data analysis
Disease prediction
Medical research

3. Retail

Retail businesses use Python to:

Analyze customer behavior
Optimize pricing
Manage inventory

4. Marketing

In marketing, Python is used for:

Campaign analysis
Customer segmentation
Social media analytics

Python Tools for Data Analytics

There are several tools that make working with Python easier

1. Jupyter Notebook

Jupyter Notebook is an interactive environment where you can write and run Python code. It is widely used in data analytics because it allows you to combine code, text, and visualizations in one place.

2. Anaconda

Anaconda is a distribution of Python that comes with many pre-installed libraries for data analytics.

3. Visual Studio Code

This is a popular code editor that supports Python development.

Advantages of Using Python in Data Analytics

Easy to learn for beginners
Large ecosystem of libraries
Strong community support
Works well with big data tools
Suitable for automation

Challenges of Using Python

While Python is powerful, it also has some limitations:

Slower than some languages like C++
Requires memory for large datasets
Can be overwhelming due to many libraries

However, these challenges can be managed with experience and proper tools.

Getting Started with Python for Data Analytics

If you are new to Python, here are some steps to begin:

Install Python or Anaconda
Learn basic Python syntax
Practice using Pandas and NumPy
Work on small projects
Explore real datasets

Conclusion

Python has become one of the most important tools in data analytics. Its simplicity, flexibility, and powerful libraries make it ideal for beginners and professionals alike.

From data collection to visualization, Python provides everything you need to analyze data and make informed decisions. Whether you are working in finance, healthcare, marketing, or any other field, learning Python can significantly enhance your data analytics skills.

As you continue your journey, remember that practice is key. The more you work with data using Python, the more confident and skilled you will become.

Final Thoughts

Data analytics is not just about tools; it is about solving problems and making better decisions. Python simply makes that process easier and more efficient.

If you are starting your career in data analytics, Python is one of the best investments you can make in your learning journey.

SQL Concepts and Practical Application

Noel Mwami — Sat, 11 Apr 2026 12:24:07 +0000

SQL is a language used to store, retrieve, and analyze data in databases.
SQL commands are grouped into categories based on their purpose.
The main two categories are;
DDL (Data Definition Language) vs DML (Data Manipulation Language) explained briefly below

DDL (Data Definition Language): Used to define and structure database objects such as tables.
DML (Data Manipulation Language): Used to manage and manipulate data inside those tables.

Difference between DDL & DML

Aspect	DDL (Data Definition Language)	DML (Data Manipulation Language)
Purpose	Defines database structure	Manipulates data in tables
Commands	CREATE, ALTER, DROP	INSERT, UPDATE, DELETE
Effect	Changes schema	Changes records/data
Example	CREATE TABLE students	INSERT INTO students VALUES (...)

2. Use of CREATE, INSERT, UPDATE, DELETE

In my assignment this week i was able to do the to use the below:

CREATE was used to define tables such as students, exam results, and subjects.
INSERT was used to add records into the tables.
UPDATE was used to correct or modify existing data, such as updating a student’s city or correcting marks in the exam results table.
DELETE was used to remove incorrect or cancelled records. For example, result_id 9 was deleted from the exam results table.

3. Filtering Data Using WHERE

The WHERE clause was used to filter records based on specific conditions. It supports several operators including:

= (equal to)
> and < (greater than / less than)
BETWEEN
IN
LIKE

Examples:

LIKE (pattern matching):
- 'A%' → starts with A
- 'E%' → starts with E
- '%Studies%' → contains "Studies"
IN (multiple values):

WHERE city IN ('Nairobi', 'Mombasa', 'Kisumu')

WHERE marks BETWEEN 50 AND 80

4. CASE WHEN for Data Transformation

CASE WHEN was used to create conditional logic in SQL queries.

It helped transform raw data into meaningful categories. For example, exam marks were classified into:
Distinction,Merit,Pass,Fail based on score ranges.

5. Reflection

This being my first week in using SQL .I learned how SQL is used to manage and analyze data efficiently.

The most interesting part was creating tables from scratch and adding data into them. Seeing the results using SELECT * was fascinating.

The most challenging part was ensuring correct syntax when writing multiple-row INSERT statements and using filtering conditions correctly. It was surprising how a small mistake like a missing comma could cause errors.

Overall, this has improved my understanding of how databases are structured and how data is manipulated in real-world scenarios. Its only the beginning and i already love it.

A Guide on Publishing Power BI Report and Embedding It on a Website Using iFrames

Noel Mwami — Fri, 10 Apr 2026 15:51:52 +0000

Introduction Power BI is a business analytics tool that allows users to visualize data and share views across organizations. It has features that allows publishing of reports online and embedding them into websites using iframes.
Requirements Before you begin or publish the power BI report , ensure you have:
A Power BI account
A completed Power BI report
Access to Power BI Service (app.powerbi.com)
Basic understanding of HTML
Step 1: Create Your Report in Power BI Desktop
Design your report with visuals, charts, and filters.

Step 2: Publish to Power BI Service Log into Power BI service Under workspace , create new work space with your name

Open the power BI report to publish
Go to file. Click "Publish" in Power BI Desktop choose the work space to publish report to

Step 3: Open Report in Power BI Service
Step 4: Generate Embed Code
Open report
Click File > Embed Report > Publish to Web

7 step 5:- Confirm and copy iframe code

Step 6: Embed in Website Paste iframe into your HTML file.

Save the file with .html extension
Click the file copy the path and paste in your browser if it works.

For example my link to the above file is a below click on it and see how a practiced power BI recently file:///C:/Users/nmwami/Desktop/PUBLISHING/Electronic%20sales%20Assignment.html
Conclusion
Embedding Power BI reports enhances interactivity and data sharing on websites.

How Excel is Used in Real-World Data Analysis

Noel Mwami — Fri, 27 Mar 2026 16:32:36 +0000

Description: Explore the enduring relevance of Microsoft Excel in professional data analysis, from auditing to business decision-making.
tags: data analysis, excel, tutorial, productivity

In today’s data-driven world, organizations rely heavily on tools that can help them organize, analyze, and interpret data efficiently. One of the most widely used tools for this purpose is Microsoft Excel. Despite the rise of advanced data analytics platforms, Excel remains a powerful and accessible solution for professionals across finance, auditing, operations, and many other fields.

What is Excel?

Excel is a spreadsheet application developed by Microsoft that allows users to store, organize, and analyze data using rows and columns. It provides a wide range of features such as:

Formulas and Functions: For automated calculations.
Charts and Graphs: For data visualization.
Pivot Tables: For summarizing large datasets.

These tools make it suitable for both simple calculations and complex data analysis.

Real-World Applications of Excel in Data Analysis

1. Internal Audit and Risk Analysis

In audit environments, Excel is essential for testing controls and identifying anomalies in data. Auditors use Excel to:

Detect duplicate transactions.
Identify gaps in voucher sequences.
Analyze unusual posting dates.

For instance, using sorting and filtering, an auditor can quickly highlight missing sequence numbers in payment vouchers, which may indicate control weaknesses.

2. Data Cleaning and Preparation

Raw data is often "messy" and needs cleaning before analysis. Excel helps users:

Remove duplicates.
Split or combine text fields.
Standardize formats.

Functions like TRIM, LEFT, RIGHT, and MID are commonly used to clean and manipulate text data.

3. Business Decision-Making

Managers and analysts use Excel dashboards and charts to visualize trends and support decision-making. For example:

Sales trends over time.
Customer purchasing patterns.
Inventory levels.
Customer satisfaction by analyzing product rejection rates.

Key Excel Features and Formulas

VLOOKUP / XLOOKUP

These functions are used to retrieve data from a table based on a matching value. For example, matching customer IDs with names from a separate dataset.

IF Function

The IF function applies logical conditions to data.
Example: Classifying transactions as “High Risk” or “Low Risk” based on value:
=IF(A2>100000,"High Risk","Low Risk")

Pivot Tables

Pivot tables summarize large datasets quickly. An auditor can summarize total expenses by department or month without writing complex formulas.

Why Excel Remains Relevant

Even with advanced tools like Python and Power BI, Excel remains a staple because:

Accessibility: It is easy to learn and widely available.
No Programming Needed: It requires no coding knowledge to get started.
Integration: It integrates well with almost every enterprise system.
Flexibility: It is effective for both small and large datasets.

Conclusion

Excel continues to be a vital tool in real-world data analysis across various industries. From financial reporting to audit testing and decision-making, its features enable users to transform raw data into meaningful insights.

Mastering Excel is an essential foundation that opens the door to more advanced analytical tools. Give it a try—you won't regret it! Start Learning Excel Today