DEV Community: WillyGachengo

Power BI Made Simple: Data Modelling Beginner's Guide

WillyGachengo — Mon, 02 Feb 2026 09:43:20 +0000

Understanding Data Modeling in Power BI

Data modeling is a fundamental component of effective reporting in Power BI. While Power BI provides powerful tools for visualization and analysis; the accuracy, performance, and reliability of reports depend largely on how data is structured behind the scenes. Data modeling in Power BI refers to the process of organizing data into tables and defining relationships between those tables so that Power BI can correctly interpret and analyze the data. Unlike simple spreadsheets, Power BI relies on relationships to determine how data is filtered, aggregated, and displayed in reports.

Fact Tables (What Happened)

A fact table contains quantitative data that represents measurable business events.

Key characteristics:

Contains numeric values
Very large (many rows)
Each row represents a transaction
Contains foreign keys to dimensions

Common examples:

Sales Amount
Quantity
Discount
Profit

DateKey	ProductKey	CustomerKey	Quantity	SalesAmount
20240101	101	501	2	4,000

Fact tables answer the question: “What happened?”

Dimension Tables (Describe the Facts)

Dimension tables contain descriptive attributes that provide context for the numeric data stored in fact tables. They are used for filtering, grouping, and labeling data in reports.

Key characteristics:

Smaller than fact tables
Mostly text or categorical data
Used for filtering and grouping
Usually unique values

Examples:

Product Name
Customer Name
Date
Region

ProductKey	ProductName	Category	Brand
101	Brake Pad	Spare Parts	Toyota

Dimension tables answer: “Who, what, where, and when?”

Star Schema

The star schema is the most widely recommended schema for Power BI data models. It consists of a single fact table connected directly to multiple dimension tables.
All dimensions connect directly to the fact table

Advantages of the Star Schema in Power BI

The star schema is optimized for Power BI’s internal storage and query engine. Its benefits include:

Improved query performance due to fewer joins
Simpler and more predictable filtering behavior
Easier DAX measure creation
Better data compression and scalability

Because of these advantages, star schemas are considered a best practice for Power BI semantic models.

Snowflake Schema

A snowflake schema is similar to a star schema, but dimension tables are further split into sub-dimensions.

Advantages and Disadvantages of Snowflake Schemas

Snowflake schemas reduce data redundancy and improve normalization. However, in Power BI they often introduce:

Additional relationships
Increased model complexity
Slower performance due to extra joins
More complex DAX expressions

Relationships in Power BI

Relationships define how tables are connected and how filters propagate between them.

One-to-Many Relationships (Recommended)
This is the most common and safest relationship type.

Dimension table is on the “one” side.
Fact table is on the “many” side.

Many-to-Many Relationships (Use Carefully)
Two tables where multiple records in one table relate to multiple records in another table. These can cause:

Confusing filter behavior
Incorrect totals
Slower performance

Use only when absolutely necessary.

Filter Direction

Filter direction determines how selections in one table affect another.
Single-direction filtering, from dimension tables to fact tables, is the preferred approach for beginner and intermediate Power BI models.
Single-direction filtering provides:

Predictable results
Better performance
Reduced risk of ambiguous filter paths

Bi-directional filtering may be useful in advanced scenarios but can introduce unexpected results if used without careful design.

Importance of Good Data Modeling

Poorly designed models can produce duplicated totals, incorrect aggregations, and visuals that do not respond properly to filters therefore; Good data modeling is essential for accurate reporting and efficient performance.

Well-designed models offer:

Correct and trustworthy results
Faster report interactions
Easier maintenance and scalability
Simpler DAX measures

Recommended Data Modeling Workflow in Power BI

A structured modelling approach typically includes:

Loading raw data
Cleaning and shaping data in Power Query
Identifying fact and dimension tables
Building a star schema
Creating one-to-many relationships
Using single-direction filters
Hiding technical key columns
Creating DAX measures

Data modelling is the backbone of Power BI reporting.
Understanding schemas, fact tables, dimension tables, and relationships in Power BI enables analysts to build reports that are accurate and scalable.
Good visuals tell a story but Good data modelling make sure it’s the right story.

Mastering Excel Fundamentals: A Beginner’s Guide to Data and Analysis

WillyGachengo — Sun, 25 Jan 2026 15:38:54 +0000

Microsoft Excel is a powerful spreadsheet application used for data entry, calculations, analysis, and visualization. It is widely used in business, education, finance, and everyday tasks. This beginner’s guide is designed to help new users understand Excel step by step, using simple language, clear examples, and practical functions.

Understanding the Excel Interface

Workbook: An Excel file that contains one or more worksheets

Worksheet (Sheet): A single spreadsheet within a workbook

Rows: Horizontal lines (1, 2, 3…)

Columns: Vertical lines (A, B, C…)

Cells: The intersection of a row and a column (e.g., A1)

Formula Bar: Shows data or formulas in the selected cell

Organizing and Formatting Data

Clean, well-organized data makes analysis easier, professional and more accurate.

Excel offers several tools to help you organize your data:

Basic Formatting Options

Bold, Italic, Underline: Emphasize text

Font Size & Color: Improve readability

Cell Borders: Separate data clearly

Fill Color: Highlight important values

