From Raw Data to Business Insights: Building a Power BI Dashboard with SQL

Data is everywhere, but data alone doesn't solve business problems.

The real value lies in transforming raw information into meaningful insights that decision-makers can actually use.

That's exactly what I set out to do in this project.

Using booking data from a fictional transport company called Safari Connect, I cleaned messy data with SQL, built business metrics, and designed an interactive Power BI dashboard that allows executives to monitor business performance at a glance.

This project mirrors a real-world data analytics workflow;from raw data to business intelligence and gave me valuable hands-on experience with SQL, Power BI, and data storytelling.

The Business Challenge

Imagine you're the operations manager of a transport company.

Every day, hundreds of bookings are made.

Passengers travel across different routes.

Drivers receive ratings.

Some bookings are cancelled.

Revenue changes from month to month.

Without a dashboard, answering simple business questions becomes difficult.

Questions like:

-Which routes generate the highest revenue?
-Which drivers perform the best?
-When do customers book the most?
-Which seat class is most popular?
-How much revenue has the company generated?

This project was built to answer those questions.

Tools Used

SQL — Data cleaning and preparation
Power BI — Interactive dashboard development
GitHub — Project documentation and version control

Cleaning the Data

Before creating any visuals, I spent time preparing the dataset.

The cleaning process involved:

Standardizing inconsistent values
Removing extra spaces
Handling missing values
Correcting data types
Fixing inconsistent entries
Preparing the data for analysis in Power BI

A clean dataset is the foundation of every reliable dashboard, and this stage ensured the final insights were accurate and meaningful.

## Before Cleaning

## After Cleaning

Building the Dashboard

With the data ready, I designed an executive dashboard focused on answering key business questions.

The dashboard includes:

Revenue KPI
Total Bookings
Average Passenger Rating
Monthly Revenue Trend
Revenue by Route
Driver Performance
Passenger Distribution by City
Seat Class Preference
Booking Trends
Cancellation Rate

To make the dashboard more interactive, I also added filters for:

Departure Date
Booking Status
Route Code
Passenger Gender
Seat Class
Vehicle Type

This allows users to explore the data from multiple perspectives instead of viewing static reports.

What the Data Revealed

After analyzing the data, several interesting insights emerged:

Revenue exceeded KES 226,000, showing healthy business performance during the analysis period.

Passenger satisfaction remained strong, with an average rating above 3.5 out of 5.

Some routes consistently generated more revenue, highlighting opportunities for route optimization and strategic investment.

Economy Class was the most popular seat category, indicating customer preference for affordability.

Bookings peaked on specific days and departure times, providing valuable information for scheduling and resource allocation.

Driver performance varied, suggesting opportunities for performance improvement and recognition of top performers.

These insights demonstrate how a dashboard can turn raw numbers into actionable business decisions.

Dashboard Preview

Challenges Along the Way

Like many analytics projects, this wasn't without its challenges.

Some fields required data type corrections before they could be analyzed correctly in Power BI. I also redesigned the dashboard several times, refining layouts, colors, and visual hierarchy to create a cleaner and more user-friendly experience.

Each iteration taught me something new—not just about Power BI, but also about designing dashboards that communicate insights clearly.

What I Learned

This project strengthened my skills in:

Writing SQL queries for data cleaning
Preparing datasets for analysis
Building business KPIs
Designing interactive Power BI dashboards
Creating visualizations that tell a story
Turning business questions into data-driven insights More importantly, it reinforced an essential lesson: