Exploring 5G KPI Report Analysis Using Google Colab (Gemini)

Why It Matters

By eliminating manual coding, AI‑powered notebooks let telecom teams extract insights faster, shortening the reporting cycle and enabling quicker network optimization.

Key Takeaways

• Gemini automates library installation in Google Colab via prompts.
• AI generates code to upload and visualize 5G KPI Excel data.
• One-line prompts create bar and scatter charts without manual coding.
• AI-driven data cleaning removes duplicates, improving insight accuracy.
• Prompt engineering extracts high‑utilization, low‑throughput cells and correlations.

Summary

The video walks through a Google Colab notebook where Gemini, Google’s generative AI, is used to analyze a 5G KPI Excel report entirely through natural‑language prompts.

Gemini first installs required libraries (pandas, matplotlib, seaborn) on command, then generates code to upload the spreadsheet, create a bar chart of PRB utilization, and plot a scatter of average downlink throughput versus active users—all without the user writing a single line of code.

The presenter also shows AI‑driven data cleaning—removing duplicate rows reduced the dataset from 214,60 to 212,66 entries—and uses prompts to flag the top five cells with high PRB usage but low throughput, as well as to compute a correlation between signal quality and throughput.

These examples illustrate how prompt engineering can turn raw telecom metrics into actionable visual insights instantly, lowering the barrier for analysts and accelerating KPI‑driven decisions across any industry.

Original Description

Exploring 5G KPI Report Analysis Using Google Colab (Gemini)

{Part of "Introduction to Prompt Engineering in 5G" Course: https://www.itelcotech.com/course/introduction-to-prompt-engineering-in-5g-enable-ai-driven-networks}

What if your Excel sheet could explain itself, create charts, and even highlight problems—just by asking the right questions?

In this session, you’ll learn how to use powerful prompts with Colab and Gemini 2.5 Flash to transform raw data into meaningful visuals, insights, and automated reports.

📌 What You’ll Learn:

✅ Create charts and visualizations using simple prompts

✅ Clean and prepare datasets automatically

✅ Generate insights from network performance data

✅ Automate KPI summaries and reporting workflows

📊 Example Prompts Covered:

• “Create a bar chart comparing PRB Utilization across all cells.”

• “Plot DL Throughput vs Active Users using a scatter plot.”

• “Identify cells with high PRB Utilization but low throughput.”

• “Generate a dashboard-style output with key KPIs.”

💡 By the end of this session, you’ll know how to:

✔ Turn tables into visuals instantly

✔ Detect trends and underperforming cells

✔ Automate repetitive analysis tasks

✔ Build smarter, faster workflows inside Colab

🎯 Hands-On Challenge:

Open your own dataset and try:

1️⃣ One visualization prompt

2️⃣ One insight-generation prompt

3️⃣ One reporting prompt

Experiment, refine, and discover how AI can make your analysis faster and more intelligent.