Number Formatting

Currency (KES, USD, etc.)

Percentage (%)

Date and Time formats

Steps:

Select cells

Go to Home → Number Group

Choose the desired format

Adjusting Rows and Columns

Double-click column edge to auto-fit

Drag borders to resize manually

Simple Formulas and Functions

Formulas always start with an equal sign (=).

Basic Arithmetic Formulas

Addition: =A1 + B1

Subtraction: =A1 - B1

Multiplication: =A1 * B1

Division: =A1 / B1

Common Beginner Functions

SUM: Adds numbers

Example: =SUM(A1:A10)

AVERAGE: Calculates the mean

Example: =AVERAGE(A1:A10)

COUNT: Counts cells with numbers

Example: =COUNT(A1:A10)

MAX: Finds the highest value

Example: =MAX(A1:A10)

MIN: Finds the lowest value

Example: =MIN(A1:A10)
Using AutoFill

Enter a formula in one cell

Drag the small square (fill handle) at the bottom-right of the cell

Excel automatically copies the formula

These formulas allow you to answer common business questions, such as total sales, average performance.

Sum Operator

Average Operator

Count Operator

Sorting and Filtering Data

Once your data grows, you’ll want to focus on specific information. That’s where sorting and filtering come in.
Sorting Data

Sorting arranges data in a specific order.

Steps:

Select your data range

Go to Data → Sort

Choose column and order (A–Z or Z–A)

Filtering Data

Filtering shows only selected data.

Steps:

Select the header row

Go to Data → Filter

Click the drop-down arrow to filter values

These tools make it easier to spot patterns, outliers, and trends without changing your original dataset.

Sorting

Filtering

Turning Numbers into Insights with Pivot Tables and Charts

Numbers alone can be hard to interpret.

With just a few clicks, you can turn raw data into clear visual insights.

Pivot Tables

Pivot Tables summarize large data sets quickly.

Creating a Pivot Table

Select your data

Go to Insert → PivotTable

Choose location (New Worksheet)

Click OK

Using Pivot Fields

Rows: Categories (e.g., Product, City)

Columns: Comparison fields

Values: Numbers to calculate (Sum, Count)

Filters: Limit displayed data

Example: Total sales per product

Charts and Data Visualization

Charts help present data visually.

Common Chart Types

Column Chart

Bar Chart

Line Chart

Pie Chart

Creating a Chart

Select data

Go to Insert → Charts

Choose chart type

Customize title and labels

Tips:

Use clear titles

Avoid too many colors

Match chart type to data purpose

Summary

In this guide, you learned:

Excel basics and interface

Simple formulas and essential functions

Data formatting techniques

Sorting and filtering data

Creating Pivot Tables

Building charts for visualization

Conclusion

Microsoft Excel is a valuable skill that improves productivity and decision-making. With consistent practice, beginners can quickly move from simple data entry to powerful analysis. Mastering the basics is the foundation for advanced Excel skills such as dashboards, advanced formulas, and automation.

Keep practicing, and Excel will become one of your most useful tools.

How Excel is Used in Real-World Data Analysis

WillyGachengo — Sun, 15 Jun 2025 07:12:53 +0000

I may not have a formal background in data analysis, but I've recently developed a strong passion for working with data. What started as curiosity has quickly grown into a deep interest consequently leading me to enroll to a recognized data analytics school. I'm now committed to learning everything I can about data analysis; from understanding Excel and visualizations to exploring tools like SQL and Power BI. I’m excited to keep building my skills and eventually contribute meaningfully to data-driven projects In today’s data-driven world. The ability to make sense of numbers is no longer optional; it’s essential. One tool that has stood the test of time in this space is Microsoft Excel. Despite the rise of advanced software and coding languages, Excel remains a go-to platform for businesses and individuals alike when it comes to data analysis.
But what exactly makes Excel so powerful; and how is it used in real-life scenarios?
Microsoft Excel is a spreadsheet program that allows users to store, manipulate, analyze, and visualize data. Its familiar grid of rows and columns might seem simple at first glance, but under the hood, it holds powerful features like formulas, pivot tables, and charts that make it an indispensable tool for data professionals.
This functionality is unrivaled & therefore has wide applications in the real world. Organizations use Excel in scenarios such as Business decision making, Financial Reporting and Marketing Performance Tracking.
Through this course I have been able to learn key features examples:
VLOOKUP which combines data from different sheets or tables; Pivot Tables
which summarizes large datasets into digestible insights & IF Statements which applies logic to data for quick classification. Use Case: Labeling whether a salesperson met their monthly target with =IF(Sales>1000, "Target Met", "Below Target").
I viewed data as static; just numbers on a screen. Now, I see data as dynamic, full of stories waiting to be told. Learning Excel has taught me how to clean messy datasets, create visual dashboards, and find patterns that influence real-world outcomes.
Excel hasn’t just improved my technical skills—it’s changed the way I approach problems. I’ve become more analytical, more structured in my thinking, and far more comfortable making decisions backed by evidence.
In an age of automation and AI, Excel remains a crucial skill for anyone dealing with data. Whether you're a beginner or an aspiring analyst, mastering Excel can open doors; and more importantly, open your eyes to the power of data.