📈 Google Trends Data Analysis using Power BI & Pytrends API

📌 Project Overview

This project analyzes real-time Google search trends using the Pytrends (Google Trends API) and visualizes the insights through an interactive Power BI dashboard.

The dashboard enables users to explore search interest over time, compare multiple keywords, analyze regional popularity, and identify rising search topics for business and marketing decision-making.

---

🎯 Objectives

• Collect real-time Google Trends data
• Clean and transform the dataset using Python
• Build interactive Power BI dashboards
• Analyze keyword popularity
• Discover regional search behavior
• Generate business insights from search trends

---

🛠 Tech Stack

Category	Technologies
Programming	Python
API	Pytrends (Google Trends API)
Data Processing	Pandas
Visualization	Power BI
Data Format	CSV / Excel

---

📂 Project Workflow

Google Trends API
        │
        ▼
Python (Pytrends)
        │
        ▼
Data Cleaning & Transformation
        │
        ▼
CSV Dataset
        │
        ▼
Power BI
        │
        ▼
Interactive Dashboard
        │
        ▼
Business Insights

---

📊 Dashboard Features

📈 Interest Over Time

Tracks how search popularity changes over time for selected keywords.

---

🔍 Keyword Comparison

Compare multiple keywords and identify the most searched terms.

---

🌍 Regional Search Trends

Visualizes search interest across different regions using map visuals.

---

🚀 Related Queries

Displays the top and rising related search queries.

---

🎛 Interactive Filters

Users can filter results by

• Keyword
• Time Period
• Region

---

📌 Key Insights

• Identified seasonal search trends.
• Compared keyword popularity over time.
• Analyzed regional interest across locations.
• Detected emerging topics using rising searches.
• Generated insights useful for marketing and business strategy.

---

📸 Dashboard Preview

Home Dashboard

Interest Over Time

Regional Analysis

Keyword Comparison

---

📁 Repository Structure

google-trends-analysis/

│── README.md
│── Google_Trends_Dashboard.pbix
│
├── images/
│      dashboard.png
│      interest-over-time.png
│      regional-analysis.png
│      keyword-comparison.png
│
└── data/
       sample_data.csv

---

🚀 How to Use

1. Clone the repository

git clone https://github.com/TejasB13/google-trends-analysis.git

2. Open the .pbix file using Power BI Desktop.

3. Explore the interactive dashboard.

---

📈 Future Enhancements

• Automate data refresh
• Publish dashboard to Power BI Service
• Add forecasting analysis
• Integrate multiple Google Trends categories
• Build a live reporting pipeline

---

👨‍💻 Author

Tejas Bhosle

• LinkedIn: https://www.linkedin.com/in/tejas-bhosle/
• Email: tejasbhosale1311@gmail.com

---

⭐ If you found this project useful, consider giving it a star!